Showing posts with label Project Accounting. Show all posts
Showing posts with label Project Accounting. Show all posts

INFO: Project Accounting main Interfaces

PRC: Interface Assets to Oracle Assets (PAXCPCAL)
The Interface Assets process sends valid asset lines to Oracle Assets to become fixed assets. The process creates one mass addition line in Oracle Assets for each asset line in Oracle Projects, assigning the asset information you entered for the CIP asset to the mass addition line in Oracle Assets. Interface the costs to General Ledger before you run the Interface Assets process.

PRC: Interface Cross Charge Distributions to General Ledger (PACCGLTR)
The process identifies the cross charged transactions that fit the parameters you specify and then interfaces the cross charged distributions to General Ledger.

PRC: Interface Expense Reports from Payables(PAAPIMP)
This process gets expense report information from Payables. This process creates pre- approved expense report batches from expense report information entered in Self-Service Expenses or in the invoices window (in payables).

PRC: Interface Expense Reports to Payables (PATTER)
The Interface Expense Reports to Payables process collects all eligible expense reports, including adjustments, in Oracle Projects and interfaces them to the Oracle Payables interface tables.

PRC: Interface Intercompany Invoices to Receivables (PATTAR-IC)
This process collects all eligible intercompany invoices in Oracle Projects and interfaces them to the Oracle Receivables interface tables.

PRC: Interface Invoices to Receivables (PATTAR)
This process collects all eligible draft invoices in Oracle Projects and interfaces them to the Oracle Receivables interface tables. The process also maintains the project balances of unbilled receivable and unearned revenue and creates accounting transactions for these amounts.

PRC: Interface Labor Costs to General Ledger (PAGGLT)
This process collects all eligible labor costs in Oracle Projects and interfaces them to the Oracle General Ledger interface tables. The interface process also determines the liability account for the labor costs.

PRC: Interface Revenue to General Ledger (PATTGL)
This process collects all eligible revenue in Oracle Projects and interfaces it to the Oracle General Ledger interface tables. This process also maintains project balances for unbilled receivables and unearned revenue and creates accounting transactions for these amounts.
PRC: Interface Supplier Costs (PAAPIMP_SI)

The PRC: Interface Supplier Invoices from Payables process retrieves the following items and interface them to Oracle Projects: All eligible posted, project related supplier invoices from Oracle Payables, Tax lines for project related intercompany invoices. The process first populates the Transaction Import Interface table, creating a cost distributed expenditure item and cost distribution line for each invoice distribution line, and expenditure for each invoice.

PRC: Interface Supplier Invoice Adjustment Costs to Payables (PAVTVC)
This process collects all eligible supplier invoice adjustment costs in Oracle Projects and interfaces them to Oracle Payables. The process determines the liability account for the supplier invoice costs.
PRC: Interface Total Burdened Cost to GL PACTFTBC This process collects all eligible total burdened distribution lines in Oracle Projects and interfaces them to Oracle General Ledger.

PRC: Interface Usage and Miscellaneous Costs to General Ledger (PASGLT) This process collects all eligible cost distribution lines of the following transactions in Oracle Projects and interfaces them to the Oracle General Ledger interface tables: usage costs, miscellaneous transaction costs, burden transaction costs, and Inventory and WIP transactions not already costed or accounted. The interface process also determines the liability account for these costs.

PRC: Transaction Import PAXTRTRX Transaction Import
This is an open interface that enables you to load transactions from external cost collection systems into Oracle Projects. Transaction Import creates pre-approved expenditure items from transaction data entered in external cost collection systems.

INFO: Project Accounting main tables

Here are the below are important Oracle Project Accounting tables

  • PA_PROJECTS_ALL
    • Information about projects
  • PA_AGREEMENTS_ALL
    • Customer contracts that serve as the basis for work authorization
  • PA_BILL_RATES_ALL
    • Information about bill rates and markups of standard bill rate schedules
  • PA_BILLING_ASSIGNMENTS_ALL
    • Assignments of billing extensions to a project type, project, or task
  • PA_COST_DISTRIBUTION_LINES_ALL
    • Information about expenditure item cost distribution
  • PA_CUST_REV_DIST_LINES_ALL
    • Information about expenditure item revenue distribution
  • PA_DRAFT_INVOICE_DETAILS_ALL
    • Intercompany invoice details for cross charged transactions
  • PA_DRAFT_INVOICES_ALL
    • Information about draft invoices generated for projects
  • PA_DRAFT_REVENUES_ALL
    • Information about draft revenue generated for projects
  • PA_EXPENDITURE_COST_RATES_ALL
    • Cost rates for non-labor expenditure types
  • PA_EXPENDITURE_GROUPS_ALL
    • Groups of pre-approved expenditures
  • PA_EXPENDITURE_ITEMS_ALL
    • The smallest units of expenditure charged to projects and tasks
  • PA_EXPENDITURES_ALL
    • Groups of expenditure items incurred by employees or organizations for an expenditure period
  • PA_PERIODS_ALL
    • Implementation-defined periods against which project performance is measured
  • PA_PROJECT_ASSET_LINES_ALL
    • Summarized project CIP costs
  • PA_PROJECT_ASSETS_ALL
    • Assets defined for capital projects
  • PA_EXPENDITURE_TYPES
    • Implementation-defined classifications of expenditures charged to projects and tasks
  • PA_EXPENDITURE_CATEGORIES
    • Implementation-defined groupings of expenditure types by type of cost
  • PA_CLASS_CATEGORIES
    • Implementation-defined categories for classifying projects
  • PA_CLASS_CODES
    • Implementation-defined values within class categories that can be used to classify projects
  • PA_PROJECT_CLASSES
    • Class codes of class categories that are used to classify projects
  • PA_BUDGET_VERSIONS
    • Versions of project budgets
  • PA_BUDGET_LINES
    • Detail lines of project and task budgets