-
Automation: Create groups in partner organizations in CPQ instance
Oracle CPQ UI Automation Selenium based automation bot to do routine and time consuming tasks on Oracle CPQ Cloud application. Pre-requisites Chrome Browser should be installed Supports Python >= 3.9 CPQ account should have admin access with proxy login option Installation pip install py-oracle-cpq-ui-automation Usage Just type import oracle_cpq_ui_automation in the module you want to use Oracle… Continue reading
-
WebADI – What is it? and how to troubleshoot?
There are basically two ways to enter data into Oracle: by typing it into a user interface (Java Form or Web Page) or by taking a file and programmatically interfacing the data. Web ADI falls into the second category in that it takes an Excel file and programmatically loads the data into Oracle. If you… Continue reading
-
Oracle CPQ Cloud Certification Q/A – Part III
101) When loading the rules in a configuration layout for each tab specifically, which option you would select? a) Define a condition for every rule in the configuration flow to check for the active tab b) Define the Tab loading Behavior as Lazy loading c) Define the processing Event as Tab Change d) Do nothing as this is the default… Continue reading
-
Oracle CPQ Cloud Certification Q/A – Part II
51) In which two locations are the keywords for mobile approval or rejection of quotes defined when setting up approvals? a) Submit sub-action – Approve b) Submit sub-action – Reject c) Submit sub-action – Submit or Approval d) Mobile Approval Email Notification 52) How can a user be restricted from removing line items that are added to the configuration through a… Continue reading
-
Oracle CPQ Cloud Certification Q/A – Part I
Oracle CPQ (Formerly Big Machine) Yellow Belt Certification Questions and Answers 1) What are three testing strategies for Oracle CPQ cloud? a) Test cases should be directly linked to business requirements. b) Avoid using a test case tracking tool because it’s time consuming to track all of the testing team effort. c) Perform isolated tests as well as intra-system… Continue reading
-
Check Oracle Incompatibility programs!
Fetch incompatibility programs of an Oracle concurrent program or current request by using the below query. Using Concurrent Program – fetch the incompatibility programs and its details Simplified query to check incompatibility programs which are running, for a concurrent request/program with timings Continue reading
-
Oracle Cloud Technical Skills
Hello Fellows, this blog is specifically to understand the oracle technical skills which a developer should have. I am planning to update this blog regularly with new information, best sites to learn these skills, free courses available in the market, my own training materials to learn and develop the below skillsets. This post is not… Continue reading
-
Oracle CPQ – Browser Cache
Have you ever wondered that even after deployment why my changes are not visible in Oracle CPQ. Sometimes I logout and logged in, then the changes are visible..Sometimes still! Where are my Changes?? Let’s see how Cache works: The browser cache is similar to a hard disk where the browser keeps existing images or data… Continue reading
-
How to find EBS User Password
We need APPS password of the instance to decrypt user Password from fnd_user table. SELECT (SELECT decrypt_pin_func(fnd_web_sec.get_guest_username_pwd,usertable.encrypted_foundation_password ) FROM DUAL) AS apps_password FROM fnd_user usertable WHERE usertable.user_name = ‘GUEST’; SELECT usr.user_name, get_pwd.decrypt( ‘B1BRF3NDEV’, usr.encrypted_user_password ) PASSWORD, encrypted_user_passwordFROM fnd_user usr WHERE UPPER(usr.user_name) = UPPER(‘XXX’); Continue reading
-
How to find APPS password in EBS
— Function To decrypt Passwordcreate or replace FUNCTION apps.decrypt_pin_func(in_chr_key IN VARCHAR2,in_chr_encrypted_pin IN VARCHAR2)RETURN VARCHAR2ASLANGUAGE JAVA NAME ‘oracle.apps.fnd.security.WebSessionManagerProc.decrypt(java.lang.String,java.lang.String) return java.lang.String’; — Retrieve APPS password using encrypted_foundation_password from GUEST login select ENCRYPTED_FOUNDATION_PASSWORD from apps.fnd_user where USER_NAME=’GUEST’; — Pass ENCRYPTED_FOUNDATION_PASSWORD in Function decrypt_pin_funcSELECT apps.decrypt_pin_func(‘GUEST/ORACLE’,’ZG182FC0BF2FD62E57F925EFE4F3′) APPS_Password from dual; Continue reading
Fellow Beginner 