Knowledge Article

Oracle EBS - Create Packages for Administrator Permissions

Author

  • sachintaware

    SailPoint

Steps to use resources.zip:

  1. Download attached resources.zip .
  2. Copy the package scripts from downloaded resources.zip to the OracleHome\bindirectory and rename the type of scripts from *.txt to *.sql:
  3. Using SQL*Plus, create one more session to the Oracle database by APPS user and run the following: @sp_xxx package. For example, if FND_USER_PKG has invoker rights, run the @sp_FND_USER _PKG
  4. Perform this step for all xxx packages, where xxx package is FND_USER_PKG, FND_RESPONSIBILITY_PKG, WF_LOCAL_SYNCH, FND_WEB_SEC, FND_GLOBAL, or FND_USER_RESP_GROUPS_API.
  5. After performing the above step, log out from APPS session.

Note: Applicable for ARM Administrator Permissions

Downloads