Solved

IFS8 Installation Error

  • 12 November 2020
  • 2 replies
  • 338 views

Badge +2

!!!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][Oracle JDBC Driver][Oracle]ORA-20110: BatchScheduleMethod.METHNOTEX: Method [BATCH_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
 

icon

Best answer by Srikanth 13 November 2020, 11:29

View original

2 replies

Userlevel 6
Badge +18

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. 

Badge +2

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

thanks for your answer. 

 

Reply