FA: SCM: Pricing: Error Thrown When Creating Revision Of Configured Order. (Doc ID 2937614.1)

Last updated on APRIL 10, 2023

Applies to:

Symptoms

On : 11.13.22.10.0 version, Pricing

Revising Configured Order to change the configuration from one item to a different item.  Manual price adjustment is on the model item and the adjustment is spread against the child items.
On trying to submit this order, they encounter error message:


ERROR
-----------------------
JBO-29000: Unexpected exception caught: oracle.apps.scm.pricing.priceExecution.algorithms.publicQuery.exception.SetQueryException, msg=Failed to execute onEach Closure. Division by zero # Algorithm Call Stack ----------------------- scc.UnitPrice.Value /= CompLine.PerModelUnitQuantity.Value at Step 'Write Spreads on Native Charges' at Algorithm: 'Spread Adjustments-2' at SubAlgorithm: 'Spread Adjustments' at Step 'Spread Matrix Adjustments' at Step 'Spread Adjustments' at Step 'Process Pricing Matrices' at Algorithm: 'Apply Matrices-1' at SubAlgorithm: 'Apply Matrices' at Step 'Invoke Apply Matrices' at Step 'Apply Matrix Adjustments' at Algorithm: 'Apply Pricing Terms-1' at SubAlgorithm: 'Apply Pricing Terms' at Step 'Invoke Apply Discount Terms' at Step 'If Terms Exist' at Step 'Process Candidates' at Algorithm: 'Apply Discounts-1' at SubAlgorithm: 'Apply Discounts' at Step 'Apply Discounts' at Step 'Calculate Invoice Price' at Algorithm: 'Calculate Pricing Charges-1' at SubAlgorithm: 'Calculate Pricing Charges' at Step 'Calculate Pricing Charges' at Step 'Calculate Pricing Charges For Goods and Services' at Algorithm: 'Price Sales Transactions-1' # Algorithm Variable Stack --------------------------- Algorithm: 'Spread Adjustments-2' payload: VariableName:'PriceRequest' DateType:'commonj.sdo.DataObject' IOType:'InOut' value:' OPTION_CLASS 2023-02-23T16:44:34.007Z Astec Direct Pricing Strategy false true true false 300000028380958 100000010557637 100000010530978 100000010518728 100000010541063 100000009747532 US S 1 100000032411101 100000009723989 300000028413002 ORDER 100000032411112 1 EA ORA_BUY 1 2023-02-23T16:33:19Z 2023-02-23T16:44:34.278Z 300000037571731 GOODS 100000032411109 300000028412447







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

Order Management/Create Order
1. Query order that has been submitted for a Configured Order.
2. Actions/Create Revision.
3. Change the options selected for the item configuration from one item to another.
4. Click OK.

5. Receive error:

JBO-29000: Unexpected exception caught: oracle.apps.scm.pricing.priceExecution.algorithms.publicQuery.exception.SetQueryException, msg=Failed to execute onEach Closure. Division by zero #

Changes

Implemented algorithm change:

Pricing Algorithm - Spread Adjustments is to be changed to fix this incorrect prorate issue. This setup fixed the incorrect adjustment prorate issue is seen even when the Model has non zero price. The adjustment has been prorated uniformly for all the eligible items.

1. Go to 'Manage Algorithms' in 'Pricing Administrator'
2. Search for 'Spread Adjustments' algorithm
3. Select Version 1 and create Version from Actions
4. Click on latest created version.
5. Select 'Write Spreads on Native Charges step
6. Go to Default Action:
7. Look at this section:

if ('ROOT' != CompLine.ItemType) {
   assert CompLine.PerModelUnitQuantity != null
   scc.UnitPrice.Value /= CompLine.PerModelUnitQuantity.Value
}

8.  The above will be changed.

Cause

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