The creation of domains is very easy except the SYNONYM domain, so I made a little tutorial for me and you..
Path: Maximo menu -> System configuration -> Platofrm configuration -> Domains (its easy but hard to remember)
This typeof domain is a bit special so you are not able to make it by easiest way (Add a new Domain).. okay.. could be easier but..
At first there is table with basic fields of SNM domain:FieldDescriptionInternal ValueSpecify the internal value for which you want a synonym.
For example, in the STATUS domain, if you want to create a synonym for WAPPR called WAPPR, you would specify the WAPPR internal value.Value Specify the synonym value you want a user to see.
For example, WAPPR.Description Type a description of the synonym to differentiate it from the existing value.
In the Synonym Domain , the Internal Value is used by the system and must be unique. The Value and its description are what users see.
First step
Check if domain name does not exists
select * from MAXDOMAIN where domainid='%DOMAINID%'
Second step
Create snm domain as record in mxdomain table
insert into MAXDOMAIN (domainid,description,domaintype,maxtype,length,scale,maxdomainid,internal) VALUES ('SNM_TEST', 'test synonym domain','SYNONYM','UPPER', 16, 0, NEXT VALUE FOR MAXDOMAINSEQ,0)
Create a value for snm domain in syndom table
INSERT INTO SYNONYMDOMAIN (DOMAINID, MAXVALUE, VALUE, DESCRIPTION, DEFAULTS, SYNONYMDOMAINID, VALUEID) VALUES ('SNM_TEST', 'OPEN','OPEN', 'Open', 1, NEXT VALUE FOR SYNONYMDOMAINSEQ, 'FAU_SYN_TEST|OPEN')
In this case we need a record with defined MAXVALUE , after that we are able to add any value with same MAXVALUE new by maximo web interface.
Comments