My Oracle Support Banner

R12: PAXEXCPD Adjusted Inventory Misc Expenditure Items Fail with "Original Transaction Is Not Accounted In Final Mode" in EXC: Transaction Exception Details Report (Doc ID 2577615.1)

Last updated on MARCH 02, 2020

Applies to:

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

Symptoms

EXC: Transaction Exception Details report shows the following error for Inventory Misc Items:

Exception Reason : Original transaction is not accounted in final mode

The following reporting query from PRC: Generate Cost Accounting Events Exceptions For Inventory Misc Transaction Source- Original Transaction Is Not Accounted In Final Mode (Doc ID 2531519.1) returns the problem items:

SELECT cdl1.expenditure_item_id expenditure_item_id,cdl1.line_num line_num
FROM pa_cost_distribution_lines_all cdl1
WHERE transfer_status_code = 'G'
AND line_type = 'R'
AND acct_event_id IS NULL
AND EXISTS
(SELECT 1
FROM pa_cost_distribution_lines_all cdlg2
WHERE cdlg2.expenditure_item_id = cdl1.expenditure_item_id
AND cdlg2.line_num = cdl1.line_num_reversed
AND cdlg2.transfer_status_code = 'V'
AND line_type = 'R'
AND cdlg2.acct_event_id IS NULL
AND cdlg2.project_id = cdl1.project_id)
AND cdl1.project_id = 'project_id'
UNION
SELECT cdl1.expenditure_item_id expenditure_item_id
,cdl1.line_num_reversed line_num
FROM pa_cost_distribution_lines_all cdl1
WHERE transfer_status_code = 'R'
AND line_type = 'R'
AND acct_event_id IS NULL
AND EXISTS
(SELECT 1
FROM pa_cost_distribution_lines_all cdlg2
WHERE cdlg2.expenditure_item_id = cdl1.expenditure_item_id
AND cdlg2.line_num = cdl1.line_num_reversed
AND cdlg2.transfer_status_code = 'G'
AND line_type = 'R'
AND cdlg2.acct_event_id IS NULL
AND cdlg2.project_id = cdl1.project_id)
AND cdl1.project_id = 'project_id'
ORDER BY 1 DESC;

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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