Hi.
We’ve created a quick report to fetch some specific data and we’re hoping to schedule said report to run on a weekly basis and e-mail the file to a specific person.
I have IFS_ALL permissions as the scheduling user.
The report query is as follows:
SELECT DISTINCT A.*, B.CF$_CC_SUPPLIER
FROM PROD_STRUCTURE_CFV A
INNER JOIN MULTI_LEVEL_STRUCTURE_CFV B ON A.COMPONENT_PART = B.COMPONENT_PART
WHERE A.QTY_PER_ASSEMBLY = 1
AND A.PRINT_UNIT = 'm'
AND A.CONTRACT = 'ULV'
AND B.CF$_CC_SUPPLIER = '5808'
The report itself executes just fine within Cloud, and we can manually export the resulting data, but when we try and schedule it, the background job ends in an error.
The errors listed in the Background Job details are as follows:
ORA-31011: XML parsing failed
ORA-06512: at "IFSAPP.QUICK_REPORT_TEMPLATE_RPI", line 305
ORA-19202: Error occurred in XML processing
LPX-00007: unexpected end-of-file encountered
ORA-06512: at "SYS.XMLTYPE", line 272
ORA-06512: at line 1
ORA-06512: at "IFSAPP.QUICK_REPORT_TEMPLATE_RPI", line 227
ORA-06512: at "IFSAPP.QUICK_REPORT_TEMPLATE_RPI", line 290
ORA-06512: at line 1
ORA-06512: at "IFSAPP.REPORT_SYS", line 3923
ORA-06512: at "IFSAPP.REPORT_SYS", line 737
ORA-06512: at "IFSAPP.ARCHIVE_API", line 2569
ORA-06512: at "IFSAPP.ARCHIVE_API", line 2728
ORA-06512: at line 1
ORA-06512: at "IFSAPP.TRANSACTION_SYS", line 2060
ORA-06512: at "IFSAPP.TRANSACTION_SYS", line 323
ORA-06512: at "IFSAPP.QUICK_REPORT_TEMPLATE_RPI", line 305
ORA-06512: at "SYS.XMLTYPE", line 272
ORA-06512: at line 1
ORA-06512: at "IFSAPP.QUICK_REPORT_TEMPLATE_RPI", line 227
ORA-06512: at "IFSAPP.QUICK_REPORT_TEMPLATE_RPI", line 290
ORA-06512: at line 1
ORA-06512: at "IFSAPP.REPORT_SYS", line 3923
ORA-06512: at "IFSAPP.REPORT_SYS", line 737
ORA-06512: at "IFSAPP.ARCHIVE_API", line 2569
ORA-06512: at "IFSAPP.ARCHIVE_API", line 2728
ORA-06512: at line 1
ORA-06512: at "IFSAPP.TRANSACTION_SYS", line 2060
ORA-06512: at "IFSAPP.TRANSACTION_SYS", line 323
ORA-06512: at "IFSAPP.TRANSACTION_SYS", line 927
Thank you!