Summary of Flow Diagram
Oracle General Ledger Integration
Oracle Projects fully integrates with Oracle General Ledger and allows you to easily update your general ledger with Oracle Projects activity. Oracle Projects lets you validate your expense, liability, revenue, and other accounts determined by your accounting rules against your chart of accounts.
When you transfer cost and revenue information to Oracle General Ledger, you use Oracle Projects to collect all project cost and revenue detail transactions, summarize them, and transfer them to Oracle General Ledger.
Oracle General Ledger integration includes:
- inquiry of journal entries imported from Oracle Projects via GL Journal Import and using the predefined journal entry sources and categories
Oracle Purchasing and Oracle Payables Integration--Requisitions, Purchase Orders, and Vendor Invoices
Oracle Projects fully integrates with Oracle Purchasing and Oracle Payables, and allows you to enter project-related requisitions, purchase orders, and vendor invoices using those products.
When you enter information in Oracle Purchasing and Oracle Payables that affects Oracle Projects, you enter project information on your source document. Oracle Purchasing, Oracle Payables, and Oracle Projects carry the project information through the document flow, from the requisition to the purchase order in Oracle Purchasing, to the vendor invoice in Oracle Payables, and to the project expenditure in Oracle Projects. You can report committed costs of requisitions and purchase orders that are outstanding against your projects in Oracle Projects.
Oracle Purchasing integration includes:
- entry of project information on requisition distribution lines
- entry of project information on PO distribution lines
- entry of project information on PO release distribution lines
- entry of project information on preferences
- copy project information from requisition to PO in AutoCreate
- support load of project information on requisitions in Requisition Import
- support building of GL account with Workflow based on project information
Oracle Payables integration includes:
- entry and inquiry of project information on invoice distributions
- entry and inquiry of project information on invoice header (for default entry)
- entry and inquiry of project information on distribution set lines
- copy project information from PO to invoice when they match
- support building of GL account with Workflow based on project information
- support load of project information in Invoice Import from project expense reports
Oracle Payables Integration--Expense Reports
Oracle Projects fully integrates with Oracle Payables so that you can easily create and pay invoices for your project expense reports in Oracle Payables. You can enter expense reports in Oracle Projects and use Oracle Payables to create invoices from the expense reports, maintain and track payments of them, and transfer the accounting transactions to Oracle General Ledger.
Oracle Receivables Integration
Oracle Projects fully integrates with Oracle Receivables to process your invoices and track customer payments. Oracle Projects generates draft invoices and uses Oracle Receivables to collect payments for the project invoices and transfer the accounting transactions to Oracle General Ledger.
When you transfer invoices to Oracle Receivables, Oracle Projects also maintains project balances of unbilled Receivables and unearned revenue and creates accounting transactions for these amounts.
Oracle Receivables integration includes:
- loading of project invoices via AutoInvoice and using the transaction flexfield for project information to be stored on the invoices in AR
- inquiry of invoices by project information using the transaction FlexField in AR forms
- inquiry of invoices by a key reference
- User able to specify one segment of the transaction FlexField as the reference (for example, key identifier for PA, project number, for OE, or order number) via the profile code PA_AR_CODE.
- Include the reference for invoice (e.g. project number, order number) in appropriate position for highly used field for display and inquiry on all AR transaction forms and quickpicks. Users will look at invoices by one or a combination of these values: reference, invoice number, and customer.
- Display source of invoice, so that a user dealing with invoices from more than one source knows what the source of the invoice is
- Distinguish Transaction Flex character field from standard descriptive Flex with 4 char field
- selection of invoices for cash application by displaying reference in the invoice List of Values in cash application forms
- inquiry of invoices by primary salesperson (project manager, if project manager is set up as salesperson in Oracle Receivables)
- entry and use of customers
Oracle Assets Integration
Oracle Projects allows you to manage capital projects. In a capital project, you can collect construction-in-process (CIP) and expensed costs for each asset you are building. You use Oracle Projects to collect all asset cost detail transactions, summarize them, and transfer them to Oracle Assets to become depreciable fixed assets. Oracle Assets will create and transfer journal entries to Oracle General Ledger to relieve the CIP account and record the asset cost.
Oracle Assets integration includes:
- inquiry of project information on mass addition lines
- drilldown to project asset line details in Oracle Projects from project-related mass addition lines in Oracle Assets
- copying of project information from mass addition lines to asset source lines during Mass Additions Posting process
- inquiry of project information on asset source lines
- drilldown to project asset line details from project-related asset source lines
- Coordination with Oracle Payables so supplier invoices lines are not interfaced to Oracle Assets by both Oracle Payables and Oracle Projects when the invoice line is associated with a capital project.
Oracle Human Resources Integration
Oracle Projects shares organization, job, and employee information with Oracle Human Resources. If your business does not use Oracle Human Resources, you can easily enter this data in Oracle Projects.
Oracle Human Resources integration includes:
- business group definition, including the specification of the Project Burdening Hierarchy
- organizations and organization hierarchies and organization types definitions
- entry and inquiry of employees and employee assignments, including date-effective assignments over time and specification of supervisors and billing titles (used in Oracle Projects) on the employee assignments
External Transaction Collection Systems Integration
You can load transactions from external cost collection systems into Oracle Projects using the Transaction Import function. You can load quantities or quantities and raw costs for the transactions. Oracle Projects calculates burdened cost, revenue, and invoice amounts, and performs all accounting functions for these imported transactions.
Summary of Project-Related Windows in Other Oracle Applications
The following table lists the windows in other Oracle Applications that include specific logic for project transactions.
See Also
Integrating with Oracle General Ledger
Interfacing Expense Reports with Oracle Payables
Integrating with Oracle Purchasing and Oracle Payables (Requisitions, Purchase Orders, and Supplier Invoices)
Integrating with Oracle Receivables
About Capital Projects