'java.sql.SQLException' Error When Uploading a GtmItemStructure XML With Transaction Code RC

(Doc ID 2327637.1)

Last updated on NOVEMBER 13, 2017

Applies to:

Oracle Global Trade Management - Version 6.4.2 to 6.4.3 [Release 6.4]
Information in this document applies to any platform.

Symptoms

When attempting to send in a GTM GtmStructure transmission with Transaction Code RC , the following error occurs.

ERROR
-----------------------
IMessageText = CAUGHT THE FOLLOWING EXCEPTION WHILE PROCESSING TRANSACTION: [220514] [SQL_STATEMENT] update gtm_structure_component set domain_name=?, item_gid=?, description=?, gtm_prod_class_code_gid=?, country_of_origin=? where gtm_structure_component_seq=? and gtm_structure_gid=?; [null, XXX.111761, 111761_LEVEL_BOM, null, null, 164, XXX.125072_1250_BOM] Cannot update the GTM_STRUCTURE_COMPONENT record. DOMAIN_NAME must be set. java.sql.SQLException: ORA-01407: cannot update ("GLOGOWNER"."GTM_STRUCTURE_COMPONENT"."DOMAIN_NAME") to NULL java.sql.SQLException: ORA-01407: cannot update ("GLOGOWNER"."GTM_STRUCTURE_COMPONENT"."DOMAIN_NAME") to NULL

XML Example:

-----------------

<GtmStructure>
    <GtmStructureGid>
        <Gid>
            <DomainName>XXX</DomainName>
            <Xid>XXX</Xid>
        </Gid>
    </GtmStructureGid>
    <TransactionCode>RC</TransactionCode>
    <ReplaceChildren>GtmStructureComponent</ReplaceChildren>
    <IsActive>N</IsActive>
    <ItemGid>
        <Gid>
            <DomainName>XXX</DomainName>
            <Xid>XXX</Xid>
        </Gid>
    </ItemGid>
    <TradeDirection>B</TradeDirection>
    <GtmStructureComponent>
        <GtmStructureCompSeq>1</GtmStructureCompSeq>
        <ItemGid>
            <Gid>
                <DomainName>XXX</DomainName>
                <Xid>3-15752308911</Xid>
            </Gid>
        </ItemGid>
        <Description>XXX</Description>
    </GtmStructureComponent>
</GtmStructure>

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms