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 FEBRUARY 16, 2017

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.

Symptoms

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

1529969 CSCS    3.0  17-OCT-2014  Marlin       Hotel 2   Vision Services  237.60

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

Marlin, Vision Services, End Date: 19-OCT-2014

                 Project Task      EI Date      Type       Amount
First line:      CSCS    3.0       17-OCT-2014  Hotel     -237.60
Second line   CSCS    3.0       17-OCT-2014  Airfare    237.60

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.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms