My Oracle Support Banner

Retrieve Time From OTL Fails After Cancel Of PO Line That Has Already Been Processed/Retrieved: PO-120- Calculate (Doc ID 1634876.1)

Last updated on AUGUST 11, 2020

Applies to:

Oracle Inventory Management - Version 12.1.1 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.


Retrieve Time from OTL (RCVOTLR) logfile returns a warning. The logfile shows the
following error:
Exception trying to call iSP store_timecard_details: x_return_status=,
x_msg_data=, sqlerrm=ORA-06502: PL/SQL: numeric or value error: NULL index
table key value
PO-120- Calculate the RTI values - StartUnexpected exception while processing
results from Generic Retrieval: User-Defined Exception

This is also included in log file:
block 13511502 in the same timecard failed Detail block not processed

Steps to Reproduce:
1.  Create and Approve/Submit Purchase Order (PO) and associated Timecard
2.  Create a new PO Line when information (Rate, for example) is incorrect on original PO Line
3.  Approve PO
4.  Correct Timecard so it has 0 for the work time associated with original PO Line
5.  Enter work time for the new PO Line
6.  Submit Timecard
7.  Cancel original PO Line
>>>>> When RCVOTLR runs again, it displays error details noted above




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.