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:

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

Steps To Reproduce

1. Create 3 items:

• Item-A
• Item-B
• Item-AB (this item has have the item structure with Item-A and Item-B)

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.