Retrieve Time from OTL Fails For Purchase Order With Multiple Distributions (Doc ID 2191060.1)

Last updated on OCTOBER 07, 2016

Applies to:

Oracle Inventory Management - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Timecard Approval

There are 4-5 weeks that are not receipting and when attempting to run Retrieve Time from OTL the following error occurs.

ERROR
-----------------------
OTL error:
PO-130 Calculate the RTI values - End Receipt not created

----------------------------
RCV error:
RVTUQ-151: Subroutine rvtuapudelivered() returned error
Cause: Subroutine rvtuapudelivered() returned an internal error.
Action: Note this error number and the actions you are trying to perform. Contact your system admini
RVTUQ-200: ORA-01403: no data found

Cause: A SQL error has occurred in RVTUQ. The SQL error is &LSQL_ERR.
[30-AUG-16 09:53:53] po.plsql.RCV_ERROR_PKG.RCV_ERROR_PKG.120: logging error on column INTERFACE_TRANSACTION_ID
[30-AUG-16 09:53:53] po.plsql.RCV_ERROR_PKG.RCV_ERROR_PKG.121: error stack from call to po_interface_call
----------------------------
PO_INTERFACE_ERRORS:

INTERFACE_TYPE INTERFACE_TRANSACTION_ID COLUMN_NAME ERROR_MESSAGE
RCV-856 1940253 INTERFACE_TRANSACTION_ID "RVTUQ-200: ORA-01403: no data found
RCV-856 1940252 INTERFACE_TRANSACTION_ID "RVTUQ-200: ORA-01403: no data found


Patches 18388691:R12.PO.B and 20421967:R12.PO.B have been applied with no change in symptoms.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create service procurement (req/po) with split distributions
2. Add time in OTL for that time frame
3. Run Retrieve time from OTL job and the SQL error will be in the log.

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