My Oracle Support Banner

R12: AR Open Balances Revaluation Report Returns Results Only For One Operating Unit (Doc ID 1530653.1)

Last updated on APRIL 03, 2019

Applies to:

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


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.




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
 1. Bug Summary
 2. Fixed Files
 3. Recommended Patches
 4. Solution Steps
 Still Have Questions?

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