ATP Down Due To ATP Processing Error

(Doc ID 2327233.1)

Last updated on NOVEMBER 10, 2017

Applies to:

Oracle Global Order Promising - Version 12.1.3.9.1 and later
Information in this document applies to any platform.

Symptoms

12.1.x or 12.2.x

PROBLEM
-------------
ATP fails with ORA-01476 error in session file
Happens while trying to calculate the resource requirements for Resource Id := 4392
which is part of department_id := 42 in organization_id = 105


ERROR
---------
FROM FILE - session-13527610.zip

Get_Res_Requirements: Resource Id := 4392
Get_Res_Requirements: New Infinite Time Fence := 04-NOV-18
Get_Res_Requirements: Plan Cutoff Date := 04-NOV-18
Get_Res_Requirements: ATP RULE NAME for Resource :=
Get_Res_Requirements: h = 3
Get_Res_Requirements: J20-OCT-17
Get_Res_Requirements: H20-OCT-17
Get_Res_Requirements: New Requested Date: 23-OCT-17
Get_Res_Requirements: Resource Lead time:0
Get_Res_Requirements: l_requested_date:23-OCT-17
Get_Res_Requirements: batch flag back to null
Get_Res_Requirements: Dont do batching
Get_Res_Requirements: j := 2
Get_Res_Requirements: l_resource_id := 4392
Get_Res_Requirements: l_department_id := 42
Get_Res_Requirements: l_requested_date := 23-OCT-17
Get_Res_Requirements: l_resource_usage := .003891
Get_Res_Requirements: l_basis_type := 1
Get_Res_Requirements: l_efficiency := 0
Get_Res_Requirements: l_utilization := 0
Get_Res_Requirements: l_batchable_flag := 2
Get_Res_Requirements: l_op_seq_num := 20
Get_Res_Requirements: Offset % := .483871
Get_Res_Requirements: Lead Time := 1
Get_Res_Requirements: Actual Resource_Usage := .003891
Get_Res_Requirements: Reverse Cum Yield := 1
Get_Res_Requirements: l_max_capacity = 0
Get_Res_Requirements: l_batchable_flag = 2
Get_Res_Requirements: l_req_unit_capacity = .82
Get_Res_Requirements: l_req_capacity_uom = KG
Get_Res_Requirements: UOM type := 1
Get_Res_Requirements: l_res_uom :=
Get_Res_Requirements: l_item_conversion_rate := 1
Get_Res_Requirements: l_res_conversion_rate := 1
Get_Res_Requirements: Basis type 1,3 qty
Get_Res_Requirements inside when others <<<<< HERE IS WHERE IT FAILS ***
error := ORA-01476: divisor is equal to zero
ATP_CHECK: IN Error block for OTHERS
ATP_Check: error := User-Defined Exception
something wrong in the ATP_Check 2, sqlcode= 1
ATP_CHECK: ATP_PROCESSING_ERROR
Get_Comp_Reqs: IN Exception Block in others
error := User-Defined Exception
ATP_CHECK: IN Error block for OTHERS
ATP_Check: error := User-Defined Exception
something wrong in the ATP_Check 2, sqlcode= 1
ATP_CHECK: ATP_PROCESSING_ERROR
Schedule: error := User-Defined Exception
Schedule: Resetting G_INV_CTP and G_ALLOCATED_ATP
Schedule: ATP_PROCESSING_ERROR


*** NORMALLY you will see lines like below
Get_Res_Requirements: Basis type 1,3 qty
Get_Res_Requirements: l_requested_res_qty := 3.40122448979591836734693877551020408163 <<< >> HERE IS SHOWS HOW MANY RES HOURS ARE REQUIRED


STEPS
--------
Try to schedule an order OR Run ATP inquiry


BUSINESS IMPACT
----------------------
cannot schedule sales orders

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