Oracle R12 Project Costing

Oracle R12 Project Costing involves capturing, processing, and accounting for costs associated with projects. Here's a breakdown of the key steps involved in Project Costing along with the important tables used in each step:

1.    Setup (Prerequisites)

        Before you start costing, ensure the project and related setups are completed:

    •  Project creation (PA_PROJECTS_ALL)
    •  Task creation (PA_TASKS)
    •  Expenditure types (PA_EXPENDITURE_TYPES ) & categories (PA_EXPENDITURE_CATEGORIES )
    •  Organization and employee assignments
2.    Transaction Sources Setup

        Define transaction sources (like Payroll, Payables, Inventory, etc.) to allow data import into Projects.
    • Transaction sources (PA_TRANSACTION_SOURCES)
3. Cost Collection (Data Entry or Integration)

        Enter time and expense charges via Expenditure Batches in the Projects module.          
    • PA_EXPENDITURE_ITEMS_ALL – Line-level cost data
    • PA_EXPENDITURE_BATCHES_ALL – Header-level data
    • PA_EXPENDITURES_ALL – Links batches and items
    • PA_COST_DISTRIBUTION_LINES_ALL – Cost distribution details
        Run following program to transfer expenditures from various modules into Oracle Projects.
    • PRC: Interface Supplier Costs 
    • PRC: Interface Expense Reports from Payables
    • PRC: Transaction Import 
                Interface Table Name  PA_TRANSACTION_INTERFACE_ALL

4.   Cost Distribution (Costing Engine)
        
        Once expenditure items are created, the system generates cost distribution lines based on setups.

    • PA_COST_DISTRIBUTION_LINES_ALL – Stores calculated costs
    • PA_CC_DIST_LINES_ALL – Cross-charge distribution lines (for inter-project/inter-org costs)
        Expenditure Processing
                Validate and process expenditures via:
    • PRC: Distribute Labor Cost
    • PRC: Distribute Usage and Miscellaneous Costs
    • PRC: Distribute Supplier Cost

       This distributes raw cost and burden cost to project tasks.

 5.    Cost Accounting

        Accounting entries are generated for project cost transactions, posted to GL.
                
    •  XLA_AE_HEADERS – Accounting event headers
    •  XLA_AE_LINES – Accounting lines
    •  XLA_EVENTS – Events triggering accounting
    •  XLA_DISTRIBUTION_LINKS – Links between source (PA) and accounting (XLA)

6.    Transfer to General Ledger
        
        Transfer the accounted transactions to the GL interface.

    • GL_INTERFACE – Interface table for GL
    • GL_JE_HEADERS, GL_JE_LINES – After posting, stores actual journal entries
7.    Reporting and Reconciliation
        
        Use views and reports to analyze costs, balances, and drill down to source transactions.

    • PA_PROJECTS_V – Project summary
    • PA_COST_DIST_LINES_V – Cost details
    • PA_EXPENDITURE_ITEMS_V – Expenditure item view
    

Comments

Post a Comment

Popular posts from this blog

Oracle APPS Creating Buy One Get One Free Modifier

Image
1.    Via Oracle Pricing Manager Responsibility 2.    Navigate > Price List > Price List Setup     Verify items (buy item and get item) are on the price list.     3.    Navigate > Modifiers > Modifiers Setup    At the header level create a Modifier Type of Promotion   4.    Modifier line info should be setup as follows:   Level   - Line Modifier Type   - Promotional Goods Automatic   - Checked Pricing Phase   - List Line Adjustment   Product Attribute - Item Number   Product Attribute value   - the item that the customer orders   Volume type   - Item Quantity                       Break type   - Recurring     Operator   - Between UOM   - select the appropriate unit of measure Value from ...
Read more

Oracle R12 Project Interface & APIs

Image
In Oracle Projects (PA) R12 , there are multiple ways to interface project-related data from external systems (like legacy systems, third-party tools, or spreadsheets). The method you choose depends on the type of data , volume , and level of control you need. 1.      Open Interface Tables (Standard Way)            Oracle provides interface tables for different types of project-related data. You insert data into                   these tables, then run Oracle’s concurrent programs to import the data.           Common Interface Tables:                      Best for: Medium to large data loads           Requires: Validation of setup values (status, types, orgs) 2.      Public APIs (PL/SQL-based)           Oracle provi...
Read more

SQL query to find pending PO for approval in Oracle EBS R12

SELECT   fu.user_name po_created_by,pha.org_id ,          (SELECT NAME || ' ( ' || short_code || ' )'             FROM hr_operating_units            WHERE organization_id = pha.org_id) ou_name,          pha.segment1 po_num, pha.revision_num, SUM(pla.quantity) po_qty, SUM(pla.unit_price) po_price,          pha.authorization_status, pha.creation_date po_creation_date,          wn.to_user, wn.subject, wn.original_recipient, wn.begin_date,          TRUNC (SYSDATE - wn.begin_date) no_days_pending,d.name Approval_path          ,wn.from_role forrwad_by,wn.notification_id,pha.po_header_id     FROM wf_notifications wn,          po_headers_all pha,          fnd_user fu,          po_lines_all pla, ...
Read more