Total Pageviews

July 29, 2017

7/29/2017 04:31:00 AM

Oracle projects and Payable integration


Oracle Payables Project Integration







The value in SYSTEM_REFERENCE columns depends on where the expenditure is coming from.
Usually the reference columns in PA_COST_DISTRIBUTION_LINES_ALL table are populated for Supplier costs – Invoices or Receipts

In case of Supplier invoice:
SYSTEM_REFERENCE2 holds invoice id
SYSTEM_REFERENCE3 holds invoice line number
SYSTEM_REFERENCE4 holds invoice_payment_id from table ap_payment_hist_dists (for discount lines)
holds variance type or tax type (like TRV, ERV, NONREC_TAX)
SYSTEM_REFERENCE5 holds PAYMENT_HIST_DIST_ID  from table ap_payment_hist_dists (for discount lines)
If it is Receipt Accrual:
SYSTEM_REFERENCE2 holds PO_HEADER_ID
SYSTEM_REFERENCE3 holds PO_DISTRIBUTION_ID
SYSTEM_REFERENCE4 holds RCV_TRANSACTION_ID from rcv_receiving_sub_ledger
SYSTEM_REFERENCE5 holds RCV_SUB_LEDGER_ID from rcv_receiving_sub_ledger

AP_INVOICE_DISTRIBUTIONS_ALLPA_EXPENDITURE_ITEMS_ALLPA_COST_DISTRIBUTION_LINES_ALL
DISTRIBUTION_LINE_NUMBERSYSTEM_REFERENCE3
DIST_CODE_COMBINATION_IDDR_CODE_COMBINATION_ID
INVOICE_IDSYSTEM_REFERENCE2
EXPENDITURE_TYPEEXPENDITURE_TYPE
EXPENDITURE_ORGANIZATION_IDEXPENDITURE_ORGANIZATION_ID
PROJECT_IDPROJECT_IDPROJECT_ID
TASK_IDTASK_IDTASK_ID
EXPENDITURE_ITEM_DATEEXPENDITURE_ITEM_DATEGL_DATE
ORG_IDORG_IDORG_ID

Potential Problems Related to Integration



1.       EXPENDITURE_TYPE is the common column between AP_INVOICE_DISTRIBUTIONS_ALL and PA_EXPENDITURE_TYPES; therefore, project accounting will not be displayed when AP_INVOICE_DISTRIBUTIONS_ALL and PA_EXPENDITURE_TYPES do not share a value in the EXPENDITURE_TYPE column.
2.       Project information cannot be updated in the invoices when the PA: Allow Override of PA Distributions in AP/PO profile option is disabled.

The total amount of the invoice cannot be modified when the invoice has already been interfaced to Oracle Projects


 
Related Posts Plugin for WordPress, Blogger...