automatic creation of Release ID thro integration

[neoandr]

Hi,
I am trying to create Release ID automatically in OTM when Release xml is uploaded through integration. I am facing error in Shipunit stating "Shipunit must reference valid Order release Id".

While checking log files, i could find that actually order release ids are getting generated automatically but while creating shipunits, it tries to refer order release id (which is blank as below) from order_Release table. Since the record is not found, it rollsback the process.

Even i tried removing the following segment inside 'shipunitcontent' but still same error.

<ReleaseGid>
<Gid>
<DomainName>Domain_Name</DomainName>
<Xid></Xid>
</Gid>
</ReleaseGid>
.
.
.
<ShipUnit>
.
.
<ShipUnitContent>
.
.
<ReleaseGid>
<Gid>
<DomainName>Domain_Name</DomainName>
<Xid></Xid>
</Gid>
</ReleaseGid>
.
.

Can anyone know how to overcome this problem??

Thanks!

[james_foran]

Re: automatic creation of Release ID thro integration

I think you need to put a value in the <xid></Xid> for the order release, then reference it against the Ship Unit...

EG

<ReleaseGid>
<Gid>
<DomainName>Domain_Name</DomainName>
<Xid>{1}</Xid>
</Gid>
</ReleaseGid>

Then reference this in the Release Gid. We use this when generating S_SHIP_UNIT gids.

[nikesh mohanlal]

Re: automatic creation of Release ID thro integration

Hi,

Version: 5.5 cu5
Can you be more specific?
I have also got the need similar to this.
the need is: user upload the OR xml with giving null as order release id .If he gives some number to <releaseline>, then it is inserted successully, meand Order release is created.But, if he gives null in <releaseline>, then he gets the error like:'java.sql.SQLException: ORA-02291: 整合性制約(GLOGOWNER.FK_SUL_ORLGID'..
Can anyone has idea on how to remove this?
Regards,
Nikesh.

Regards,
Nikesh.

[neoandr]

Re: automatic creation of Release ID thro integration

James,
While using

<ReleaseGid>
<Gid>
<DomainName>Domain_Name</DomainName>
<Xid>{1}</Xid>
</Gid>
</ReleaseGid>

It did not auto generate the Release ID but as "Domain_Name.{1}". Please let me know what i am following is correct

Thanks!

[james_foran]

Re: automatic creation of Release ID thro integration

Not to sure.

We only use it in the <ActualShipment> XML as follows:

<ShipUnit>
<ShipUnitGid>
<Gid>
<DomainName>TEST</DomainName>
<Xid>{1}</Xid>
</Gid>
</ShipUnitGid>

Make sure you have a BN_RULE set up, or else it will not work.

From what you have previously said, it works if you leave the XID blank is this correct?

[neoandr]

Re: automatic creation of Release ID thro integration

Hi,
Issue is resolved. Initially i used 'TransactionCode' in both Release level and also in Shipunit. But i removed TransactionCode at Shipunit level and changed the value of Release level TransactionCode to 'I'.

It works fine.
Thanks!