Third Party Accrual From Resale Program Fails With A Divisor By Zero Error

(Doc ID 2378800.1)

Last updated on MARCH 30, 2018

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, Indirect Sales Management

Third Party Accrual from Resale Program fails with a divisor by zero error

Our Third Party Accrual program continues to error out from a divisor by zero error. This is impacting our accruals for UAT testing, and preventing us from going live. Log files being sent over ASAP.

ERROR
-----------------------
l_discount_type %
l_ord_grp_prod_bucket_price
exception in getting bucket priceORA-01476: divisor is equal to zero  ---- error
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) OZF_TP_ACCRUAL_PVT.Process_Pricing_Result: IFACE
(4) OZF_TP_ACCRUAL_PVT.Process_Pricing_Result: IFACE l_cust_account_id
(5) Create_Adj_And_Utilization mg USD
(6) p_act_util_rec.plan_currency_code mg: USD
(7) l_act_util_rec.plan_curr_amount mg:
(8) l_act_util_rec.plan_currency_code mg: USD
(9) l_act_budgets_rec.arc_act_budget_used_by mg: OFFR
(10) update_Act_budgets.plan_currency_code mg: USD
(11) SYSPARAM: Post to GL is T
(12) Source Table : OZF_FUNDS_UTILIZED_ALL_B
(13) Create_Adj_And_Utilization mg USD
(14) p_act_util_rec.plan_currency_code mg: USD
(15) l_act_util_rec.plan_curr_amount mg:
(16) l_act_util_rec.plan_currency_code mg: USD
(17) l_act_budgets_rec.arc_act_budget_used_by mg: OFFR
(18) update_Act_budgets.plan_currency_code mg: USD
(19) SYSPARAM: Post to GL is T
(20) Source Table : OZF_FUNDS_UTILIZED_ALL_B
(21) Create_Adj_And_Utilization mg USD
(22) Create_Adj_And_Utilization mg USD
(23) Create_Adj_And_Utilization mg USD
(24) Create_Adj_And_Utilization mg USD
(25) Create_Adj_And_Utilization mg USD
(26) Create_Adj_And_Utilization mg USD
(27) Create_Adj_And_Utilization mg USD
(28) Create_Adj_And_Utilization mg USD
(29) OZF_TP_ACCRUAL_PVT.Process_Pricing_Result: IFACE
(30) OZF_TP_ACCRUAL_PVT.Process_Pricing_Result: IFACE l_cust_account_id
(31) Create_Adj_And_Utilization mg USD
(32) p_act_util_rec.plan_currency_code mg: USD
(33) l_act_util_rec.plan_curr_amount mg:
(34) l_act_util_rec.plan_currency_code mg: USD
(35) l_act_budgets_rec.arc_act_budget_used_by mg: OFFR
(36) update_Act_budgets.plan_currency_code mg: USD
(37) SYSPARAM: Post to GL is T
(38) Source Table : OZF_FUNDS_UTILIZED_ALL_B
(39) Create_Adj_And_Utilization mg USD
(40) p_act_util_rec.plan_currency_code mg: USD
(41) l_act_util_rec.plan_curr_amount mg:
(42) l_act_util_rec.plan_currency_code mg: USD
(43) l_act_budgets_rec.arc_act_budget_used_by mg: OFFR
(44) update_Act_budgets.plan_currency_code mg: USD
(45) SYSPARAM: Post to GL is T
(46) Source Table : OZF_FUNDS_UTILIZED_ALL_B
(47) Create_Adj_And_Utilization mg USD
(48) Create_Adj_And_Utilization mg USD
(49) Create_Adj_And_Utilization mg USD
(50) Create_Adj_And_Utilization mg USD
(51) Create_Adj_And_Utilization mg USD
(52) Create_Adj_And_Utilization mg USD
(53) Create_Adj_And_Utilization mg USD
(54) Create_Adj_And_Utilization mg USD
(55) OZF_TP_ACCRUAL_PVT.Process_Pricing_Result: IFACE
(56) OZF_TP_ACCRUAL_PVT.Process_Pricing_Result: IFACE l_cust_account_id
(57) Create_Adj_And_Utilization mg USD
(58) p_act_util_rec.plan_currency_code mg: USD
(59) l_act_util_rec.plan_curr_amount mg:
(60) l_act_util_rec.plan_currency_code mg: USD
(61) l_act_budgets_rec.arc_act_budget_used_by mg: OFFR
(62) update_Act_budgets.plan_currency_code mg: USD
(63) SYSPARAM: Post to GL is T
(64) Source Table : OZF_FUNDS_UTILIZED_ALL_B
(65) Create_Adj_And_Utilization mg USD
(66) p_act_util_rec.plan_currency_code mg: USD
(67) l_act_util_rec.plan_curr_amount mg:
(68) l_act_util_rec.plan_currency_code mg: USD
(69) l_act_budgets_rec.arc_act_budget_used_by mg: OFFR
(70) update_Act_budgets.plan_currency_code mg: USD
(71) SYSPARAM: Post to GL is T
(72) Source Table : OZF_FUNDS_UTILIZED_ALL_B
(73) Create_Adj_And_Utilization mg USD
(74) Create_Adj_And_Utilization mg USD
(75) Create_Adj_And_Utilization mg USD
(76) Create_Adj_And_Utilization mg USD
(77) Create_Adj_And_Utilization mg USD
(78) Create_Adj_And_Utilization mg USD
(79) Create_Adj_And_Utilization mg USD
(80) Create_Adj_And_Utilization mg USD
(81) OZF_TP_ACCRUAL_PVT.Process_Pricing_Result: IFACE
(82) OZF_TP_ACCRUAL_PVT.Process_Pricing_Result: IFACE l_cust_account_id
(83) OZF_TP_ACCRUAL_PVT.Process_Pricing_Result: IFACE
(84) OZF_TP_ACCRUAL_PVT.Process_Pricing_Result: IFACE l_cust_account_id
(85) Create_Adj_And_Utilization mg USD
(86) p_act_util_rec.plan_currency_code mg: USD
(87) l_act_util_rec.plan_curr_amount mg:
(88) l_act_util_rec.plan_currency_code mg: USD
(89) l_act_budgets_rec.arc_act_budget_used_by mg: OFFR
(90) update_Act_budgets.plan_currency_code mg: USD
(91) SYSPARAM: Post to GL is T
(92) Source Table : OZF_FUNDS_UTILIZED_ALL_B
(93) Create_Adj_And_Utilization mg USD
(94) p_act_util_rec.plan_currency_code mg: USD
(95) l_act_util_rec.plan_curr_amount mg:
(96) l_act_util_rec.plan_currency_code mg: USD
(97) l_act_budgets_rec.arc_act_budget_used_by mg: OFFR
(98) update_Act_budgets.plan_currency_code mg: USD
(99) SYSPARAM: Post to GL is T
(100) Source Table : OZF_FUNDS_UTILIZED_ALL_B
(101) Create_Adj_And_Utilization mg USD
(102) Create_Adj_And_Utilization mg USD
(103) Create_Adj_And_Utilization mg USD
(104) Create_Adj_And_Utilization mg USD
(105) Create_Adj_And_Utilization mg USD
(106) Create_Adj_And_Utilization mg USD
(107) Create_Adj_And_Utilization mg USD
(108) Create_Adj_And_Utilization mg USD
(109) OZF_TP_ACCRUAL_PVT.Process_Pricing_Result: IFACE
(110) OZF_TP_ACCRUAL_PVT.Process_Pricing_Result: IFACE l_cust_account_id
(111) Create_Adj_And_Utilization mg USD
(112) p_act_util_rec.plan_currency_code mg: USD
(113) l_act_util_rec.plan_curr_amount mg:
(114) l_act_util_rec.plan_currency_code mg: USD
(115) l_act_budgets_rec.arc_act_budget_used_by mg: OFFR
(116) update_Act_budgets.plan_currency_code mg: USD
(117) SYSPARAM: Post to GL is T
(118) Source Table : OZF_FUNDS_UTILIZED_ALL_B
(119) Create_Adj_And_Utilization mg USD
(120) p_act_util_rec.plan_currency_code mg: USD
(121) l_act_util_rec.plan_curr_amount mg:
(122) l_act_util_rec.plan_currency_code mg: USD
(123) l_act_budgets_rec.arc_act_budget_used_by mg: OFFR
(124) update_Act_budgets.plan_currency_code mg: USD
(125) SYSPARAM: Post to GL is T
(126) Source Table : OZF_FUNDS_UTILIZED_ALL_B
(127) Create_Adj_And_Utilization mg USD
(128) Create_Adj_And_Utilization mg USD
(129) Create_Adj_And_Utilization mg USD
(130) Create_Adj_And_Utilization mg USD
(131) Create_Adj_And_Utilization mg USD
(132) Create_Adj_And_Utilization mg USD
(133) Create_Adj_And_Utilization mg USD
(134) Create_Adj_And_Utilization mg USD
(135) OZF_TP_ACCRUAL_PVT.Process_Pricing_Result: IFACE
(136) OZF_TP_ACCRUAL_PVT.Process_Pricing_Result: IFACE l_cust_account_id
(137) Create_Adj_And_Utilization mg USD
(138) p_act_util_rec.plan_currency_code mg: USD
(139) l_act_util_rec.plan_curr_amount mg:
(140) l_act_util_rec.plan_currency_code mg: USD
(141) l_act_budgets_rec.arc_act_budget_used_by mg: OFFR
(142) update_Act_budgets.plan_currency_code mg: USD
(143) SYSPARAM: Post to GL is F
(144) Source Table : OZF_FUNDS_UTILIZED_ALL_B
(145) ORA-01086: savepoint 'INSERT_VOLUME' never established in this session or is invalid
ORA-06512: at "APPS.OZF_VOLUME_CALCULATION_PUB", line 1070
ORA-01476: divisor is equal to zero in Package OZF_VOLUME_CALCULATION_PUB Procedure create_volume
(146) Unexpected error when processing pricing result. Please check log for detail.
(147) ORG ID is required.
(148) System Error: Organization identifier not found.
(149) Error occurred while inserting to resale log table.



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Set up volume offer with first line in discount tier as 0% discount

2.Run Third Party Accrual from Resale Program



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