E1: 43: Supplier/Item Relationship FAQ (F43090 / P43090) (Doc ID 1619779.1)

Last updated on MARCH 06, 2023

Applies to:

JD Edwards EnterpriseOne Procurement and Subcontract Management - Version 9.0 and later
Information in this document applies to any platform.

This document serves as a compilation of questions and answers for the Supplier/Item Relationship functionality in Procurement.

	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 there an interoperability program or EDI program to upload the Supplier/Item Relationship (F43090) table through a batch process?

Question 2: Is there a way for a Supplier/Item Relationship (F43090) record to get created automatically during the creation of an Item Branch Record with the supplier populated?

Question 3: Is there a way for a Supplier/Item Relationship (F43090) record to get created automatically during the creation of the first purchase order for a new supplier and item?

Question 4: Is it possible to create multiple Supplier/Item Relationship records with the same supplier, branch and item, but different effective dates?

Question 5: Is there a standard batch or application available to update the F43090.PCCXPJ field (Expiration Date)?

Question 6: What function is performed by Supplier/Item Relationships Rebuild (R43900)?

Question 7: Is it required to enter a branch/plant (BU) when adding a non-stock item to F43090?

Question 8: Why is the alternate route is being selected more often than every 5th receipt when the Supplier/Item Relationships Frequency Number (F43090.TFRQ) is set to 5 for every fifth receipt?

Question 9: When processing option 5 is activated for Supplier Analysis within Enter Purchase Orders (P4310), what fields will be populated in the Supplier/Item Relationships Table (F43090)?

Question 10: Can the default receipt route be updated in the F43090 based on the processing option default in the R43900 if a receipt record (F43121) does not exist?

Question 11: The Stocking Type in the Find/Browse Form for this application is showing the Stocking Type from the Item Master (F4101). Is there a way to instead retrieve the Stocking Type value from the F4102 (Item/Branch?)

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