My Oracle Support Banner

E1: 76B: The Update F7603B1 Credit Groups - Brazil (R7603B1) UBE Incorrectly Sets the Bank Duplicata Number (BBDN) in the A/R Additional Information – Brazil table (F7603B1) to Blank. (Doc ID 2878621.1)

Last updated on JUNE 22, 2022

Applies to:

JD Edwards EnterpriseOne Accounts Receivable - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

When the Update F7603B1 Credit Groups - Brazil (R7603B1) UBE is run to group invoices together for auto receipts processing, it incorrectly blanks out the value in the Bank Duplicata Number (BBDN) field of the records for these invoices in the A/R Additional Information – Brazil table (F7603B1).

This happens even if the value in Processing Option 2 on the Mode tab of R7603B1 is set to a blank. Per the text for this processing option:

Enter "1" if you want to update Duplicata Number with the value retrieved from the Dynamic Formater G/L Bank Account file (F76B477).

Enter any other value to keep current Duplicata Number.

The help text behind this processing option states the same:

This PO indicates if the UBE updates Bank Duplicata Number in A/R Additional Information file (F7603B1) with the value retrieved from Dynamic Formater G/L Bank Account file (F76B477). Valid values are:

'1': update Bank Duplicata Number.

Other value: do not update Bank Duplicata Number.

 

STEPS TO REPRODUCE

  1. Setup:
    1. P0092: set the Localization Country Code field to BR for Brazil.
    2. UDC: make sure that these UDC tables are set up with the values that you want to use in the layouts:
      1. Bank Codes (76/BC)
      2. Date Format (00/DF)
      3. Date Separator (H98/DS)
      4. Decimal Format (H98/DE)
      5. Direction Indicator (00/DN)
      6. Record Type (00/RD)
      7. Transaction Type (00/TT)
    3. Batch/Interactive Versions: set up versions and processing options for:
      1. P01012BR
      2. R7603B1: make sure that processing option 2 on the Mode tab does NOT have a 1 (one) in it.
    4. Set up a Brazil Company:
    5. P0030G: set up a GL bank account for the Brazil Company.
    6. Bank Additional Information for Dynamic Formatter (P76B474):
      1. Specify the payment instrument to be used for auto receipts.
      2. Row exit GL Bank Account: make sure there is a value for the Bank Duplicata number.
    7. Set up a Brazil customer:
      1. P03013
      2. P01012
      3. P01012BR
      4. P0030A
  2.  Processing:
    1. P03B11: create some invoices for the customer.
    2. R09801: post the invoices.
    3. Databrowser: get the records for the invoices from the following tables as a baseline:
      1. F03B11
      2. F7603B1
    4. Using SQL update the Duplicata field in the F7603B1 for the invoices.
      NOTE: there is no standard application that will update this field; clients have also used custom programs to update it with the Duplicata value they received from their banks for the invoices.
    5. Databrowser: get the records for the invoices from the following tables:
      1. F7603B1: verify that the Duplicata field for the invoices has the updated value
    6. Run R7603B1 to update credit groups with all the required values to be sent to the bank.
      1. Proof mode
      2. Final mode
    7. Databrowser: get the records for the invoices from the following tables:
      1. F7603B1: the Duplicata field for the invoices is now blank
    8. P7603B1: the Duplicata field for the invoices is now blank.

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


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