Oracle Projects- AP Integration Part1

转自：http://www.linkedin.com/pulse/20140701051202-19818376-oracle-projects-ap-integration-part1

PA – AP Flow:

Here iam considering the AP invoice integration with Oracle Projects. I will explain about the Expense Reports flow in another topic.

This integration involves 2 sub processes given below:

• Interfacing Supplier Invoice From Oracle Payables To Oracle Projects
• Interfacing Supplier Invoice Adjustments From Oracle Projects To Oracle Payables

Interfacing Supplier Invoice From Oracle Payables To Oracle Projects:

This process involves :

1. Creating the invoice.
2. Approve the invoice.
3. Account for the invoice in payables.
4. Run the ‘Interface Supplier Costs’ process in Oracle Projects which interfaces the invoices from AP to PA.

Interfacing Supplier Invoice Adjustments From Oracle Projects To Oracle Payables:

This process involves:

1. Adjust the supplier invoice interfaced to Oracle Projects by either splitting the quantity or transferring an invoice from one project/task to another.
2. Execute the PRC: Distribute Supplier Invoice Adjustment Costs process in Oracle Projects.
3. Run the PRC: Interface Supplier Invoice Adjustment Costs to Payables process in Oracle Projects.

Important Project Related Fields in AP:

• Project Name – Project Name to which the Invoice is accounted in Payables.
• Task Number – Task Number of the Project to which the invoice is accounted. Note: If the Task is not chargeable, the system displays the following error message: APP-PA-19270 The Task is Not Chargeable. The same error will be received if the Chargeable Flag is not checked while defining Tasks in Projects Setup or if the task is a Parent Task. Expenditures cannot be created at the Parent Task level.
• Expenditure Types – Expenditure Type of the invoice. This is based on the projects expenditure types (pa_expenditure_types table)
• Expenditure Item Date – The date of the invoice expenditure item to be created in Projects.
• Expenditure Organization – Active Project Expenditure/Event Organization against which the invoice has to be mapped.
  The Expenditure Org can be find in PA_ALL_Organizations table with pa_org_use_type = ‘EXPENDITURES’. For any organization to be a Expenditure Organization, it has to be classified in HR as ‘Expenditure/Event Organization’.