Retrieve Time From OTL RCVOTLR Does Not Import Data For Contingent Worker ORA-06502:
(Doc ID 1054070.1)
Last updated on JANUARY 31, 2019
Applies to:Oracle Time and Labor - Version 12.0 to 12.0.6 [Release 12.0]
Oracle Inventory Management - Version 12.0.0 to 12.0.7 [Release 12.0 to 12]
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
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