EGL9.2: Multiple Lines(Incorrect no of Lines) In The GL Subsystem Reconciliation/ Inquiry Page/ GL To Billing (Doc ID 2160980.1)

Last updated on DECEMBER 08, 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

On : 9.2 version, Journal / Ledger Inquiry

Actual Behavior:
------------------
Multiple lines in the GL Subsystem Reconciliation/ Inquiry page/ GL to Billing

There are a few issues observed on the GL to Billing Inquiry page under the GL Subsystem Reconciliation menu:
 1) Multiple lines in the inquiry pages are displaying for the same invoice ID for different user ids.The amount showing as not posted to GL is a sum of ALL the lines in the query (including the duplicate rows).
a.If I click Load Data I get 2,3 rows for one invoice number
 2) On the Subsystem Document Definition-Source Document = BI_INVOICE. I tried to alter the Monetary Amount back to INVOICE_AMT_BSE and the field does not exist in the drop down.

Expected Behavior:
---------------------
The system should display only one invoice for each user and shouldn't duplicate them

Steps:
-------

1) Create an invoice in status Ready
2) Run Reconciliation Data process with user VP1. General Ledger >> GL Subsystem Reconciliation >> Load Reconciliation Data
3) On line appear on GL Reconciliation Inquiry  Document details section. General Ledger >> GL Subsystem Reconciliation >> GL Reconciliation Inquiry
4) Run Load Reconciliation Data Process AGAIN AS VP2/ VP2
5) Review on Inquiry page for VP2
6) Duplicate lines now appear on the GL Reconciliation Inquiry page. General Ledger >> GL Subsystem Reconciliation >> GL Reconciliation Inquiry

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