Using Exception Filter to Upload just Approved Forecasts To ASCP
(Doc ID 1341040.1)
Last updated on SEPTEMBER 09, 2023
Applies to:
Oracle Demantra Demand Management - Version 7.3.0 and laterInformation 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.
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 |