E1: 16: 42: Missing Deferred Revenue Amount at Sales Update (R42800) with Flex Accounting, Advanced Cost Accounting (ACA) and G/L Summarization Enabled and Cycle Billing Used for Scheduled Invoice Date (Doc ID 2836112.1)

Last updated on MARCH 22, 2023

Applies to:

Symptoms

When using Cycle Billing there is an issue with Sales Update report (R42800) that is causing difference in the posting of discount Loyalty (Deferred Revenue) and Unbilled A/R for the IB batches. Sales update report processed the order but batch posting report cannot post the particular IB batch because of mismatch between the Deferred Revenue and Unbilled A/R in the G/L table (F0911).
This issue seems to happen when the flex accounting is enabled for only one of the AAIs used for Deferred Journal Entries (4231 or 4232) and, also, the Summarize G/L entries is activated on Sales Update (R42800).

The issue can be reproduced at will without Advanced Cost Accounting setup with the following steps:

It is a two days process because deferred entries are created on 1st day through Cycle Billing and the Invoice runs on 2nd day followed by Sales Update and Batch Posting programs.

           First day (01/22/2022)

1. Go to Work With Invoice Cycle (P40315) and define Invoice cycle (BOD) on a customer (e.g. 670).
2. Select and go inside, Row exit and click on Calc Rule and set as below:
      Calculation Rule 6 = Based on Date
      Number of Days Increment 1
      Based On Date Name 6 = Actual Ship Date
3. Enter Fiscal Year 22, then check in the Date Validation Tests by entering today's date. Calc date should be next day date.
4. Save changes and come out from all screens.
5. Work With Flexible Sales Accounts (P40296) - Set flex accounting on Subsidiary using Short Item Number for DMAAI 4231. No flex setup for DMAAI 4232.
6. P4210 Enter a SO with 2 lines and different items for the customer set with Invoice cycle (670 / BOD). Order Date 01/22/2022.
7. P4205 Ship Confirm the SO.
8. Manually change the status of SO to 560-578.
9. Run Cycle Billing R49700 for the SO entered. The R42800 called has Summarize G/L entries by Invoice and flex accounting enabled.
10. Check the table F49211 for the record created:
       The Deferred Entries Flag (DEFF)  is 1
       Invoice Cycle (INCY) BOD
       Scheduled Invoice Date (SIDT) 01/23/2022
11. Notice the JEs created in F0911 table:  
        4 records for LNID 1 with JELN from 1,0 to 4,0. The lines corresponding to the accounts set behind DMAAIs 4232 (2,0), 4221 (3,0) and 4240 (4,0) have summarized amount for both lines of the SO.
        1 record for LNID 2 with JELN 5,0. The lines JELN 6,0 to 8,0 are missing for LNID 2 as their amounts were summarized within LNID 1.
    The accounts corresponding to DMAAI 4231 did not summarized due to the differentiation created by flex done on ITM which is different on the 2 SO lines.
    All good until now.
    
    Second day (01/23/2022): invoice printed, sales update and batch posting.
12. Run R42565_XJDE0009 – which generates the invoice number.
13. Run R42800 with same version as the one called by R49700. Note the Deferred Revenue amount for the second line on SO is missing.
14. Run R09801_ZJDE0006 to post the batch – Out of Balance error is displayed due to the mismatch between the Deferred Revenue and Unbilled A/R in the GL table.

Steps with Advanced Cost Accounting enabled:

First day (11/09/2022):

1. Advanced Cost Accounting setup:
   Go to P1620 and create Cost Object Types V, C, O, G:
2. Set ACA setup in Account Master P0901, select account -> Row Exit -> ACA:
   Cost Object Edit code 01 - Specific = V
   Cost Object Edit code 02 - Specific = C
   Cost Object Edit code 03 - Specific = O
   Cost Object Edit code 04 - Specific = G
3. Set different Category Codes for items in P41026 for SRP4
4. Go to Work With Invoice Cycle (P40315) and define Invoice cycle (BOD) on a customer (670).
5. Select and go inside, Row exit and click on Calc Rule and set as below:
   Calculation Rule 6 = Based on Date
   Number of Days Increment 1
   Based On Date Name 6 = Actual Ship Date
6. Enter Fiscal Year 22, then check in the Date Validation Tests by entering today's date. Calc date should be next day date.
7. Save changes and come out from all screens.
8. Work With Flexible Sales Accounts (P40296) - Set flex accounting on Cost Objects for DMAAI 4231.
   No flex setup for DMAAI 4232.
9. Enter a SO with 2 lines and different items for the customer set with Invoice cycle (670 / BOD). Order Date 11/09/2022.                            
10. Ship Confirm the SO.                                                  
11. Manually change the status of SO to 560-578.                            
12. Run R49700 for the SO entered. The R42800 called has Summarize G/L entries by Invoice and flex accounting enabled.
13. Check the table F49211 for the record created:
         The Deferred Entries Flag (DEFF)  is 1
         Invoice Cycle (INCY) BOD
         Scheduled Invoice Date (SIDT) 11/09/2022
Notice the JEs created in F0911: 2 lines for deferred revenue
All good until now.

Second day (11/10/2022): invoice printed, sales update and batch posting.
14. Run R42565_XJDE0009 – which generates the invoice number.
15. Run R42800 with same version as the one called by R49700. Note the Deferred Revenue amount for the second line on SO is missing.
16. Post the batch – Out of Balance error is displayed due to the mismatch between the Deferred Revenue and Unbilled A/R in the GL table.

Changes

Cause

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