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

Last updated on MARCH 08, 2017

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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms