R31804 - Error Code 'A224' Case Study

Purpose of Document

This document is part of an Information Center - to see other related documents, please use this link provided: Information Center: Overview of JD Edwards EnterpriseOne Prod Cstg & Mfg Acctg > Information Center: Troubleshooting JD Edwards EnterpriseOne Prod Cstg & Mfg Acctg > Document 1351725.1

This document describes possible causes for work center error messages displaying when running Variance Journal Entries (R31804).

Case Study on Error Code 'A224 - DMAAI 3280 accounts were used', which can be interpreted as below,

The Default DMAAI 3280 accounts were used
Possible reasons:

1. Completed versus Standard cost variance
2. Cost Rollup run in the middle of an order cycle
3. Complete quantity plus scrapped quantity does not equal the work or rate schedule quantity
4. Rounding issues
5. Key for AAI Tables 3220, 3240, 3260 or 3270 failed, AAI 3280 used as default table

This document explains the fifth example, "Key for AAI Tables 3220, 3240, 3260 or 3270 failed."

 Data from F3102 - Production Cost

Data from F3102 is written below (for example),

Order NumberShort Item No2nd Item NumberCost TypeP CStandard Amount [OPAT] (A)Actual Amount [CLAT] (B)Current Amount [CCCA] (C)Planned Amount [PLAT] (D)Completed Amount [CPAT]
(E)		Scrapped Amount [SLAT] (F)Engineering Variance [ENGV]
(G = C - A)		Planned Variance [PLNV]
(H = D - C)		Actual Variance [VACT]
(I = B - E)		Other Variance [OTHV]
(J = B - E + F - (G + H + I)
9999 2 B A1 P 8.4312 8.4314 8.4314 8.4314 8.4312          
9999 2 B A2 P                    
9999 2 B B1 P 0.5679   0.5678 0.5408 0.5679          
9999 2 B B3 P 0.4518   0.4519 0.4304 0.4518          
9999 2 B C1 P 0.0549   0.0550 0.0524 0.0549          
9999 2 B C2 P 0.2949   0.2948 0.2808 0.2949          

    
The data in the table above is sorted as below:

sql> SELECT * FROM PY909DTA.F3102 WHERE ( IGDOCO = 9999.000000 AND IGITM = 2.000000 AND IGPART = 'P' ) ORDER BY IGDOCO ASC,IGITM ASC,IGCOST ASC

 

Sequence of Variance Computation and its DMAAI:

          1. Set default AAI: 3280

2.Engineering Variance: (DMAAI = 3270)
Engineering Variance = {[Current Amount (F3102)(CCCA)]-[Standard Amount (F3102)(OPAT)]}-[Engineering variance amount (F3102)(ENGV)]

3. Planned Variance: (DMAAI = 3260)
Planned Variance = {[Planned Amount (F3102)(PLAT)]-[Current Amount (F3102)(CCCA)]} - [Planned variance amount (F3102)(PLNV)]

4. Actual Variance: (DMAAI = 3240/3220, DMAAI 3240 for cost type A1 and A2)
Material Usage Variance = {[Actual Amount (F3102)(CLAT)]-[Planned Amount (F3102)(PLAT)]} - [Actual variance amount (F3102)(VACT)]

5. Other Variance: (DMAAI = 3280)
Other Variance = [Actual Amount (F3102)(CLAT)]-([Completed Amount (F3102)(CPAT)]+[Scrapped Amount (F3102)(SLAT)])
                       - {Engineering Variance = [Current Amount (F3102)(CCCA)]-[Standard Amount (F3102)(OPAT)]}
                       - {Planned Variance = [Planned Amount (F3102)(PLAT)]-[Current Amount (F3102)(CCCA)]}
                       - {Material Usage Variance = [Actual Amount (F3102)(CLAT)]-[Planned Amount (F3102)(PLAT)]}
                       - [Other variance amount (F3102)(OTHV)]

6. WIP Balance:
NetVariance = {[Actual Amount (F3102)(CLAT)]-[Completed Amount (F3102)(CPAT)]}-[Net variance amount (F3102)(NETV)]


For this example, if there is no specific definition for 3270, 3260, 3240,3220 the system searches for 3280. If DMAAI 3280 is already used, then the error code A224 will be written into a Work Center message.

 

Example of variance computation:

A. COST=A1


B. COST=B1

 

How to debug:


[4](263): VA sec_AAINumber_ANUM = RV AAI Table Number - GV
[4](268): Processing BSFN : RetrieveDistributionAAI
Calling Business function RetrieveDistributionAAI from Level 1. Application Name [R31804], Version [ZJDE0001] (BSFNLevel = 1)
IN->[  1] mnAAITableNumber                 [3220]
IN->[  2] szCompanyNumber                  [08190]
IN->[  3] szOrderType                      [SC]
IN->[  4] szDocumentType                   [IV]
IN->[  5] szGLCategory                     [SIC ]
IN->[  6] szCostType                       [B1 ]
IN->[  7] szBranchPlant                    []
IN->[  8] szObjectAccount                  []
IN->[  9] szSubsidiary                     []
IN->[ 10] szCostCenter                     []
...
IN->[ 14] cVoidAccountValidation           [2]
IN->[ 15] mnJobNumber                      [1]
...
sql> SELECT  *  FROM PY909DTA.F4095  WHERE  ( MLANUM = 3220.000000 AND MLCO = '08190' AND MLDCTO = 'SC' AND MLDCT = 'IV' AND MLGLPT = 'SIC ' AND MLCOST = 'B1 ' )  ORDER BY MLANUM ASC,MLCO ASC,MLDCTO ASC,MLDCT ASC,MLGLPT ASC,MLCOST ASC
No More Data found
sql> SELECT  *  FROM PY909DTA.F4095  WHERE  ( MLANUM = 3220.000000 AND MLCO = '08190' AND MLDCTO = 'SC' AND MLDCT = 'IV' AND MLGLPT = '****' AND MLCOST = 'B1 ' )  ORDER BY MLANUM ASC,MLCO ASC,MLDCTO ASC,MLDCT ASC,MLGLPT ASC,MLCOST ASC
No More Data found
sql> SELECT  *  FROM PY909DTA.F4095  WHERE  ( MLANUM = 3220.000000 AND MLCO = '00000' AND MLDCTO = 'SC' AND MLDCT = 'IV' AND MLGLPT = 'SIC ' AND MLCOST = 'B1 ' )  ORDER BY MLANUM ASC,MLCO ASC,MLDCTO ASC,MLDCT ASC,MLGLPT ASC,MLCOST ASC
No More Data found
sql> SELECT  *  FROM PY909DTA.F4095  WHERE  ( MLANUM = 3220.000000 AND MLCO = '00000' AND MLDCTO = 'SC' AND MLDCT = 'IV' AND MLGLPT = '****' AND MLCOST = 'B1 ' )  ORDER BY MLANUM ASC,MLCO ASC,MLDCTO ASC,MLDCT ASC,MLGLPT ASC,MLCOST ASC
No More Data found

sql> SELECT  *  FROM PY909DTA.F4095  WHERE  ( MLANUM = 3280.000000 AND MLCO = '08190' AND MLDCTO = 'SC' AND MLDCT = 'IV' AND MLGLPT = 'SIC ' AND MLCOST = 'B1 ' )  ORDER BY MLANUM ASC,MLCO ASC,MLDCTO ASC,MLDCT ASC,MLGLPT ASC,MLCOST ASC
Fetched the record
OUT->[  1] mnAAITableNumber                 [3280]
OUT->[  2] szCompanyNumber                  [08190]
OUT->[  3] szOrderType                      [SC]
OUT->[  4] szDocumentType                   [IV]
OUT->[  5] szGLCategory                     [SIC ]
OUT->[  6] szCostType                       [B1 ]
OUT->[  7] szBranchPlant                    []
OUT->[  8] szObjectAccount                  [133000]
OUT->[  9] szSubsidiary                     [2000    ]
OUT->[ 10] szCostCenter                     [       93400]
...
OUT->[ 14] cVoidAccountValidation           [2]
OUT->[ 15] mnJobNumber                      [1]
...
Return value is 0 for RetrieveDistributionAAI. (BSFNLevel = 1)
...
[4](328): <met> If RV AAI Table Number - GV is not equal to VA sec_AAINumber_ANUM (3280 vs 3220 because F4095 does not have it)
[4](329): <Processing SET_UBE_ERROR> Set UBE Error("A224")

 

Note:

 

 

How to resolve this error?

To overcome error 'A224,' define DMAAI as appears in jdedebug.log for specific Cost Type and DMAAI combination (3220 B1 for this example). 

For this example, by adding DMAAI 3220.000000 AND MLCO = '08190' AND MLDCTO = 'SC' AND MLDCT = 'IV' AND MLGLPT = 'SIC ' AND MLCOST = 'B1

To discuss this information further with Oracle experts and industry peers, we encourage you to review, join or start a discussion in the E1 Manufacturing Community.

To look at upcoming or archived Advisor Webcasts please see Advisor Webcast Details Document 1450327.1 if your topic is not currently scheduled please suggest it.