My Oracle Support Banner

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


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

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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