EGL9.2: Create Recon Process (GLRN_CREATE) Creates Reconciliations Only As Per Combinations Defined in Last CFV Set (Doc ID 2037196.1)

Last updated on FEBRUARY 03, 2019

Applies to:

Symptoms

Issue:
-------

When running Create Account Reconciliation Process(GLRN_CREATE), Reconciliation is getting created for last Reconciliation rule and its Chartfield Value Set only although there are multiple Reconciliation rules listed.

Steps to Replicate:
---------------------

1. In PIA navigate to Setup FSCM > Common Definitions > Design Chartfields >Chartfield Value Sets > Setup Chartfield Value set > Add a new value. Create 2 similar CFV sets with multiple Chartfields but include different Chartfield values

    - CFV1: Chartfields - Account(Values-400000), Business Unit(Values-US001), Department(Values-21000,20000)
    - CFV2: Chartfields - Account(Values-401000), Business Unit(Values-US003), Department(Values-10500,21100,21600)

2. Navigate to General Ledger > Perform Reconciliation > Configurations. Select Reconciliation Rule. Create 2 Reconciliation rules & include these CFV1 in one of them & CFV2 in another.
3. Navigate to General Ledger > Perform Reconciliation > Reconciliation Set. Create a new reconciliation set including 2 reconciliation rules
    - Business Unit: Range From US001 to US003. Recon Rule = RULE1
    - Business Unit: Range From US001 to US003. Recon Rule = RULE2
4. Run Create Reconciliation process for above reconciliation set.

Actual Behavior:
--------------------
Reconciliation are only created for the chartfield values from last CF Value set/ Reconciliation rule

Business Unit = US001, Account = 401000, Department = Blank
Business Unit = US001, Account = 401000, Department = 10500
Business Unit = US001, Account = 401000, Department = 21100
Business Unit = US001, Account = 401000, Department = 21600
Business Unit = US003, Account = 401000, Department = Blank
Business Unit = US003, Account = 401000, Department = 10500
Business Unit = US003, Account = 401000, Department = 21100
Business Unit = US003, Account = 401000, Department = 21600

Expected Behavior:
----------------------
Reconciliations should be created for each Recon Set, Recon Rule and the respective Chartfield Value Set.

Changes

Issues appeared after applying <Bug 21087137> which was posted in 9.2 PUM Image 13

Cause

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