Retrieve Time From OTL RCVOTLR Does Not Import Data For Contingent Worker ORA-06502:
Last updated on NOVEMBER 25, 2014
Applies to:Oracle Inventory Management - Version 12.0.0 to 12.0.7 [Release 12.0 to 12]
Oracle Time and Labor - Version 12.0 to 12.0.6 [Release 12.0]
Information in this document applies to any platform.
Executable:RCVOTLR - Retrieve Time from OTL
The User is unable to delete or update a timecard.
Timecard hours entered in past month for a specific contingent worker are not being picked up by the module "Retrieve Time from OTL".
This specific contingent worker has had time entered from previous months without issue. The only difference is that the hours were entered in later month than the when the time was worked (so backdating the timecard entry) .
The PO for the contingent worker was not altered and still remains as approved.
Note: Other contingent workers had hours in that month that processed.
When this timecard is attempted to be reprocessed, the RCVOTLR log file indicates the following error:
> The above sql error ORA-06502: PL/SQL: numeric or value error: NULL index table key value is due to the rti_idx= being null
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms