EGL9.2: Subystem Journal has Blank Monetary Amount for Penny Balance Foreign Amount Which Results in Error -- 'Foreign amount and monetary amount are of different signs.' and/or 'The transaction for ledger xxxxxxx is not in sync with the primary ledger tr (Doc ID 2913709.1)

Last updated on JANUARY 09, 2023

Applies to:

Symptoms

Blank monetary amount in journal line for penny balance foreign amount.
A journal was uploaded in the system through Journal Generator (FS_JGEN) process which had couple of Foreign Amounts having penny balances which resulted to blank base amounts.
When it was edited, it went to error stating Foreign amount and Monitory amount are of different signs. Then, they it was re-edited in batch mode checking the Recalc Exchange Rate checkbox.
After this, it went to error stating 'The transaction for ledger CAD_REPORT is not in sync with the primary ledger transaction'.
Need a way to correct these journals so that the base amounts are calculated and journal is posted successfully.

Error/s:

They were running GL_JEDIT process for a journal generated from subsystem, they were initially getting error:

Steps to replicate:

1.  Run Journal Generator (FS_JGEN) process w/o Edit option selected.  (Navigation:  General Ledger > Journals > Subsystem Journals > Generate Journals)
2.  Run Edit Journal Request (GL_EDIT) process. Get the 1st error.  (Navigation:General Ledger > Journals > Process Journals > Edit Journals Request)
3.  Re-run GL_JEDIT process. Get the 2nd error.

Cause

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