Actuals API
Oracle Projects also provides a package that contains an API to give you additional control for custom summarization reporting. You can use the API to get amounts by a specific Oracle Projects or Oracle General Ledger period, a specific range of Oracle Projects or Oracle General Ledger periods and by various transaction attributes as follows:
- Project, task, and resource combinations
- All levels of the project work breakdown structure
- Oracle Projects or Oracle General Ledger period
- Oracle Projects or Oracle General Ledger period ranges
- Various transaction attributes from the following:
- non-labor resource organization
- event type classification
- expenditure type classification
The name of the package is pa_accum_api, and the name of the procedure is get_proj_accum_actuals. You can get actual amounts only if you successfully ran the Update Project Summary process for the project.
This procedure returns the actual cost, revenue, and commitment amounts by:
Package.Procedure
The following table lists the parameters that Oracle Projects provides for the API, pa_accum_api.get_project_accum_actuals. (See files PAAAPIS.pls and PAAAPIB.pls under the admin directory.)
Additional Information about Parameters
Using the Identifier for the Task
When retrieving project-level amounts, this parameter can be null.
Using the Identifier for the Resource
When retrieving aggregate project or task amounts, this parameter can be null.
Using the Identifier for the Period Type
You use this parameter to tell the procedure that you are expect summary amounts by either Oracle Projects or Oracle General Ledger period. Allowable values are as follows:
- 'P' for Oracle Projects Period
- 'G' for Oracle General Ledger Period
Using the From-Period Names and To-Period Names
You must pass these two parameters to the procedure with the following constraints:
- If the period type is Oracle Projects Period, then both period names must be Oracle Projects period names. Otherwise, Oracle General Ledger period names must be used for both parameters
- If you are retrieving amounts for one period, you must specify the same period name for both parameters
- For a range of periods, the from period name must be earlier than the to period name
Custom Reporting Strategies for Summarization API
To see how the API can be used for reporting, refer to the following Oracle Projects reports:
- Revenue, Cost, Budgets by Resources (Project Level)
- Task - Revenue, Cost, Budgets by Resources
