Sunday, December 5, 2010

GL_INTERFACE Reference Columns in 11i EBS



Reference columns are populated/updated in GL_INTERFACE, GL_JE_LINES and GL_IMPORT_REFERENCES tables only in 11i EBS and not in R12. In R12, there are different set of SLA tables which we need to refer to retrieve subledger data after transfer to GL.

Below is the detailed analysis of Reference columns in GL_INTERFACE

Reference 1 To 10

reference1 => BATCH NAME
reference2 => BATCH Description
reference4 => Header NAME
reference5 => Header Description.
reference7 => JE Reversal FLAG
reference8 => JE Reversal PERIOD
reference10 => JOURNAL LINE DESCRIPTION(GE LINE description field )

Reference 11 To 20

Not Used

Reference 21 To 30

In Summary mode, gl_interface.reference21 - reference30 maps to gl_je_lines.reference1 - reference10.

In Detail mode, gl_interface.reference21 - reference30 maps to gl_import_reference.reference1 - reference10.

Below is the mapping for Reference 21-30 Columns with Subledgers (AP/ AR/ FA)

AP (Reference 21 To 30)

reference21 = vendor_name
reference22 = invoice_id
reference23 = distribution_line_number or check_id
reference24 = check_number
reference25 = invoice_num
reference26 = 'AP INV. JUST INSERTED' or  'AP PAYMT. JUST INSERTED'
reference27 = set_of_books_id
reference28 = invoice_distribution_id or distribution_line_number
reference29 = invoice_payment_id

For more details, Refer to Metalink Note ID- 1011799.6

AR (Reference 21 To 30)

Adjustments
-------------
REFERENCE21 = posting_control_id
REFERENCE22 = adjustment_id
REFERENCE23 = line_id
REFERENCE24 = trx_number
REFERENCE25 = adjustment_number
REFERENCE26 = cust_trx_type
RERENCE27 = bill_to_customer_id
REFERENCE28 = ADJ
REFERENCE29 = source_type prefixed by �ADJ_�
REFERENCE30 = AR_ADJUSTMENTS

Transactions
-------------
REFERENCE21 = posting_control_id
REFERENCE22 = customer_trx_id
REFERENCE23 = cust_trx_line_gl_dist_id
REFERENCE24 = trx_number
REFERENCE25 = cust.account_number
REFERENCE26 = CUSTOMER
REFERENCE27 = bill_to_customer_id
REFERENCE28 = type(CM/DM/CB/INV)
REFERENCE29 = type account_class
REFERENCE30 = RA_CUST_TRX_LINE_GL_DIST

Receipts
---------
REFERENCE21 = posting_control_id
REFERENCE22 = cash_receipt_history_id or cash_receipt_id for MISC
REFERENCE23 = line_id
REFERENCE24 = receipt_number
REFERENCE25 = null for CASH / cash_receipt_history_id for MISC
REFERENCE26 = null
REFERENCE27 = pay_from_customer
REFERENCE28 = MISC / TRADE
REFERENCE29 = MISC_sourcetype or TRADE_source_type
REFERENCE30 = AR_CASH_RECEIPT_HISTORY

Applications
--------------
REFERENCE21 = posting_control_id
REFERENCE22 = cash_receipt_id (receivable_application_id for CASH / receivable_application_id for CM)
REFERENCE23 = line_id
REFERENCE24 = receipt_number for CASH / trx_number for CM
REFERENCE25 = trx_number if status = APP/ NULL for unapplied records
REFERENCE26 = cust_trx_type
REFERENCE27 = pay_from_customer for CASH / bill_to_customer_id for CM
REFERENCE28 = application_type (TRADE or CCURR for CASH / CMAPP for CM)
REFERENCE29 = application_type source_type
REFERENCE30 = AR_RECEIVABLE_APPLICATIONS

Bills Receivable
----------------
REFERENCE21 = posting_control_id
REFERENCE22 = transaction_history_id
REFERENCE23 = line_id
REFERENCE24 = trx_number
REFERENCE25 = customer_Trx_id
REFERENCE26 = cust_trx_type
REFERENCE27 = drawee_id
REFERENCE28 = cust_trx_type
REFERENCE29 = BR_source_type
REFERENCE30 = AR_TRANSACTION_HISTORY

FA (Reference 21 To 30)

reference21 = transaction_header_id
reference22 = asset_id
reference23 = distribution_id
reference24 = adjustment_line_id
reference25 = book_type_code
reference26 = period_counter
reference27 = FA_TRANSFER_TO_GL
reference28 = adjustment_type / lookup_code
reference29 = cje_id

6 comments:

  1. thats a very good information. Wondering if we have any similar kinda details for "Purchasing" entries.

    Keep up the good work.

    Arun

    ReplyDelete
    Replies
    1. Did you ever get a reply? I'm interested as well.

      Delete
  2. Good one! keep posting nice content like this.

    http://easyapps.blogspot.com

    ReplyDelete
  3. Any reference information like this for Purchasing?? Please advise. Thanks.

    ReplyDelete
  4. Post was very helpful, thank you.
    Any reference info like this for Payroll?

    ReplyDelete
  5. This subject re-posted by OraPedia
    -------------------------------------------
    http://orapedia.wordpress.com
    -------------------------------------------
    http://orapedia.wordpress.com/2012/12/30/gl_interface-reference-columns-in-11i-ebs
    -------------------------------------------
    OraPedia (Oracle Encyclopedia) is written collaboratively by largely anonymous internet volunteers who write without pay to collect any information from anywhere about oracle products how to install, how to do, how to solve problems in one place to be encyclopedia for oracle only.

    When you search to find a solution for any problem in Oracle Products in your work and got it.

    When you search to find how to do anything in Oracle Products and got it.

    When you do any workshop for anything related to Oracle Products.

    When you get new information about Oracle Products from anywhere.

    You need to document this information to be as a reference and publish this information to access easily to him again.

    For this purpose OraPedia launched.

    If you want to write on the OraPedia just send your email to orapedia@hotmail and OraPedia will send to you an invitation to be contributor in OraPedia then follow the following instruction.

    Signup for a WordPress.com account. You can also sign in with your existing WordPress.com account if you already have one.
    Accept the invitation.
    After create the account and accept the invitation you can log to OraPedia and add new posts.

    The new post must contain the information source link If you are not the owner of this information and your signature If you are the owner of this information.
    --------------------------------------------------------------------
    أورابيديا (موسوعة أوراكل) تكتب بشكل تعاوني من قبل متطوعين مجهولين من خلال الإنترنت دون أجر لجمع أي معلومات من أي مكان حول منتجات أوراكل كيفية تثبيت ….، كيفية القيام بـ….، وكيفية حل المشاكل في مكان واحد لتكون الموسوعة لأوراكل فقط.

    عند البحث لإيجاد حل لأية مشكلة في منتجات أوراكل في عملك وحصلت عليه.

    عند البحث للعثور على كيفية القيام بأي شيء في منتجات أوراكل وحصلت عليه.

    عند القيام بأي عمل للأي شيء متعلق منتجات أوراكل.

    عندما تحصل على معلومات جديدة حول منتجات أوراكل من أي مكان.

    فأنت تحتاج إلى توثيق هذه المعلومات لتكون مرجعا وكذلك نشرهذه المعلومات للوصول بسهولة إليها مرة أخرى.

    لهذا الغرض أطلقت أورابيديا.

    إذا كنت تريد أن تكتب على أورابيديا فقط أرسل بريدك الإلكتروني orapedia@hotmail وأورابيديا سوف ترسل لك دعوة لتكون مساهما في أورابيديا ثم اتبع التعليمات التالية:

    1- اشترك للحصول على حساب WordPress.com. يمكنك أيضا تسجيل الدخول باستخدام حسابك على WordPress.com القائمة إذا كان لديك بالفعل واحدة.

    2- قبول الدعوة.

    بعد إنشاء الحساب وقبول الدعوة يمكنك تسجيل الدخول إلى أورابيديا وإضافة مقالات جديده.

    يجب أن تحتوي أي مقاله جديدة على رابط مصدرالمعلومات إن كانت غير منسوبه إليك وتوقيعك إن كانت هذه المعلومات منسوبه إليك.

    ReplyDelete

Note: Only a member of this blog may post a comment.