OracleAppsBlog

A day in the life of an Oracle Applications Consultant

Sunday, November 29, 2020

Setting up Control Accounts and Restricting GL Manual Journal Posting

One of the options to consider when setting up the nominal segment within your Chart of Accounts is what your Third Party Control Account values should be. Before doing this its critical to understand what options are available and the impact of selecting these. Hence, I thought I’d put together a brief post explaining these.

The image below depicts where within the value set you would select the appropriate option and is followed by an explanation of the resultant impact.

Third Party Control Account Options

General Ledger journals can be entered directly in that module or be received from a Subledger. Since control accounts should accurately reflect the movements in a related Subledger its ideal that we only allow postings to these that are sourced from the Subledger. Hence, minimising the number of manual postings to a control account is recommended and makes Subledger to General Ledger Control Account reconciliation a lot simpler.

Whichever option is chosen below will determine the allowed journal source for a GL nominal account and the level of restriction to be applied:

1. Customer Control Account - only journal postings sourced from Accounts Receivable can be posted to this nominal.
2. No - either this is not a control account or you want to allow any type of journal to be posted to this account.
3. Restrict GL Manual Journals - journals with a source of Manual which are those entered directly into General Ledger will not be allowed. This provides more flexibility in that any Subledger can post to this account.
4. Supplier Control Account - only allow journal postings sourced from Accounts Payable can be posted to this nominal.
5. Third Party Control Account - only allow journal postings sourced from Accounts Receivable or Payables can be posted to this nominal.

Inherit Segment Values

Following any updates to a value set its important to point out that you should run the Inherit Segment Value Attributes program. This will propagate the attributes of a segment value to all account combinations that contain that segment value. Note that selecting the Create Execution Report option when running this program produces a report which lists each updated account for comparison including original and current attributes. Download an example of the Segment Value Inheritance Execution Report

Saturday, November 28, 2020

Oracle Fusion Financials R13 -  Reports and Analyses

Perhaps the most useful report listing I always have at my disposals is the one Oracle delivers for Financials. It lists all the reports currently available for the following modules: -

• Accounting Hub
• Advanced Collections
• Assets
• Budgetary Control
• Cash Management
• Expenses
• Financials for EMEA
• Financials for Asia/Pacific
• Financials for the Americas
• General Ledger
• Intercompany Accounting
• Payables
• Payments
• Receivables
• Revenue Management
• Tax

Furthermore it classifies the reports accounting to type, sub type and run type and provides catalogue location, description and report output samples.

Download the Oracle Financials Cloud Release 13 Reports and Analyses Listing which covers reports available from Release 12 up to R13.18A

Wednesday, November 25, 2020

Oracle Fusion Procurement R13 -  Reports and Analyses

With each major release Oracle produces a seeded listing of reports. Periodically with the quarterly updates one might see a a few new reports appear. I always find it quite useful to have this to hand when working with clients as it is searchable and you can filter by specific modules. Download the Oracle Procurement Cloud Release 13 Reports and Analyses Listing which outlines what’s available for Sourcing, Suppliers, Purchasing, Self Service Procurement and Purchasing.

Wednesday, October 11, 2017

Oracle OpenWorld 2017 Keynotes and Presentations

If you missed out on Oracle OpenWorld 2017 or simply want to catch up on the plethora of keynotes and sessions that were available then the session catalog is a good place to start as you can download presentations there. You can search by keyword or apply any of the following filters to view pertinent content: -

• Day
• Emerging Technologies for Business
• IT Infrastructure
• Intelligent Cloud Applications
• Integrated Cloud Platform
• SMB (Small to Medium Business)
• Session Type

Furthermore, there’s a pretty good library of on-demand keynotes where you can watch highlights or full length replays.

Personally, I’m going to start making my way through this content with a view to highlighting some of the best picks here.

Sunday, October 08, 2017

Learn Oracle Fusion through the Help

One of the challenges with learning Oracle Fusion is having access to an environment. I used to have Oracle E-Business Suite installed on a very powerful laptop. However, with cloud based solutions the likelihood of you be able to run such a system on your own hardware is very low. Regardless, the Oracle Fusion Help which is accessible online is very good starting point for persons just getting to know the system.

You’ll find help for each of the following modules

• Financials
• HCM
• Procurement
• Projects
• Risk Management
• Sales
• Service
• Supply Chain

Within each module you can see the help sorted by task and product. Furthermore there is role specific help and numerous videos

Happy Learning…….