APCC Production Volumes By Resource Inflated In MSC_RESOURCES_F Table (Doc ID 2103545.1)

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.

Goal

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.

SUPPLY_ID RESOURCE_SEQ_NUM OPERATION_SEQ_NUM SR_INSTANCE_ID ORGANIZATION_ID DEPARTMENT_ID RESOURCE_ID RESOURCE_CODE ANALYSIS_DATE ORDER_QUANTITY
59645987 20 10 2022 734 189762 190655 RESOURCE1 29-FEB-16 100
59645987 10 10 2022 734 189762 190655 RESOURCE1 29-FEB-16 100

APCC collects this as RESOURCE1 QTY = 200 on this date this is processed.

PLAN_ID PLAN_RUN_ID SR_INSTANCE_ID ORGANIZATION_ID DEPARTMENT_ID RESOURCE_ID INVENTORY_ITEM_ID ANALYSIS_DATE ORDER_QUANTITY
4021 107015 2022 734 189762 190655 66605 29-FEB-16 200

Solution

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