EBS Customizations (MOSC)

MOSC Banner

PLSQL APIs for MOAC

in EBS Customizations (MOSC)

Oracle E-Business Suite R12

I am accessing vision (vanila) instance where in the profile MO: Operating Unit is set to a default value "Vision Operations" (204) and the profile MO: Security Profile is set to "Global Vision" (340)

Now I am trying to query OE_ORDER_HEADERS_V in the backend (sql developer session) without calling any of the APIs.. and I see no records (as expected)

Though the default output of the function fnd_profile.value ('ORG_ID') in the backend points to 240, the above view fails to fetch any records because as per Oracle documentation, unless the global temporary table "mo_glob_org_access_tmp" is populated with a record for organization_id 240 the query against the above-mentioned multi-org partitioned view shall not fetch any record.

Tagged:

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

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