My Oracle Support Banner

BDI_PRICING_PROMO_OFFER_TX_JOB Fails When Location Lists are Used For Promo Creation (Doc ID 2762660.1)

Last updated on APRIL 08, 2021

Applies to:

Oracle Retail Pricing Cloud Service - Version 19.1 and later
Information in this document applies to any platform.

Symptoms

BDI_PRICING_PROMO_OFFER_TX_JOB Fails When Location Lists are Used For Promo Creation. Below error can be noted in the server logs.

Error: Calling Oracle Function RMS01.RPM_PROMO_OFFER_BDI_SQL.PUBLISH_PROMO_OFFERS .
Oracle Function RMS01.RPM_PROMO_OFFER_BDI_SQL.PUBLISH_PROMO_OFFERS executed but returned with error @0PACKAGE_ERROR@1ORA-01400: cannot insert NULL into (RMS_BDI_INT.PROMO_OFFER_LOC_OUT.EXCLUDE_IND)@2RPM_PROMO_OFFER_BDI_SQL.BUILD_ADD_DEL_OFFER_LOC."

Steps to reproduce:
-------------------
1. Create a promotion using the Localtion List and approve them.
2. Run BDI_PRICING_PROMO_OFFER_TX_JOB.
3. Note the job fails and the above error can be noted in the server logs.

Cause

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
Symptoms
Cause
Solution
References


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