My Oracle Support Banner

Fusion CST: Post 20B Upgrade: Cost Rollup Error : ORA-01438 Value Larger Than Specified Precision Allowed For This Column (Doc ID 2688795.1)

Last updated on JULY 08, 2020

Applies to:

Oracle Fusion Inventory Management Cloud Service - Version 11.13.20.04.0 to 11.13.20.07.0 [Release 1.0]
Oracle Fusion Manufacturing Cloud Service - Version 11.13.20.04.0 to 11.13.20.07.0 [Release 1.0]
Oracle Fusion Purchasing Cloud Service - Version 11.13.20.04.0 to 11.13.20.07.0 [Release 1.0]
Oracle Fusion Order Management Cloud Service - Version 11.13.20.04.0 to 11.13.20.07.0 [Release 1.0]
Oracle Fusion Cost Management Cloud Service - Version 11.13.20.04.0 to 11.13.20.07.0 [Release 1.0]
Information in this document applies to any platform.

Symptoms

 
Users observe that Cost Rollup fails with error and it does not create any rollup cost due to this error. 

This can occur when running Restore Rolled-up Costs or Roll up Costs programs.

 

Error

ERROR: Preprocessing: Could not Restore the Rollup Data Process rolled back and aborted due to SQL Exception
on ScenarioProcessor/insertRollupCosts_CWOO: ORA-01438: value larger than specified precision allowed for this column.

 

Steps To Reproduce

1. Create 3 items:

2. Create work definition for the Item-AB.
3. While adding the Item-A, change the material sequence number to 1000000000 in the Item Master (for Discrete Manufacturing) or work definition (for Process Manufacturing).
    (any material sequence number greater than 9 digits long).
4. Supply Chain Execution > Cost Management
5. Task: Manage Cost Scenario
6. Create Scenario with selective item rollup for Item-AB.
7. Run the Cost Roll Up (Restore Rolled-up Costs or Roll up Costs).
8. Job ends in reported error.

Changes

 Upgrade to 20B (Cohorts A, B and C)

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.