R12: AR Open Balances Revaluation Report Returns Results Only For One Operating Unit

(Doc ID 1530653.1)

Last updated on JUNE 20, 2016

Applies to:

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

Symptoms

Attempting to run the AR Open Balances Revaluation Report (AROBRR).  When executed, it only displays data for one Single Operating Unit (OU) and no data is returned when another OU parameter is selected.

The report is considers data to be selected, based upon the MO: Security profile, as well as the GL Data Access Set.
The Operating Unit selected in the parameter should also have the access to the corresponding ledger through GL Data Access Set.
In this scenario, only the data will be picked for the selected OU.

For example:
MO Security profile has three OUs like OU1, OU2, OU3 which are attached to the ledgers like OU ledger 1, OUledger 2, OUledger 3.
Then GL Data Access Set profile should also include these three ledgers.

IF Operating unit OU1 is selected in the parameter, then the GL Data Access set must also include OU ledger 1 for the data to be selected,
If GL Data Access set does not include OU ledger 1, then for OU1 operating unit data will not be displayed.

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