Error ORA-01438: VALUE LARGER THAN SPECIFIED PRECISION PAY_COST_ALLOCATION In Payroll And OTL Forms

(Doc ID 2405723.1)

Last updated on MAY 31, 2018

Applies to:

Oracle Payroll - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

Error reported on following Forms.

  i . When saving time in Timekeeper form with a costing code combination that doesn't exist.
  ii. When adding element entry value with costing code combinations that doesn't exist in keyflex table.

ERROR
-----------------------
"The application has registered an empty message as part of this transaction. Contact your system administrator"

FNDLOG ERROR
   ORA-01438: value larger than specified precision allowed for this column  Cost Alloc entry made

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Timekeeper Entry
2. Create timecard for employee
3. Save timecard
4. Receive error

 

Changes

 

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