Impossible To Create GTM Location Via UI Without Entering A Location ID (Doc ID 1438455.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Global Trade Management - Version 6.2.4 and later
Information in this document applies to any platform.

Symptoms

A location cannot be created in GTM without specifying a Location ID. This is contrary to the OTM Location creation, where entering a location ID is unnecessary.
When trying to create a location without ID in GTM, an error similar to the one below is displayed:

glog.util.exception.CreateExceptionWrapper
insert into corporation (corporation_gid,corporation_xid,corporation_name,is_domain_master,is_shipping_agents_active,is_allow_house_collect,max_house_collect_amt,pickup_routing_sequence_gid,dropoff_routing_sequence_gid,domain_name,max_house_collect_currency_gid,max_house_collect_amt_base) values (?,?,?,?,?,?,?,?,?,?,?,?); http://CPAMP., , null, N, Y, Y, null, null, null, CPAMP
Cannot insert the CORPORATION record. CORPORATION_XID must be set.
java.sql.SQLIntegrityConstraintViolationException: ORA-01400: cannot insert NULL into ("GLOGOWNER"."CORPORATION"."CORPORATION_XID")

java.sql.SQLIntegrityConstraintViolationException: ORA-01400: cannot insert NULL into ("GLOGOWNER"."CORPORATION"."CORPORATION_XID")

at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:85)
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:206)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1034)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:194)
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:953)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1223)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3386)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3467)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1350)
at weblogic.jdbc.wrapper.PreparedStatement.executeUpdate(PreparedStatement.java:172)
at glog.util.jdbc.noserver.SqlPreparedStatement.executeUpdate(SqlPreparedStatement.java:35)
at glog.util.jdbc.SqlUpdate.resetArguments(SqlUpdate.java:241)
at glog.util.jdbc.SqlUpdate.resetArguments(SqlUpdate.java:161)
at glog.util.jdbc.SqlUpdate.execute(SqlUpdate.java:90)
at glog.util.remote.BeanManagedEntityBean.executeUpdate(BeanManagedEntityBean.java:795)
at glog.util.remote.BeanManagedEntityBean$1.execute(BeanManagedEntityBean.java:197)
at glog.util.remote.BeanManagedEntityBean.dbModify(BeanManagedEntityBean.java:1068)
at glog.util.remote.BeanManagedEntityBean.doCreate(BeanManagedEntityBean.java:193)
at glog.util.remote.BaseEntityBean$1.doIt(BaseEntityBean.java:455)
at glog.util.remote.BaseEntityBean.ejb(BaseEntityBean.java:798)
at glog.util.remote.BaseEntityBean.ejbCreator(BaseEntityBean.java:453)
at glog.ejb.location.db.CorporationBeanDB.ejbCreate(CorporationBeanDB.java:59)
at glog.ejb.location.ejb_Corporation_3r5gtq_Impl.ejbCreate(ejb_Corporation_3r5gtq_Impl.java:295)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at weblogic.ejb.container.manager.ExclusiveEntityManager.create(ExclusiveEntityManager.java:801)
at weblogic.ejb.container.manager.ExclusiveEntityManager.remoteCreate(ExclusiveEntityManager.java:772)
at weblogic.ejb.container.internal.EntityEJBHome.create(EntityEJBHome.java:270)
at glog.ejb.location.ejb_Corporation_3r5gtq_HomeImpl.create(ejb_Corporation_3r5gtq_HomeImpl.java:86)
at gtm.server.service.party.GTMPartySessionDelegate.createCorporationForLoc(GTMPartySessionDelegate.java:36)
at gtm.server.service.party.GTMPartySessionBean.createCorporationForLoc(GTMPartySessionBean.java:24)
at gtm.server.service.party.GTMPartySessionServerSideEJBWrapper.createCorporationForLoc(GTMPartySessionServerSideEJBWrapper.java:83)
at gtm.server.service.party.GTMPartySessionHome_ygrjtd_EOImpl.createCorporationForLoc(GTMPartySessionHome_ygrjtd_EOImpl.java:59)
at gtm.server.service.party.gen.GTMPartySessionSkel.createCorporationForLoc(GTMPartySessionSkel.java:84)
at gtm.server.service.party.gen.GTMPartySessionSkel.exec(GTMPartySessionSkel.java:38)
at glog.webserver.wrapper.SkelImpl.execDispatch(SkelImpl.java:15)
at glog.server.wrapper.WrapperSessionBean.execDispatch(WrapperSessionBean.java:83)
at glog.server.wrapper.WrapperSessionServerSideEJBWrapper.execDispatch(WrapperSessionServerSideEJBWrapper.java:48)
at glog.server.wrapper.WrapperSessionHome_a06097_EOImpl.execDispatch(WrapperSessionHome_a06097_EOImpl.java:58)
at glog.server.wrapper.WrapperSessionHome_a06097_EOImpl_WLSkel.invoke(Unknown Source)
at weblogic.rmi.internal.BasicServerRef.invoke(BasicServerRef.java:589)
at weblogic.rmi.cluster.ClusterableServerRef.invoke(ClusterableServerRef.java:230)
at weblogic.rmi.internal.BasicServerRef$1.run(BasicServerRef.java:477)
at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:363)
at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:147)
at weblogic.rmi.internal.BasicServerRef.handleRequest(BasicServerRef.java:473)
at weblogic.rmi.internal.wls.WLSExecuteRequest.run(WLSExecuteRequest.java:118)
at weblogic.work.ExecuteThread.execute(ExecuteThread.java:201)
at weblogic.work.ExecuteThread.run(ExecuteThread.java:173)

Fix Errors

The logfile indicates that the BN Rule isn't called at all:

https://support.us.oracle.com/oip/faces/filedownloadservlet?ObjectType=SR&ObjectNo=3-5322016621&FileName=logfile.txt

Note: BNRules was switched on when this log was created.


To reproduce:

* Go to Trade Master Data -> Trade Contact Management -> Location Manager
* Press 'new'
* Only enter something into the fields marked with the red star, i.e. the Country and Time Zone
* Press 'finished'


You will see the error.

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