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)
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
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_ALL | PA_EXPENDITURE_ITEMS_ALL | PA_COST_DISTRIBUTION_LINES_ALL |
|---|---|---|
| DISTRIBUTION_LINE_NUMBER | SYSTEM_REFERENCE3 | |
| DIST_CODE_COMBINATION_ID | DR_CODE_COMBINATION_ID | |
| INVOICE_ID | SYSTEM_REFERENCE2 | |
| EXPENDITURE_TYPE | EXPENDITURE_TYPE | |
| EXPENDITURE_ORGANIZATION_ID | EXPENDITURE_ORGANIZATION_ID | |
| PROJECT_ID | PROJECT_ID | PROJECT_ID |
| TASK_ID | TASK_ID | TASK_ID |
| EXPENDITURE_ITEM_DATE | EXPENDITURE_ITEM_DATE | GL_DATE |
| ORG_ID | ORG_ID | ORG_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.
