My Oracle Support Banner

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

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
Symptoms
Cause
Solution
References


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.