Retrieve Time From OTL RCVOTLR Does Not Import Data For Contingent Worker ORA-06502: (Doc ID 1054070.1)

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


Symptoms

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

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms