Search Results copy_actuals1

Overview

PAXBUBDB is a concurrent program within the Oracle Projects (PA) module of Oracle E-Business Suite, exposed to end users under the name PRC: Copy Actuals. Its documented purpose is to copy actual cost transactions into a budget or budgetary baseline context within Oracle Projects. The program is delivered as an enabled, standard Oracle EBS component and is available in both the 12.1.1 and 12.2.2 releases. Organizations running Project Costing and Project Budgeting leverage this program when they need to establish or refresh a budget version using actual expenditures already recorded against a project, rather than re-keying or re-importing cost data from an external source.

The object belongs to the PA - Projects product family, which encompasses project definition, budgeting, costing, billing, and resource management. Because the program operates against existing actual cost transactions, it is typically invoked after cost distribution and accounting processes have populated the project cost tables.

Execution Details

The documented execution metadata for PAXBUBDB is as follows:

• User-facing name: PRC: Copy Actuals
• Product: PA - Projects
• Enabled: Yes
• Execution Method: PL/SQL Stored Procedure
• Argument Method: Standard
• Executable: PAXBUBDB
• Execution Filename: pa_budget_core1.copy_actuals1
• Short Name / Executable User Name: PAXBUBDB
• Subroutine Name: (not specified in the documented metadata)

The Execution Filename pa_budget_core1.copy_actuals1 identifies the PL/SQL package and procedure invoked at runtime. This is the internal entry point that performs the copy logic; administrators should not invoke the package procedure directly but rather submit the concurrent program through the standard request submission interface.

How to Run

Users submit PRC: Copy Actuals through the standard Oracle EBS Submit Request (SRS) window, typically navigated from the Projects responsibility under Others > Requests > Run. Because the Argument Method is Standard, the program presents its parameters in the standard concurrent program parameter dialog.

Although the excerpted metadata does not enumerate the specific parameter list, programs of this class in Oracle Projects generally require a small set of mandatory arguments. Typical parameters include the source project or project range, the source and target budget versions or budget types, the period or date range delimiting which actual costs are eligible for copying, and an indicator controlling whether existing target records should be replaced or appended. Users should confirm the exact parameter prompts against their instance, since the labels and validation logic can vary by patch level and by configuration of descriptive flexfields and project-related value sets.

After submission, the request log and output file should be reviewed for error messages, particularly those relating to period status, missing budget types, or projects that are not eligible to receive copied actuals. Corrective action before resubmission avoids partial or duplicate budget lines.

Related Objects

The Copy Actuals process interacts closely with the broader Oracle Projects budgeting and costing architecture. Frequently associated objects include:

• Budget entry and baseline programs in the PA_BUDGET package family, which share the pa_budget_core1 package used by this executable.
• Project Costing transactions tables such as PA_COST_DISTRIBUTION_LINES_ALL and PA_TRANSACTION_INTERFACE_ALL, from which actual cost data is read.
• Budget line tables including PA_BUDGET_LINES and PA_BUDGET_VERSIONS, which receive the copied amounts.
• Related concurrent programs such as PRC: Generate Draft Revenue, PRC: Distribute Costs, and other budget-oriented requests that operate on the same project structures.
• Project Budgeting inquiry screens and reports used to verify the resulting budget lines after the process completes.

Administrators troubleshooting the program should inspect the concurrent request log, the PA output file, and the underlying package body for pa_budget_core1.copy_actuals1 to confirm behavior at the specific patch level deployed.