Bug 25164668: Positive Correction Is Not Happening In Oracle (Doc ID 2234482.1)

Last updated on FEBRUARY 16, 2017

Applies to:

Oracle Warehouse Management - Version 12.2.5 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.5 version, Receiving Functions

When attempting Positive Correction in WMS enabled org, an error is encountered

ERROR
-----------------------
RVTTH-115j: Subroutine process_transaction() returned error
Cause: Subroutine process_transaction() returned an internal error.
Action: Note this error number and the actions you are trying to perform. Contact your system

Additional error:
"RVSUT-025: ORA-01403: no data found
Cause: A SQL error has occurred in RVSUT. The SQL error is &LSQL_ERR.
Action: Take note of both this error number and the actions you were t"
There are no invalid packages.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
  This error is reproducible from the Enter Corrections form. Steps to reproduce:
1. Create and approve a PO with one line, one shipment for any item with quantity of say 100.
2. Receive and Deliver the PO shipment (Direct Delivery) for a quantity of 70.
3. Now try to add a quantity of 10 to the receipt using the Enter Corrections form.
On saving the transaction, let the receiving transaction processor (running in IMMEDIATE mode) complete. This completes with ERROR and you will see the following error in PO_INTERFACE_ERRORS:
RVTTH-115j: Subroutine process_transaction() returned error
Cause: Subroutine process_transaction() returned an internal error.
Action: Note this error number and the actions you are trying to perform. Contact your system


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot complete positive correction transactions.

Cause

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 hundreds of Community platforms