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

Inventory Transfer To GL

Posted on December 3rd, 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

dgreybarrow-2How Inventory Passes Journals To General Ledger (GL)

Inventory Transactions transfer to GL normally done by Program called INCTGL.

Inventory to GLThe accounting information related to transactions in INV module is transferred to GL by running the ‘Transfer Transactions to GL’ concurrent program. This is part of ‘Period End Process' . However, you can run explicitly any time during an open period. When you run this process and in case if more than one period is open, all the transactions from the earliest open period to the date up to which the process is run (Transfer Date) are considered for transfer to GL.

When you run this program all the accounting information is inserted into gl_interface table. ‘Journal Import’ and ‘Post Journals’ processes in Oracle General Ledger can then be used to post the information in General Ledger.

The level of detail that is transferred to GL for the accounting information related to these transactions depends on the value chosen in the Organization Parameters Screen

Navigation: Oracle Inventory > Setup > Organization > Parameters

Each parameter has there own significance.

  1. Organization Code : This is one of inventory organization, for which the gl transfer has to be done.
  2. Date :A date in any open period.
  3. Current Period
  4. GL Description

The possible values for the ‘Transfer to GL’ field (in Organization Parameters Screen) are – Detail, Summary, None.

  • When Summary is selected :The accounting information pertaining to the transactions is summarized and the summary entries are posted to GL. One of the advantage of running the process in 'Summary' mode over 'Detail' mode is minimising the posting times.
  • When ‘Detail’ is selected :The detailed accounting entries are transferred to GL. In this case, the posting times are larger due to a larger number of records. The advantage of this mode is creation of detailed accounting records in GL for every transaction in Inventory/WIP.
  • When none is selected: This case no transfer of accounting information to GL is done for this organization.

dgreybarrow-2 Running ‘Transfer to GL’ process

You can run Transfer Transactions to GL process can be run from Oracle Inventory

Accounting Close Cycle .. General Ledger Transfers

dgreybarrow-2Technical Details

These are the tables which get affected By transfer Program.

  • GL_INTERFACE : Based out of Program logic, new row inserted into this table. The connecting link are established by these columns.GROUP_ID, REFERENCE21, REFERENCE22,ACCOUNTING_DATE,
    USER_JE_CATEGORY_NAME,GL_SL_LINK_TABLE

    • Action on this table :Insert
  • MTL_TRANSACTION_ACCOUNTS : Mtl_transaction_accounts holds the accounting information for each
    material transaction in mtl_material_transactions.

    • Action on this table :Select/Update
  • WIP_TRANSACTION_ACCOUNTS :This table stores the accounting information for each resource transaction in wip_transactions.
    • Action on this table :Select/Update
  • MTL_PARAMETERS :This table maintains a set of defaults and controls like general ledger accounts; locator, lot, and serial controls; inter-organization options; costing method; etc. for each organization defined in Oracle Inventory.
    • Action on this table :Select
  • ORG_GL_BATCHES :This table holds history rows for every batch of transactions that have been interfaced to the gl_interface table.
    • Action on this table :Insert/Delete/Update
  • ORG_ACCT_PERIODS :This table holds the open and closed financial periods for organizations.
    • Action on this table :Select
  • ORG_ORGANIZATION_DEFINITIONS : Defination of the Org is derived from this table
    • Action on this table :Select
  • GL_SET_OF_BOOKS : Table holds the setof book data used for joining purpose.
    • Action on this table :Select

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:

  1.  
  2. <pre>
  3.  
  4. SELECT gjh.period_name "Period name"
  5. ,gjb.name "Batch name"
  6. ,gjjlv.header_name "Journal entry"
  7. ,gjjlv.je_source "Source"
  8. ,glcc.concatenated_segments "Accounts"
  9. ,mmt.subinventory_code "Subinventory"
  10. ,glcc3.segment4 "Costcenter"
  11. ,gjjlv.line_entered_dr "Entered debit"
  12. ,gjjlv.line_entered_cr "Entered credit"
  13. ,gjjlv.line_accounted_dr "Accounted debit"
  14. ,gjjlv.line_accounted_cr "Accounted credit"
  15. ,gjjlv.currency_code "Currency"
  16. ,mtt.transaction_type_name "Transaction type"
  17. ,TO_CHAR(mta.transaction_id)"Transaction_number"
  18. ,mta.transaction_date "Transaction_date"
  19. ,msi.segment1 "Reference"
  20. FROM apps.gl_je_journal_lines_v gjjlv,
  21. gl_je_lines gje,
  22. mtl_transaction_accounts mta,
  23. mtl_material_transactions mmt,
  24. mtl_system_items_b msi,
  25. gl_je_headers gjh,
  26. gl_je_batches gjb,
  27. apps.gl_code_combinations_kfv glcc,
  28. apps.gl_code_combinations_kfv glcc2,
  29. mtl_secondary_inventories msin,
  30. mtl_transaction_types mtt,
  31. MTL_SECONDARY_INVENTORIES cost,
  32. gl_code_combinations glcc3
  33. WHERE gjjlv.period_name BETWEEN 'NOV-2008' AND 'DEC-2008'
  34. AND gje.code_combination_id = gje.code_combination_id
  35. AND gjjlv.line_je_line_num = gje.je_line_num
  36. AND gl_sl_link_table = 'MTA'
  37. AND gjjlv.je_header_id = gje.je_header_id
  38. AND mmt.inventory_item_id = msi.inventory_item_id
  39. AND gje.je_header_id = gjh.je_header_id
  40. AND gjh.je_batch_id = gjb.je_batch_id
  41. AND mmt.organization_id = msi.organization_id
  42. AND mmt.organization_id = msin.organization_id
  43. AND mmt.subinventory_code= msin.secondary_inventory_name
  44. AND mta.gl_sl_link_id= gje.gl_sl_link_id
  45. AND mta.reference_account = glcc.code_combination_id
  46. AND msin.expense_account = glcc2.code_combination_id
  47. AND mmt.transaction_id = mta.transaction_id
  48. AND mtt.transaction_type_id = mmt.transaction_type_id
  49. AND cost.organization_id(+) = mmt.organization_id
  50. AND cost.secondary_inventory_name(+) = mmt.subinventory_code
  51. AND glcc3.code_combination_id(+) =
  52.  
  53. cost.expense_account
  54.  
  55.  

Related Posts

Posted in Oracle General Ledger | 2 Comments »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
2 Responses
  1. A Bowling Says:

    perfect piece of code – just what I was after! Thanks

  2. kavita Says:

    its cool!!

Leave a Comment

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