EGL: External Transaction is Appearing on Both Reconciliation Review Page and Documents Not Processed to the GL Section (Doc ID 3050907.1)

Last updated on OCTOBER 01, 2024

Applies to:

Symptoms

The External Transaction accounting entries that are posted to GL are appearing on both the GL Reconciliation > Reconciliation Overview > Drill to Source page and the “Documents not processed to the GL section” of the Subsystem reconciliation page.

Since the External Transaction accounting entries are posted to GL, the External Transaction amount should not appear under the "Documents not processed to the GL" section.

1. Banking > Reconcile Statements > External Transactions
2. Add an External Transaction
    a. Tran Amount = 7,777.00
    b. Transaction Code = Check
3. General Ledger > GL Subsystem Reconciliation > Load Subledger Recon Data
4. Run Load Reconciliation Data
5. General Ledger > GL Subsystem Reconciliation > GL to Subsystem Recon Inquiry
6. Add a new Inquiry Name with the following criteria:
    a. GL Business Unit
    b. Ledger Group
    c. Ledger
    d. Fiscal Year
    e. From Period
    f. To Period
    g. As of Date
    h. ChartField = Account
    i. Click Search
7. Reconciliation Overview page
    a. Amount of 7,777.00 is not displayed
    b. Click Document not yet Posted link
8. Subsystem reconciliation page
    a. Click Load Data
    b. Under Documents not processed to the GL, the amount of 7,777.00 appears
9. Banking > Bank Statements > Enter Bank Statements
10. Add a Bank Statement for the same amount as the External Transaction
      a. Transaction Amount = 7,777.00
      b. Trans Code = Check
11. Banking > Reconcile Statements > Process Bank Reconciliation
12. Run Bank Reconciliation
13. Banking > Reconcile Statements > Semi-Manual Reconciliation
14. Semi-Manual Reconciliation page, enter the following criteria:
      a. Bank ID of the Bank Statement entered in Step 10
      b. Account # of the Bank Statement entered in Step 10
      c. Statement ID of the Bank Statement entered in Step 10
      d. Reconciliation Status = Reconciled
      e. Click Search
      f. External Transaction is reconciled to the Bank Transaction
15. Run Load Reconciliation Data
16. Display the GL to Subsystem Recon Inquiry Name from Step 6 and click Search
17. Reconciliation Overview page
      a. Amount of 7,777.00 is not displayed
      b. Click Document not yet Posted link
18. Subsystem reconciliation page
      a. Click Load Data
      b. Under Documents not processed to the GL, the amount of 7,777.00 still appears
19. Cash Management > Treasury Accounting > Automated Accounting
20. Run Automataed Accounting
21. Cash Management > Treasury Accounting > Accounting Entries
22. Display the Accounting entries created for the External Transaction
      a. Status = Provisional since the Requires Review box is checked
      b. Status will need to be changed to Final
23. Cash Management > Treasury Accounting > View/Approve Entries
      a. Change the Status from Provisional to Final
      b. Save the page
24. Accounting Entries page shows the Status = Final for the External Transaction Accounting entries
25. General Ledger > Journals > Subsystem Journals > Generate Jrnl from Subsystem
26. Run Journal Generator
27. Accounting Entries page has the Journal ID field populated for the External Transaction, which confirms that the accounting entries were Journal Generated successfully over to GL
28. Run Load Reconciliation Data
29. Display the GL to Subsystem Recon Inquiry Name from Step 6 and click Search
30. Reconciliation Overview page, click the Detail icon assoicated to Account 100001
31. Drill to Source page
      a. The amount of -7,777.00 is displayed for the Transaction Reference ID of the External Transaction from Step 2
      b. Click Return to Inquiry Overview link
32. Reconciliation Overview page, click Documents not yet Posted link
33. Subsystem reconciliation page
      a. Click Load Data
      b. Under Documents not processed to the GL, the amount of 7,777.00 is still appearing. This is incorrect since the External Transaction has been posted to GL

Changes

Cause

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