My Oracle Support Banner

Using Exception Filter to Upload just Approved Forecasts To ASCP (Doc ID 1341040.1)

Last updated on JANUARY 30, 2022

Applies to:

Oracle Demantra Demand Management - Version 7.3.0 and later
Information in this document applies to any platform.
How To... Upload only Approved Forecast from Demantra to ASCP:
1. Integration Interface definition -> Data Profile Exception -> Set your "Final Approved By" as "Not is Null"
2. Final Forecast Series definition - should have only a Server Expression.
3. The bieo_* table rows, - should contain only desired data, provided that if only a part of records are approved, the whole series will appear as approved.

a. add a series final_approve having min(branch_data.final_approve) as Server Expression
b. Use this series in the Integration Interface.
c. Run the export
d. Check the output of the following SQL statement :
select * from bieo_ldr_upload_local_forecast where (rownum < 20) order by sdate;


1. When we upload forecasts, approved as well as unapproved forecasts are being uploaded to ASCP.
2. How can we just send approved forecasts?


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.