APP-SQLAP-10000
ORA-01403 no data found

Symptoms
On opening supplier form the system shows an error APP-SQLAP-10000: ORA-01403 no data found in AP_APXVDVDMVD_PKG.INITIALIZE ORA-01403 no data found in AP_APXVDVDMVD_PKG.INITIALIZE ORA-01403


Cause
For the particular Payable responsibilty in Financial options Inventory organization is not defined
Navigate Set Up ---> Options----> Fianacial Supplier Purchasing Tab, No value for Invenory
organization and LOV for the same does not display any value.


In Inventory responsibilty ,either no inventory organization is attached with the particular set of books (with which Payable
responsibilty is attached or
Inventory information for the defined Inventory organization attached with the particular set of books (with which Payable responsibilty is attached), is not defined.



Solution
Do the following if No inventory organization is defined with the particular Set of book with which the payable responsibilty is attached:
1) Log in to Inventory Responsibilty
2) Navigate to Organization window (Set up ----> Organizations -> Organizations)
3) Define a new inventory organization.
4) In Organization Classification region enter "Invetory Organization" in the name field and enable it
5) Click on Others Button---------> from the LOV select Accounting Informations---------> it will open "Additional Organization Information" window----->enter respective value for Set Of Books , Legal entity and Operating unit ------> Save----> Close "Additional Organization Information" window
6) click on Others button---------> from the LOV select Accounting Informations---------> it will open "Organozation Parameter" window ------>enter respective values----> Save.


Do the following if inventory organization is defined with the particular Set of book with which the payable responsibilty is attached, but inventory information is not defined


1) Log in to Inventory Responsibilty
2) navigate to Organization window (Set up ----> Organizations -> Organizations)
3) Query for the Invenory organization
4) In Organization Classification region put cusrsor on the record having value "Inventory
organization" for Name field.
5) click on Others button---------> from the LOV select Accounting Informations---------> it will open "Organozation Parameter" window ------>enter respective values----> Save.