Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

IG report doesn't maintain layout

I have an application with 2 orgs. ORG1 and ORG2. I can switch between these Orgs on the fly. I have an IG with 3 common fields A,B and C. However I have column D (specific to ORG1) and column E specific to ORG2. Each has an authorization scheme against the columns… ORG1 for column D and ORG2 for column E. The IG uses the same query for all columns. So on the primary report I select column A,B,C,D only (when ORG1) and save it while my app is set to ORG1 (this is using a global variable) and column A,B,C,E (when ORG2). So when I set the ORG1 format and save its fine. When I switch to ORG2 I have to find E in the column list to add it and then save. However, when I revert back to ORG1 columns A,B,C are there but column D is missing (but available in the column listing). If I add it back in and save, but then switch back to ORG2 column A,B,C are there and column E is missing (but available in column listing). I would have thought that because these columns were secured at an ORG level, they would show up based on the application org being ORG1 or ORG2, but clearly I am missing the boat somewhere. Anyone have any ideas as to what I am doing wrong?

Comments
Post Details
Added 4 days ago
1 comment
53 views