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.


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.

==================== 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.

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

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

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




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.