BI Publisher (MOSC)

MOSC Banner

Couldn't fetch resp_id / resp_name / org_id in BIP with E-Business Security model

edited Jan 2, 2020 4:03AM in BI Publisher (MOSC) 6 commentsAnswered ✓

Hi

We have installed standalone BI Publisher (version- 12.2.1.3.0) and configured with security model 'Oracle E-Business Suite' for integration with EBS.
We have created a report using a EBS secured table i.e. PO_HEADERS but its throwing 'NO RESULT' irrespective of selecting any responsibility from 'My Account'.
So the org context is not getting fetched in BIP reports by default.
We are not getting the ORG ID by conventional means---either using fnd_global.org_id or fnd_profile.value('ORG_ID').

If we have the ORG_ID we can use the Before Report Event Trigger to set the ORG CONTEXT. If the ORG CONTEXT is not set, secured tables like PO_HEADERS or AP_INVOICES will not give any data in report.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

EBS BI Publisher Tags

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center