Oracle update to nVision layout issue

 

We have multibook turned on with ledgers defined under multiple SetIDs.  Our USD based ledgers are stored under ‘SHARE’ but our non-USD ledgers are stored under a SetID that reflects the currency code (i.e., ‘GBP01’, ‘HKD01’).  A sample of our ledger structure is:

 

·         SHARE – ACTUALS (single book)

o   ACTUALS

·         GBP01 – ACTUALS (multibook)

o   ACT_GBP

o   ACTUALS

·         HKD01 – ACTUALS (multibook)

o   ACT_HKD

o   ACT_GBP

o   ACTUALS

 

At a transaction level, everything is working correctly.  However, we are having some issues with nVision reporting.  When we try to define an nVision matrix report for the GBP based ledgers, we define the business unit and the ledger’s SetID up front.  When we try to specify the amount field (i.e., POSTED_TOTAL_AMT), it returns no values.  When I trace the SQL, it is selecting the SetID of ‘SHARE’, which is nowhere to be found in the nVision report.  It seems like a bug, but we are wondering if anyone else has any ideas.  Here is the SQL and bind variables