Using XML with BI Publisher

Here's a quick guide for this deadly combo:
XML, BI Publisher, and Application Engine.

We start by importing the delivered Application Package.

import PSXP_RPTDEFNMANAGER:*;

The following function is optional if

Find Temp Tables used by Application Engine

I've been running into situations where our application engines are not clearing the temp tables even after process instance has been deleted.

Also, multiple occurrences of the process halting for no reason.

Oracle's workaround is to clear the temp tables and restart the process.

But which temp tables do you clear?

Try this script.

Read Multiple Files Using App Engine and FileLayout

I want to process several files using PeopleSoft's filelayout.

Assuming you have created your Application Engine, here's a step by step guide.