My Oracle Support Banner

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

Last updated on APRIL 30, 2018

Applies to:

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


On : 12.1.3 version, Reports and Dashboards


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


Excess and Obsolescence report should calculate expired lots as excess




To view full details, 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 a vibrant support community of peers and Oracle experts.