My Oracle Support Banner

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.

Symptoms

Problem Statement
When attempting to query in Find Receiving Transactions form,
the following error occurs.

 

Error
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

  1. Navigate to Receiving > Receiving Transactions

  2. Find Receiving Transactions window,
    Operating Unit is selected
    Perform the query by PO number

  3. The query finishes successfully.

  4. Find Receiving Transactions window, click Clear button
    Operating Unit is NOT selected this time
    Perform another query by Supplier or Receipt number

  5. Error shows

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.