Thursday Apr 09, 2015

Webcast: Implement & Customize Transaction Account Derivation Rules (TADR) in AGIS

Webcast_icon.jpgImplement & Customize Transaction Account Derivation Rules (TADR) in AGIS

Date: April 22,, 2015 at 11:00 am ET, 8:00 am PT, 3:00 pm GMT, 8:30 pm, India Time (Mumbai)

This one-hour Advisor Webcast is intended for functional and technical users who would like to implement and customize intercompany Transaction Account Derivation Rules (TADR) in AGIS based on their business needs. Join us to learn required setups, the transaction process flow, basic troubleshooting and more!

Topics will include:

  • Transaction Account Derivation (TAD) Overview
  • Advantages of TAD
  • Required Setups
  • Transaction Process Flow
  • Basic Troubleshooting

Details & Registration via the My Oracle Support Community thread:  Advisor Webcast On 22-Apr-15: Implement & Customize Transaction Account Derivation Rules (TADR) in AGIS

Tuesday Mar 31, 2015

General Ledger Recommended Patch Collection Released Recently!

Recommended Patch Collections (RPC's) are released by Development periodically with the main purpose of providing a compact, reliable collection of relevant product patches that would address the main and most oftenly reported issues.

With a relatively small footprint, RPC's deliver solutions to address critical issues that could otherwise affect important business processes and flows.

Which Patches?

Patch 20251722:R12.GL.B: R12.1 General Ledger Recommended Patch Collection, February 2015

Patch 20255342:R12.RG.B: R12.1 General Ledger Recommended Patch Collection(FSG), February 2015 

What do they bring?

Solutions for multiple functional areas, addressing Bugs related to: 

  • Standard reports
  • Consolidation
  • Revaluation 
  • Financial Statement Generator Reports (FSG)
  • Drilldown
  • Gl Setup and Performance

I want more! 

Thank you, please review this document providing all the additional details you may need: 

General Ledger Recommended Patch Collection (GL RPC) Feburary 2015 (Doc ID 1982728.1

Be Proactive! Don't wait to have a problem, Prevent it from occurring!  

Monday Nov 25, 2013

Webcast: R12: Business Flow Accounting In Financials Accounting Hub (FAH)


ADVISOR WEBCAST: R12: Business Flow Accounting In Financials Accounting Hub (FAH)

Date:  December 12, 2013 at 11:00 am ET, 10:00 am CT, 9:00 am MT, 8:00 am PT

Oracle Financials Accounting Hub (FAH) is used to account for third party transactions. The Business Flow Accounting feature of FAH allows the accounting of downstream transactions (i.e., payments) to be derived based on the accounting of upstream transactions (i.e., invoices). Our discussion will focus on how to utilize Business Flow Accounting in FAH. This session is recommended for technical and functional users who have a basic understanding of the components FAH and want to learn about the Business Flow Accounting feature of FAH. We recommend reviewing Doc ID 1465987.1, Accounting for Transactions from a Custom Application Using R12 FAH, prior to the webcast.

Topics will include:

  •     Relevant Fundamentals of FAH
  •     How to use Business Flow Accounting feature of FAH to account for logically related third party transactions
  •     Demonstration of Business Flow Accounting
  •     Drill down to Subledger Accounting from General Ledger


For more details and how to register see Doc ID 1596331.1.

Thursday Sep 26, 2013

Webcast: Fundamentals of Oracle Financials Accounting Hub


Webcast: Fundamentals of Oracle Financials Accounting Hub

Date: October 10, 2013 at 11 am ET, 10 am CT, 9 am MT, 8 am PT

Curious about Oracle Financials Accounting Hub (FAH)? Join us live to discover the fundamentals and ask questions. This one-hour session is recommended for technical and functional users who would like to understand the basis of Oracle Financials Accounting Hub (FAH).


  • Introduction to Oracle Financials Accounting Hub
  • Financials Accounting Hub Setup
  • Troubleshooting.


For more details and how to register see Doc ID 1577621.1

Thursday Dec 13, 2012

Do you have Reconciliation Problems in Procurement between the Subledger and GL?

We are happy to announce the New Accrual Reconciliation Diagnostic & Troubleshooting Guide provided in Doc ID 1478292.1.  The Accrual Diagnostics script is designed to run when there is a reconciliation issue between subledger and GL and provides a user friendly report .  It was created to allow customers to run a single script to retrieve all data from various tables instead of having to run individual scripts. 

Doc ID 1478292.1 guides you through downloading and running the script, includes a full sample output in the attachments and gives steps for troubleshooting based on the report output.

Doc 1478292.1

We welcome your feedback for improvement of the Diagnostic. After visiting the note, click on the +/- icon in the note (shown in the sceenshot above) and provide us with your valuable comments!

Thursday Jun 28, 2012

What's the difference between General Ledger Transfer Program, Create Accounting and Submit Accounting?

In Release 12, the General Ledger Transfer Program is no longer used.

Use Create Accounting or Submit Accounting instead.

Submit Accounting spawns the Revenue Recognition Process.

The Create Accounting program does not.

So if you create transactions with rules, then you would want to run Submit Accounting Process

to spawn Revenue Recognition to create the distribution rows, which Create Accounting is then spawned to process to the GL.

Create Accounting

Submit Accounting

Short Name for Concurrent Program



Specific to Receivables



Runs Revenue Recognition automatically



Can be run real-time for one Transaction/Receipt at a time



Spawns the following Programs

1) XLAACCPB module: Create Accounting

2) XLAACCUP module: Accounting Program

3) GLLEZL module: Journal Import

1) ARTERRPM module: Revenue Recognition Master Program

2) ARTERRPW module: Revenue Recognition with parallel workers - could be numerous

3) ARREVSWP - Revenue Contingency Analyzer

4) XLAACCPB module: Create Accounting

5) XLAACCUP module: Accounting Program

5) GLLEZL module: Journal Import

Keep in mind, Reports owned by application 'Subledger Accounting' cannot be seen when running the report from Receivables responsibility.

You may want to request your sysadmin to attach the following SLA reports/programs to your AR responsibility as you will need these for your AR closing process:

XLAPEXRPT : Subledger Period Close Exception Report - shows transactions in status final, incomplete and unprocessed.

XLAGLTRN : Transfer Journal Entries to GL - transfers transactions in final status and manually created transactions to GL

To add reports/programs owned by application 'Subledger Accounting' (Subledger Period Close Exception Report and Transfer Journal Entries to GL_

Add to the request group as follows:

Let's use Subledger Accounting Report XLATBRPT: Open Account Balances Listing Report as an example.

Responsibility: System Administrator

Navigation: Security > Responsibility > Define

Query the name of your Receivables Responsibility and note the Request Group (ie. Receivables All)

Navigation: Security > Responsibility > Request

Query the Request Group

Go to Request Zone and Click on Add Record

Enter the following:

Type: Program

Name: Open Account Balances Listing


Responsibility: Receivables Manager

Navigation: Control > Requests > Run

In the list of values you should now see 'Open Account Balances Listing' report


Note: 748999.1 How to add reports for application subledger accounting to receivables responsibiilty

Note: 759534.1 R12 ARGLTP General Ledger Transfer Program Errors Out

Note: 1121944.1 Understanding and Troubleshooting Revenue Recognition in Oracle Receivables

Sunday Mar 25, 2012

Upcoming Webcast: “Supporting References” In Release 12 - SLA

ADVISOR WEBCAST: “Supporting References” In Release 12 - SLA
PRODUCT FAMILY: Receivables, Payables, General Ledger

April 18, 2012 at 14:00 UK / 15:00 CET / 06:00 am Pacific / 7:00 am Mountain / 9:00 am Eastern

"Supporting References” enables users to enter additional information for the “Journal Entry Header” and “Journal Entry Lines” that can be used for analytical purposes. This functionality was earlier known as “Analytical Criteria”. In 11i, additional data was interfaced to GL on the journals using “Descriptive Flexfields” whereas using this feature in R12, customers can create customized sources as ‘Supporting References’ and pass values into those sources from Subledgers like AP / AR / PA, etc.

  • Supporting References
  • Business information about a subledger journal entry at the header or line level
  • Establishing a subledger balance for a particular source value or combination of source values for a particular account
  • To assist with reconciliation of account balances
  • Financial and managerial analysis
A short, live demonstration (only if applicable) and question and answer period will be included. Oracle Advisor Webcasts are dedicated to building your awareness around our products and services. This session does not replace offerings from Oracle Global Support Services.

Current Schedule can be found on Note 740966.1
Post Presentation Recordings can be found on Note 740964.1

Welcome to the EBS Support Blog where Oracle insiders share news and information about EBS products including new releases, tips and tricks, troubleshooting guides, upcoming webcasts and links to EBS Communities.

Stay Connected



« July 2016