My Oracle Support Banner

Excess And Obsolescence Report Does Not Calculate Expired Lots As Excess (Doc ID 2392341.1)

Last updated on FEBRUARY 28, 2019

Applies to:

Oracle Advanced Planning Command Center - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Reports and Dashboards

ACTUAL BEHAVIOR

Excess and Obsolescence report does not calculate expired lots as excess

Expired lot is included within Demand within Excess Horizon on APCC E&O Report and Aggregate Horizontal Plan drill-down.

It is accurate to reflect the expired lot as no longer available supply. However, since the lot is expiring it is truly excess inventory that needs to be reserved for and this is not reflected in E&O calculations.
According to the APCC user’s guide, Excess On-Hand is computed as follows: Max{On Hand – Demand within Excess Horizon, 0}.
However, to calculate accurate E&O for the purpose of related reservation & scrapping activities, expiring lots within the demand horizon should be added back into the Excess On-Hand calculation. For example, calculation could be Max{On Hand – Demand within Excess Horizon, 0} + Total Expired Lots within Excess Horizon Furthermore, Minimum Remaining Shelf Life Days appears to have no bearing on available inventory or lot expiration. It would be helpful to understand the intended purpose of this setting.   Please see below where the item is set with minimum remaining shelf life of 180

EXPECTED BEHAVIOR

Excess and Obsolescence report should calculate expired lots as excess

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


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