Create Accounting Error "0 The Subledger Journal Entry Does Not Balance In The Entered Currency" for Layer Cost Update Source Type (Doc ID 1527157.1)

Last updated on JUNE 21, 2023

Applies to:

Symptoms

In Cost Management > SLA > Create Accounting, Create Accounting process fails for some events: Layer Cost Update with error:

Steps to Reproduce the Issue:

       1. Create an item in an FIFO costing organization. This item can be copied from Puchased Item template, and needs to be inventory item, stockable, and cost enabled.                                  
       2. Make a misc receipt for this item with some unit cost and quantity.                                                          
       3. go to Cost->Item Costs->Layer Cost Update-> Update Costs        
       4. Select the Type to Layer Cost Update and fill the Adjustment Acct in the Update Transaction tag.                                    
       5. Fill in the created item and default cost group                  
       6. Click continue to go to Layer Cost Update Transactions form.    
       7. Go to the newly created layer, fill in value in Layer Value Change, and value in Adjustment Quantity cells. The Adjustment Quantity shall be bigger than the Layer Quantity value. Please select the Value Change and Adjustment Quantity carefully.      Need to make the balance is not 0 after rounding without the balancing code. For example, can select Value Change to 120.52245, and Adjustment Quantity is 29. If the Layer quantity is 1, then the three accounts before rounding will be: 4.155946552,       120.52245, 116.3665034. After rounding they will 4. 16, -120.52, 116.37. The balance is 0.01. Or can select the Value Change and Adjustment Quantity as in the Scenario tested by developer.        
       8. Fill in the expense account in the Accounts tag. and save.      
       9. After this transaction is costed in MTA table, check the balance of the debit and credit accounts in MTA table. The balance should be 0 with one account value change 0.01.                    
       10. (Optional) try to create accounting for this transaction, there should not be any error.                                     

Changes

Cause

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