My Oracle Support Banner

Disabled Account Derivation Rule Account Does Not Error In Creat Accounting Uses Defualt Account (Doc ID 2757581.1)

Last updated on MARCH 08, 2021

Applies to:

Oracle Cost Management - Version 12.1.3 and later
Information in this document applies to any platform.

Goal

ACTUAL BEHAVIOR
---------------
when we run create accounting, if the derived account combination is disabled, we noticed that the account combination is replaced by the default cost variance
account defined at the inventory org level.

Problem summary: We have an account derivation rule for work in process valuation which works as follows:

The default material account from the wip class is used as the base account;
The expense code is derived based on the eam category code for stockable items, for
non-stockable items we use the purchasing category code, for direct purchases we use
the purchasing category code enter when creating the requisition;

For the cost center, if the operation has a value in the DFF then we will replace the
default cost center with the one define at the operation level.

When we run create accounting, if the derived account exists but is disabled, for wip issues, instead of
throwing an error, the account combination is replaced with the default cost variance account.

EXPECTED BEHAVIOR
-----------------------
need to stop this and just error these transactions/prevent them from going through to GL,
similar to when the account does not exist in GL then the transaction does not go through it
shows up as error in the Create Accounting log and users need to create the account and then
re process these transactions.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. We have work order 1954047 which is using the WIP accounting class = CC 0282
CMX EAM Planner > EAM Workbench > Query work order = 1954047

2. The default material account for WIP accounting class= CC 0282 is 8011
Work in Process > Setup > WIP Accounting Classes > Query WIP Accounting Class = CC 0282

3. Run Create Accounting in Draft mode for
CMX Supply Chain Closer > Accounting Close Cycle > Create Accounting

4. Review the output of the create accounting. With the ADR rule, we expect the work in
process valuation account to be 088-8011-252-0268-000-0000. Instead the account
used in the default cost variance account.

5. When we check this account we can see that it is disabled

6. However, if we enable account 088-8011-252-0268-000-0000 and run create account,
the correct account combination is derived and used (see below screenshot)

7. We need to stop this and just error these transactions/prevent them from going through to GL,
similar to when the account does not exist in GL then the transaction does not go through it
shows up as error in the Create Accounting log and users need to create the account and then
re process these transactions.
 

Solution

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
Goal
Solution


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