Extracting the SEPA Direct Debit Statement

The SEPA Direct Debit Extractor program (R743005) and the SEPA Direct Debit Multiple XML Extractor program (R743005A) (Release 9.2 Update) use the JD Edwards EnterpriseOne BI Publisher from Oracle to generate reports. After you generate and download the SEPA direct debit files using the R743005 or the R743005A program (Release 9.2 Update), you can access the report definitions used by the BI Publisher to extract the Direct Debit Statement. You can access the XML file from the Submitted Jobs form. To generate the PDF, you republish the XML.

To extract the Debit Statement:

  1. Access the Batch Versions program (P98305W).

    Available Versions form.
  2. On the Available Versions form, select Submitted Jobs from the Form menu.

    Available Versions form: Submitted Jobs.
  3. On the Submitted Jobs Search form, select the report that you want to view and then select Republish RD from the Row menu.

  4. On the Publish Report Definition Prompt from, select Prompt for Report Definition, and then click OK.

  5. On the Report Definition Submission Search & Select form, select the RD743005B report and click Select.

  6. On the Submitted Jobs Search form, select View RD Output from the Row menu.

  7. On the Report Definition Output Repository form, select the row for the Error and Debit Statement PDF.

  8. Click the icon in the View Output column to open the PDF.