Oracle projects integration

Oracle Projects Integration

1. Oracle Projects Integration

2. Oracle Projects Suite Provides a robust functionality across the end—to-end project management lifecycle Objectives Scenarios Portfolios Project Approvals Project Selection & Initiation Updates Forecasts Changes Billings Capitalization Progress Documents Issues Actuals Workplans Resources Budgets/ Estimates Project Planning Project Execution Project Control Metrics KPI ’ s Reports Project Reporting & Closeout Finances Resources Work

3. Project Setup Select a Project template Enter mandatory project setup details e.g. project attributes like the project name, project number, project manager, start/end dates etc Enter additional details e.g. 60+ PTA columns for OPW, reporting parameters etc. SAVE to create Project Project Manager Update WBS

4. Non Labor Cost Collection PR Creation Best Practice OPA visibility of Commitments P O E T A Entry on PR

5. Non Labor Cost Collection PO Creation Best Practice OPA visibility of Commitments P O E T A Entry on PO

6. Non Labor Cost Collection AP Creation Best Practice OPA visibility of Commitments P O E T A Entry on AP

7. Cost Collection OTL OTL Oracle Payables Oracle Projects Oracle GL (1) Oracle GL Labor Cost Usages Labor Hours Payroll Burden Payroll taxes Employee Benefits Admin Express Workers Corporation Supplier Invoices

8. Capitalization: Integrating Oracle Projects and Oracle Assets Oracle Purchasing Oracle Payables Oracle Assets Oracle Projects Oracle General Ledger Send purchasing details Send non-CIP assets Send project costs Send CIP asset costs Post invoice CIP and expensed costs Post non-invoice CIP and expensed costs Post asset costs and clear CIP accounts Send expense report costs

9. Capitalization: Creating Assets through Oracle Projects Project Top Task 2 Capitalizable Asset 3 Asset 4 Top Task 1 Capitalizable Top Task 3 Capitalizable (Common Costs) Task 1.1 Capitalizable Asset 1 Task 1.2 Capitalizable Asset 1 Asset 2 Task 2.1 Capitalizable Task 2.2 Capitalizable Task 2.3 Not Capitalizable Grouping Levels Single asset assigned to multiple grouping levels Single asset assigned to single grouping levels Multiple assets assigned to single grouping levels Unassigned grouping

10. Invoicing: End to End Solution Invoice Formats Choose invoice formats Labor Nonlabor Retention Project Setup Invoice Process Printed Invoices Generate draft invoice Print invoice review report Release and interface draft invoice Printed invoice lines by format Customer invoice Printed invoice lines passed from Oracle Projects Invoice review report Oracle Projects Oracle Receivables Print invoice Setup tables Labor formats Non-labor formats Retention formats Defined during implementation

11. Creating Invoices in Oracle Project Billing AR interface Costs AR invoices Generate draft invoice Interface to Receivables Tieback invoices Approve/release invoice AR Auto Invoice Oracle Receivables Events Adjustments

12. Invoices to Oracle Accounts Receivable Oracle Projects interfaces invoices to Oracle Receivables This flow uses 3 step process of Interface to AR, Import in AR, and Tieback in Oracle Projects All accounting transactions, except for tax, are determined by Oracle Projects auto accounting. AR auto accounting rules are not used. Audit details in Oracle Projects link project invoices in Oracle Projects to invoices in AR. Oracle General Ledger Oracle Projects Oracle Receivables Released Invoices Invoices Journal entries