My Oracle Support Banner

Datafix/Root-Cause: Uncosted Transaction Error: CST_INVALID_ACCT_ALIAS / The Account Alias Is Not Defined For This Org [Video] (Doc ID 428403.1)

Last updated on SEPTEMBER 28, 2018

Applies to:

Oracle Inventory Management - Version 11.5.10.0 and later
Information in this document applies to any platform.
FORM:INVTVTXN.FMB - View Transactions

This document includes all versions of 11i
This document includes all versions of R12.0.x, R12.1.x, and R12.2.x.


Symptoms

Find uncosted transactions with the following error in the Material Transactions (INVTVTXN.fmb) form.

Error (Error Code: CST_INVALID_ACCT_ALIAS)

The account alias is not defined for this organization.


Steps
See the costing error with the following steps BUT users could not replicate the issue at will:

  1. Navigate to Inventory > Transactions > Material Transactions
  2. The find window appears
  3. Enter the query criteria.
  4. Press Find.
  5. Navigate to the Reason, Reference tab.
  6. Review the error code / error explanation.

Steps: Forcing the Issue
Support engineers were able to force the issue to happen with 2 scenarios. In scenario #1, the engineer used Help > Diagnostics > Examine to clear the account alias source id. The record saved and caused the data corruption. In scenario #2, the navigation including a backwards tab allowed the engineer to clear the source.

Scenario #1: Help > About
This is not a recommended and NOT a supported approach but discussed here to show how the issue could be tested.

Important: This method in Scenario #1 forces the corruption using Help > Diagnostics > Examine. This is NOT a supported method to use in normal application usage and is only shared to FORCE bad data. The root cause (RCA) patches do not prevent or fix this scenario #1. Again, you would not do this in normal work and it is NOT supported.


Video - Issue With Help > Diagnostics (02:45)


Scenario #2: Backwards Tab
This is not a recommended approach but discussed here to show how the issue could be tested. You start to enter a transaction, go back to the header information and backward tab to the date. After this, you can perform a transaction without the source entered.



Business Impact
Users cannot close the related inventory period related to the transactions. All transactions must be costed before the period can close.

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
 A. Datafix
 1. Check the data.
 2. Backup data.
 3- Run the datafix script.
 4- Check the data.
 B. Preventing the Issue
References

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