Suppliers (Pay Sites) Are Not Being Published From MFCS and Remain in SUPPLIER_MFQUEUE Table (Doc ID 2950823.1)

Last updated on MAY 23, 2023

Applies to:

Symptoms

Suppliers (Pay Sites) are not being published from MFCS.

Suppliers having PAYMENT_SITE_IND = 'Y' are not being published from MFCS and getting stuck in SUPPLIER_MFQUEUE table.
On top of it, others supplier sites are taking long time to get published from MFCS to RIB.

Steps To Recreate:

1) MFCS integrated with CFIN via RFI.
MFCS system option FINANCIAL_AP is set to 'A'.

2) ADD_TYPE_MODULE where module = 'SUPP'.
    - set address type 01 to have primary_ind Y.
    - set address type 02 to 06 to have primary_ind N.
    - set address type 01, 02, 03, 05 to have mandatory_ind Y.
    - set address type 04, 06 to have mandatory_ind N.

3) Create Supplier in CFIN with 2 Sites and integrate with RFI to MFCS.
      - one site indicated as 'Purchasing' only.
      - another site indicated as 'Pay' only.

4) Verify after supplier and sites are in MFCS :
      - the 'Purchasing' site get published out of MFCS through RIB.
      - the 'Pay' site does not get published (which is correct and as expected),
     however, records for this 'Pay' site remains in SUPPLIER_MFQUEUE

Changes

Cause

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