Customer interface and org_id
Apologies if there is a thread covering it as I would imagine it is a common issue, bit I could not find it.
We have a SQLLDR concurrent program that loads data into the standard customer interface tables.
Under 11i we load into RA_CUSTOMERS_INTERFACE and ORG_ID gets populated with the org_id of the responsibility running the sqlldr concurrent request.
Under R12 the same load puts the data in the table with a null org_id
I have tried changing the control file to load into RA_CUSTOMERS_INTERFACE_ALL with ORG_ID "FND_PROFILE.VALUE('ORG_ID')"
We have a SQLLDR concurrent program that loads data into the standard customer interface tables.
Under 11i we load into RA_CUSTOMERS_INTERFACE and ORG_ID gets populated with the org_id of the responsibility running the sqlldr concurrent request.
Under R12 the same load puts the data in the table with a null org_id
I have tried changing the control file to load into RA_CUSTOMERS_INTERFACE_ALL with ORG_ID "FND_PROFILE.VALUE('ORG_ID')"
0