My Oracle Support Banner

E1: 03B: When Running R03B551 (Update Receipts Header) and Updating the Customer Bank Account in the F0030 (Bank Transit Master) a Work Center Error on the F00022 (Next Unique Number) for the F0030 UKID (Unique Key ID) Number is Given (Doc ID 2854340.1)

Last updated on MARCH 08, 2022

Applies to:

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

Symptoms

When activating the following processing option to Update the Bank Account Information on a Customer that does not currently have any Bank Account Information, the system is giving Work Center Error “The record to be fetched from table F00022 does not exist or you do not have authority to fetch records from this table.” when processing the Batch Receipt with R03B551.

Processing option 1 on the Updates tab of R03B551 is set to 1:

  1. Bank Account Information 1
    Blank = No update
    1 = Update

Work Center message text says:

CAUSE . . . .  The record to be fetched from table F00022 does not exist or you
              do not have authority to fetch records from this table.

RESOLUTION. . Verify that the record being fetched exists and that you have
              proper authority.  Check the JDE.LOG and JDEDEBUG.LOG for
              additional information.

The JDEDEBUG.LOG shows the following:

 

Steps to duplicate error in your test environment:

  1. Verify the Customer Master (P03013) record for the customer does not have any Bank Account Information set up in P0030A.
  2. Add an Invoice in Standard Invoice Entry (P03B2002) for the customer. Post the invoice (R09801).
  3. From Review Electronic Receipts (P03B121) create a record in the F03B13Z1 with no Customer Number value, but with the following fields populated:

    • Receipt and G/L date
    • Company
    • Company G/L Bank account
    • Payor Bank Transit number
    • Payor Bank Account number
    • Receipt Amount
    • Remark
    • Document Company
    • Document Type
    • Invoice Document Number
    • Pay Item
    • Amount to Apply

  4. Set processing option 1. for the Updates tab of R03B551 (Update Receipts Header) to 1.
  5. Verify you have set up an Execution list that will be used in the process along with the associate R03B551 and R03B50 versions set to call that Execution list.
  6. Set processing option 1. for the Updates tab of R03B551 (Update Receipts Header) to 1.
  7. Run the R03B551 calling the R03B50 and note the Work Center error(s) and verify the Customer Bank Account did not get updated.

 

Changes

 

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
Changes
Cause
Solution

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