BDI Jobs Failing During Nightly Cycle with PACKAGE_ERROR@1ORA-01400: Cannot Insert NULL
(Doc ID 2903401.1)
Last updated on OCTOBER 18, 2022
Applies to:
Oracle Retail Merchandising Foundation Cloud Service - Version 19.2 to 19.2 [Release 19.2]Information in this document applies to any platform.
Symptoms
3 BDI jobs in failed status and 2 RPM jobs are Skipped on error status in nightly cycle.
1. BDI_PRICING_PC_TX_CYCLE_JOB - Error
2. BDI_PRICING_CLR_TX_CYCLE_JOB- Error
3. BDI_PRICING_PROMO_OFFER_TX_CYCLE_JOB -Error
4. RPM_PRICE_CHANGE_PUBLISH_CYCLE_JOB – Skipped on Error
5. RPM_CLEARANCE_PUBLISH_CYCLE_JOB- Skipped on Error
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 |