Provide ouput of APListh.sql file?

1)Download APListh.sql from metalink.
Standalone APList - Payables Data Collection Test [ID 148388.1]

2)connect to database as apps schema and run it and will require atleast one input as Invoice Id.

3)It will run for some minutes and generate and HTML report.

4)Give this HTML report to User.



SQL>select name from v$database;

NAME
---------
EBSOLTP

SQL>

SQL> show user

USER is "APPS"

SQL>

SQL> @APListh.sql

RDBMS Version = 11.2.0.3.
ERROR - The Script requires RDBMS version 8.1.6 or higher
ACTION - Type Ctrl-C to exit the script.
RDBMS Version = 11.2.0.3.
NLS Character Set = UTF8
ERROR - The HTML version of this script is incompatible with this Character Set
for RDBMS version 8.1.7.3 and lower
ACTION - Please run the Text version of this script.
Are you entering an Invoice Number, Check Number, Check Id or Invoice_id?
Enter 1 for Invoice Number
Enter 2 for Check Number
Enter 3 for Check Id
Enter 4 for Invoice Id
DEFAULT=1>4
Press Enter
>
Press Enter
>
Enter the Invoice ID:
>704864

Print NULL Columns (Y or N)?
DEFAULT=Y>

Show Spaces (Y or N)?
DEFAULT=N>

Details Layout: Portrait or Landscape (P or L)?
DEFAULT=L>

GL Details (Y or N)?
DEFAULT=N>

Related Details (Y or N)?
DEFAULT=Y>

Max number of rows returned?
Default=500>


Running...

Output spooled to filename APListh_704864_04241351_diag.html

SQL>


To check old post click on older post in the bottom of the page.