My Oracle Support Banner

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

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


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.