Skip to main content

!!!Error deploying file fndbas\BatchScheduleMethods.ins at 2020-11-12 08:56:37
!!!Error occurred while executing Plsql Block
DECLARE
   schedule_method_id_ NUMBER          := NULL;
   seq_no_             NUMBER          := NULL;
   info_msg_           VARCHAR2(32000) := NULL;
BEGIN
-- Construct Main Message
   info_msg_    := Message_SYS.Construct('');
   Message_SYS.Add_Attribute(info_msg_, 'METHOD_NAME', 'BATCH_SYS.FND_HEAVY_CLEANUP_');
   Message_SYS.Add_Attribute(info_msg_, 'DESCRIPTION', 'Heavy Cleanup');
   Message_SYS.Add_Attribute(info_msg_, 'MODULE', 'FNDBAS');
   Message_SYS.Add_Attribute(info_msg_, 'SINGLE_EXECUTION_DB', 'TRUE');
   Message_SYS.Add_Attribute(info_msg_, 'ARGUMENT_TYPE_DB', 'NONE');
-- Register Batch Schedule Method
   Batch_SYS.Register_Batch_Schedule_Method(schedule_method_id_, info_msg_);
-- Adding parameters
END;
;DATABASE]AOracle JDBC Driver] Oracle]ORA-20110: BatchScheduleMethod.METHNOTEX: Method 1BATCH_SYS.FND_HEAVY_CLEANUP_] does not exist in database.
ORA-06512: at "IFSAPP.ERROR_SYS", line 180
ORA-06512: at "IFSAPP.BATCH_SCHEDULE_METHOD_API", line 313
ORA-06512: at "IFSAPP.BATCH_SCHEDULE_METHOD_API", line 647
ORA-06512: at "IFSAPP.BATCH_SCHEDULE_METHOD_API", line 1044
ORA-06512: at "IFSAPP.BATCH_SYS", line 1959
ORA-06512: at line 14
 

Are you installing the code as the Application Owner; Example: IFSAPP?

If the answer is Yes,

Can you please check whether the following API procedure exists in the database?

BATCH_SYS.FND_HEAVY_CLEANUP_

As per the error message, it looks like the API doesn’t exists and your install is failing. 


Yes I am installing it as IFSAPP.  Yes I do see the API and BATCH_SYS.FND_HEAVY_CLEANUP_. 

thanks for your answer. 

 


Reply