After XDOLoader/FNDLOAD upload, there are no new rows in XDO_DS_DEFINITIONS_B and XDO_TEMPLATES_B
I am trying to migrate BI Publisher reports from one environment to another. The download completes all right, I transfer the files to the other environment and I launch XDOLoader and FNDLOAD in upload mode. The files appear correctly in XDO_LOBS, but not in XDO_DS_DEFINITIONS_B and XDO_TEMPLATES_B.
DOWNLOAD:
cd /tmp/download
rm *
java oracle.apps.xdo.oa.util.XDOLoader DOWNLOAD \
-DB_USERNAME apps \
-DB_PASSWORD apps \
-JDBC_CONNECTION '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=viiperdb-test.apps.elex.be)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=VIPRTEST)))' \
-APPS_SHORT_NAME XDO \
-LCT_FILE $XDO_TOP/patch/115/import/xdotmpl.lct \
DOWNLOAD:
cd /tmp/download
rm *
java oracle.apps.xdo.oa.util.XDOLoader DOWNLOAD \
-DB_USERNAME apps \
-DB_PASSWORD apps \
-JDBC_CONNECTION '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=viiperdb-test.apps.elex.be)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=VIPRTEST)))' \
-APPS_SHORT_NAME XDO \
-LCT_FILE $XDO_TOP/patch/115/import/xdotmpl.lct \
0