My Oracle Support Banner

Archive One Package Is Not Copying All Purchase Orders Found In ASCP Planning Workbench To OBIEE Reports (Doc ID 2783364.1)

Last updated on JUNE 17, 2021

Applies to:

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

Symptoms

On : 12.2.9 version, Reports and Dashboards

ACTUAL BEHAVIOR

Archive One Package is not copying all purchase orders found in ASCP Planning Workbench to OBIEE Reports

The MSC concurrent program Archive One Package is failing to inset into APCC all of the transactions found in the Planning workbench. The package msc_phub_pkg which is executed by this concurrent program is executing, for instance, insert into msc_st_item_orders_f:supplies. However, the result that in terms of volume there are more purchasing recommendations listed in the planning workbench than that are in the command center data.

 
EXPECTED BEHAVIOR

All the eligible POs should be copied to the table: msc_st_item_orders_f

STEPS

The issue can be reproduced at will with the following steps:
1. Run the process: Archive One Package


Changes

 

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