Monday Mar 31, 2014

Intercompany Program Passing Incorrect CREATED_BY Details to Interfaces

Audit Trails represent chronological recordings of event sequences and keep track of the users involved in specific processes, giving a clear view of all historical details for financial transactions. Details related to id's of the users creating or changing an accounting record are extremely relevant for auditing purposes.

What was reported?

A couple of bugs were discovered with Advanced Global Intercompany System (AGIS) transfers with incorrect CREATED_BY id's for certain processes.

What Processes Were Affected?

The following relevant programs that record user id's were reported to pass incorrect details to other programs and interfaces:

  • Intercompany Import Program (FUNXIMPB)
  • Manual Intercompany Transactions Sweep (FUNPRDSTSB)

Created_by_data sample

How to Address This Issue?

A patching solution is now available for both affected processes!

Keep a Clean Audit Trail linking to correct user id's, Patch Today!

Sunday Mar 30, 2014

New Feature! Balance Intercompany Journals Using Clearing Balancing Segment Value!

Intercompany transactions occur between two related legal entities or between groups in the same legal entity. In Release 12 of Oracle Applications these transactions are split into two different categories, INTERcompany and INTRAcompany.

Intracompany transactions can also be generated within a ledger where there is no legal entity context.

How Did This Work Before?

For 'no legal entity context', only Intracompany journals could be balanced using a clearing balancing segment value, based on Intracompany rules defined.

What's New?

  • R12.1+ Intracompany Rules user interface was enhanced, now allowing users to setup rules at ledger level (no legal entity context) even when the legal entities to balancing segment value associations are defined in the system
  • Balancing code was enhanced to use ledger level balancing rules instead of the Intercompany or Intracompany rules set up at legal entity level
  • Ability to derive different accounts based on the source and category , when ledger level balancing is used
  • Advanced Global Intercompany System(AGIS) functionality will not be affected by this new setup
  • Possible to toggle between old/new functionality through profile options

Fun balance profile option

Interested?  

Review How to Balance Intercompany Journals Using a Clearing Balancing Segment Value(BSV)? (Doc ID 1640618.1) for full details.

Friday Mar 28, 2014

Using Additional Currencies for Reporting Purposes in General Ledger

The need to report in additional currencies may occur at any time to satisfy legal, statutory or management supplementary reporting requirements. This is also a good option to be considered if you operate in countries with highly inflationary economies.

In General Ledger this can be accomplished using

  • Reporting Currencies - where the need is to simply maintain transactions in multiple currencies
  • Secondary Ledgers - where the main purpose is to represent transactions in a different accounting method, calendar, currency, chart of accounts

You may configure any of these setup alternatives to comply with your Generally Accepted Accounting Principles circumstances.

Add Secondary Ledger, Why The Primary Ledger is in Use?

qm1

But what if the business requirement comes after your Primary Ledger is already in use?

What would be the impact of such setup changes?

Would this change be permitted? 

The answer is Yes!

We Can accommodate such a change, find out How in

Impact of Newly Added Alternate Ledger Currency(ALC)/Secondary Ledger in Release12 (Doc ID 1479782.1)

This document provides a complete impact analysis for new installs or upgraded instances regarding

  • Business flows
  • Accounting and Reversals
  • Validations
  • Non-upgraded data options

We made it EASY to get meaningful balances in Any Currency, Anytime!


Wednesday Mar 26, 2014

Interested in E-Business Tax Integration with General Ledger?

Did you ever consider using Tax Journals feature in General Ledger but felt discouraged by the complex setup required, or simply did not know where to start?  We now have a simple solution for you!

A new Whitepaper was published recently on this topic: 

E-Business Tax Integration with General Ledger in Release 12 (Doc ID 1613279.1)!

This document aims to provide all required setup steps in E-Business Tax and General Ledger with the final purpose of creating Tax Journals in Oracle Applications.

Find step by step details with screenshots and examples regarding setup for:

  • Tax and Tax Regime
  • Tax Jurisdictions
  • Tax Rates and Rules
  • Transactions Processing in General Ledger
  • Useful Standard Reports
  • Table Level Details 

Sample of Tax Setup from the Whitepaper

E-Business Tax permits configuration of taxes according to local tax laws and international requirements. Integration of E-Business Tax with General Ledger allows uniformly using tax configurations for manual journals too.

Don't just READ about this setup, SEE it! 

Monday Mar 24, 2014

Get Help to Verify Your General Ledger Balances Anytime!

General ledger is the core of accounting information summarizing all financial transactions into accounts and gathering all data into balances that will be used to prepare financial statements or for various other reporting purposes. 

  • Maintaining correct balances is crucial for reporting purposes
  • Financial users may want to verify balances periodically to make sure they are accurate 

In order to gather information needed for analyzing problems related to General Ledger balances, in addition to the usual period closure activities such as running specific diagnostics from Doc ID 1416402.1 that would spot balances issues, you should also consider our Glbalfix - Gl Balances Corruption Script.

We have gathered all the useful information related to Glbalfix script, from installation to detailing all checks performed, preparation and execution along with potential errors and suggestions to spot and eliminate the root cause prior to performing any fix, in this new document:

Glbalfix: GL Balances Corruption Script - Master Note (Doc ID 1563019.2).

Once installed, the script can be safely submitted to run anytime in report mode, to verify the balances only - here's a sample output:

Glbalfix output sample

Remember, running the script does not mean it would change any data, you can use it just to verify the balances are correct! If a problem is detected, you decide further if and when to fix it!

Why don't you give Glbalfix a try?


Thursday Sep 26, 2013

Webcast: Fundamentals of Oracle Financials Accounting Hub

Webcast.jpg

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).

TOPICS WILL INCLUDE:

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

REGISTER.jpg


For more details and how to register see Doc ID 1577621.1

About

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

Twitter

Search

Archives
« April 2014
SunMonTueWedThuFriSat
  
1
5
6
12
13
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today