My Oracle Support Banner

EGL9+: Journal Edit Creates Intercompany Lines On Multi-BU Journal Instead Of Balancing It Using The Rounding Adjustment. (Doc ID 1476455.1)

Last updated on FEBRUARY 04, 2019

Applies to:

PeopleSoft Enterprise FIN General Ledger - Version 9 to 9 [Release 9]
Information in this document applies to any platform.
****Checked for Currency on July-03-2014****


  On :  9 version, Journal Edit


  - 9.0 bundle #7
  - Multibook ledger. Anchor BU has translate. Non-anchor BU has primary ledger only.
  - Currency Balance Option: Balance by All Currencies.
  - Rounding Adjustment: Adjust Last Journal lines

  If the journal is entered/uploaded with foreign currency amount only, Journal edit creates interunit balancing lines rather than adding rounding adjustment

  After journal edit creating base amounts and secondary ledger lines, user expects rounding adjustment to be added per currency rounding adjustment setup, ie last line adjustment.

  The issue can be reproduced at will with the following steps:

  1. Set up 2 business units as below

   - CAD01 in base CAD - Multiple ledgers ACTLCL (CAD ledger) and ACTUSD ( USD translate ledger)
   - USD01 in base USD - Singel ledger ACTUSD (USD ledger).

  2. Upload a spreadsheet journal with balanced foreign amount as below.

   - USD01 is header/anchor BU. Journal lines are entered in USD (Foreign currency = Base currency USD) to ACTUSD ledger.
   - CAD01 is non-anchor BU. Journal lines are entered in foreign currency USD to ACTLCL ledger (CAD ledger)
   - Since exchange rate is CAD 1.00 = USD 0.30, we expect round adjustment.


USD01 ACTUSD 640001 USD 1.00
USD01 ACTUSD 100002 USD -1.00
CAD01 ACTLCL 640001 USD 1.00
CAD01 ACTLCL 640002 USD 1.00
CAD01 ACTLCL 640003 USD 1.00
CAD01 ACTLCL 100002 USD -3.00

  3. Run batch journal edit.

  4. Additional interunit line is created for both primary ledger and secondary ledger although user expect these lines are created as rounding adjustment instead.

Primary ledger lines.

USD01 ACTUSD 640001 USD 1.00 USD 1.00  
USD01 ACTUSD 100002 USD -1.00 USD -1.00  
CAD01 ACTLCL 640001 USD 1.00 CAD 3.33  
CAD01 ACTLCL 640002 USD 1.00 CAD 3.33  
CAD01 ACTLCL 640003 USD 1.00 CAD 3.33  
CAD01 ACTLCL 100002 USD -3.00 CAD -10.00  
CAD01 ACTLCL 100100 USD 0.00 CAD 0.01 USD01

Secondary ledger lines

CAD01 ACTUSD 640001 CAD 3.33 USD 1.00  
CAD01 ACTUSD 640002 CAD 3.33 USD 1.00  
CAD01 ACTUSD 640003 CAD 3.33 USD 1.00  
CAD01 ACTUSD 100002 CAD -10.00 USD -3.00  
CAD01 ACTUSD 100100 CAD 0.01 USD 0.00 USD01


  Last line rounding works in below scenario with same replication data/steps:
  - both anchor and non-anchor BU have same base currency CAD.
  - spreadsheet journal is entered with line amounts in foreign currency USD.
  - journal lines are balanced in foreign currency for both BU before edit.
  - After edit, since one BU is balanced in both base (CAD) and foreign currency (USD), there is no rounding adjustment expected
  - Another BU is balanced in foreign currency only hence rounding adjustment is expected. After edit, Rounding adjustment is added as expected either to the last line or as additional lines to balance the journal in base amount.

  The issue has the following business impact:
  Due to this issue, users has to manually correct the journal entry.




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

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