setManualDataAccess

Specifies whether Oracle is permitted to manually access the relational and Essbase databases of an environment in emergency situations when an environment is unresponsive and customer has not yet provided a service request to investigate and make the environment available.

In emergency situation, Oracle resorts to an internal process whereby a high-level development executive, after an independent verification process, permits manual access to the relational and Essbase databases. You use this command to stop Oracle from accessing these databases without your explicit approval. Additionally, you have the option to prohibit Oracle from manually accessing the relational and Essbase databases in emergency situations even if a service request is open.

The setting you specify using this command takes immediate effect.

Applies to

Planning, Planning Modules, FreeForm, Financial Consolidation and Close, Tax Reporting, Account Reconciliation, Profitability and Cost Management, Enterprise Profitability and Cost Management, Oracle Enterprise Data Management Cloud, Narrative Reporting, Oracle Sales Planning Cloud, and Oracle Strategic Workforce Planning Cloud.

Required Roles

Service Administrator

Usage

epmautomate setManualDataAccess Allow|Revoke [disableEmergencyAccess=true|false], where disableEmergencyAccess, optionally, specifies whether you want to prohibit all manual access to the relational and Essbase databases. Setting this property value to true stops Oracle from manually accessing these databases even if a service request is open. Default is false.

Oracle does not recommend setting disableEmergencyAccess=true because Oracle cannot access the relational and Essbase databases if access is required to troubleshoot and fix a down environment. If the environment is down, you will not be able to issue this command to allow Oracle to manually access these databases.

Examples

  • Revoke the permission that was granted to manually access the relational and Essbase databases in emergency situations without explicit approval:

    epmautomate setManualDataAccess revoke

  • Allow manual access to relational and Essbase databases during emergencies:

    epmautomate setManualDataAccess allow

  • Prohibit manual access to the relational and Essbase databases even if a service request is open:

    epmautomate setManualDataAccess revoke disableEmergencyAccess=true