Results for “get_detail_indirect_costs”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

PA_COST_PLUS is the core Oracle Projects package responsible for cost-plus burdening and rate compilation in Oracle E-Business Suite 12.1.1 and 12.2.2. It manages the generation, maintenance, and retrieval of compiled multipliers associated with cost-plus burden structures and indirect rate schedule revisions. The package supports the full lifecycle of burden calculation: compiling organization rates and hierarchies, populating indirect cost amounts on expenditure items, computing burden amounts, and exposing indirect cost details for inquiry and reporting.

The user search term "new_org" corresponds directly to a notable internal variable in this package. The global G_MODULE variable is initialized to 'XXX' and is set to the value 'NEW_ORG' whenever the "Added New Organization" process is executed—that is, whenever the NEW_ORGANIZATION procedure is called. This flag forces the generation of compiled multipliers for the new organization across all burden schedule revisions, even when nothing in the revision has changed (i.e., when ready_to_compile_flag is neither 'Y' nor 'X'). This mechanism (tracked under bug 3005625) ensures that a newly added organization is not omitted from burden compilation simply because the parent revision was already flagged as compiled.

Key Procedures and Functions

The 39 documented program units divide into compilation, retrieval, and utility categories:

• Compilation: COMPILE_ORG_RATES compiles multipliers for a single organization; COMPILE_ORG_HIERARCHY_RATES extends this across an organization hierarchy; COMPILE_SCHEDULE and COMPILE_ALL drive full compilation of a rate schedule or all schedules; NEW_ORGANIZATION is the entry point invoked when an organization is added, setting G_MODULE := 'NEW_ORG'.
• Indirect cost retrieval: GET_EXP_ITEM_INDIRECT_COST, GET_INDIRECT_COST_SUM, GET_DETAIL_INDIRECT_COSTS, VIEW_INDIRECT_COST, and POPULATE_INDIRECT_COST calculate, summarize, display, and persist indirect costs on expenditure items.
• Burden calculation: GET_EXP_ITEM_BURDEN_AMOUNT, GET_BURDEN_AMOUNT, and GET_BURDEN_AMOUNT1 return burdened amounts for expenditure items and adjustments.
• Schedule and structure resolution: FIND_RATE_SCH_REV_ID, GET_RATE_SCH_REV_ID, GET_HIERARCHY_FROM_REVISION, GET_COST_BASE, GET_COST_PLUS_STRUCTURE, GET_ORGANIZATION_ID, and GET_COMPILED_SET_ID resolve the applicable revision, structure, cost base, organization, and compiled set identifiers.

Tables Accessed

The package reads and writes the principal burdening tables. PA_COMPILED_MULTIPLIERS and PA_IND_COMPILED_SETS store the compiled rate output. PA_IND_RATE_SCH_REVISIONS and PA_IND_COST_MULTIPLIERS define revisions and multiplier definitions. PA_COST_PLUS_STRUCTURES holds cost-plus structure definitions, while PA_COST_BASES, PA_COST_BASE_COST_CODES, PA_COST_BASE_COST_CODES_S, and PA_COST_BASE_EXP_TYPES define what costs the bases include. Expenditure-related tables (PA_EXPENDITURES_ALL, PA_EXPENDITURE_ITEMS, PA_EXPENDITURE_ITEMS_ALL, PA_EXPEND_ITEM_ADJ_ACTIVITIES) provide the transactional basis for burdening, and PA_COST_DISTRIBUTION_LINES / PA_COST_DISTRIBUTION_LINES_ALL receive distributed indirect cost results.

Usage Notes

PA_COST_PLUS is referenced by 16 other packages and is invoked primarily by the concurrent programs that compile burden schedules and generate indirect cost distributions, and by Oracle Projects forms displaying burdened amounts and indirect cost detail. The NEW_ORGANIZATION procedure is triggered from organization setup, and its interaction with G_MODULE = 'NEW_ORG' is the key behavior to understand when diagnosing why multipliers are recompiled despite an unchanged revision. Additional package-level state (such as G_GMS_ENABLED, tied to GMS implementation status, and the caching variables for impacted cost bases) means callers should treat package globals as stateful within a session. Custom code should call the documented API procedures rather than manipulating PA_COMPILED_MULTIPLIERS directly.