Updating PONumber in Verifier is not Updating to the Correct Vendor Details (Multiple Company Codes) (Doc ID 2054515.1)

Last updated on SEPTEMBER 29, 2022

Applies to:

Symptoms

There are multiple Organizations within the purchasing company which go by different Company Codes (e.g. 101 and 690). Both companies may issue the same Purchase Order number for different purchases (e.g. both ORGS 101 and 690 issue a PO Number "10138" for different purchases to different vendors). However, when attempting to change the PONumber in Verifier, the vendor gets updated with the same value regardless of the Company Code specified in Verifier. For instance, the following 2 records exist in the PO Number view:

VENDORID;   PONUMBER;      COMPANY_CODE;     CURRENCY
95338;         10138;            690;                       XOF
1055;           10138;            101;                       GHS

Whenever updating the PONumber to 10138, the VendorID for the first record in the POHeader table updates the vendor in Verifier, and therefore the Currency of XOF is always set as well as the vendor details for that first vendor in the table. There needs to be a way to allow Verifier to update the correct vendor details (including currency) from the PO Header table / view.

Cause

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