My Oracle Support Banner

Unable To Activate The Adjustment For Ship And Debit Accrual Offer (Doc ID 2266014.1)

Last updated on JULY 14, 2020

Applies to:

Oracle Trade Management - Version 12.2.5 and later
Information in this document applies to any platform.


On : 12.2.5 version, Offers

When trying to create adjustments for all the offers of different type (Accrual, FAB Accrual, Volume Offer & Ship And Debit Accrual Offer) you need to just change the offer effective date using below APIs twice to create Adjustment and then update to make it Active.

OZF_OFFER_PUB.process_adjustment – for Non-Volume Offer
OZF_OFFER_PUB.Process_VO_Adjustment – for Volume Offer

It’s working fine for all the offer types except ‘Ship And Debit Accrual Offer’. For this offer type, adjustment is getting created but not getting Active. API is throwing below error message:-

calling OZF_OFFER_PUB.process_adjustment
API Return Status : E
Private API: Update_Offer_Adjustmentstart
Private API: - Open Cursor to Select
Private API: - Close Cursor
One or all of offer discount rule, qualifier data, effective dates needs to be changed in order to make an adjustment active.
Update_Offer_Adjustment: Status: E

The same error is seen in application when trying to activate the SD Accrual Offer.




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.