My Oracle Support Banner

Incorrect Account Was Derived On Adjusted Expenditure Items With Custom Journal Line Types (Doc ID 2043585.1)

Last updated on FEBRUARY 03, 2019

Applies to:

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

Symptoms

User has setup Event Classes Miscellaneous Cost and Miscelleneous Cost
Adjustment to generate 2 sets of Journal Entries versus the standard one set.
1 set of custom Journal Line Types
1 set of standard Journal Line Types

The original EI generates the correct accounts, but when reversed the
accounts are not reversed correctly.


Example:

Original Expenditure Item

CDL
DR_CODE_COMBINATION_ID = 152294
CR_CODE_COMBINATION_ID = 83802

XLA_AE_LINES
1   83540
2   152294
3   83802
4       96319

XLA_DISTRIBUTION_LINKS
1  CUSTOM_MIS_COST_CIP_DR  (83540)
2  PA_RAW_COST  (152294)
3  PA_RAW_COST_CLEARING  (83802)
4  CUSTOM_MISC_COST_CIP_CLEAR_CR  (96319)

Event Class Miscellaneous Cost
Accounting Class   Account

Cost 01.15100000.DIR.000000.000000.00000000
Cost 01.62810000.STE.401843.000000.00000000
Cost Clearing 01.13230009.DIR.042936.000000.00000000
Cost Clearing 01.68399000.DIR.000000.000000.00000000



Reversing Expenditure Item

CDL
DR_CODE_COMBINATION_ID = 152294
CR_CODE_COMBINATION_ID = 83802

XLA_AE_LINES
1   83540
2   83540
3   83802
4        96319

XLA_DISTRIBUTION_LINKS
1  CUSTOM_MISC_ADJ_CIP_DR  (83540)
2  PA_RAW_COST_ADJ (83540)
3  PA_RAW_COST_CLEARING_ADJ (83802)
4  CUSTOM_MISC_ADJ_CIP_CLEAR_CR (96319)

Event Class Miscelleneous Cost Adjustment
Accounting Class  Account

Cost 01.15100000.DIR.000000.000000.00000000
Cost 01.15100000.DIR.000000.000000.00000000
Cost Clearing 01.13230009.DIR.042936.000000.00000000
Cost Clearing 01.68399000.DIR.000000.000000.00000000

The PA_RAW_COST_ADJ (83540) is not correct.  Is it incorrectly setting to the
account generated by the CUSTOM_MISC_COST_CIP_DR  (83540).

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


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.