Performance Tuning

Database Metrics and Alerts:

Metrics and Statistics

Histograms

Database Alerts - DBA_THRESHOLDS gives you the threshold settings defined for the instance

Baselines:

Real-time Operation Monitoring:

Oracle Documentations

TSD / TDD Guidelines

• Mapped to its FSD / BRD.
• Data Flow Diagram
• Process Flow Diagram
• ER Diagram linking all the tables involved.
• Use Cases
• Assumptions / Dependencies / Open Issues needs to be updated regularly.

Oracle Finance

Chart of Accounts:
Chart of Accounts (COA) determines how your accounting information is collected, categorized, and stored for reporting purposes. In Oracle Financials, all accounts are identified by a unique Accounting key Flexfield combination, which is your COA structure. The Accounting Flexfield (AFF) consists of multiple segments, such as those for company, cost center, and account. One full AFF is called a combination.You assign each account the qualifier of asset, liability, owner's equity, revenue, or expense.

Subledger Accounting:
Sub Ledger Accounting (SLA) introduced in Release 12, provides a common repository of all your accounting information.

Just as Oracle General Ledger stores balances and journals, Subledger Accounting stores subledger balances and subledger journals for all of your subledgers that require accounting.

In Release 11i the transactions and distributions represented the accounting. In Release 12 however, distributions on transactions in subledgers are considered to be the default accounting and should therefore not be used for reconciliation purposes. The reason is that subledger accounting enables you to change the accounting for transactions so it is different from the default accounting. Therefore, the subledger accounting becomes the single source of truth for accounting reconciliations.

Things to Ponder:

1. Using more GL account KFF Segments doesn't affect the performance as the application uses the CCID (Code Combination ID) and not run the processes via the concatenated segments. However more the segments the more GL manual entries.

Fixed Assets

Unique 'Tag Numbers' are assigned to a each asset in FA...Incase you need to group assets use 'Asset Key'.

Q. Why do I have journal entries for zero dollar amounts? (i.e. Debit 0 Credit 0)
A: The expense segment is part of a single distribution row which also contains the asset's owner and location.  Changes to any one of these items will result in the creation of a new distribution.  If a change is made in the location or owner, journal entries are posted to reflect the new distribution, even though there has been no accounting impact (thus the zero dollar accounting entries).

Q. 
A: 

DBA Basics

• View common db properties

SELECT Property_Name, Property_Value, Description
FROM Database_Properties

• Oracle Apps Release/Version from backend?

SELECT Release_name FROM Fnd_Product_Groups

• Multi-Org enabled?

SELECT Multi_Org_Flag FROM Fnd_Product_Groups

• Multilingual?

SELECT Multi_Lingual_Flag FROM Fnd_Product_Groups

• MRC Implemented?

SELECT Multi_Currency_Flag FROM Fnd_Product_Groups

• How do I find the tablespace name where I need to create the table in xyz schema?
  

Get the tablespace name using the below query:
SELECT * FROM dba_users WHERE username = 'xyz'
Tablespace details if required, can be viewed from dba_tablespaces table.

Oracle Value Chain Planning

Oracle Value Chain Planning (earlier called Oracle Advance Planning and Scheduling) is an integrated set of mules which enables companies to efficiently design, plan and service their value chains from 'factory to shelf'.

Fusion

Overview
Fussion Apps will fully leverage ADF for the UI