My Oracle Support Banner

Clearance ReST Service Creating Empty Clearance Group Records During Failures (Doc ID 3001819.1)

Last updated on FEBRUARY 01, 2024

Applies to:

Oracle Retail Pricing Cloud Service - Version 19.3 to 19.3 [Release 19.3]
Information in this document applies to any platform.


On : NA version, Operations & Maintenance

Clearance ReST service creating empty clearance group records during failures

While testing the integration between the PMO (Pricing markdown Optimization) and RPCS systems, it was observed that there are empty rpm clearance group records i.e records in rpm_clearance_group table and no subsequent clearance records in rpm_clearance table.

This can be seen when the ReST service returns an error due to an invalid item, invalid date, etc.

There should be no records created in either table; rpm_clearance_group nor rpm_clearance

The issue can be reproduced at will with the following steps:
1. Make clearance ReST service calls with Invalid Item or Invalid Date.
2. Invoke the service
3. Observe that there are empty records created in RPM_CLEARANCE_GROUP table which do not have corresponding records in RPM_CLEARANCE table


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.