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:

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

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