My Oracle Support Banner

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.


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.

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

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.

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.


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

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

In this Document

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