How To Use A Default Value In Application Designer

How To Use A Default Value In Application Designer:

Many time during the implementation I found that we get requirement to set Default value in application or in drop down list, especially when we have cloned application. The one way is to set the default value at database level using database configuration, but that do not work when we have cloned application and in both application we need two different value.  The other way is to set a default value in application using Application designer.

Steps for setting default value using application designer is as mentioned below.

Step 1:

 a) First of all create two objects Experience and ID proof in database configuration. Then add an attribute named as LABORCODE in both the objects.

b) Make Experience and Id proof as child object in it. Then give the relationship of both the objects in Labor objects as shown below:

Step 2: In application designer, from control palette add a default value control in labor application on table body.

Step 3: Set the properties of default value as shown below:

Step 4: Save the Record and Check the values entered in labor application.

Step 5: The record that uses a default value has been shown below:

If you want to set in existing attribute follow step 2 onward. 

ORA-27476: "MAXIMO.MAXIMOTSSYNC" does not exist when Upgrading Maximo 7.1.1.10 to Maximo 7.5.0

ORA-27476: "MAXIMO.MAXIMOTSSYNC" does not exist


This problem Mainly i faced during Upgrading Maximo 7.1.1.10 to Maximo 7.5.0.

Step 1 : Change to use DBMS_SCHEDULER

CREATE OR REPLACE PROCEDURE maximo_ts_job_call AS 
BEGIN 
dbms_scheduler.create_job( 
job_name => 'MAXIMOTSSYNC', 
job_type => 'STORED_PROCEDURE', 
job_action => 'maximo_ts_job', 
start_date => SYSDATE, 
repeat_interval => 'SYSDATE + 5/1440', 
enabled => TRUE); 
END; 
/ 
exec maximo_ts_job_call(); 



select job, substr(what,1,80) from user_jobs; 

Re-run Integrity checker