FAH: Journal Entry Is Not Balanced In Entered/Accounted Currency After Using Custom Formula In SLA Rules (Doc ID 2496302.1)

Last updated on DECEMBER 11, 2019

Applies to:

Symptoms

On : 11.13.18.05.0 version, Capture Transactions-Manage Subledgers

When attempting to run Create Accounting having a custom formula, the entered/accounted amounts are out of balance for 1 cent. The process ends in error.

ERROR
-----------------------
Error and Warning Message: The subledger journal entry does not balance in the entered currency.
Cause: The subledger journal entry does not balance in the entered currency and entered currency balancing is not enabled for the ledger.
Action: Verify the entered amounts on the journal entry lines are correct or define a valid entered currency balancing account for the ledger.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Have a custom formula in an accounting rule as below:
((((((((((((("Prices Future Host Payable" * (ToInteger("Host Curr To USD") / 1000000)) + (("Prices Host Payable" * ToInteger("Host Curr To USD")) / 1000000)) + ((ToInteger("Prices Pass Through Cleaning Fee") / 1000000) * (ToInteger("Guest Curr To Usd") / 1000000))) + ((ToInteger("Prices Pass Through Gratuity Fee") / 1000000) * (ToInteger("Guest Curr To Usd") / 1000000))) + ((ToInteger("Prices Pass Through Service Charge") / 1000000) * (ToInteger("Guest Curr To Usd") / 1000000))) + ((ToInteger("Prices Pass Through One Time Fee") / 1000000) * (ToInteger("Guest Curr To Usd") / 1000000))) + ((ToInteger("Prices Pass Through Tot") / 1000000) * (ToInteger("Guest Curr To Usd") / 1000000))) + ("Prices Create FX Diff" * (ToInteger("Guest Curr To Usd") / 1000000))) + ("Prices Resolution Guest Gain" * (ToInteger("Guest Curr To Usd") / 1000000))) + ("Prices Cleaning Fee" * (ToInteger("Guest Curr To Usd") / 1000000))) + ("Prices Rounding Loss" * (ToInteger("Host Curr To USD") / 1000000))) + ("Prices Host Remitted Tot" * (ToInteger("Host Curr To USD") / 1000000))) * (ToInteger("USD To Host Curr") / 1000000))

2. Import transactions, Run Create Accounting.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot import successfully the transactions

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.