Home » Applications » Oracle Fusion Apps & E-Business Suite » Open Forecast entry API throwing an error (oracle business suit 12R)
Open Forecast entry API throwing an error [message #316260] Thu, 24 April 2008 07:11
vijay.nimmakuri@gmail.com
Messages: 10
Registered: February 2008
Location: inida
Junior Member

114 is a valid organization in mtl_parameters and org_organization_definations.

 1  Declare
 2       t_forecast_interface_tab    MRP_FORECAST_INTERFACE_PK.t_forecast_interface;
 3       t_forecast_designator_tab   MRP_FORECAST_INTERFACE_PK.t_forecast_designator;
 4       var_bool                    BOOLEAN;
 5  begin
 6  fnd_global.apps_initialize(679569,20454,704);
 7       t_forecast_interface_tab(1).inventory_item_id :=20004;
 8       t_forecast_interface_tab(1).forecast_designator := 'MER_FG_FCS';
 9       t_forecast_interface_tab(1).organization_id := 114;
10       t_forecast_interface_tab(1).forecast_date := sysdate;
11       t_forecast_interface_tab(1).bucket_type := 3;
12       t_forecast_interface_tab(1).quantity := 100;
13       t_forecast_interface_tab(1).process_status := 2;
14       t_forecast_interface_tab(1).confidence_percentage := 100;
15       t_forecast_designator_tab(1).organization_id := 114;
16       t_forecast_designator_tab(1).forecast_designator := 'MER_FG_FCS';
17       var_bool := MRP_FORECAST_INTERFACE_PK.MRP_FORECAST_INTERFACE (t_forecast_interface_tab);
18       dbms_output.put_line('Return Status = '||t_forecast_interface_tab(1).process_status);
19       dbms_output.put_line('Error Message = '||t_forecast_interface_tab(1).error_message);
20       commit;
21* end;
QL> /
eturn Status = 4
rror Message = You have entered an invalid organization value: 114

L/SQL procedure successfully completed.




an any one please help me out in this issue

Thanks in advance,
Vijay.
Previous Topic: Printing check problem in Oracle Payables
Next Topic: Record history disabled in GL open/Close periods form
Goto Forum:
  


Current Time: Fri Dec 09 17:13:42 CST 2016

Total time taken to generate the page: 0.29443 seconds