Admin User in Parent Domain has No Write Privilege to Data in Child Domain. (Doc ID 889662.1)

Last updated on SEPTEMBER 08, 2016

Applies to:

Oracle Transportation Management - Version: 5.5.04.02
This problem can occur on any platform.

Symptoms

-- Problem Statement:

On 5.5.04.02 a new Child domain has been created that is 2 levels below the Parent domain, however it is not possible for the parent domain Admin user to update the data in the child domain.

ERROR

IMessageText = CAUGHT THE FOLLOWING EXCEPTION WHILE PROCESSING TRANSACTION: java.lang.Exception:
User PARENTDOMAIN.ADMIN has no write privilege to ORDER_RELEASE in PARENTDOMAIN/CHILDDOMAIN1/CHILDDOMAIN2 domain
java.lang.Exception: User PARENTDOMAIN.ADMIN has no write privilege to ORDER_RELEASE in
PARENTDOMAIN/CHILDDOMAIN1/CHILDDOMAIN2 domain at
glog.integration.xmlbasewrapper.XmlBaseWrapper.checkWritability(XmlBaseWrapper.java:555) at
glog.integration.application.release.ReleaseWrapper.validatePriorMapping(ReleaseWrapper.java:111)
at glog.integration.xmlbasewrapper.XmlBaseWrapper.map(XmlBaseWrapper.java:159) at
glog.integration.xmlbasewrapper.XmlBaseWrapper.persistViaContainer(XmlBaseWrapper.java:274) at
glog.integration.application.release.ReleaseInterface.persistIndivXML(ReleaseInterface.java:150)
at glog.integration.application.release.ReleaseInterface.persistXML(ReleaseInterface.java:137) at
glog.integration.application.BaseInterface.persistXMLBase(BaseInterface.java:185) at
glog.integration.application.TransactionProcessor.processTransaction(TransactionProcessor.java:210)
at
glog.integration.application.TransactionProcessor.processTransaction(TransactionProcessor.java:349)
at glog.server.workflow.transproc.TransProc.execute(TransProc.java:94) at
glog.server.workflow.SimpleWorkflow.execute(SimpleWorkflow.java:23) at
glog.server.workflow.WorkflowSessionBean.execute(WorkflowSessionBean.java:64) at
sun.reflect.GeneratedMethodAccessor21.invoke(Unknown Source) at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at
java.lang.reflect.Method.invoke(Method.java:324) at
com.evermind.server.ejb.interceptor.joinpoint.EJBJoinPointImpl.invoke(EJBJoinPointImpl.java:35) at
com.evermind.server.ejb.interceptor.InvocationContextImpl.proceed(InvocationContextImpl.java:119)
at com.evermind.server.ejb.interceptor.system.DMSInterceptor.invoke(DMSInterceptor.java:52) at
com.evermind.server.ejb.interceptor.InvocationContextImpl.proceed(InvocationContextImpl.java:119)
at
com.evermind.server.ejb.interceptor.system.TxNotSupportedInterceptor.invoke(TxNotSupportedIntercepto
r.java:43) at
com.evermind.server.ejb.interceptor.InvocationContextImpl.proceed(InvocationContextImpl.java:119)
at
com.evermind.server.ejb.interceptor.system.SecurityRoleInterceptor.invoke(SecurityRoleInterceptor.ja
va:47) at
com.evermind.server.ejb.interceptor.InvocationContextImpl.proceed(InvocationContextImpl.java:119)
at com.evermind.server.ejb.interceptor.system.DMSInterceptor.invoke(DMSInterceptor.java:52) at
com.evermind.server.ejb.interceptor.InvocationContextImpl.proceed(InvocationContextImpl.java:119)
at com.evermind.server.ejb.InvocationContextPool.invoke(InvocationContextPool.java:55) at
com.evermind.server.ejb.StatelessSessionEJBObject.OC4J_invokeMethod(StatelessSessionEJBObject.java:8
7) at workflow_WorkflowSession_NonTransactional_RemoteProxy_mkgm02.execute(Unknown Source) at
glog.server.workflow.WorkflowManager.execute(WorkflowManager.java:341) at
glog.server.workflow.Trigger.trigger(Trigger.java:123) at
glog.util.event.MemoryEventQueueRunnable.processEvent(MemoryEventQueueRunnable.java:141) at
glog.util.event.MemoryEventQueueRunnable.run(MemoryEventQueueRunnable.java:96) at glog.u

-- Steps To Reproduce:

1 - Have a parent domain.
2 - Create a child domain.
3 - Create a child domain from within the domain created in step 2 above.
4 - Attempt to process transmissions to load data into the child domain created in step 3 using the admin user of the parent domain.
5 - The transmissions fail with the reported 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