E1: 01: How To Upload Supplier Master Records (R04010Z)
(Doc ID 625789.1)
Last updated on JANUARY 14, 2020
JD Edwards EnterpriseOne Address Book - Version XE and later Information in this document applies to any platform.
Once an address book record is uploaded successfully into the Address Book Master (F0101) table, additional information can be processed into the Supplier Master (F0401) table using the Supplier Master Upload program (R04010Z). The table that is used to process this information is the Supplier Master - Batch File (F0401Z1).
A custom program must be written to upload information into the Supplier Master - Batch File (F0401Z1) table from another system. When records are processed successfully, the records will be added to the Supplier Master (F0401) table. The requirements for mapping fields are outlined below. The key to processing additional information is that the Address Book Number (AN8) must the same number that was assigned to the record during the Address Book Batch Upload process. Address Book Number (AN8) is the key required field for uploading information into the Customer Master (F03012Z1) and Supplier Master ( F0401Z1) Batch Processing tables. In order to identify source address book records from an external system, consider utilizing the Long Address Book Number field (ALKY) to record the "old" address book number. Then, once address book records are created in the Address Book Master (F0101) table, the newly assigned Address Book Numbers (AN8) can be associated with "old" source address book number for uploading information into the Customer and Supplier Master tables. This will make the transition easier for the users in identifying the number conventions for AN8.
If records are not processing correctly into the F0401 when R04010Z is run, enter in a transaction into the F0401Z1 manually through Supplier Master Batch Revisions (P0401Z1). This program will help identify fields the system is requiring and other fields not mapped correctly. This is a required step prior to contacting the Global Support Center, if the upload is not successful.
Note: For troubleshooting purposes, Oracle Support asks that you try a manual test first. If the processor is successful, this test can be a mapping guide for your custom upload program. Please note that Oracle Support is not able to troubleshoot your custom upload program, please duplicate issue/error with manual test for service request troubleshooting.
Documents process functionality, as well as which fields are required, optional and ignored for uploading information into the Supplier Master (F0401) table.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!