Enterprise Resource Planning and Integrations BlogSpot

Skip to content

General Ledger

GL Flexfield Qualifiers in R12

  • by Yogesh Pachpute
  • Posted on October 30, 2018October 30, 2018
  • General Ledger

Flexfield Qualifier is “which segment qualifies for which attribute“. Each Segment can have one of the following Qualifying attributes attached to it. Some of them are mandatory others are optional. Cost Center: Usually assigned to Department Segment. This qualifying segment is used by Oracle Assets. Natural Account: This […]

Read More

Mapping between GL and XLA tables

  • by Yogesh Pachpute
  • Posted on February 7, 2018February 7, 2018
  • General Ledger

How Subledger Accounting (XLA) Tables are link to General Ledger (GL) Tables Assumption is GL Entry Summarization: Summarize (By GL Date or Period) JLT – Transfer to GL: Detail Expected behavior is: Summarize Entries at […]

Read More

GL_BALANCES

  • by Yogesh Pachpute
  • Posted on December 19, 2017December 19, 2017
  • General Ledger

Summary GL_BALANCES contains actual, budget, and encumbrance balances for detail and summary accounts. This table stores ledger currency, foreign currency, and statistical balances for each accounting period that has ever been opened. ACTUAL_FLAG is either […]

Read More

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

Posts navigation

Older posts

Categories

  • AR Reconciliation (8)
  • BI Publisher (3)
  • Cash Management (4)
  • Concurrent Processing in R12 (4)
  • Conversion (2)
  • Fixed Asset (23)
  • General Ledger (19)
  • GRC (5)
  • iExpense (21)
  • Linux Server Security and Maintenance (1)
  • Microsoft Windows Configurations (6)
  • Oracle Cloud Fusion Financial (11)
  • Oracle Database (2)
  • Oracle Fusion HCM (9)
  • Oracle Fusion HCM Technical (4)
  • Oracle Fusion Technical (9)
  • Oracle Installations (3)
  • Oracle Inventory (1)
  • Oracle SQL (4)
  • Order Management (1)
  • Payables (47)
  • Payables Period Close (10)
  • Payables Reconciliation (10)
  • Payments (29)
  • Payroll (1)
  • Perl and Unix Scripting (1)
  • Purchasing (4)
  • Receivables (16)
  • Receivables Period Close (15)
  • Receiving Subledger (3)
  • SubLedger Accounting (25)
  • 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 18 other followers

Calendar

Calendar

April 2021
M T W T F S S
 1234
567891011
12131415161718
19202122232425
2627282930  
« Apr    
Blog at WordPress.com.
Cancel

 
Loading Comments...
Comment
    ×