Earned Value, Schedule Performance Index, CPI(Cost performance Index) formale

Earned Value#

Planned Value The total budgeted cost up to the analysis date.
Earned Value Calculated for the task using the following formula:

Earned Value = Current Budget x Physical Percent Complete

If the physical percent complete rollup method for the workplan is Effort, then earned value is based on effort. Otherwise, earned value is based on cost. Depending on the hysical percent complete rollup method, Oracle Projects uses either the baseline planned effort or cost for the task to determine the Current Budget.
Schedule Performance Index

Calculated for the task using the following formula:

Schedule Performance Index = Earned Value / Planned Value

Cost Performance Index

Calculated for the task using the following formula:

Cost Performance Index = Earned Value / Actual Cost

If the values are null, after running the project performance reporting requests(jobs) looks like Earned value is not getting calculated, cross check the budgets, physical percent complete complete rollup method for the workplan

R12 Tax setups

Step 1: Create the Tax RegimeThe tax regime is the highest/ultimate level that taxes are rolled up to, typically, a specific country. In this step, the Controls and Defaults must be set. The Control section outlines 4 options. Once the tax is made live, the control options cannot be changed.The Defaults section will default as applicable to the tax, status, jurisidiction, and tax rate levels, but they can be changed at each level.Step 2: Create the TaxOne Tax Regime can have multiple taxes defined under it. The tax type, e.g. sales, VAT, use, is determined when the tax is set up. Taxes can be set up by geography type, which allows for taxes at different levels.. For example, in the US, there is can be a tax levied at the State level, one at the County level, and one at the City level.Step 3: Create the Tax StatusThis is used primarily in the UK to define reduced rate, zero rate, etc. taxes. All taxes must have at least one tax status defined, and one of those must have the "Set as Default Status" option checked.Step 4: Create the Tax JurisdictionA tax jurisdiction is a geographic area for which a tax is levied, e.g.Colorado, California, Florida, El Paso County, Los Angeles.There must be at least one Tax Jurisdiction for each Tax Status with the "Set as default Tax Jurisdiction" selected and the "Default Effective Date" supplied.Step 5: Create the Tax RateCreate specific tax rates to be applied for a geography. There must be at least one default tax rate. The tax accounts are also set up in this step.Step 6: Define Tax RulesSet defaults for the following rule types:Place of Supply, Registration, Taxable Basis, Calculate Tax AmountsStep 7: Make the Tax Live for TransactionsReturn back to the Tax created in step 2, and select the Make Tax Available for Transactions option. If it is not available to be checked, the tax is not set up correctly. Any missed setups will need to be completed before this can be setup.

Journal Line Reconciliation

Journal Line Reconciliation
Journal Line Reconciliation enables you to reconcile journal lines that should net to zero, such as suspense accounts, or payroll and tax payable accounts for countries, such as Norway, Germany, or France.
In R12, we’ve made many improvements to intercompany accounting. R11i’s Global Intercompany System (GIS) has been replaced with an exciting new product called Advanced Global Intercompany System (AGIS). We also extended intercompany balancing support to include encumbrance journals.

SubLedger Accounting Advantages

•Internal control and compliance with multiple accounting policies through user-defined accounting rules
•Single source of truth for all subsystem accounting activity with a common data model and repository
•Accounting, reconciliation and reporting facilitated by centralized data model
•Streamline closing process with common posting engine
•Auditable and transparent entries accessible with full drilldown


----Transaction Level Compliance-----

•National Daily Journal Requirements
•Internal Control: Central Definitions, Eliminate overrides
•Policy Enforcement in Volume Processing
•Transparent Accounting Rules
•Debits & Credit at the point of the event
•Automate Foreign Operation adjustments
•ReconciliationPlatform

SLA ties with GL and keeps the financial flow intact and makes simpler to auditors as well

Budgets in Projects

f you use the Forms for budgeting you can setup various budget types, like approved cost budget, proposal cost plan, funded revenue budget, forecast cost, etc... For each one of those types you have the same functionality, and budget entry is just keying in the quantities and amounts on the budget form. You could automate the calculation of burdened cost based on the entry of raw cost amount, or that based on quantity. Such automation is done using the budget client extension, and that extension is called immediately as you key in the line value. With Oracle Project Management (PJT) a new entity was introduced called Financial Plans. A financial plan type is an enhancement of a budget type. The entry of financial plan is done on HTML pages. You could set up financial plans for Firm annual budget, for forecast, for funded revenue etc. With PJT Oracle also delivered a concurrent program called Forecast. That program can generate the plan amounts and insert them on the financial plan defined as parameter. Such calculation functionality is not supported on the Form based budgets.

Setting up Tax in R12 Payables

Step 1: Create the Tax Regime
The tax regime is the highest/ultimate level that taxes are rolled up to, typically, a specific country. In this step, the Controls and Defaults must be set. The Control section outlines 4 options. Once the tax is made live, the control options cannot be changed.
The Defaults section will default as applicable to the tax, status, jurisidiction, and tax rate levels, but they can be changed at each level.
Step 2: Create the Tax
One Tax Regime can have multiple taxes defined under it. The tax type, e.g. sales, VAT, use, is determined when the tax is set up. Taxes can be set up by geography type, which allows for taxes at different levels.. For example, in the US, there is can be a tax levied at the State level, one at the County level, and one at the City level.
Step 3: Create the Tax Status
This is used primarily in the UK to define reduced rate, zero rate, etc. taxes. All taxes must have at least one tax status defined, and one of those must have the "Set as Default Status" option checked.
Step 4: Create the Tax Jurisdiction
A tax jurisdiction is a geographic area for which a tax is levied, e.g.Colorado, California, Florida, El Paso County, Los Angeles.
There must be at least one Tax Jurisdiction for each Tax Status with the "Set as default Tax Jurisdiction" selected and the "Default Effective Date" supplied.
Step 5: Create the Tax Rate
Create specific tax rates to be applied for a geography. There must be at least one default tax rate. The tax accounts are also set up in this step.
Step 6: Define Tax Rules
Set defaults for the following rule types:
Place of Supply
Registration
Taxable Basis
Calculate Tax Amounts
Step 7: Make the Tax Live for Transactions
Return back to the Tax created in step 2, and select the Make Tax Available for Transactions option. If it is not available to be checked, the tax is not set up correctly. Any missed setups will need to be completed before this can be setup.

Data Derivation for Auto Invoice

1. Date Derivation In AutoInvoice: How It Works
During the process of AutoInvoice you can enter the General Ledger (GL) date and the Transaction date for a particular transaction explicitly in the relevant columns of the RA_INTERFACE_LINES_ALL table or you can allow the AutoInvoice process to derive the dates.If the dates are provided, AutoInvoice will typically use them. There are a few scenarios where dates cannot be provided as input parameters; these scenarios are discussed in section 2.e titled GL Date Validation.If the dates are not provided, they will be derived. Date Derivation of the General Ledger date and Transaction date during the process of AutoInvoice depends on the following:
1. The columns that are populated in the RA_INTERFACE_LINES_ALL table, namely
· GL_DATE
· TRX_DATE
· SHIP_DATE_ACTUAL
· SALES_ORDER_DATE
· RULE_START_DATE
2. Selection of the Derive Date Option in the Accounting Information Tab of the Transaction Sources window.3. Whether or not Invoicing Rules and Accounting Rules are used.4. Setting of the GL Date in a Closed Period option in the AutoInvoice Options tab of the particular Transaction Batch Source.5. Default Date entered while submitting the AutoInvoice Program.Once imported as a transaction in receivables, the GL date used by AutoInvoice is stored in the table.column: RA_CUST_TRX_LINE_GL_DIST_ALL.GL_DATE.