My Oracle Support Banner

Third Party Accrual From Resale Table Running Into Error For A Customer (Doc ID 2725734.1)

Last updated on NOVEMBER 04, 2020

Applies to:

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

Symptoms

On : 12.1.3 version, Budget Concurrent Requests

In Trade Management User is running the Third Party Accrual From Resale Table and is encountering an error.
 

ERROR
-----------------------
==================== get_as_of_date_volume ====================
PK is 
volume b4 trx_date 662087.24
volume of trx_date 0
as_of_date_volume 662087.24
accrual amount from pricing = -11.136
accrual amount from pricing(after rounding) = -11.14
JL: bill_to_site_use_id = 

...
Update_Act_Budgets: create_act_budgets ledger for util.org_id(xxx)=2021
UNEXP ERROR in process_one_line
UNEXP ERROR in process_pricing_result
(1) OZF_TP_ACCRUAL_PVT.Process_Pricing_Result: IFACE
(2) OZF_TP_ACCRUAL_PVT.Process_Pricing_Result: IFACE l_cust_account_id
(3) Create_Adj_And_Utilization mg USD
(4) p_act_util_rec.plan_currency_code mg: USD
(5) l_act_util_rec.plan_curr_amount mg:
(6) l_act_util_rec.plan_currency_code mg: USD
(7) l_act_budgets_rec.arc_act_budget_used_by mg: OFFR
(8) update_Act_budgets.plan_currency_code mg: USD
(9) Requested amount is more then committed amount. Please request more budget.
(10) User-Defined Exception in Package OZF_RESALE_COMMON_PVT Procedure Create_Adj_and_Utilization
(11) Unexpected error when processing pricing result. Please check log for detail.
(12) ORG ID is required.
(13) System Error: Organization identifier not found.
(14) Error occurred while inserting to resale log table.
(15) Error happened when processing resale orders.



STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. Trade Management
2. Run concurrent program Third Party Accrual From Resale Table

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot process Third Party Accrual From Resale Table

Changes

 

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
Changes
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.