I'm using Clarity PPM 22.214.171.1246 with Oracle and at this point we are trying to collect some data in other systems (using external data sources) and put this information in Clarity using for this custom objects. To data collect I create a process (on demand) to be executed by a job in the future and in the process I create some custom script (gel script) to collect the data, using sql:query and sql:update. Here, in the sql:update I have an issue, because I can't run the update sucessfully ([CA Clarity][Oracle JDBC Driver][Oracle]ORA-01400: cannot insert NULL into ("PMT"."ODF_CA_KPI1"."ID") .)
The custom object is a Master Object with some additional fields. I set the column ID with autonumbering, but this sequence is not executed. My question is, there is some way in Clarity to do this? Or I need to execute each insert calling the next val for a SEQUENCE in Oracle? I'm open to other solutions if more suitable to that situation.
See if Aurora can help you, too, in XOG and autonumbering Status Reports
Thank you for the reply. Reading the recommended post, I find the sequence generated in the database for the column. Now, I'm calling directly in sql to obtain the next val.
select odf_ca_kpi1_s1.nextval from dual
By the way you should NOT be creating data directly in Clarity/PPM using SQL 'insert' statements as this is not a supported integration method - you should be using XOG (ref the 'custom_object_instances_write.xml' file) which you can call from within your GEL.
Yes, You are correct. WSDL of custom object should be used for creating a custom object.