Retrieve Time from OTL" concurrent program Completes with Error "PO-120- Calculate the RTI values - Start Unexpected exception while processing results from Generic Retrieval: User-Defined Exception Detail block not processed"
(Doc ID 2994511.1)
Last updated on JANUARY 30, 2024
Applies to:
Oracle Purchasing - Version 12.2.9 and laterInformation 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:
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 |