My Oracle Support Banner

R12: PA: Generate Cost Acct Events Results in "Original Transaction Is Not Accounted In Final Mode" for Negative Reversing Misc Transaction that Reverses Expense Reports (Doc ID 2069813.1)

Last updated on NOVEMBER 15, 2022

Applies to:

Oracle Project Costing - Version 12.1.3 to 12.2.4 [Release 12.1 to 12.2]
Information in this document applies to any platform.


Users are able to create a negative reversing misc transaction that reverses expense report lines in Projects.  The result is that the PRC: Generate Cost Accounting Events errors on these items giving 'Original transaction is not accounted in final mode' and the period cannot be closed.

Steps to Reproduce

1.  Find an expense report created in AP.  Note all of the attributes of the expenditure item.

Projects, Vision Services (USA)
Expenditure Inquiry - Query for existing ERs

Item Id Project Task   Date              Employee Type  Qty Org                Amount

2.  Create a pre-approved Misc Transaction batch with the first line having the exact same information as the original expenditure:

 Vision Services, End Date: 19-OCT-2014

                 Project Task      EI Date      Type       Amount
First line:     <Backing out original line>
Second line  <Creating new line>

3.  PRC:  Distribute Usages and Misc Transactions
4.  PRC: Generate Cost Accounting Events errors on these items with 'Original transaction is not accounted in final mode'.

Applied patch 19311537:R12.PJC.B 'Expenditure Processing : Critical consolidated code fix patch. This patch contains all critical Expenditure Processing related fixes and is recommended for all Oracle Projects customers using Expenditure Proc' internally and it did not resolve the issue.

These adjustment result in net zero adjustments with the original item having a system linkage function of ER but the reversals have a system linkage function of PJ.

The form should NOT allow these adjustments.  Adjustments made to Payables' Expense Reports need to be made in Payables and interfaced over to Projects. There is no supported way to reverse these items in Projects.




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.