Receivables - EBS (MOSC)

MOSC Banner

AR_DISTRIBUTIONS_ALL.LINE ID not held in any XLA table for SOURCE_TYPE='EXCH_GAIN' in R12

edited Sep 23, 2014 1:54AM in Receivables - EBS (MOSC) 1 commentAnswered

Hi,

I am upgrading a BI Publisher view from EBS 11.5.10 to R12.1.3.

We have a requirement to link the GL_IMPORT_REFERENCES table with AR_DISTRIBUTIONS_ALL table.

In 11i, the mapping was as follows.

AR_DISTRIBUTIONS_ALL.LINE_ID=GL_IMPORT_REFERENCES.REFERENCE_3

GL_IMPORT_REFERENCES.REFERENCE_10='AR_RECEIVABLE_APPLICATIONS'

AR_DISTRIBUTIONS_ALL.SOURCE_TABLE='RA'

The GL_SL_LINK_ID and GL_SL_LINK_TABLE in GL_IMPORT_REFERENCES table were not populated

In R12, the mapping has changed - the relation between GL_IMPORT_REFERENCES and AR_DISTRIBUTIONS_ALL is held via the Subledger Accounting (XLA) tables, using GL_SL_LINK_ID and GL_SL_LINK_TABLE columns.

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