Oracle Cloud offers a broad portfolio of software as a service applications, platform as a service, and social capabilities, all on a subscription basis. Oracle Cloud delivers instant value and productivity for end users, administrators, and developers alike through functionally rich, integrated, secure, enterprise cloud services.
 Get a Free Magzine ...Profit:The Executive's Guide to Oracle Applications

Subscribe to the OracleAppsHub to receive notifications when there are new posts:

 get RSS feed
 Oracle Fusion Applications (OFA) is a portfolio of next generation suite of software applications from Oracle Corporation. It is distributed across various product families; including financial management, human capital management, customer relationship management, supply chain management, procurement, governance, and project portfolio management
 Get a Free Magzine ...Profit:The Executive's Guide to Oracle Applications

AR to GL Transfer : Part II

Posted on December 10th, 2008 by Sanjit Anand |Print This Post Print This Post |Email This Post Email This Post

Have you tried OracleappsHub in ipad/iphone/smart Phone? Don't wait. try it today

Read This for AR to GL Transfer

AR to GL Transfer

dgreybarrow-2GL Transfer Can Capture the Fingerprints (Link between GL to AR )

TRANSFER Receipt

 

 

 

 

 

 

When you run AR Transfer to GL , GL_INTERFACE table get first populated with reference columns that is then pushed the detailes in GL_JE_LINES table. Here are the details for Reference columns

  • REFERENCE21 :posting_control_id
  • REFERENCE22 :cash_receipt_id||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_source type or TRADE_source_type
  • REFERENCE30 :AR_CASH_RECEIPT_HISTORY

dgreybarrow-2Key Tables

In order to obtain what is going to be tranfered to GL you can these Major AR table to drill down information.

  • ar_cash_receipt_history_all:Receitps accounting
  • ar_distributions_all: Receitps accounting
  • ar_receivable_applications_all: Receipt applications accounting
  • ar_distributions_all:Receipt applications accounting & misc receipts accounting
  • ar_misc_cash_distributions_all:Misc receipts accounting

dgreybarrow-2Query for Subledger Transfer to GL

If you want to get details of different journals transferred to GL, use this to get the result. You can also fine tune with period , currency or clearing company code or Journal Type.Here is the query for Transaction.

  1.  
  2.  
  3. gjjlv.period_name "Period"
  4. , gjb.name "Batch name"
  5. , gjjlv.header_name "Journal Entry For"
  6. , gjjlv.je_source "Source"
  7. , glcc.concatenated_segments "Accounts"
  8. , gjjlv.line_entered_dr "Entered Debit"
  9. , gjjlv.line_entered_cr "Entered Credit"
  10. , gjjlv.line_accounted_dr "Accounted Debit"
  11. , gjjlv.line_accounted_cr "Accounted Credit"
  12. , gjjlv.currency_code "Currency"
  13. , arm.name "Payment Method"
  14. , acra.receipt_number "Receipt Num"
  15. , acra.receipt_date "Receipt Date"
  16. , RA.CUSTOMER_NAME "Reference"
  17. , gjjlv.created_by "Gl Transfer By"
  18. FROM apps.gl_je_journal_lines_v gjjlv
  19. , gl_je_lines gje
  20. , gl_je_headers gjh
  21. , gl_je_batches gjb
  22. , ar_cash_receipts_all acra
  23. , apps.ra_customers ra
  24. , apps.gl_code_combinations_kfv glcc
  25. , ar_receipt_methods arm
  26. WHERE gjh.period_name IN ('OCT-2007','NOV-2007')
  27. AND glcc.code_combination_id = gje.code_combination_id
  28. AND gjh.JE_BATCH_ID = gjb.JE_BATCH_ID
  29. AND gjh.JE_HEADER_ID = gje.JE_HEADER_ID
  30. AND gjh.period_name = gjb.default_period_name
  31. AND gjh.period_name = gje.period_name
  32. AND gjjlv.period_name = gjh.period_name
  33. AND gjjlv.je_batch_id = gjh.je_batch_id
  34. AND gjjlv.je_header_id = gjh.je_header_id
  35. AND gjjlv.LINE_JE_LINE_NUM = gje.je_line_num
  36. AND gjjlv.line_code_combination_id = glcc.code_combination_id
  37. AND gjjlv.line_reference_4 = acra.receipt_number
  38. AND ra.customer_id = acra.pay_from_customer
  39. AND acra.receipt_method_id = arm.receipt_method_id
  40. AND gjjlv.SUBLEDGER_DOC_SEQUENCE_VALUE = acra.DOC_SEQUENCE_VALUE
  41. AND gjjlv.SUBLEDGER_DOC_SEQUENCE_id = acra.DOC_SEQUENCE_ID
  42. --and glcc.segment1 ='30D'
  43.  
  44.  

dgreybarrow-2Run ARGLTP module: General Ledger Transfer Program

AR to GL transfer rECEIPT

If your program is running bit slow , you can run this in debug mode and investigate why performance is done.

Based out of experince , the performance hit would be related to the number of records. If you are trying to determine why records are not imported you could run a smaller range than a week and run that in degbug mode. If you are trying to determine performance issues the debug is likely not going to help.

Here are the steps to run in the debug mode.

1)Go to Run General Ledger Interface Screen:

Interfaces -> General Ledger

2) Activate DEBUG_FLAG parameter:

Menu: Help -> Tools -> Examine
Block: Control
Field: DEBUG_FLAG
Value: Y

3) Run ARGLTP module: General Ledger Transfer Program.

After activating the debug mode the ARGLTP log file will show you more detailed information about this process. In you are unable to debug you can ask Oracle support they will help you in addressing slow performance.

Hope this will be helpful for rootcausing any issue during month end or addressing daily reconciliation.Will back soon for PO and PRJ transfer details.

Related Posts

Posted in Oracle Receivable | 1 Comment »Email This Post Email This Post | Print This Post Print This Post

Have you tried OracleappsHub in ipad/iphone/smart Phone? Don't wait. try it today
One Response
  1. Donald Ferreira Says:

    Hi Sanjit,

    Am new to Oracle General Ledger.
    Am wondering if you have queries similar to the ones above for :
    -GL Balances Drill down
    -GL Journal Drill down
    -GL Sub-Ledger drill down

    Thanks a ton for your posts

    Have a nice day

    Kind regards
    Donald

Leave a Comment

Please note: Comment moderation is enabled and may delay your comment. There is no need to resubmit your comment.