In the fast-evolving landscape of data management, organizations are increasingly turning to cloud-based solutions for enhanced efficiency, flexibility, and accessibility. One burning question that often arises is, “Is SQL Server cloud-based?” In this blog post, let’s take a closer look … Read More
Blogs
PCG 7.3.3 Issue: Preventive Controls Governor SQL Rule Compilation Failure
PCG 7.3.3: PCG SQL Rule Remote Compilation Fails Applies to: This document pertains to Oracle Preventive Controls Governor, starting from version 7.3 and beyond. Please note that the information provided here is specific to the EBS 12.2.4 platform. Symptoms: Within … Read More
User Password Reset Guide for Versions 8.6.5 and Beyond
Scenario The customer forgot the password for admin during installation. He has already changed it from the original ‘admin’. The customer has already tried running java –jar grcc-utility-8.5.0-SNAPSHOT.jar as mentioned in the GRCC 8.5 installation guide in section 5-1 titled … Read More
User and Role Management in AACG 8.6.3
Managing User Roles in AACG 8.6.3 Version: AACG 8.6.3 With AACG 8.6.3, you can easily set up permissions and grant access in EGRCC 8.6.3. Creating a New Role in AACG 8.6.3: Log in to AACG 8.6.3 using your credentials. Go … Read More
Upgrading AACG from Version 8.6.3 to 8.6.5: Comprehensive Patching Guide for WebLogic Integration
Upgrading AACG (Application Access Control Governor) from version 8.6.3 to 8.6.5 is a critical process that ensures your application is up-to-date and secure. This comprehensive patching guide provides step-by-step instructions for a seamless transition while integrating with WebLogic. By following … Read More
Simplified Access Control Creation in AACG 8.6.3
Creating Access Controls: To establish access controls, it’s essential to have access models in place, as every control is built upon a model, and each model relies on entitlements. Ensure that you have at least one access model before attempting … Read More
Installation Guide for Oracle GRC Application Access Controls Governor 8.6.5 with WebLogic
Table of Contents Installation Checklist Software Staging Location Edit environment file .bash_profile (Technical Validation) ##Added per GRC Installation export JAVA_HOME=/apps/grc/jdk1.7.0_11 export PATH=$JAVA_HOME/bin:$PATH export MW_HOME=/apps/grc/Middleware Specification Step 1 – Confirm OS settings GRC runs on a 64-bit Linux server. Be sure … Read More
Data Source Synchronization Failure in AACG 8.6
(oracle.apps.grc.common.job.JobExecutionException: oracle.apps.grc.dataservices.exception.DataServiceException: Datasource synch failed ) Symptom:- If you get a below error like this in the Weblogic adminserver.log file. Please follow the below troubleshooting. Navigate to $WLS_HOME/user_projects/domains/grc_Domain/servers/AdminServer/logs/Adminserver.log 2015-04-09 16:28:52,384 DEBUG [Thread-100] EtlService:642 sync Id :362 2015-04-09 16:28:52,384 DEBUG [Thread-100] … Read More
Access Control and Entitlement Management in AACG 8.6.3
Creating Access Controls: Before you start creating access controls in AACG 8.6.3, remember that each control is built on a model, and every model relies on entitlements. Therefore, make sure you have at least one access model in place before … Read More
Query to Validate Modifications Made by ‘Approver’ to Purchase Orders, Including Blanket POs
The query to validate the existence of any POs (inclusive of Blanket POs) that were altered by the ‘approver,’ where the creator differs from the modifier or approver. SELECT DISTINCT poh.org_id “ORG ID”, poh.segment1 “PO NUM”, poh.type_lookup_code “TYPE”, (SELECT agent_name … Read More