Which table stores flags when update is done on supplier contact in Fusion ERP — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Which table stores flags when update is done on supplier contact in Fusion ERP

edited May 20, 2024 3:02PM in Supplier Management 1 comment

Summary:

I am currently creating an OIC integration based on the Supplier update event from Fusion ERP. In my process, I have been monitoring changes based on the 'supplier_locked_flag' in 'poz_suppliers_v' and 'request_status_code' in 'poz_supp_requests'.

Typically, when there is an update on a supplier's profile or a site addition, the 'supplier_locked_flag' is altered to 'Y', and subsequently reverts to 'N' once the request has been approved. However, I have noticed certain instances where this flag isn't updated despite changes being made, such as when updates are made to Contact Information, Products Services, or Bank details on the supplier's end. These updates do not require approval.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!