My Oracle Support Banner

MTL_TRANSACTION_ACCOUNTS.TRANSACTION_VALUE=NULL Causing SLA Error 0 Subledger Journal Entry does not balance in the Entered Currency (Doc ID 2446186.1)

Last updated on SEPTEMBER 12, 2018

Applies to:

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

Symptoms

On : 12.1.3 version, Performance

ROOT CAUSE for: When field MTL_TRANSACTION_ACCOUNTS.TRANSACTION_VALUE=NULL and there is a currency conversion, the record created in XLA_AE_LINES by Create Accounting is incorrect and creates an error:

It is unclear if the root cause is the way the record is created in MTL_TRANSACTION_ACCOUNTS, or with the way the Subledger record is created, or something else.

ERROR
-----------------------
"The subledger journal entry does not balance in the entered currency. Please verify the entered amounts on the journal entry lines."


OBSERVATIONS
-----------------------
The issue can NOT be reproduced at will.

1. Issue has only been observed to occur with PO Delivery transactions
2. Issue is observed with Material Overhead Absorption lines.
3. It is the currency conversion that causes the imbalance error: the affected record does not convert properly.



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.