My Oracle Support Banner

Issue with GL Cross Reference Filter Criteria in RESA (Doc ID 2780893.1)

Last updated on MARCH 06, 2023

Applies to:

Oracle Retail Merchandising Foundation Cloud Service - Version 19.2 and later
Information in this document applies to any platform.


In the RESA(Retail Sales Audit) application, into GL(General Ledger) Cross reference -> Filter Criteria section, there are incorrect list of stores shown in the 'Store' drop-down.

Issues are as below:

Issue1 - Though the table has 3 stores, the dropdown does not show the 3 stores but another list of 10 stores.
Issue2 - Provide Total Id filter and click 'Download'. The 'xls' format file contains GL mapping for all totals present in the table and not just the filtered one.

Steps to replicate the issue:

  1. Create RESA GL mapping for 3 stores (data populated in sa_fif_gl_cross_ref table).
  2. Login to UI and navigate to Foundation->Data loading->Download-> Finance Administration.
  3. Then under filter criteria select the store dropdown.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

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