My Oracle Support Banner

MFCS Order Message Should Not Fail with PUBERROR for Missing ITEM_SUPP_COUNTRY Record (Doc ID 2977191.1)

Last updated on OCTOBER 04, 2023

Applies to:

Oracle Retail Merchandising Foundation Cloud Service - Version 19.3 and later
Information in this document applies to any platform.


PO 91016125 has been failing publication. It’s being republished but always failing as it’s in the hospital.

Publication fails with NO_ORD_DETAIL_PUB - Order detail cannot be found for order being published. When publishing logic in RMSMFM_ORDER is trying to publish, it’s trying to find the PO details but can’t find it. The cursor C_GET_DETAIL_MSG_INFO is failing to return records.

No records are found when the cursor joins with ITEM_SUPP_COUNTRY. The PO has item/supplier/origin country of 809689/ 42967/MM but ITEM_SUPP_COUNTRY only has 809689/ 42967/CN. This results in pubError.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

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