E1: 41: Enhancement Request of Integrity Check Up To G/L Class level (Both R41543 And R41540 Not Checking Integrity Correctly) (Doc ID 2404763.1)

Last updated on AUGUST 05, 2022

Applies to:

Goal

Both R41543 and R41540 do not handle the scenario below,

Example of BOM with DMAAI 3110 during R31802A (Manufacturing Accounting Journal Entries) for a single order as below,
220                      (IN10) M30.1411.A
---| 2001              (IN20) M30.1411.B
------| 2004          (IN30) M30.1411.C
------| 2005          (IN30) M30.1411.C
---| 2002              (IN20) M30.1411.B

Branch   Item    UOM   G/L Class            Item Ledger Amount        G/L Amount            Variance
    M30   220     EA      IN10      
                                                          -------------------------------------------------------------
                                                                       93,246.72-          93,246.72-                    .00 <sum of account M30.1411.A>
     M30 2001    EA      IN20
     M30 2002    EA      IN20
                                                         --------------------------------------------------------------
                                                                       24,955.77-          24,955.76-                   .01- <Variance because of rounding & sum of account M30.1411.B>
     M30 2004    EA     IN20
     M30 2005    EA     IN20
                                                        ---------------------------------------------------
                                                                            20.97-                  19.41-                1.56- <Other variance on M30.1411.c>

As - Is comparison: comparison between F4111 and F0901 is not done up to G/L class code. As a result, the account to reconcile is not accurate when penny difference is found because of rounding. (It adds up all values from F0911 so long as F0911.OBJ = 1411 for this example). Note that rounding variance can be significant when the primary UOM is not the smallest unit of measure. For instance, the variance can exceed 1 dollar when primary UOM is KG and transaction UOM is GM (Gram).

- R41543 uses hard coded F40095.OBJ to determine the inventory account and read F0911.
- R41540 sets F0911.GPF1 = '1' when the record is originated from Inventory object

Hence, this request is to refine R41543 to get F40095.OBJ based on KCO, DCT, GLC (which returns unique OBJ) and compare the value from F4111 only for the specific account.

Solution

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