Integration to Project Costing and Billing

This chapter covers the following topics:

Overview

Oracle Project Costing calculates cost and accounts it. In any organization there are application that track costs of the projects and categorize the costs. Costing is the processing of expenditures to calculate their cost to each project and determine the GL accounts to which the costs are posted.

Non-recoverable taxes of India Local Taxes are included in Commitments on Project Status inquiry for document types.

Requisitions

Non-recoverable taxes of India Local Taxes are included in Actual Costs in Expenditure Inquiry for document types.

Receipts

The base processes and concurrent processes used by Projects to update commitments and interface costs would automatically bring in local taxes into Projects.

The main objective of this document is to provide a deep dive of the data model compilation for the Oracle Financials for India (OFI) integration with Project Costing.

Setup for Project Costing:

  1. Navigate to Transactions Sources using the (N) Navigation > Oracle Projects > Setup > Expenditures > Transaction Sources.

  2. Map the Localization procedure.

Project Costing Transactions

Oracle Projects Costing base set up and Oracle Financials for India set up for Purchasing, Payables and Inventory.

The preprocessing client extension jai_pa_costing_pkg.pre_process which is a seeded value, gets attached to the transaction source Oracle Purchasing Receipt Accruals

Commitments

Requisitions/ Purchase Order/ Supplier Invoices matched to Purchase Order PRC: Update Project Summary Amounts for a Single Project

Actual Costs:

Purchase Receipts/ Supplier Invoices matched to Receipts

PRC: Interface Supplier Cost

Flows

Process Commitments

  1. Navigate to Purchase Order India Localization window using (N) Navigation > Oracle Purchasing > Purchase Orders (localized).

  2. Click Open.

  3. Create Purchase order for quantity 300.

  4. Click Shipments.

  5. Click on More tab on the Shipments window.

  6. Check Accrue at Receipt option.

  7. Click Distribution button.

  8. On the Distribution window, select Expense as the Type.

  9. Click Projects tab.

  10. Attach the Project.

  11. Save the Purchase order. Purchase order gets created.

  12. Add the Localization tax using the Tools > India Tax Details.

  13. Tax category is defaulted based on the setup. Taxes are also populated.

  14. Non-recoverable tax must be attached for interfacing to Oracle project.

  15. Save the data.

  16. Tax amount is calculated.

  17. Navigate to Purchase Order window.

  18. Approve the Purchase order by clicking the Approve button.

  19. Click Ok.

  20. Purchase order is approved. Check the status change.

  21. Navigate to Oracle Projects application by changing responsibility, (N) Navigation > Oracle Projects.

  22. Run the concurrent process, PRC: Update Project Summary Amounts.

  23. Select the Projects.

  24. Click Ok. Click Submit.

  25. Concurrent process completes successfully.

  26. Navigate to the Project Status window using (N) Navigation > Oracle Projects > Project Status Inquiry.

  27. Click the Project Status Inquiry.

  28. Select the Project to view the commitments.

  29. Select the project and Find.

  30. Click the Commitments.

  31. Find the specific Supplier and Commitment Type.

  32. View the commitment details for the selected purchase order.

  33. View the Project Raw Cost and Project Burdened Cost for the purchase order.

  34. View the Expenditure Type for selected purchase order.

Process Actual Costs for Receipt accrual

  1. Navigate to Receipts Localized window using (N) Navigation > Oracle Purchasing > Receipt (Localized).

  2. Click New.

  3. Select a PO.

  4. Create a receipt for the selected purchase order.

  5. Receive the material against the selected PO.

  6. Tick the checkbox and Quantity populates.

  7. Check the location.

  8. Attach the Localization taxes by using Tools > India Tax Details.

  9. The tax details are populated automatically, click confirm to confirm the taxes.

  10. Navigate back to Receipt Localization window and save it.

  11. Click Header on the Receipts window.

  12. Receipt is created.

  13. The concurrent process runs automatically once the Receipt is saved.

  14. Navigate to Receiving Transactions window using (N) Navigation > Oracle Purchasing > Receiving Transactions.

  15. Select Receipts.

  16. Select Expense as the Destination Type.

  17. Select the Location.

  18. Navigate to the India Tax Details window using Tools > India Tax Details.

  19. View the Localization tax details that populate automatically.

  20. Navigate back to the Receipt window and save it.

  21. Navigate to Oracle Projects India Localization.

  22. Run the concurrent process, PRC > Interface Supplier Costs.

  23. Select Project name and choose Yes as the value for the Interface Receipt Accruals option.

  24. Click Ok.

  25. Click Submit.

  26. Concurrent process completes.

  27. Navigate to the Project Expenditure Items using (N) Navigation > Oracle Projects > Expenditure Inquiry.

  28. View Expenditure Inquiry, select a Project and click Find.

  29. On the Project Expenditure window, the amount and tax amount is displayed in separate lines.

  30. View the Referred Receipt detail by selecting a PO receipt.

  31. View the receipt details.

Process Actual Costs for Invoice

  1. Navigate to the Purchase Orders (India Localization) window using the (N) Navigation > Oracle Purchasing > Purchase Orders (Localized).

  2. Create a purchase order for 50 quantity.

  3. Click More tab.

  4. Check Accrue at Receipt option.

  5. Click Distribution.

  6. Select or enter the Type on the Distribution window.

  7. Click Project tab.

  8. Select a Project.

  9. Enter quantity.

  10. Save the purchase order.

  11. Add the Localization tax on the India Tax Details window by selecting Tools > India Tax Details window.

  12. Tax category gets defaulted based on the setup.

  13. Save the data.

  14. The tax amount is calculated.

  15. Approve the purchase order.

  16. Purchase order is approved.

  17. Navigate to Receipts window using (N) Navigation > Oracle Purchasing > Receipts.

  18. Click New.

  19. Select a purchase order.

  20. Create a purchase order receipt.

  21. Attach the Localization Taxes by using the India Tax Details using Tools > India Tax Details.

  22. The tax details gets populated automatically, confirm the taxes.

  23. Navigate back to Receipt localization window and save it.

  24. Click Header button.

  25. Receipt is generated. Note the receipt number.

  26. Navigate to Receiving Transaction window by using (N) Navigation > Oracle Purchasing > Receiving Transactions.

  27. Receive the material in Expense location. Select location.

  28. Attach the Localization Taxes by using the India Tax Details using Tools > India Tax Details.

  29. View the Localization tax details that populates automatically.

  30. Navigate to Receipts window and save the data.

  31. Navigate to Invoice Workbench – India Localization window using (N) Navigation > Oracle Payables > Invoice Workbench > Entry > Invoice Workbench.

  32. Create an AP invoice matching with receipt. Select the purchase order and enter the project details.

  33. Match the purchase order with a receipt. Specify a receipt and click Finish.

  34. Check the Match option in the Match the Receipts window. Click Match.

  35. Attach the Localization Taxes by using the India Tax Details using Tools > India Tax Details.

  36. View the Localization tax details that populate automatically.

  37. Validate the invoice.

  38. Approve the invoice.

  39. Account the invoice.

  40. Navigate to Oracle Projects window using (N) Oracle Application > Oracle Projects.

  41. Run the concurrent process, PRC: Interface Supplier Costs.

  42. Select the project number, and specify Yes for the Interface Supplier Invoices option.

  43. Click Ok and click Submit.

  44. View the concurrent process completes normally.

  45. Navigate to Oracle Projects window using (N) Navigation > Oracle Projects.

  46. View the base amount and the non-recoverable tax amount in separate lines on the Project Expenditure Items window.

  47. Click Item Details.

  48. Select AP Invoice and click Ok.

  49. View the invoice details.

Introduction to Project Billing

The main objective of this document is to provide a deep dive of the data model compilation for the Oracle Financials for India (OFI) integration with Project Billing.

Setup for Project Billing

Tax rule setup

  1. Navigate to the Tax Rule for Projects window using (N) Navigation > India Local Project Billing > Setup > Tax Rule for Project

  2. Attach the Rule as Project

Transaction Flow

  1. Run the concurrent process, PRC: Generate Draft Invoice.

  2. Navigate to India Invoice Review.

  3. Modification to taxes, is it required?

  4. Modify, apply and save.

  5. Localization taxes are frozen. If modifications to taxes are required, then modify, apply and then save. Repeat Steps 3 and 4.

  6. Approve and release the draft invoice.

  7. Run the concurrent process, PRC: Interface Invoices to Receivables.

  8. Run the Auto Invoice Master and Import process in Receivables.

  9. Query the invoice in Localization Transaction window.

  10. Run the India Import Project Taxes to receivables.

Transaction Cycle

  1. Navigate to Tax Category window by using (N) Navigation > Oracle Payables.

  2. View the tax category.

  3. Navigate to the Event Details window by using (N) Navigation > Oracle Projects > Billing > Events > Projects.

  4. Select the project for which event must be created.

  5. Create a new Event and save.

  6. Notice the transaction ID generated.

  7. Run the concurrent process, PRC: Generate Draft Invoices for a Single Project.

  8. View the concurrent status.

  9. View the output. Notice the invoice approved.

  10. View the Invoice Summary window using (N) Navigation > India Local Project Billing > Billing > Invoice Review.

  11. View the Project invoice details

  12. Navigate to India Tax Details window using Tools > India Tax Details.

  13. View the localization tax.

  14. Navigate to Invoice Summary window and approve it.

  15. Release it. Enter the AR Invoice number on the Release Invoice window.

  16. AR invoice is released.

  17. Find the invoice. View the Invoice summary.

  18. View the AR invoice.

  19. Run the concurrent process, PRC: Interface Invoices to Receivables.

  20. View the output.

  21. Navigate to Transactions window using (N) Navigation > Oracle Receivables > Transactions.

  22. Run the Autoinvoice Master program.

  23. View the concurrent process status.

  24. View the output of Autoinvoice Master Program.

  25. Navigate to Transaction Summary to view the transaction details using (N) Navigation > Oracle Receivables > Transactions > Transactions Summary.