E1: 03B/04: In Speed Invoice Entry (P03B11SI) and Speed Voucher Entry (P0411SV) With Batch Control On, When Using a Past or Future Batch Date (DICJ), the F0911.DSYJ for the PV/RI is Incorrectly Updated with this Date instead of Today's date (Doc ID 2872156.1)

Last updated on JULY 26, 2022

Applies to:

Symptoms

Batch Control is activated for A/R and A/P in the Constants (P0000). If a date value is used that is in the past or in the future for the Batch Date (DICJ) on the Batch Control form, this value is also incorrectly used for the ICU System Date (DSYJ) field on the PV and RI records in the General Ledger (F0911). This only happens when using either of the following programs:

• Speed Invoice Entry (P03B11SI)
• Speed Voucher Entry (P0411SV)

This works fine when using Standard Invoice Entry (P03B2002/P03B11) and Standard Voucher Entry (P0411).

Note: this is similar to an issue reported for the latter, Standard Voucher Entry (P0411), on Bug 25591623 - E1: 04: BATCH CONTROL CAUSES INCORRECT DATE IN GLDSYJ DURING VOUCHER ENTRY. You can review and download the ESU for this bug from the Update Center.

STEPS TO REPRODUCE

A/R Test

1. P0000: activate Batch Control for A/R
2. P03B11SI: create an AR invoice by clicking on Add:
   1. On the Batch Control form enter a future date in the batch date field, and save
   2. Add invoice information and save
3. Databrowser: get the records for the invoice from the following tables and note the Batch Date values:
   1. F0011
   2. F03B11
   3. F0911: the RI record has a DSYJ value equal to its DICJ value
4. R09801: post the invoice
5. Databrowser: get the records for the invoice from the following tables and note the Batch Date values:
   1. F0011
   2. F03B11
   3. F0911: the RI record still has a DSYJ value equal to its DICJ value; the AE record created by R09801 correctly has today’s date as its value.

A/P Test

6. P0000: activate Batch Control for A/P
7. P0411SV: create an AP voucher by clicking on Add:
   1. On the Batch Control form enter a future date in the batch date field, and save
   2. Add voucher information and save
8. Databrowser: get the records for the voucher from the following tables and note the Batch Date values:
   1. F0011
   2. F0411
   3. F0911: the PV record has a DSYJ value equal to its DICJ value
9. R09801: post the voucher
10. Databrowser: get the records for the voucher from the following tables and note the Batch Date values:
    1. F0011
    2. F0411
    3. F0911: the PV record still has a DSYJ value equal to its DICJ value; the AE record created by R09801 correctly has today’s date as its value.

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.