PCS Promotions JSON Cache Tables Don't Have Any Data
(Doc ID 2918117.1)
Last updated on DECEMBER 27, 2022
Applies to:Oracle Retail Pricing Cloud Service - Version 22.1 and later
Information in this document applies to any platform.
While validating the Pricing Cloud Services (PCS) integration with external applications via REST services:
Price Changes and Clearances integrations work fine. Promotions integration doesn't work - the service returns a blank response, even though PCS has promotions data available and Promotions JSON cache tables are empty.
Steps to recreate:
- Create a promotion in PCS
- Run RPM_PROMOTION_CACHE_ADHOC_JOB in POM
- Note that RPM_PROMO_JSON_CACHE has no rows and promotions REST service returns a blank response
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