E1: 03B: Frequently Asked Questions on A/R EDI Lockbox Cash Receipts and Deductions Batch Upload (Doc ID 945685.1)

Last updated on DECEMBER 01, 2022

Applies to:

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

This document provides answers to frequently asked questions regarding A/R Interoperability.

	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

Purpose

Question 1: Is it possible to upload records to the F03B41Z1 table and validate through the Process Interoperability Deductions UBE (R03B41Z1)?

Question 2: When trying to use Inbound Receipt EDI Processing (823), is it required to have a record in the EDI Lockbox/Payment Header - Transactions (F47111) with a matching Line Number (EDLN) for every line number that needs processing in the subsequent tables?

Question 3: What is the first value EDLN (from F03B13Z1) can take when more lines are entered in an electronic receipt and how it is incremented?

Question 4: Can you re-run the R47111, if it stopped updating the F03B13Z1 table in the middle?

Question 5: Why R03B551 is ending with "Transaction failed to commit"?

Question 6: How can the DMTJ (Check Item date) be populated in the F03B13Z1 when running the R47111 (EDI - Update Electronic Receipts) as part of the 820 EDI process ?

Question 7: Can receipt records imported/uploaded through the Inbound Receipt EDI Processing (823) process to populate the F03B13Z1 table contain different values in the Document Company (KCO) field in the F47114 data within the same EDI batch?

Question 8: Does the Receipt Matching Reference 1 (RMR1) value in the F47114 table flow through to the F03B13Z1/F03B13/F03B14 to ultimately be visible in the Receipt Matching Reference 1 value in the P03B102 grid of the receipt?

Question 9: Does the Remark (RMK) value in the F47114 table flow through to the F03B13Z1/F03B13/F03B14 tables?

Question 10: Does the Remark (EXR) value that is visible in the header area of a receipt in P03B102 get populated by a value upstream in the EDI process from one of the F47* tables (F47111/F47112/F47113/F47114)?

Question 11: What are the key fields that need to be populated in F03B13Z1, when you have duplicate check numbers?

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