Enterprise Resource Planning and Integrations BlogSpot

Skip to content

General Ledger

The Link between GL to SLA and reference columns in GL

  • by Yogesh Pachpute
  • Posted on November 2, 2017November 2, 2017
  • AR Reconciliation

The Link between GL to SLA and reference columns in GL_IMPORT_REFERENCES Since there is always a one-to-one correspondence between XLA_AE_LINES and GL_IMPORT_REFERENCES, they are used to link GL and the subledgers.  GL_IMPORT_REFERENCES.gl_sl_link_id => XLA_AE_LINES.gl_sl_link_id  GL_JE_BATCHES.group_id => […]

Read More

How to Reconcile Account Payable with GL trial balance

  • by Yogesh Pachpute
  • Posted on October 4, 2017October 4, 2017
  • General Ledger

How to Reconcile Account Payable with GL trial balance Run the Accounts Payable Trial Balance for a particular period which you have already closed (or) intend to close in both AP and GL. Now Run […]

Read More

Payroll Journal Entries

  • by Yogesh Pachpute
  • Posted on August 11, 2017August 11, 2017
  • General Ledger

Payroll journal entries are used to record the compensation paid to employees. These entries are then incorporated into an entity’s financial statements through the general ledger. The key types of payroll journal entries are: Initial […]

Read More

Asset Trace or Single Asset Diagnostics

  • by Yogesh Pachpute
  • Posted on July 5, 2017July 5, 2017
  • Fixed Asset

Asset Trace or Single Asset Diagnostics Run the program “Generate Asset Trace” FA responsibility:  Other > Requests > Run  Generate Asset Trace                  It will span following two […]

Read More

How to Setup the New Manage Accounting Exception Program (Sweep) in Receivables?

  • by Yogesh Pachpute
  • Posted on May 5, 2017May 5, 2017
  • General Ledger

Goal: How can I setup the new Consolidated Review and Manage Accounting Exception Program in Receivables? Also referred to as the Sweep program. Solution: Please perform the following: For Release 12.1, in order to enable […]

Read More

How to disabled GL Account and All associated GL Code Combinations.

  • by Yogesh Pachpute
  • Posted on April 25, 2017January 4, 2018
  • General Ledger

Execute Following action plan to disable GL Account and all associated GL code combinations. Query GL Account Value Set through Flexfield à Validation à Values Then uncheck “Enabled” check box and save the changes Then […]

Read More

API to create Code Combination and get CCID

  • by Yogesh Pachpute
  • Posted on April 21, 2017
  • General Ledger

It may not always be the case that Account codes will be created by user from the front end. There may be scenarios sometimes where we need to have programs that will be creating the code combinations. […]

Read More

API to Get and Create GL Code Combination Id

  • by Yogesh Pachpute
  • Posted on April 21, 2017August 23, 2017
  • General Ledger

1) Key Assumption is “Allow Dynamic Inserts” should have been enabled for GL Accounting Flexfield Structure One May have to use apps initialize, but mostly not required if called from concurrent program. 1 2 3 […]

Read More

GL Daily FX Rate Upload

  • by Yogesh Pachpute
  • Posted on April 17, 2017April 17, 2017
  • General Ledger

Following are 3 key programs that can be used to upload GL Daily Conversion Rates. A) XXCB FX Rates Data Load Program B) XXCB FX Rates Validation Procedure Program C) Program – Daily Rates Import […]

Read More

Query to write Custom Invoice And Payment Report that matches with GL Liability Account Balance, GL Prepayment Account Balance, Expense Accounts etc.

  • by Yogesh Pachpute
  • Posted on April 12, 2017August 11, 2017
  • General Ledger

Query to write Custom Invoice And Payment Report that matches with GL Liability Account Balance, GL Prepayment Account Balance, Expense Accounts etc. 1 2 3 4 5 6 7 8 9 10 11 12 13 […]

Read More

Posts navigation

Older posts
Newer posts

Categories

  • AR Reconciliation (8)
  • BI Publisher (3)
  • Cash Management (4)
  • Cloud Enterprise Structure (2)
  • Concurrent Processing in R12 (4)
  • Conversion (2)
  • Cost Management (1)
  • Fixed Asset (23)
  • General Ledger (26)
  • GRC (7)
  • iExpense (21)
  • Linux Server Security and Maintenance (1)
  • Microsoft Windows Configurations (6)
  • Oracle Cloud Cutover Tasks (1)
  • Oracle Cloud Fusion Financial (12)
  • Oracle Cloud Security (2)
  • Oracle Database (2)
  • Oracle Fusion HCM (10)
  • Oracle Fusion HCM Technical (5)
  • Oracle Fusion Technical (10)
  • Oracle Installations (3)
  • Oracle Inventory (2)
  • Oracle SQL (4)
  • Order Management (2)
  • Payables (47)
  • Payables Period Close (10)
  • Payables Reconciliation (10)
  • Payments (29)
  • Payroll (1)
  • Perl and Unix Scripting (1)
  • Purchasing (4)
  • Receivables (17)
  • Receivables Period Close (15)
  • Receiving Subledger (3)
  • RMCS (1)
  • SubLedger Accounting (26)
  • Supply Chain Managment (1)
  • TCA – DQM (1)
  • Uncategorized (2)
  • Useful SQL Scripts (4)
  • Workday (7)

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 37 other subscribers

Calendar

Calendar

June 2023
M T W T F S S
 1234
567891011
12131415161718
19202122232425
2627282930  
« Feb    
Blog at WordPress.com.
  • Follow Following
    • Enterprise Resource Planning and Integrations BlogSpot
    • Join 37 other followers
    • Already have a WordPress.com account? Log in now.
    • Enterprise Resource Planning and Integrations BlogSpot
    • Customize
    • Follow Following
    • Sign up
    • Log in
    • Report this content
    • View site in Reader
    • Manage subscriptions
    • Collapse this bar
 

Loading Comments...