My Oracle Support Banner

Accounting In Projects Is Different from AP For Self Assessed Tax Lines (Doc ID 2619405.1)

Last updated on DECEMBER 28, 2019

Applies to:

Oracle Project Costing - Version 12.1.3 and later
Information in this document applies to any platform.


Invoices with one item and self assessed tax lines that have been created and then reversed in AP do not have the correct pa_cost_distribution_lines_all.DR_CODE_COMBINATION_ID for Variances and Taxes on the reversal.

The issues is with the accounting on the Projects expenditure items.

The invoice is matched to a PO and charged to a Project with a task (Expense).

Later the initial invoice lines are discarded and the PO was updated with a different task (Capital) for the same project.

The invoice is then re-matched to the same PO but with the different task.

1) Invoice is created and Matched to PO. This is coded to a project where task is expense type
2) Invoice tax and price variance lines are coded to account A
3) Invoice is validated, accounted and paid
4) Invoice is transferred to Projects. Tax and Invoice price variance lines charge account is still coded account A
5) Invoice lines are discarded and reversal entries are coded to A
6) Un-received the PO
7) Updated PO with a different task (Capital) but same project# as earlier
8) Received the PO
9) Re-entered the lines, matched to PO and coded to different task as PO but same project# as earlier
10) Invoice validated and accounted
11) Invoice is transferred to Projects
12) New Tax and Invoice Price Variance lines are coded to account B
13) Earlier discarded lines reversal entries are interfaced but the charge account is B instead of A.

Reversal entries should be charged to the new DR_CODE_COMBINATION_ID based on the updated task in the PO but is instead being charged to a Capital account based on original task.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.