Error When Executing EAM_PMDEF_PUB.UPDATE_PM_DEF (Doc ID 987864.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Enterprise Asset Management - Version 12.1.1 and later
Information in this document applies to any platform.

Symptoms

 

In the EAMPPMDB.pls in procedure update_pm_def In the INSERT statement, the variable "i" should be replaced with "n", since i is not initialized anywhere in the procedure.
This issue will cause error while executing PM update API 'EAM_PMDEF_PUB.UPDATE_PM_DEF '
Issue started with EAMPPMDB.pls 120.20:

 In EAMPPMDB.pls 120.20.12010000.3   in procedure update_pm_def   we see:
 
 
 n:=1;
    while (p_pm_activities_tbl.exists(n)) loop /*FP of 7030271*/
 
        insert into eam_pm_activities(
              pm_schedule_id,
              activity_association_id,
              interval_multiple,
              allow_repeat_in_cycle,
              day_tolerance,       
              created_by,
              creation_date,
              last_update_login,
              last_update_date,
              last_updated_by
              )
        values(
            l_pm_schedule_id,
            p_pm_activities_tbl(i).activity_association_id,
            p_pm_activities_tbl(i).interval_multiple,
                p_pm_activities_tbl(i).allow_repeat_in_cycle,
            p_pm_activities_tbl(i).day_tolerance,   
            fnd_global.user_id,
                    sysdate,
                    fnd_global.login_id,
                    sysdate    ,
                    fnd_global.user_id
           );     
    n:=n+1;
 
    end loop;
 
 

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms