diagnostic script ap_gdf_detect_pgk.sql of AP

This diagnostic script ap_gdf_detect_pgk.sql  to identify known data integrity issues within your Payables application
1.Download the file ap_gdf_detect_pkg.zip . This file contains the package definition file ap_gdf_detect_pkg.sql as well as two wrapper scripts which can be used to submit the detection procedures:

• single_trx.sql: This script can be used to submit the validation procedure for a single transaction.
• date_range.sql This script will submit the validation procedure for a range of dates within specified operating units

2.First you must run the script ap_gdf_detect_pkg.sql as user APPS to create the package definition.  This is required each time you download a new version of the script.  Then you can run one of the wrapper files as described below.