Emailing Reports from ORS - Revision history

Lwinchester at 10:05, 13 August 2015

2015-08-13T10:05:57Z

← Older revision		Revision as of 12:05, 13 August 2015
Line 58:		Line 58:


	When the job runs a copy of the report will emailed out to the addresses on the email list and a copy will be placed in the specified directories.		When the job runs a copy of the report will emailed out to the addresses on the email list and a copy will be placed in the specified directories on the server.

2015-08-13T10:04:53Z

← Older revision		Revision as of 12:04, 13 August 2015
Line 46:		Line 46:


	'''<center>[[image:ORS6.PNG \| XF Monitor - Parameters ]]</center>		'''<center>[[image:ORS6.PNG \| XF Monitor - Directory Parameters ]]</center>


	Set up your directories as per normal -		Set up your directories as per normal -


			'''<center>[[image:ORS7.PNG \| XF Monitor - Email Parameters ]]</center>


	Enter the name and email address of the recipients and then start the job.		Enter the name and email address of the recipients and then start the job.


	When the job runs a copy of the report will emailed out to the addresses on the email list and a copy will be placed in the specified directories.		When the job runs a copy of the report will emailed out to the addresses on the email list and a copy will be placed in the specified directories.

2015-08-13T10:02:31Z

← Older revision		Revision as of 12:02, 13 August 2015
Line 35:		Line 35:


	EDI – XF Monitor		'''EDI – XF Monitor

	<center>[[image:ORS5.PNG \| XF Monitor ]]</center>		'''<center>[[image:ORS5.PNG \| XF Monitor ]]</center>


	Set up a Job in XF Monitor similar to the above		Set up a Job in XF Monitor similar to the above

	Ensure the Process Command is set to ORS and the ORS Report value is the name of your saved Data Extract Report		Ensure the Process Command is set to ORS and the ORS Report value is the name of your saved Data Extract Report
	The Process Code can be called anything		The Process Code can be called anything

	Set up ~~you~~ directories as per normal -
			'''<center>[[image:ORS6.PNG \| XF Monitor - Parameters ]]</center>


			Set up your directories as per normal -

2015-08-13T09:58:26Z

← Older revision		Revision as of 11:58, 13 August 2015
Line 36:		Line 36:

	EDI – XF Monitor		EDI – XF Monitor

			<center>[[image:ORS5.PNG \| XF Monitor ]]</center>


	Set up a Job in XF Monitor similar to the above		Set up a Job in XF Monitor similar to the above

2015-08-13T09:55:24Z

← Older revision		Revision as of 11:55, 13 August 2015
Line 21:		Line 21:

	Note the name of the report that you have created. I.e. 'RECEIPT_SPD'		Note the name of the report that you have created. I.e. 'RECEIPT_SPD'


			<center>[[image:ORS4.PNG \| ORS Reporting]]</center>



	'''NB''' If you need to restrict the data reported by a data range, enter sysdate for current date or sysdate''-n'' for historic dates or sysdate''+n'' for dates running into the future.		'''NB''' If you need to restrict the data reported by a data range, enter sysdate for current date or sysdate''-n'' for historic dates or sysdate''+n'' for dates running into the future.

2015-08-13T09:48:40Z

← Older revision		Revision as of 11:48, 13 August 2015
Line 24:		Line 24:
	'''NB''' If you need to restrict the data reported by a data range, enter sysdate for current date or sysdate''-n'' for historic dates or sysdate''+n'' for dates running into the future.		'''NB''' If you need to restrict the data reported by a data range, enter sysdate for current date or sysdate''-n'' for historic dates or sysdate''+n'' for dates running into the future.

	The example above will report from a date range of 10 days in the past up to the date the report is automatically generated.		The example above will report from a date range of 10 days in the past and up to 10 days in the future from the date the report is automatically generated.

	If the report is to extract data with parameters of a future date then must ensure you place the ''’+’ ''		If the report is to extract data with parameters of a future date then must ensure you place the ''’+’ ''

2015-08-13T09:47:15Z

← Older revision		Revision as of 11:47, 13 August 2015
Line 20:		Line 20:


	Note the name of the report that you have created.		Note the name of the report that you have created. I.e. 'RECEIPT_SPD'

	'''NB''' If you need to restrict the data reported by a data range, enter sysdate for current date or sysdate''-n'' for historic dates or sysdate''+n'' for dates running into the future.		'''NB''' If you need to restrict the data reported by a data range, enter sysdate for current date or sysdate''-n'' for historic dates or sysdate''+n'' for dates running into the future.

2015-08-13T09:46:26Z

← Older revision		Revision as of 11:46, 13 August 2015
Line 22:		Line 22:
	Note the name of the report that you have created.		Note the name of the report that you have created.

	NB If you need to restrict the data reported by a data range, enter sysdate for current date or sysdate-n for historic dates or sysdate+n for dates running into the future.		'''NB''' If you need to restrict the data reported by a data range, enter sysdate for current date or sysdate''-n'' for historic dates or sysdate''+n'' for dates running into the future.

	The example above will report from a date range of 10 days in the past up to the date the report is automatically generated.		The example above will report from a date range of 10 days in the past up to the date the report is automatically generated.

	If the report is to extract data with parameters of a future date then must ensure you place ~~the’~~+’		If the report is to extract data with parameters of a future date then must ensure you place the ''’+’ ''

2015-08-13T09:43:20Z

← Older revision		Revision as of 11:43, 13 August 2015
Line 14:		Line 14:

	Within the Oracle Reporting suite create the report		Within the Oracle Reporting suite create the report


			<center>[[image:ORS3.PNG \| ORS Reporting]]</center>



	Note the name of the report that you have created.		Note the name of the report that you have created.

2015-08-13T09:31:34Z

← Older revision		Revision as of 11:31, 13 August 2015
Line 1:		Line 1:
	The ORS package requires setting up in the EDI screens XF Command and XF Re-sequence, (this may already be inserted)		The ORS package requires setting up in the EDI screens XF Command and XF Re-sequence, (this may already be inserted)


	<center>[[image:ORS-1.PNG \| ~~Location Maintenance~~]]</center>
			<center>[[image:ORS2a.PNG \| XF Command Screen]]</center>




			<center>[[image:ORS-1.PNG \| XF Re-Sequence]]</center>