APCC Production Volumes By Resource Inflated In MSC_RESOURCES_F Table
Last updated on MARCH 08, 2017
Applies to:Oracle Advanced Planning Command Center - Version 12.1.3 to 12.2.5 [Release 12.1 to 12.2]
Information in this document applies to any platform.
In APCC, the table msc_resource_f has column order_quantity and this data is inflated with sequence number.
The corresponding transaction/supply id in msc_supplies shows correct data.
We have RESOURCE1 and it is setup as follows in the routing
Operation 10 / Resource Seq Num 10 - BASIS_TYPE = 1 - Lot based - used for SETUP time on the resource - qty = 100
Operation 10 / Resource Seq Num 20 - BASIS_TYPE = 2 - Item based - used for RUN time on the resource - qty = 100
MSC_REOSURCE_REQUIREMENTS shows each line.
APCC collects this as RESOURCE1 QTY = 200 on this date this is processed.
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