Friday, September 14, 2012

How to identify the package name and version of an API

To identify the package name of an API as compiled into the Oracle database, in SQL*Plus enter the following select statement (logged in as APPS)
SQL> SELECT text FROM all_source
WHERE name like '%user_api_name%'
  AND text like '%Header%';
(eg:HZ_CUSTOMER_ACCOUNT_PUB API)
A header line of the package and package body showing the package name and version number is returned.
To compare the version of the API package in user’s operating system directory to the one compiled in user’s database, execute the following from the command line from the API directory:
prompt>strings -a packagename | grep Header
All occurrences of the package, package body, and the version number of the file. Version numbers should match what is compiled in the database.