My Oracle Support Banner

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

Last updated on APRIL 02, 2019

Applies to:

Oracle Demantra Demand Management - Version 7.3.0 and later
Information in this document applies to any platform.
***Checked for relevance on 13-May-2013***

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

TEST CASE:
-----------------
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;


Goal


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


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
References


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