OSB 12c xref:lookupXRef : unable to use MDS in xref function (Doc ID 2831174.1)

Last updated on SEPTEMBER 24, 2023

Applies to:

Symptoms

On : 12.2.1.4.0 version, OSB Transports

When attempting to implement XREF function in OSB12c like below:
xref:lookupXRef("oramds:/apps/Folder/xref/file_name.xref", "parameter_01", "parameter_02, "parameter_03", fn:true())}

the following error occurs.

ERROR
-----------------------
Invalid metadata for Cross Reference Table "oramds:/apps/Folder/xref/file_name.xref"
Please ensure the metadata confirms to the XSD.

In the log file:
Error executing the transformation: {http://www.w3.org/2005/xqt-errors}FOER0000: [OSB-395350]Error invoking custom xquery java function: java.lang.reflect.InvocationTargetException
java.lang.reflect.InvocationTargetException
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at com.bea.wli.sb.stages.functions.x10.XQueryExternalFunction.evaluate(XQueryExternalFunction.java:64)
at oracle.xml.xquery.adapter.java.XQJFunctionBindingFactory$FunctionIterator.fetchNext(XQJFunctionBindingFactory.java:102)
at oracle.xml.xquery.iterators.GenericIterator.peekNext(GenericIterator.java:162)
at oracle.xml.xquery.runtime.typing.SeqTypeMatching.fetchNext(SeqTypeMatching.java:220)
at oracle.xml.xquery.iterators.GenericIterator.next(GenericIterator.java:101)
at oracle.xml.xquery.runtime.constructor.AtomicElementConstructor.fetchNext(AtomicElementConstructor.java:155)
at oracle.xml.xquery.iterators.GenericIterator.next(GenericIterator.java:101)

......
at weblogic.servlet.internal.ServletRequestImpl.runInternal(ServletRequestImpl.java:1720)
at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1680)
at weblogic.servlet.provider.ContainerSupportProviderImpl$WlsRequestExecutor.run(ContainerSupportProviderImpl.java:272)
at weblogic.invocation.ComponentInvocationContextManager._runAs(ComponentInvocationContextManager.java:352)
at weblogic.invocation.ComponentInvocationContextManager.runAs(ComponentInvocationContextManager.java:337)
at weblogic.work.LivePartitionUtility.doRunWorkUnderContext(LivePartitionUtility.java:57)
at weblogic.work.PartitionUtility.runWorkUnderContext(PartitionUtility.java:41)
at weblogic.work.SelfTuningWorkManagerImpl.runWorkUnderContext(SelfTuningWorkManagerImpl.java:655)
at weblogic.work.ExecuteThread.execute(ExecuteThread.java:420)
at weblogic.work.ExecuteThread.run(ExecuteThread.java:360)
Caused by: oracle.tip.xref.exception.RepositoryException: Invalid metadata for Cross Reference Table "oramds:/apps/Folder/xref/file_name.xref"
Please ensure the metadata confirms to the XSD.
at oracle.tip.xref.repos.mds.MDSRepository.getXRefMetadata(MDSRepository.java:183)
at oracle.tip.xref.XRefManagerImpl.lookupXRef(XRefManagerImpl.java:592)
at com.bea.wli.sb.functions.xref.XrefFunctions.lookupXRef(XrefFunctions.java:91)
... 138 more

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.