Offer Adjustments Fail Error: "Product Return StatusE " and No Offer Adjustments are Created

(Doc ID 746419.1)

Last updated on SEPTEMBER 02, 2016

Applies to:

Oracle Trade Management - Version 11.5.10 to 12.2.3 [Release 11.5 to 12.2]
Information in this document applies to any platform.
Checked for relevance on 03-Jun-2014.

Symptoms

Offer adjustments do not create entries in Budget Checkbook after running Funds Accrual Engine (FAE) program.

Steps to Reproduce

  1. Responsibility: Oracle Trade Management
  2. Navigation: Trade Planning > Offer > Adjustments
  3. Create an offer adjustment
  4. Set the status to Active
  5. Responsibiity: Oracle Trade Management Administrator
  6. Navigation: Concurrent Programs > Run
  7. Run Funds Accrual Engine
  8. No entries are created in Budget Checkbook


    /****** Offer Adjustment Failed For OfferCA OB 09 Dealer Co-op Direct (71087)
    SOURCE CODE CA OB
    09 Dealer Co-op Direct (" Offer Adjustment Id "1 with the following Errors *******/
    Return Status After AdjustmentE
    /******** Begin Adjusting For Offer NAME 'CA OB 09 Dealer Co-op Direct
    (71087)' SOURCE CODE 'CA
    OB 09 Dealer Co-op Direct (' ******/
    OZF_Adjustment_Ext_PVT.perform_adjustment : Adjusting From Date
    15-JUL-08Adjusting To
    Date15-JUL-08
    OZF_Adjustment_Ext_PVT.perform_adjustment : Before Processing Product For
    Offer Adjustment Id 2
    OZF_Adjustment_Ext_PVT.process_offer_product : In Process Product 2
    OZF_Adjustment_Ext_PVT.process_offer_product : Get Sql Returns
    OZF_Adjustment_Ext_PVT.process_offer_product : Insert SqlINSERT INTO
    ozf_temp_eligibility(object_type, exclude_flag,
    eligibility_id,offer_adjustment_line_id) (SELECT
    'FUND', 'N', product_id,2 FROM ( ))
    OZF_Adjustment_Ext_PVT.perform_adjustment : After Process Product Return StatusE
    /*************************** DEBUG MESSAGE END *************************/
    /****** Offer Adjustment Failed For OfferCA OB 09 Dealer Co-op Direct (71087)
    SOURCE CODE CA OB
    09 Dealer Co-op Direct (" Offer Adjustment Id "2 with the following Errors *******/
    Return Status After AdjustmentE
    /*************************** ADJUST BD END *************************/
Logs from 12.2.3 instance:

/*************************** ADJUST BD START *************************/
/******** Begin Adjusting For Offer NAME 'PreBS Walmart Ozark Reserve' SOURCE
CODE 'AMER09140008ACC' l_offerAdjustmentIdTbl(i) : '11003'******/
OZF_Adjustment_Ext_PVT.adjust_backdated_offer : Perform Adjustment For 522278
OZF_Adjustment_Ext_PVT.perform_adjustment : Adjusting From Date
01-SEP-14Adjusting To Date02-OCT-14
OZF_Adjustment_Ext_PVT.perform_adjustment : Before Processing Product For
Offer Adjustment Id 11003
OZF_Adjustment_Ext_PVT.process_offer_product : In Process Product 11003
OZF_Adjustment_Ext_PVT.process_offer_product : Get Sql Returns
OZF_Adjustment_Ext_PVT.process_offer_product : Insert SqlINSERT INTO
ozf_temp_eligibility(object_type, exclude_flag,
eligibility_id,offer_adjustment_line_id) (SELECT 'FUND', 'N',
product_id,6003 FROM ( ))     <<< Note that FROM CLAUSE is missing !
OZF_Adjustment_Ext_PVT.perform_adjustment : After Process Product Return
StatusE
/****** Offer Adjustment Failed For OfferPreBS Walmart Ozark Reserve SOURCE
CODE AMER09140008ACC

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms