Error When Removing Offer Lines On Copied Net Accrual Offer (Doc ID 2091332.1)

Last updated on MARCH 08, 2017

Applies to:

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

Symptoms

In 12.1.3, Navigate to Oracle Trade Management User > Trade Management > Trade Planning

Create a copy of a Net Accrual Offer, when trying to remove the discount rule
line(s) get the following error.

1. Open an existing accrual offer Copy a Net Accrual offer and create a new one.
2. Open the newly created offer and check remove flag on any offer line.
3. Once you select update button you get the error.

ERROR
Operation is is :UPDATE
SQL statement: SELECT 1 FROM DUAL WHERE EXISTS (SELECT 1 FROM
JTF_RS_RESOURCE_EXTNS WHERE RESOURCE_ID = :b1)
SQL statement: SELECT 1 FROM DUAL WHERE EXISTS (SELECT 1 FROM
QP_LIST_HEADERS_ALL_B WHERE LIST_HEADER_ID = :b1)
SQL statement: SELECT 1 FROM DUAL WHERE EXISTS (SELECT 1 FROM
AMS_CUSTOM_SETUPS_VL WHERE CUSTOM_SETUP_ID = :b1)
SQL statement: SELECT 1 FROM DUAL WHERE EXISTS (SELECT 1 FROM
AMS_USER_STATUSES_VL WHERE USER_STATUS_ID = :b1)
OZF_ACTBUDGETS_PVT.Create_Act_Budgets: start
 create_Act_budgets.plan_currency_code mg:
request_currency USD
arc_act_budget_used_by OFFR
act_budget_used_by_id 2595705
approved_amount
status_code NEW
OZF_ACTBUDGETS_PVT.Create_Act_Budgets: validate
Create_Act_Budgetsl_src_currency USD
Create_Act_Budgetsbudget_source_type FUND
Create_Act_Budgetsbudget_source_id 15866
OZF_ACTBUDGETS_PVT.Create_Act_Budgets l_act_budgets_rec.exchange_rate_date3:
OZF_ACTBUDGETS_PVT.Validate_Act_Budgets: check items
SQL statement: SELECT 1 FROM DUAL WHERE EXISTS (SELECT 1 FROM OZF_ACT_BUDGETS
WHERE ACTIVITY_BUDGET_ID = :b1)
SQL statement: SELECT 1 FROM DUAL WHERE EXISTS (SELECT 1 FROM
QP_LIST_HEADERS_ALL_B WHERE LIST_HEADER_ID = :b1)
SQL statement: SELECT 1 FROM DUAL WHERE EXISTS (SELECT 1 FROM OZF_FUNDS_ALL_B
WHERE FUND_ID = :b1)
OZF_ACTBUDGETS_PVT.Validate_Act_Budgets: check record level
Create_Act_Budgets: check items
Offer Type is : NET_ACCRUAL
p_modifier_line_tbl.COUNT :0
Private API: Delete_offer_linestart
Private API: Delete_Productstart
Private API: Delete_Relationstart
Private API: Delete_Productend


 

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