General Ledger - EBS (MOSC)

MOSC Banner

Intercompany Organizations

edited Feb 17, 2014 12:00PM in General Ledger - EBS (MOSC) 1 commentAnswered
 Hello,
Can someone help to understand the underlying table for Intercompany Organiations in 11i and R12?
What I understood is all GIS Subsidiaries are upgraded to Intercompany Organizations in R12 when I run this query the counts do not match between 11i and R12. Is there anything I am missing?

SELECT COUNT(*)
FROM apps.GL_IEA_SUBSIDIARIES
WHERE ENABLED_FLAG='Y' -- 11i query

SELECT COUNT(*)
FROM AR.HZ_PARTIES HZP,
           AR.PARTY_USG_ASSIGNMENTS HUA
WHERE HUA.PARTY_ID=HZP.PARTY_ID
AND HUA.PARTY_USAGE_CODE='INTERCOMPANY_ORG'

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 GL 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