RCVTXERT - Receiving Transactions Form Shows Error APP-PO-14142: DISTRIBUTION_DETAIL-10: ORA-01403: no data found
(Doc ID 2425860.1)
Last updated on JULY 22, 2018
Applies to:Oracle Inventory Management - Version 12.1.3 and later
Information in this document applies to any platform.
When attempting to query in Find Receiving Transactions form,
the following error occurs.
APP-PO-14142: DISTRIBUTION_DETAIL-10: ORA-01403: no data found
Cause: A SQL error has occurred in DISTRIBUTION_DETAIL. The SQL error is ORA-01403: no data found.
Action: Take note of both this error number and the actions you were trying to perform. Contact your system administrator for further assistance.
Click OK, then
Steps to Reproduce
- Navigate to Receiving > Receiving Transactions
- Find Receiving Transactions window,
Operating Unit is selected
Perform the query by PO number
- The query finishes successfully.
- Find Receiving Transactions window, click Clear button
Operating Unit is NOT selected this time
Perform another query by Supplier or Receipt number
- Error shows
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!