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 laterOracle 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:
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:
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 |