EBS Customizations (MOSC)

MOSC Banner

I create SQL to insert forecast to item but I need to insert more than one month to the same item

edited Apr 21, 2017 2:55AM in EBS Customizations (MOSC) 4 commentsAnswered

I create SQL to insert forecast to item but I need to insert more than one month to the same item

set serveroutput on

Declare   

t_forecast_interface_tab    MRP_FORECAST_INTERFACE_PK.t_forecast_interface;   

t_forecast_designator_tab  MRP_FORECAST_INTERFACE_PK.t_forecast_designator;   

var_bool                    BOOLEAN;

begin   

t_forecast_interface_tab(1).inventory_item_id := 1824;   

t_forecast_interface_tab(1).forecast_designator := 'Qtest';   

t_forecast_interface_tab(1).organization_id := 83;   

t_forecast_interface_tab(1).forecast_date := '01-MAY-2017';   

t_forecast_interface_tab(1).bucket_type := 3;   

t_forecast_interface_tab(1).quantity := 273000;   

t_forecast_interface_tab(1).process_status := 2;   

t_forecast_interface_tab(1).confidence_percentage := 100; 

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center