Enterprise Resource Planning and Integrations BlogSpot

Skip to content

General Ledger

How to enable auditing on Financial Structure (COA, Trees, Value Sets)

  • by Yogesh Pachpute
  • Posted on February 2, 2023February 16, 2023
  • General Ledger

Requirements: To enable auditing for following GL configurations Analysis: What are tables for key GL Configurations: Solution1: Enable audit using “Manage Audit Policies” As the product keeps evolving, evaluate the Audit Report for the Value […]

Read More

Cloud GL to ESSBase Cubes – How to Ensure Successful GL Posting

  • by Yogesh Pachpute
  • Posted on August 4, 2022August 5, 2022
  • Cloud Enterprise Structure

Reference: Checklist to Ensure Successful Posting (Doc ID 2158295.1)

Read More

Cloud GL to ESSBase Cubes – Setup Changes which require Cube maintenance

  • by Yogesh Pachpute
  • Posted on August 4, 2022August 5, 2022
  • Cloud Enterprise Structure

Reference: Check List – Setup Changes which require Cube maintenance (Doc ID 2158731.1)

Read More

Consolidation in Oracle GL ERP and FCCS EPM Cloud

  • by Yogesh Pachpute
  • Posted on May 20, 2022May 20, 2022
  • General Ledger

Oracle Financials Cloud streamlines consolidation process by addressing both accounting transformation and financial reporting challenges. Oracle Financials Cloud provides an excellent Reporting Platform for Real-time multidimensional, self-service reporting and analytics. You perform Real-time reporting on […]

Read More

Protected: Conversion, Revaluation, Translation, Elimination, Consolidation: Reporting only & Balance Transfer

  • by Yogesh Pachpute
  • Posted on May 20, 2022May 20, 2022
  • General Ledger

There is no excerpt because this is a protected post.

Read More

RMCS – Order Management Integration

  • by Yogesh Pachpute
  • Posted on May 13, 2022May 13, 2022
  • Cost Management

Storyline and Personas: The demo flow begins with a sales order being entered into Order Management. We then follow the transaction through to Accounts Receivable, Revenue Management, Inventory, and Cost Accounting. In RMCS we will […]

Read More

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

Posts navigation

Older 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 (25)
  • 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 35 other subscribers

Calendar

Calendar

March 2023
M T W T F S S
 12345
6789101112
13141516171819
20212223242526
2728293031  
« Feb    
Blog at WordPress.com.
  • Follow Following
    • Enterprise Resource Planning and Integrations BlogSpot
    • Join 35 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...