My Oracle Support Banner

'Retrieve Time from OTL' Program Is Failed With Error "ORA-12899: value too large for column "HXC"."HXC_TIMECARD_SUMMARY"."TRANSFERRED_TO" (actual: 241, maximum: 240)" (Doc ID 2969153.1)

Last updated on AUGUST 22, 2023

Applies to:

Oracle Time and Labor - Version 12.2.4 and later
Information in this document applies to any platform.

Symptoms

Receiving Transaction Processor" triggered by 'Retrieve Time from OTL' is completing with following Error.

ERROR in log file:
--------------------
Unexpected exception in
Retrieve_Timecards_Body: ORA-12899: value too large for column
"HXC"."HXC_TIMECARD_SUMMARY"."TRANSFERRED_TO" (actual: 241, maximum: 240)

The issue can be reproduced at will with the following steps:
1. Login to E-Business Suits
2. N> Purchasing Responsibility
3. Reports > Run
4. Run 'Retrieve Time from OTL' concurrent program
5. The concurrent program will completed with error with above mentioned error message captured in log file

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
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.