E1: 42: Sales Update (R42800) Returns Account in AAI Table 4230 Invalid Errors (029Q and 043C) (Doc ID 3040681.1)

Last updated on AUGUST 12, 2024

Applies to:

Symptoms

A new Freight line was recently created. A two-line Sales Order is created with the old freight line and the new freight line. When the order is processed by Sales Update (R42800) four errors are returned to the work center.

ERROR #1
Fetch Unsuccessful (017F)
CAUSE: An error occurred while fetching a record.
RESOLUTION: Verify that the record being fetched is valid.

This error was returned by GetTableColValue (b4002420) on Line 913 of the code

ERROR #2
Account XXXXX.YYYY in AAI Table 4230 invalid (029Q)
CAUSE : The Account Number 10010.5310 referenced by Distribution AAI Number 4230 is invalid. Either this account does not exist or has a posting edit
code that does not allow manual journal entries.
RESOLUTION : Check the Account Number to verify that it exists and has a valid posting edit code for data entry. Change the Distribution AAI to reference a valid account or add the missing account

This error was returned by RetrieveDistAAIwF4095Cache (b4000351) on Line 544 of the code

ERROR #3
Account Number XXXXX.YYYY is Invalid (043C)
CAUSE . . . . XXXXX.YYYY does not exist in the Account Master file (F0901).
RESOLUTION. . Enter the correct account number.

This error is returned by ProcessDistributionAAICache (b4204190) on Line 629 of the code

ERROR #4
Account Number ZZZZZ.YYYY(043C)
CAUSE . . . . ZZZZZ.YYYY does not exist in the Account Master file (F0901).
RESOLUTION. . Enter the correct account number.

This error is returned by GetSalesAAIsAndCallF0911EditLine (b4200520) on Line= 2578 of the code

Steps to Reproduce:

1. Create a two line sales order with SO Order Type and two freight lines as follows:
   1. Line 1 is Item AAAA with N Line Type with G/L Class Code GLC1
   2. Line 2 is Item BBBB with N Line Type with G/L Class Code GLC2
2. Process the order all the way through Sales Update (R42800) and the job fails and sends these four errors to the work center.
   1. Fetch Unsuccessful (017F)
   2. Account XXXXX.YYYY in AAI Table 4230 invalid (029Q)
   3. Account Number XXXXX.YYYY is Invalid (043C)
   4. Account Number ZZZZZ.YYYY is Invalid (043C)

Cause

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