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

AR to GL Transfer : Part II

Read This for AR to GL Transfer

AR to GL Transfer [1]

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

 

 

 

 

 

 

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

Key Tables

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

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

Run ARGLTP module: General Ledger Transfer Program

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.

1 Comment (Open | Close)

1 Comment To "AR to GL Transfer : Part II"

#1 Comment By Donald Ferreira On December 16, 2008 @ 6:09 am

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