You are browsing the archive for PA.

Oracle Projects Overview

Oracle Projects Module Overview:

Oracle Projects suite provides the functionality for enterprise customers to setup a project, plan, execute and close it. Oracle projects suite consists of

  • Oracle Project Costing
  • Oracle Project Billing
  • Oracle Project Resource Management
  • Oracle Project Management
  • Oracle Project Portfolio Analysis

Functionality Supported by Oracle Projects

  • Setting up a project
  • Allocate resources
  • Setup project schedule/tasks
  • Project Status / performance reporting
  • Project Cost setting and monitoring
  • Event/Milestone based billing
  • Project budgeting
  • Integration with OM, WIP, Costing, AR, GL, HRMS modules

Projects Concurrent Programs

Oracle Projects Concurrent Programs

CONCURRENT PROGRAM SHORT CODECONCURRENT PROGRAM NAME
PAXRWDREProcess Responsibility Type Programs
PAXRWLUPProjects Lookups
PAXRWPRGProject Accounting Programs
PAXRWIMPImplementation Options
PAXRWPTYProject Types
PAXRWLCOLabor Cost Rates Listing By Organization
COMPILE_SCHEDULECompile Burden Rate Schedule
COMPILE_ALLCompile All Uncompiled Burden Schedule Revisions
PAXTRTRXTransaction Import
PAXTRTXSTransaction Sources
PADTBCInterface Total Burdened Costs to GL
PACOCRSRCompile Burden Schedule Revision
PACOANORCompile New Organization Burden Rates
PACODTBCDistribute Total Burdened Cost
PACTFTBCInterface Total Burdened Cost to GL
PACTBTBCTieback Total Burdened Cost from GL
PAXCCARSCompile All Burden Schedule Revisions
PAXCPGALPRC: Generate Asset Lines for a Range of Projects
PAXCPCALInterface Assets to Fixed Assets
PAXACMPTUpdate Project Summary Amounts
PAXACRPTRefresh Project Summary Amounts
PAXACRTARefresh Transaction Summary Amounts
PAXACRLTPRC: Update Project Summary Amounts after Resource List Change
PARGDR_SINGLEGenerate Draft Revenue
PAIGEN_SINGLEGenerate Draft Invoices
PAXACMPT_SINGLEUpdate Project Summary Amounts for a Single Project
PAXCPGAL_SINGLEGenerate Asset Lines for a Single Project
PASTRPSubmit Project Streamline Processes
FNDRSSUB122Generate and Interface Asset Lines
PAADWCPCollect Dimension and Fact Tables
PAADWGVADW Generate Collection Views
PAXBAUPDProcess project/task attribute mass update batches
PASDUC_BURDENCreate and Distribute Burden Transactions
PAADWRPRefresh Dimension and Fact Tables
PAXMGSLSAUD: Project Subledger: Summary
PAXMGSLDAUD: Project Subledger: Detail by Project:  Shows the transactions in Oracle Projects for a GL account projectwise
PAXMGSLEAUD: Project Subledger:  Detail by Expenditure Type:  Shows the transactions in Oracle Projects for a GL account Expenditure Typewise across projects
PAXAURATAUD: Revenue Audit Report
PAXAUGLTAUD: Cost Audit Report
PAXEXCPSTransaction Exception Summary
PAXEXCPDEXC: Transaction Exception Details
PAXSMPRDSummarization Period Exceptions
PARGDR_DELETEDelete Draft Revenue of a Single Project
PABISUMSPRC: Refresh OBIS Summary Amounts – Obsolete
PAXALRATRelease Allocations Transactions
PAXALGATGenerate Allocations Transactions
PAMRCUPGUPG: MRC Setup – Projects Transactions Upgrade
PAMRCUPGRPTUPG: MRC Setup – Projects Transactions Upgrade Status Report
PAAPIMPInterface Expense Reports from Payables
PAAPIMPRInterface Project Costs from Payables/Purchasing Report
PAICGEN_SINGLEGenerate Intercompany Invoices for a Single Project
PAICGENGenerate Intercompany Invoices for a Range of Projects
PATTAR-ICInterface Intercompany Invoices to Receivables
PACCBLThis is a process run in the Provider Operating Unit and processes all transactions identified for Borrowed and Lent accounting
PAXICGNSPRC: Intercompany Invoice Generation report for a Single Project
PAXICGNRPRC: Intercompany Invoice Generation report for a Range of  Projects
PAXCCBLRPRC: Borrowed and Lent Amounts Distribution Report
PACCTIERTieback Cross Charge Distributions From General Ledger
PACCGLTRInterface Cross Charge Distributions to General Ledger
PAAPIMP_SIInterface Supplier Invoices from Payables
PAXCCGLAAUD: Cross Charge Audit Report
PAXAUMTCMissing Timecards
PAXRWETPExpenditure Types
PAXRWSBRStandard Rate Schedules
PAXPRWBSWork Breakdown Structure
PAXPRCONProject Configuration
PAXPRTSKTask Details
PAXAASVLAutoAccounting Lookup Sets
PAXAAFTPAutoAccounting Functions
PAXAASRPAutoAccounting Segment Rule Pairings
PAXAARULAutoAccounting Rule Definitions
PAXEXRPEExpenditures Detail
PAXBUBSSRevenue, Cost, Budgets by Work Breakdown Structure
PAXPEEMOEmployee Assignments By Organization
PAXEXPEAPre-Approved Expenditures Entry Audit
PAXEXADJProject Expenditure Adjustment Activity
PAXPCEGSExpenditure Batch Status
PAXEXESRExpenditures Summary
PAXMGPSDRevenue, Cost, Budgets by Resources (Project Level)
PAXMGTSDTask – Revenue, Cost, Budgets by Resources
PAXMGURAUnbilled Receivables Aging
PAXARAGEReceivables Aging by Project/Customer
PAXPCRFDRevenue Flow Detail
PAXAGASTAgreement Status By Customer
PAXEMRAOEmployee Activity By Organization
PAXPCIDFInvoice Flow Detail
PAXEXTARTransfer Activity Report
PAXPCTCETimecard Entry
PAXPCIFSInvoice Flow Summary
PAXPCPRSPotential Revenue Summary
PAXINGENInvoice Review
PAXEXONEExpense Report Entry
PAPBERDistribute Expense Report Adjustments
PATTERInterface Expense Reports to Payables
PAFFERTieback Expense Reports from Payables
PARTARTieback Invoices from Receivables
PARGDRGenerate Draft Revenue for a Range of Projects
PAIGENGenerate Draft Invoices for a Range of Projects
PALDLCDistribute Labor Costs
PATTARInterface Invoices to Receivables
PAGGLTInterface Labor Costs to General Ledger
PAGTIETieback Labor Costs from General Ledger
PASDUCDistribute Usage and Miscellaneous Costs
PASGLTInterface Usage and Miscellaneous Costs to General Ledger
PASTIETieback Usage Costs from General Ledger
PASTRMSubmit Interface Streamline Processes
PARCFRCompute Forecast Labor Revenue
PATTGLGenerate Accounting Events for Revenue
PARTIETieback Revenue from General Ledger
PAXMGPBSProject Billing Status
PAVTVCInterface Supplier Invoice Adjustment Costs to Payables
PAVTIETieback Vendor Invoice Adjustment Costs from GL
PAVDVCDistribute Supplier Cost Adjustments
PAXARTRXCreate Invoice Organization Transaction Types in Oracle Receivables
PAXRWAGTAgreement Types
PAXRWCTYCredit Types
PAXRWPETEvent Types
PAXRWBCCBurden Cost Codes
PAXRWLCMLabor Cost Multipliers
PAXRWPCTProject Contact Types
PAXRWPCRProject Customer Relationships
PAXRWPRTIMP: Project Roles
PAXRWPJSProject Statuses
PAXRWPSVService Types
PAXRWBCMBurden Cost Multipliers By Organization
PAXRWCRSLabor Costing Rules Listing
PAXRWLCRLabor Cost Rates Listing
PAXRWUDFUnits Definition
PAXPEJOBJob Listing
PAXPEORGOrganization Listing
PAXRWPSTProjects Periods
PAXRWDIFInvoice Formats Listing
PAXRWAUTRevenue Authorization Rules Configuration
PAXRWRVCRevenue Categories
PAXRWPCCClass Categories and Codes
PAXRWNLRNon-Labor Resources By Organization
PAXPEASTEmployee Assignment
PAXRWECRExpenditure Cost Rates
PAXRWDOHOrganization Hierarchy
PAOSTRMInterface Streamline Processes to GL for Primary and Reporting Set of Books
PARRGLB_CUT_OFF_DATEPRC : Identify Transactions for Actuals Utilization – Obsolete
PA_WRAP_GEN_FORECASTRun Generate Forecast
PABDGRLRYear End Budget Rollover Process
PAFCUPAEMaintain Budgetary Control Balances
PAXAUERTExpense Report Audit Report
PARRGLBB_ACTUALSRun Summarization for Actuals Utilization Amounts – Obsolete
PAXAUVITSupplier Invoice Audit Report
PARRGLBB_FORECASTSRun Summarization for Scheduled Utilization Amounts – Obsolete
PAFICALFCalculate Forecast Amounts (Initial)
PAYROPPGManage Project Requests: Create Project Requests and Update Projects
PAFICALICalculate Forecast Amounts (Incremental)
PAFICALPUpdate Forecast Amounts
PAFPEXRPOrganization Forecast Exceptions Report
PAJEBRUPThis Program will update the bill rate schedule for project and Task defaulted from Project Types
PAFPORGFGenerate Organization Forecasts
PAPERACTRULESPRC: Perform Action Rules
PARASCNRPAutomated Candidate Search for a Range of Projects
PARASCNSPAutomated Candidate Search for a Single Project
PASDUC_BURDEN_RANGECreate and Distribute Burden Transactions for a Range of Projects
PAUBRUERThis process creates unbilled receivables and unearned revenue summary balances for draft revenue and draft invoices in Oracle Projects.
PAWKTPUPUpgrade Work Types/Project Manufacturing Attributes.
PAXALDATDelete Allocations Transactions
PAXEXGLDTransaction Exception Details by GL Period
PAXEXGLSTransaction Exceptions Summary by GL Period
PARGCALGGenerate Calendar Schedules for a Range of Calendars
PARGCALGSGenerate Calendar Schedule for a Single Calendar
PARLBLDGRebuild Timeline for a Range of Resources
PARLBLDGSRebuild Timeline for a Single Resource
PARCPRJRMaintain Project Resources
PARFIEXP_PROCESSProcess Forecast Exceptions
PARFIEXP_REPORTList Forecast Exceptions
FNDRSSUB740Generate Utilization
Stage10Create Utilization Summary Amounts
PAFPMRCUpgrade Budgets For Multi Reporting Currency
PAFPUPGUpgrade Budget Types and Budget Versions
PAFUNDMCThis process upgrade the Funding for the multi reporting currency and list all the funding lines that failed to convert from primary to reporting currency in Oracle Projects.
PALDLC_RANGEDistribute Labor Costs for a Range of Projects
PAPDPROFRefresh Project Plan Versions Period Profile
PARRSAVLPRC: Refresh Resource Availability
PATMUPGSUpgrades all the task managers in the project as project members in the given role
PAXARPPRPurge Project Data
PAXARPVDPRC: Validate Purge Batches
PAXFRADRRevaluated Funding Audit Report
PAXINTCPRebuild Project Search Intermedia Index
PAXOPTCPOptimize Project Search Intermedia Index
PAXPRFRP_DELETEDelete Revaluated Funding for a Range of Projects
PAXPRFRP_RANGERevaluate Funding for a Range of Projects
PAXPRFRP_SINGLERevaluate Funding for a Single Project
PAXUPACCUPG: Update Project Access Level
PAXUSGNSProcess to Archive/Purge Unassigned Forecast items
PAVDVC_RANGEDistribute Supplier Cost Adjustments for a Range of Projects
PAYROPPG_ASNManage Project Requests: Create Project Requests and Update Projects for Oracle Sales
PACRCAPSReport for viewing capital project summary amounts
PACRCIPFReport that displayes the interfaced CIP and RWIP Amounts
PACCINTGPRC: Generate Capitalized Interest Transactions
PACAPINTCompile Capitalized Interest Rate Schedule
PACRCBDTProject Asset Details Report
PACINTPGPurge Capitalized Interest Transactions Audit
PAIGEN_DELETEDelete Unreleased Draft Invoices for a Range of Projects
PACACCBPCreate Periodic Capital Events
PACFATBPTieback Asset Lines from Oracle Assets
PAWPUWBSThis process recalculates task weighting percentages for the work breakdown structure, and updates planning elements for budgeting and forecasting.
PACINTARAUD: Inactive Capital Projects Report
PAXCIDATDelete Capitalized Interest Transactions
PAPFEXCPProgram to generate Performance Transaction Data, KPA Scoring and notification
PARBSRSHFor refreshing resource names
PAUPGRRLUPG: Upgrade Resource List To Planning Resource List
PAINIACTPRC: Initiate Project Deliverable Actions
PA_FP_GEN_AMT_WRPGenerate Financial Plan Amounts
OKEDPDRFPRC: Relieve Project Deliverable Demand
PAFPMIPRMissing Periods: Date-Range Budgets
PAFPWACPThis concurrent program processes the plan version data uploaded from a spreadsheet to Oracle Projects
PACCSLARGenerate accounting events for cross charge distributions
PAACCPBCreate Accounting Program
PAGCAEGenerate accounting events for cost transactions
PACCGLER
PATXMASThis program processes mass adjustments of expenditure items.
PAXSIADJThe program reports on supplier cost transactions. You can use the report as an aid to reconcile Oracle Projects with Oracle Payables, Oracle Purchasing, and Oracle General Ledger.
PAXBUBDBCopy Actuals
PAXLAUPGCPUpgrade on demand child process program
PAXACCPBCreate Accounting Program
PAXGLTRNUse this program to transfer to GL subledger journal entries generated by previous executions of the create accounting program
PA_XLAALEXPExport Application Accounting Definitions
PA_XLAALIMPImport Application Accounting Definitions
PA_XLAAPPURGEPurge old Transaction Objects Diagnostics related information
PA_XLAAPDIAGTransaction Objects Diagnostics Output
PA_XLAONDEUPGThis program upgrades subledger transactions into Subledger Accounting for periods that have not been upgraded as part of the upgrade to release 12 process.
PA_XLABABUPSubledger Accounting Balances Update
PA_XLATBDMGOpen Account Balances Data Manager
PAPEXRPTThis report is called by the Period Close Validation Program to extract all those events which are either untransferred or are not accounted for.
PAJELINESRPTSLA Standard Journal Entry Lines Report
PAXAARPTStandard Account Analysis Report
PATTARICInterface Intercompany Invoices to Receivables
PATTAR_ICInterface Intercompany Invoices to Receivables
PAXRWPET_XMLEvent Types
PAFPURUPStreamline Rollup for Financial Plan Versions, Workplan Versions, and Change Orders
PAXRWPJS_XMLProject Statuses
PAXRWPRT_XMLIMP: Project Roles
PAXRWPST_XMLProjects Periods
PAXRWPSV_XMLService Types
PAXRWPTY_XMLProject Types
PAXRWRVC_XMLRevenue Categories
PAXRWSBR_XMLStandard Rate Schedules
PAXRWUDF_XMLUnits Definition
PAXSIADJ_XMLThe program reports on supplier cost transactions. You can use the report as an aid to reconcile Oracle Projects with Oracle Payables, Oracle Purchasing, and Oracle General Ledger.
PAXSMPRD_XMLSummarization Period Exceptions
PAXTRTRX_XMLTransaction Import
PAXTRTXS_XMLTransaction Sources
PAAPIMPR_XMLInterface Project Costs from Payables/Purchasing Report
PACCGLER_XMLPRC: Sweep Transaction Accounting Events (XML)
PACCINTG_XMLPRC: Generate Capitalized Interest Transactions
PACCSLAR_XMLGenerate accounting events for cross charge distributions
PACINTAR_XMLAUD: Inactive Capital Projects Report
PACRCAPS_XMLReport for viewing capital project summary amounts
PACRCBDT_XMLProject Asset Details Report
PACRCIPF_XMLReport that displayes the interfaced CIP and RWIP Amounts
PAFPEXRP_XMLOrganization Forecast Exceptions Report
PAPERACTRULES_XMLPRC: Perform Action Rules (XML)
PARCPRJR_XMLMaintain Project Resources
PARGCALGS_XMLGenerate Calendar Schedule for a Single Calendar
PARGCALG_XMLGenerate Calendar Schedules for a Range of Calendars
PARLBLDGS_XMLRebuild Timeline for a Single Resource
PARLBLDG_XMLRebuild Timeline for a Range of Resources
PAUBRUER_XMLThis process creates unbilled receivables and unearned revenue summary balances for draft revenue and draft invoices in Oracle Projects.
PAUPGRRL_XMLUPG: Upgrade Resource List To Planning Resource List (XML)
PAXAAFTP_XMLAutoAccounting Functions
PAXAARUL_XMLAutoAccounting Rule Definitions
PAXAASRP_XMLAutoAccounting Segment Rule Pairings
PAXAASVL_XMLAutoAccounting Lookup Sets
PAXACMPT_SINGLE_XMLUpdate Project Summary Amounts for a Single Project
PAXACMPT_XMLUpdate Project Summary Amounts
PAXACRPT_XMLRefresh Project Summary Amounts
PAXACRTA_XMLRefresh Transaction Summary Amounts
PAXAGAST_XMLAgreement Status By Customer
PAXALGAT_XMLGenerate Allocations Transactions
PAXALRAT_XMLRelease Allocations Transactions
PAXARPPR_XMLPurge Project Data
PAXARPVD_XMLPRC: Validate Purge Batches
PAXAUERT_XMLExpense Report Audit Report
PAXAUGLT_XMLAUD: Cost Audit Report
PAXAUMTC_XMLMissing Timecards
PAXAUVIT_XMLSupplier Invoice Audit Report
PAXBAUPD_XMLProcess project/task attribute mass update batches
PAXBUBSS_XMLRevenue, Cost, Budgets by Work Breakdown Structure
PAXCCARS_XMLCompile All Burden Schedule Revisions
PAXCCGLA_XMLAUD: Cross Charge Audit Report
PAXCPCAL_XMLInterface Assets to Fixed Assets
PAXCPGAL_SINGLE_XMLGenerate Asset Lines for a Single Project
PAXCPGAL_XMLPRC: Generate Asset Lines for a Range of Projects (XML)
PAXEMRAO_XMLEmployee Activity By Organization
PAXEXADJ_XMLProject Expenditure Adjustment Activity
PAXEXCPD_XMLEXC: Transaction Exception Details
PAXEXCPS_XMLTransaction Exception Summary
PAXEXGLD_XMLTransaction Exception Details by GL Period
PAXEXGLS_XMLTransaction Exceptions Summary by GL Period
PAXEXONE_XMLExpense Report Entry
PAXEXTAR_XMLTransfer Activity Report
PAXFRADR_XMLRevaluated Funding Audit Report
PAXINGEN_XMLInvoice Review
PAXMGPBS_XMLProject Billing Status
PAXMGPSD_XMLRevenue, Cost, Budgets by Resources (Project Level)
PAXMGSLD_XMLAUD: Project Subledger: Detail by Project:  Shows the transactions in Oracle Projects for a GL account projectwise
PAXMGSLE_XMLAUD: Project Subledger:  Detail by Expenditure Type:  Shows the transactions in Oracle Projects for a GL account Expenditure Typewise across projects
PAXMGSLS_XMLAUD: Project Subledger: Summary
PAXMGTSD_XMLTask – Revenue, Cost, Budgets by Resources
PAXMGURA_XMLUnbilled Receivables Aging
PAXPCEGS_XMLExpenditure Batch Status
PAXPCIDF_XMLInvoice Flow Detail
PAXPCIFS_XMLInvoice Flow Summary
PAXPCPRS_XMLPotential Revenue Summary
PAXPCRFD_XMLRevenue Flow Detail
PAXPCTCE_XMLTimecard Entry
PAXPEAST_XMLEmployee Assignment
PAXPEEMO_XMLEmployee Assignments By Organization
PAXPEJOB_XMLJob Listing
PAXPEORG_XMLOrganization Listing
PAXPRCON_XMLProject Configuration
PAXPRFRP_DELETE_XMLDelete Revaluated Funding for a Range of Projects
PAXPRFRP_RANGE_XMLRevaluate Funding for a Range of Projects
PAXPRFRP_SINGLE_XMLRevaluate Funding for a Single Project
PAXPRTSK_XMLTask Details
PAXPRWBS_XMLWork Breakdown Structure
PAXRWAGT_XMLAgreement Types
PAXRWCTY_XMLCredit Types
PAXRWDIF_XMLInvoice Formats Listing
PAXRWDOH_XMLOrganization Hierarchy
PAXRWETP_XMLExpenditure Types
PAXRWIMP_XMLImplementation Options
PAXRWLCO_XMLLabor Cost Rates Listing By Organization
PAXRWLCR_XMLLabor Cost Rates Listing
PAXRWNLR_XMLNon-Labor Resources By Organization
PAXRWPCC_XMLClass Categories and Codes
PAXRWPCR_XMLProject Customer Relationships
PAXRWPCT_XMLProject Contact Types
PAPMPRPBThis process recalculates task weighting percentages for the work breakdown structure, and updates planning elements for budgeting and forecasting.
PAPPURGEPurge Obsolete Projects Data
PARPPROJMGRProject Manager Reporting Pack
PARPWORKERReporting Pack Worker Concurrent Program
PAPWPRIPRC: Release Pay when Paid Holds
PAPWPRIREPAUD: Pay When Paid Release Audit
PAREPGENTo generate and deliver reports
PA_DEBITMEMO_IMPORTPRC: Import Deductions To Payables

Oracle Projects Forms

Oracle Projects Module Forms:

FORM SHORT CODEORACLE FORM NAME
PAADWDIMDimensions
PAXAAASRAssign AutoAccounting Rules
PAXAADCLAutoAccounting Lookup Sets
PAXAADRUAutoAccounting Rules
PAXALARLAllocation Rule
PAXALRARReview Allocation Run
PAXBAUPDMass Update Batches
PAXBUDBMBudget Entry Methods
PAXBUDBTBudget Types
PAXBUEBUBudgets
PAXCARVWCapital Projects
PAXCCPRCProvider/Receiver controls
PAXCCTPRTransfer Price Rules
PAXCCTPSTransfer Price Schedules
PAXCOCBMCost Bases
PAXCOCPSBurden Structures
PAXCOICCBurden Cost Codes
PAXCOIRSBurden Schedules
PAXCOVCMView Burdened Costs
PAXICRBEBilling Extensions
PAXINBCLBilling Cycles Maintenance
PAXINCTLControl Billing by Top Task
PAXINEAGAgreements
PAXINEVTEvents Maintainence
PAXINRVWInvoices
PAXINVPFProject Funding Inquiry
PAXPMSUCControl Actions
PAXPRCASAssignments
PAXPRCCOConversion Options
PAXPREPCProject Percent Complete
PAXPREPRProjects
PAXREDRLResource Lists
PAXRVRVWReview Revenues
PAXSUDATAgreement Types
PAXSUDBRRate Schedules
PAXSUDCCProject Classifications
PAXSUDCRLabor Costing Rules
PAXSUDECExpenditure Categories
PAXSUDETExpenditure Types
PAXSUDEVEvent Types
PAXSUDIFInvoice Formats
PAXSUDNRNon-Labor Resources
PAXSUDPSProject Statuses
PAXSUDPTProject Types
PAXSUDRTProject Role Types
PAXSUDSIImplementation Options
PAXSUEHCEmployee Cost Rates
PAXSULCMLabor Cost Multipliers
PAXSULKPProject Accounting Lookups
PAXSUMPSPA Periods
PAXTRAPEExpenditure Inquiry
PAXTREPEPre-Approved Expend Entry
PAXTRIMPReview Rejection Form
PAXTRONEOnline Expenditure Entry
PAXTRRTEOnline Expenditure Review
PAXTRTXSTransaction Sources
PAXURDDCProject Status Display Columns
PAXURVPSProject Status Inquiry
PAXLABSROrganization Labor Costing Rules
PAXARPURPurge Project Data
PAXSUDPRProject Probabilities
PAWRKTYPDefine Work Type
PAXJBMAPDefine Job Relationships
PAXTRFCKTransaction Funds Check Results
PARUTOPTUtilization Options
PAXSUDRORoles (new)
PAXSUDRLRole Lists
PAXRESSCOrganization Authority
PARUTCTGUtilization Category
PARUTFRTForecasting Options
PAXBUBCLBudgetary Control
PAXBLRSLBudget Funds Check Results
PAXPAGLPGL Periods
PAXSUSUCStandard Asset Unit Costs