- OracleApps Epicenter - http://www.oracleappshub.com -

Supporting References In Release 12 SLA

Supporting References enables users to enter additional information for the journal entry header and lines that can be used for analytical purposes. This functionality was earlier known as Analytical Criteria. This enhancement was released in R12.0.3.

Business Benifits of Supporting references may be used as follows:

The use of supporting references is optional, consist of these steps in order to use.

  1. Define a Supporting Reference
  2. Attach the Supporting Reference to the Journal Line Type (JLT)
  3. Validate the Applications Accounting Definitions

In R11i, additional data was interfaced to GL on the journals using Descriptive Flexfields where as R12 With this, customers can create customized sources as Supporting References and pass values into those sources from Subledgers like AP/AR/PA etc. Supporting references (SR) are associated at the Event Class Level. These SRs are stored in XLA_AE_LINE_ACS and associated using ae_header_id/ae_line_num. This helps link back to XLA_AE_LINES records.

From XLA_AE_LINES, the link to GL is using GL_SL_LINK_ID and GL_SL_LINK_TABLE

For setup of Supporting References, there are 3 options

Supporting References - What Tables for Analytical

Here are the list of table. If you have plan to do some custom reporting for Analytical for Opertional reporting you can understand the data model as per figure below.

 

Supporting Refrence for Manual created Refrence

In R12, supporting references were introduced and the UI enables a user to However, the current version of manual journal creation API has not been supported to capture. Check it out with latest version of the code.

2 Comments (Open | Close)

2 Comments To "Supporting References In Release 12 SLA"

#1 Comment By mark On January 7, 2012 @ 3:44 am

thanks for the great definition of supporting reference, can we see an example of how it helps reconcilliation ?,
thanks a lot

#2 Comment By Debi Prasad On January 14, 2013 @ 8:06 am

Great article.
I am trying to capture the AR Transaction Tax Code in Supporting reference, but can’t seem to find the correct source for it. Have you done this before? If Yes, please