EGL: 9.2 GLRN_CREATE Reconciliation Run For All Nodes Of The Same Level, Not Considering Criteria Of Chartfield Value Set (Doc ID 1960800.1)

Last updated on SEPTEMBER 14, 2016

Applies to:

PeopleSoft Enterprise FIN General Ledger - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

ISSUE:
----------
When running Create Account Reconciliation (GLRN_CREATE), Reconciliation run for all the nodes at the same level if a tree node is specified in the Assignment level while in the conciliation rule there is only one node.

a. Create and post a journal with a balance sheet and expense account.
b. Now setup reconciliation setup as below -

1. Go to General Ledger > Perform Reconciliation > Configurations > Assignments
2. Create an assignment level for Account and Business Unit. Click on chartfield link next to the description. Provide the field name - Account and Business Unit. For Account select "Assignment Done At" Node At Selected Level.  Provide the tree name and level name (say tree name is all_acct and level rpt_type. Note in the tree all_acct, Balance Sheet Accounts , Income Sheet and Statistical Accounts are at the same level i.e. rpt_level).
3. Go to General Ledger > Perform Reconciliation > Reconciliation Rule. Under "Chartfield Values to Reconcile" provide the chartfield value set. Click "update/new". Verify the ChartField Value Set. Provide the tree name and node ( say tree name is all_acct and node as balance sheet).
4. Go to GL > Perform Reconciliation > Reconciliation Set. Provide the business unit From and To values and assignment level (Account and Business Unit - what we created in step 2).

c. Hit Create Reconciliation. Provide the reconciliation rule value (step 3). Run the process GLRN_CREATE.
d. Go to reconciliation workbench. Provide the criteria. Notice that all data appears for all nodes of level rpt_level i.e. Balance Sheet Accounts , Income Sheet and Statistical Accounts but at the chartfield value set we provided a specific node (i.e. balance sheet).


Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms