"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.
While attempting to process a correction transaction on a Timecard,
"Retrieve Time from OTL" concurrent program errors with below message
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
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.
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