My Oracle Support Banner

"Retrieve Time From OTL" errors with message "Exception trying to call iSP store_timecard_details" - "PO-120- Calculate the RTI values" For correction transaction (Doc ID 2724193.1)

Last updated on NOVEMBER 01, 2020

Applies to:

Oracle Purchasing - Version 12.2.4 and later
Information in this document applies to any platform.

Symptoms

While attempting to process a correction transaction on a Timecard,
"Retrieve Time from OTL" concurrent program errors with below message


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
Begin set_rhi_table_status



STEPS TO REPLICATE:
 The issue can be reproduced at will with the following steps:
1. Navigate to Purchasing responsibility
2. Run "Retreive timecards from OTL" program.
3. Find that the program ends with error.

 

Changes

 

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!


In this Document
Symptoms
Changes
Cause
Solution
References


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