My Oracle Support Banner

Collect Revenue Recognition Information Program Completed with Error 'ar_match_rev_cogs_grp.populate_cst_tables : ORA-01438: value larger than specified precision allowed for this column' (Doc ID 3056339.1)

Last updated on DECEMBER 11, 2024

Applies to:

Oracle Receivables - Version 12.2 and later
Oracle Cost Management - Version 12.2 and later
Information in this document applies to any platform.

Symptoms

When attempting to run program CSTRCMCR: Collect Revenue Recognition Information the following error occurs:

PROGRAM_EXCEPTION IN Match_RevenueCOGS at (30)
ar_match_rev_cogs_grp.populate_cst_tables : ORA-01438: value larger than specified precision allowed for this column
Error in CST_RevenueCogsMatch_PVT . Match_RevenueCOGS ( 30 )

The ORA error can be found in Trace file as well and can be used to identify the SQL statement causing the issue and the set of binds that will help identify the Transaction with incorrect value.

The ORA-01438 was showing as below in raw Trace file:

ERROR #139767753818624:err=1438 tim=6684064715953

The cursor number starting with # was used to identify the SQL statement. The error was displayed under the set of binds that lead to the error.


The issue can be reproduced at will with the following steps:

Responsibility: Cost Management
Navigation:  COGS Recognition > Collect Revenue Recognition Information
1. Provide the parameters > Submit

Changes

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