EAP: Is it Possible to Select a Different Bank SetID for a Supplier Regardless of What SetID is Associated to FS_39 Banks of the Consolidated Supplier SetID? (Doc ID 2972566.1)

Last updated on SEPTEMBER 06, 2023

Applies to:

Goal

Want to be able to establish a consolidated Supplier SetID using one SetID (for example WWWWW) which can be shared by all business units in the organization. The Bank SetID's (FS_39 Banks) will not change. It will match the corresponding Set Control Value (for example XXXXX, YYYYY, ZZZZZ). However, establishing one consolidated Supplier SetID forces some of the prompts within the Supplier pages to use the consolidated Supplier SetID of WWWWW (FS_38 Supplier Tables). One of the prompts affected is for the Bank. Since the Bank SetID points to the WWWWW SetID, when trying to search for a different SetID such as XXXXX, YYYYY, or ZZZZZ, the message of “No matching values were found” is displayed.

Is it possible to select a different Bank SetID for a Supplier regardless of what SetID is associated to FS_39 Banks of the consolidated Supplier SetID?

Solution

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