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

Last updated on MARCH 08, 2017

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

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