When A Supplier Update is Sent from CFIN After approving Deal Upload Status Is Overwritten (Doc ID 2826657.1)

Last updated on OCTOBER 28, 2022

Applies to:

Symptoms

When a supplier first come across from CFIN to MFCS through RFI integration, MFCS will default the deal_upload_status in SUPS table to 'W'.
Using MFCS UI, we then change the deal_upload_status from 'W' to 'A' so that deals created by dealupld batch will be created in approved status.
The subsequent update of the supplier from CFIN > RFI > MFCS will cause the deal_upload_status to revert back to default value of 'W'.



Steps to reproduce : 

1) Create new supplier in CFIN
2) New supplier/site(s) should end up in MFCS
- Confirm that deal_upload_status in SUPS table is 'W' (default)
3) Login to MFCS UI and change deal_upload_status from W to A
4) Login to CFIN and make some changes for the same supplier/site(s)
5) Updated supplier/site(s) should flow from CFIN > RFI > MFCS
- Notice that deal_upload_status is reverted back to "W" 

Cause

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