My Oracle Support Banner

SCP Cloud Extract Entity BOOKING_HISTORY_BI_RD Has A Performance Problem (Doc ID 2432925.1)

Last updated on JUNE 11, 2020

Applies to:

Oracle Advanced Supply Chain Planning - Version 12.1.3.9.2 and later
Information in this document applies to any platform.

Symptoms

EBS on 12.1.3.9.2  --> INTEGRATION WITH SCP CLOUD

Have collected all setup data (items, OM, WIP, etc.) and now are trying to get historical sales data and having issues.

GOAL: Extract the booking history aggregated by item/date - not by default of customer/item/date - so we see all data under single customer.

The request to extract booking data running forever.
Data extraction worker (Data extraction worker) with parameters - 3021, EBS, 3, -999, , BOOKING_HISTORY_BI_RD, 1846264234,
/opt/oracle/app/apps_st/appl/msc/12.0.0/out/EbsToSCPCloudExtract_43917193/, 1, , ,

We are using custom view per instructions available in the whitepaper

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