Blitz Report Extension Package API Signatures – Oracle EBS SQL Report

Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.

Overview

Shows this instance’s signatures of the Oracle EBS APIs that Blitz Report’s extension packages call: every argument of every procedure, with its position, data type, in/out mode, whether it is defaulted, and the fields of any record argument.

Its purpose is comparison. An extension package that calls an EBS API by named parameters fails to compile where a patch level does not have that parameter (PLS-00306) or that record field (PLS-00302), the installer then drops the package, and its reports and uploads fail with PLS-00201 at runtime. Running this report here and on a working instance and comparing the two shows exactly which argument or field is absent.

Left empty, it reports every EBS API called by the extension packages installed here, and Referenced By names the calling package. That list is derived from the installed package source, so an extension package that failed to compile is not in it - name its API in the API Package Name parameter instead, which reports that package’s full signature whether or not anything here calls it.

Types and constants declared in a package specification are not arguments and so do not appear here. Use the DBA Text Search report on the specification for those.

Report Parameters

API Package Name, API Procedure Name, Argument Name

Oracle EBS Tables Used

user_source, table, user_arguments

Report Categories

Enginatics

FND Forms Personalizations, AP Posted Invoice Register, AP Posted Payment Register, AR Customers and Sites

Running This SQL Without Blitz Report

Some Oracle EBS SQL reports in this library require functions from the utility package xxen_util. Install it before running the SQL directly against your Oracle EBS database.

Download & Import Options

Resource Link
Excel Example Output Blitz Report Extension Package API Signatures 26-Aug-2026 022325.xlsx
Blitz Report™ XML Import Blitz_Report_Extension_Package_API_Signatures.xml
Full SQL on Enginatics www.enginatics.com/reports/blitz-report-extension-package-api-signatures/

© 2026 Enginatics