My Oracle Support Banner

Revaluation Journals of Primary Ledger Can Now be Replicated in Secondary Ledger (Doc ID 1558172.1)

Last updated on JUNE 07, 2021

Applies to:

Oracle General Ledger - Version 12.1.3 and later
Information in this document applies to any platform.
Executable:GLCRVL - Program - Revalue Balances

Details

As per original design, Revaluation journals of Primary ledger are not replicated in Secondary ledger.

The  Oracle Financials Implementation Guide page 3-84 (Journal Conversion) also states:

By default, journals using the journal sources described in the following table are not automatically converted to the secondary ledger using General Ledger Posting.  

Journal Source

Journal Category

Transfer Journals to Secondary Ledger

Move/Merge Other No
Move/Merge Reversal Other No
Revaluation Other No

 

Even if user define Revaluation source and category Revaluation with a Yes Conversion option the journals were not transferred.

You would need to run Revaluation separately in the secondary ledger. General Ledger does not automatically convert the primary ledger's revaluation journal to the secondary ledger.


Actions

The enhancement request from <BUG 7126482> - REVALUATION JOURNALS ARE NOT TRANSFERRED TO SECONDARY LEDGER has been implemented and released via <patch:7126482> for R12.1 and higher.

To implement the solution, please execute the following steps:

1. Download and review the readme and pre-requisites for the relevant patch:
For R12.0 - neither <patch:7126482>:R12.GL.A nor <patch:19872993>:R12.GL.A is currently released
For R12.1 - <patch:19872993>:R12.GL.B
For R12.2 -this functionality has been included in 12.2.4 application version. For earlier releases for R12.2 you need to apply <patch:20434143>:R12.GL.C

Note that <patch:19872993> supersedes <patch:7126482>

2. Ensure that you have taken a backup of your system before applying the recommended patch.

3. Apply the patch in a test environment.

4. Confirm the following file versions:

For R12.1:
glrascs3.sql                                    120.0.12010000.2  
b7126482.ldt                                  120.0.12010000.2  
GLLedgerConfigurationsAMImpl.java  120.152.12010000.7  
ConfigPLtoSLMapPageCO.java          120.20.12010000.2
glpcsl.lpc                                        120.9.12010000.20  
For 12.2:
GLLedgerConfigurationsAMImpl.java 120.157.12020000.3
ConfigPLtoSLMapPageCO.java 120.20.12020000.3
glpcsl.lpc 120.25.12020000.8


You can use commands like the following:
strings -a $JAVA_TOP/oracle/apps/gl/asflow/config/server/GLLedgerConfigurationsAMImpl.class | grep '$Header'
strings -a $JAVA_TOP/oracle/apps/gl/asflow/config/webui/ConfigPLtoSLMapPageCO.class | grep '$Header'
strings -a $GL_TOP/bin/GLPPOS |grep '$Header' | grep glpcsl

5. Retest the issue.

6. Migrate the solution as appropriate to other environments.


Note: After the patch application Revaluation journals of primary ledger are replicated in secondary ledger conditionally by allowing to update the journal conversion rule for the 'Revaluation' source (Prior to this enhancement, this was not updateable) in Update Primary to Secondary Ledger Mapping page (navigate to Accounting Setup Manager, under Secondary Ledger select *Primary to Secondary Ledger Mapping and see the Journal Conversion Rules Section).

  • For Journal Level secondary ledger, journal conversion of Revaluation source can be enabled ONLY IF primary ledger and secondary ledger have same ledger currency.
  • For Subledger Level secondary ledger, journal conversion of Revaluation source can be enabled ONLY IF primary ledger and secondary ledger have same ledger currency and subledger accounting method.

 

The main reason why this cannot be achieved when using SUBLEDGER conversion and different SLAM is:


When setting up a Secondary Ledger with transaction level as SUBLEDGER, there might be different setups for SLAM:
One ledger has Accrual Accounting and the second ledger has Cash Basis.
In this case, the accounting date is different for the same transaction -> this leads to different exchange rates used and the journal cannot be replicated from Primary to Secondary Ledger.

Posting program will replicate the Primary revaluation journal entries to secondary ledger based on Journal Source and Category Conversion setup of the Secondary ledger.

 

 

 

Contacts

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
Details
Actions
Contacts
 Still Have Questions?
References

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