View Accounting WIll Not Pull Up Any Accounting Information Bug 5652295 [ID 376862.1]

Bug 5652295 : VIEW ACCOUNTING LINES DOES NOT SHOW ANY INVOICE DATA ONLY PAYMENTS

Applies to:

Oracle Payables – Version: 11.5.10
This problem can occur on any platform.
PATCHSET:11I.AP.N
PATCHSET:11I.AP.M
PATCHSET:11I.AP.O
FORM:XLAIQACL.FMB – View Accounting Lines
FORM:APXINWKB.FMB – Invoice Workbench
FORM:APXPAWKB.FMB – Payment Workbench

Symptoms

The view accounting screen will not pull up any lines.

Cause

The ap_lookup_gt table is not getting populated properly.
Ran independent queries using the view AP_INV_AEL_SL_V Found that the view works fine if the ap_lookup_gt table is not linked in.
Per 5115918 – Find Accounting Lines(Ap – Xlaiqacl) Performance Issue
++ 1. Description -> No rows will be returned on querying the transactions in -> View Accounting lines after the performance fix

Bug 5652295 – View Accounting Lines Does Not Show Any Invoice Data Only Payments
++ 1. Description:  -> View Accounting Lines is not displaying the lines related  -> to invoices, when queried without mentioning the document class.

Solution

1. Apply patch 5137245 – 1 Off For Bug 5115918:11.5.10.Ap.M:Find Accounting Lines(Ap – Xlaiqacl) Performa

2.  Apply patch 5652295 – View Accounting Lines Does Not Show Any Invoice Data Only Payments

References

BUG:5115918 – NO DATA FOUND WHEN ACCOUNTED TRANSACTIONS FROM VIEW ACCOUNTING
PATCH:5137245 – 1 OFF FOR BUG 5115918:11.5.10.AP.M:FIND ACCOUNTING LINES(AP – XLAIQACL) PERFORMA
BUG:5652295 – VIEW ACCOUNTING LINES DOES NOT SHOW ANY INVOICE DATA ONLY PAYMENTS

Advertisements

SQL Statement to Get Session Information Which Used any Database Object

To get the session information which used any database objects you can use the following sql statement:

SELECT S.SID,
       S.SERIAL#,
       S.USERNAME,
       TO_CHAR(S.LOGON_TIME,'MMDDYYYY:HH24:MI') LOGON_TIME,
       TYPE,
       STATUS,
       PROCESS,
       SQL_ADDRESS,
       SQL_HASH_VALUE,
       P.OPTIMIZER_MODE,
       P.HASH_VALUE,
       P.ADDRESS,
       P.CPU_TIME,
       P.ELAPSED_TIME,
       P.SQL_TEXT
  FROM V$SQLAREA P,
       V$SESSION S
 WHERE S.SQL_HASH_VALUE = P.HASH_VALUE
   AND S.SQL_ADDRESS    = P.ADDRESS
   AND S.USERNAME       IS NOT NULL
   AND UPPER(P.SQL_TEXT) like '%'||UPPER(:P_OBJ_NAME)||'%'