THE RESULT OF FOLDER QUERY IN ARXTWMAI IS NOT PROPER - CHANGE STILL SHOWS PREVIOUS FOLDER RESULTS (Doc ID 1469775.1)

Last updated on JUNE 21, 2012

Applies to:

Oracle Receivables - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

Customer is using 2 folders that has different folder query in Transaction Summary window.

When customer opens the one of these folder in transaction summary window, transactions shows as expected.
But then customer changes the folder, the result of folder query is not proper.
 
1. Create following 2 folders in trahsaction summary window.
 
      FOLDER A  -- Query customer 'CUSTOMER A'as bill to customer.
        
        Autoquery: Ask
        Anyone's Default: OFF
        Public: OFF
        Where Clause: (BILL_TO_CUSTOMER_ID = 145053)
 
      FOLDER B  -- Query customer 'CUSTOMER B'as bill to customer.
        
        Autoquery: Ask
        Anyone's Default: OFF
        Public: OFF
        Where Clause: (BILL_TO_CUSTOMER_ID = 145055)
 
2. Open FOLDER A in Trasactions Summary window. Showing message 'Find all records in this folder?' - Select 'YES'.
   -> Transactions that bill to customer is 'CUSTOMER A' is displayed. *This is proper.
 
3. Now change the folder to FOLDER B. Showing message 'Find all records in this folder?' - Select 'YES'.
   -> Transactions that bill to customer is 'CUSTOMER A' is displayed.
 
In stap 3.  'CUSTOMER A' is selected as bill to customer even though user is opening FOLDER B.

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