Hello Everyone, 

The automations script is getting the next transaction by selecting the maximum transaction id from interface table.  So when we receive a new transaction prior to the completion of the previous transaction, the same transaction id can be assigned to multiple transactions.

We are trying to use an oracle sequence instead.  The sequence would be updated immediately instead of when the transaction is saved.

I have created the sequence and register the sequence to Maximo.  Once the sequence has been created the automation script will need to be updated to select the next value from sequence instead of selecting maximum transaction id from the interface table (transactionid= ifacetSet.max("TRANSID")+1)..

Here comes my question. how can we write this using automation script, To select the next value from sequence.

Can anyone help on this. Thanks in Advance

Hi,

SQL statements can be executed via Automation Script. You can search for 'Run SQL statement in Maximo Auto script' 
Similar topic is discussed here - https://www.ibm.com/mysupport/s/question/0D50z000060d93ACAQ/execute-update-statement-through-automation-script?language=en_US

Thanks!
------------------------------
Sankar Ganesh
------------------------------

Hi, just my two cents. It's challenging to attempt to correlate application state to database state, at best. You don't describe the business process you want to solve. The most general suggestion is to either solve the requirement in the database as a stored procedure (still some risk due to the application database misalignment), or preferably rely on the integration framework context within the script to remain (more or less) consistent with the state of the application. But thats just me!