Which table stores flags when update is done on supplier contact in Fusion ERP
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.