Table of Contents

Search

  1. Preface
  2. Starting Data Archive
  3. System Configuration
  4. Database Users and Privileges
  5. Source Connections
  6. Target Connections
  7. Archive Store Configuration
  8. Datatype Mapping
  9. Database Optimization
  10. SAP Application Retirement
  11. z/OS Source Data Retirement
  12. Seamless Data Access
  13. Data Discovery Portal
  14. Security
  15. SSL Communication with Data Vault
  16. LDAP User Authentication
  17. Auditing
  18. Running Jobs from External Applications
  19. Salesforce Archiving Administrator Tasks
  20. Upgrading Oracle History Data
  21. Upgrading PeopleSoft History Data
  22. Data Archive Maintenance
  23. Appendix A: Datetime and Numeric Formatting
  24. Appendix B: Data Archive Connectivity

Administrator Guide

Administrator Guide

Configuring the Query and Combined Users in Oracle E-Business Suite 12.2.5

Configuring the Query and Combined Users in Oracle E-Business Suite 12.2.5

In Oracle E-Business Suite version 12.2.5, the ability to configure a new user through the
Add
button on the
Oracle Users
screen was disabled for custom applications and schemas. To create the query user and the combined user for seamless access, complete the following steps:
  1. Connect to the Linux machine through SQLPlus and run the following package:
    SQL> sqlplus apps/apps Connected. SQL> exec FND_ORACLE_USER_PKG.LOAD_ROW('TEST', 'CUSTOM', 'INVALID', NULL, 'N', 'B');
  2. To register the user, run the following commands:
    SQL> conn system/manager Connected. SQL> alter session set current_schema=APPS; SQL> exec AD_ZD_PREP.ENABLE_CUSTOM_USER('TEST');
  3. In the
    Oracle Users
    screen, query the name of the database user you created, in this example "test."
    The new user should be present in the
    Oracle Users
    screen. You can now edit the user, change the user privilege to enabled, and save the user. You can also change the user password.

0 COMMENTS

We’d like to hear from you!