AnsweredAssumed Answered

Locking of Attributes - Which sequence is called?

Question asked by dgudipudi on May 24, 2010
Latest reply on Jul 2, 2010 by dgudipudi
Hi,

I have this problem: My process is locking the attributes to an object. I see that in the bg log that the ID of odf_locked_attributes is called using a sequence.

Does anyone know which sequence this is called?

From the snippet below, we see that: <param direction="IN" expressionListDelimiter="," tableName="ODF_LOCKED_ATTRIBUTES" sequenceType="nextValue"/>
calls a sequence next value. Where is this sequence called?

Initially I thought it was called from CMN_SEQ_ODF_LOCKED_ATTRIBUTES, but this number doesnt increase after the process successfully inserts into the ODF_LOCKED_ATTRIBUTES table.


Snippet:

Executed:
insert into
odf_locked_attributes(id,object_code,odf_pk,attribute_code,created_date,created_by,last_updated_date,last_updated_by)
values(?,?,?,?,?,?,?,?)
Derived from statement:
<?xml version="1.0" encoding="UTF-8"?>
<statement batchable="true" sortColumnPath="/data/header/sortInfo/@sortColumn" sortDirectionPath="/data/header/sortInfo/@sortDirection" slicePath="/data/header/pagination/sliceInfo/@slice" sliceSizePath="/data/header/pagination/sliceInfo/@sliceSize" inputSource="map" inputMapIndex="1" xmlns="http://schemas.niku.com/2002/pmd">
<secondaryInput id="instance" inputSource="map"/>
<sql dbVendor="all">
<text>
insert into
odf_locked_attributes(id,object_code,odf_pk,attribute_code,created_date,created_by,last_updated_date,last_updated_by)
values(?,?,?,?,?,?,?,?)
</text>
<param direction="IN" expressionListDelimiter="," tableName="ODF_LOCKED_ATTRIBUTES" sequenceType="nextValue"/>
<param name="object_code" secondaryInputId="instance" type="string" direction="IN" expressionListDelimiter=","/>
<param name="odf_pk" secondaryInputId="instance" type="long" direction="IN" expressionListDelimiter=","/>
<param name="attribute_code" type="string" direction="IN" expressionListDelimiter=","/>
<param replace="timestamp" direction="IN" expressionListDelimiter=","/>
<param replace="userId" direction="IN" expressionListDelimiter=","/>
<param replace="timestamp" direction="IN" expressionListDelimiter=","/>
<param replace="userId" direction="IN" expressionListDelimiter=","/>
</sql>
</statement>

Outcomes