Thursday, October 27, 2022
Oracle E-Business Suite with Oracle Autonomous Database on Dedicated Exadata Infrastructure
Monday, October 17, 2022
How to Change Profile Option Value Without Forms? (Doc ID 943710.1)
APPLIES TO:
Oracle Application Object Library - Version 11.5.10.0 to 12.2.10 [Release 11.5 to 12.2]Information in this document applies to any platform.
GOAL
How to update a Profile Option using SQL (if Forms login is not possible)?
SOLUTION
Please use the API: FND_PROFILE
The package FND_PROFILE can be found in file AFPFPROS.pls
Note: FND_PROFILE is not public interface. Use of this API is considered a customization and should be tested in a test environment.
FND_PROFILE.SAVE - sets the value of a profile option permanently to the database,
at any level. This routine can be used at runtime or during patching.
This routine will not actually commit the changes; the caller must commit.
The levels are: 'SITE', 'APPL', 'RESP', or 'USER'.
Examples of use:
FND_PROFILE.SAVE('P_NAME', 'P_VAL', 'APPL', 321532);
FND_PROFILE.SAVE('P_NAME', 'P_VAL', 'RESP', 321532, 345234);
FND_PROFILE.SAVE('P_NAME', 'P_VAL', 'USER', 123321);
returns: TRUE if successful, FALSE if failure.
To update a Profile Option value at Site level, you need to run the SQL Script below:
value Boolean;
Begin
value := fnd_profile.save('APPS_DATABASE_ID','<new_value>','SITE');
End;
Example:
Sample Code
===========
DECLARE
stat boolean;
BEGIN
dbms_output.disable;
dbms_output.enable(100000);
stat := FND_PROFILE.SAVE('GUEST_USER_PWD', 'GUEST/ORACLE', 'SITE');
IF stat THEN
dbms_output.put_line( 'Stat = TRUE - profile updated' );
ELSE
dbms_output.put_line( 'Stat = FALSE - profile NOT updated' );
END IF;
commit;
END;
===============
End of Sample Code
===============
Description of the FND_PROFILE.SAVE function parameters:
X_NAME in varchar2, /* Profile name you are setting */
X_VALUE in varchar2, /* Profile value you are setting */
X_LEVEL_NAME in varchar2, /* Level that you're setting at:
'SITE','APPL','RESP','USER', etc. */
X_LEVEL_VALUE in varchar2 default NULL,
/* Level value that you are setting at,
e.g. user id for 'USER' level.
X_LEVEL_VALUE is not used at site level. */
X_LEVEL_VALUE_APP_ID in varchar2 default NULL,
/* Used for 'RESP' and 'SERVRESP' level;
Resp Application_Id. */
X_LEVEL_VALUE2 in varchar2 default NULL
/* 2nd Level value that you are setting at.
This is for the 'SERVRESP' hierarchy. */
) return boolean;
Reference: https://docs.oracle.com/cd/E26401_01/doc.122/e20927.pdf
Thursday, October 13, 2022
FND_CONCURRENT_QUEUE Control Code Meaning
In the FND_CONCURRENT_QUEUE table we have a column named control_code.
To get the details of the code present in the column we can use below script.
SQL> select lookup_code,meaning from apps.fnd_lookups where lookup_type = 'CP_CONTROL_CODE' order by lookup_code;
LOOKUP_CODE MEANING
---------- ------------------------------
A Activating
B Activated
D Deactivating
E Deactivated
H System Hold, Fix Manager before resetting counters
N Target node/queue unavailable
O Suspending concurrent manager
P Suspended
Q Resuming concurrent manager
R Restarting
T Terminating
U Updating environment information
V Verifying
X Terminated
Saturday, October 8, 2022
adop fs_clone failure
adop fs_clone failure
Validating credentials.
Initializing.
Run Edition context : /ascprd/app/applmgr/IRASCPRD_R122/fs1/inst/apps/IRASCPRD_Admin_host/appl/admin/IRASCPRD_Admin_host.xml
Patch edition context: /ascprd/app/applmgr/IRASCPRD_R122/fs2/inst/apps/IRASCPRD_Admin_host/appl/admin/IRASCPRD_Admin_host.xml
Patch file system free space: 696.66 GB
Validating system setup.
[UNEXPECTED]Invalid worker Count: 0
[UNEXPECTED]Error validating worker count
[STATEMENT] Please run adopscanlog utility, using the command
"adopscanlog -latest=yes"
to get the list of the log files along with snippet of the error message corresponding to each log file.
adop exiting with status = 2 (Fail)
Fix : Run with one worker
$ adop phase=fs_clone worker=1
Solution worked for others
The default worker count information(recomm & max) is stored in a file adpawc.xml that can be found under $APPL_TOP/admin/$TWO_TASK/log
Somehow this file has been modified with recommended value as 0 and max value as 1 during node addition.
FileContent:
<?xml version="1.0"?>
<WORKER_COUNT>
<RECOMMENDED>0</RECOMMENDED>
<MAX>1</MAX></WORKER_COUNT>
Update recommended & max value based on cpu count.
Here I updated recommended value as 8 and max value as 64 and saved the file.
Once the changes are made, fs_clone went smoothly.
How to choose the number of workers for adop or adpatch
How to choose the number of workers:
For less than 32 cores set:
• parallel_max_servers = 2 x number of CPU cores
• AD Parallel workers – start with 1.5 x number of CPU cores. Possibly increase to 2 x number of CPU cores
• job_queue_processes = 2 x number of CPU cores
For 32 cores and above, start with:
• parallel_max_servers = 1.5 x number of CPU cores
• AD Parallel workers = between 1.0 and and 1.5 x number of CPU cores
• job_queue_processes = 1.5 x number of CPU cores
Friday, September 30, 2022
Expand Your Skills: Announcing New OCI training for AWS and Azure Architects
One of the of the most effective ways to learn a new skill is to leverage your existing experience, learning, and knowledge in that area and build upon it. For example, let’s say you have a fair amount of experience with gardening and now want to learn about vertical hydroponic gardening (quite a craze in the last few years!). To do that, you don’t need to relearn everything you already know about gardening (basics of how plants grow, the amount of sunshine they need, etc.). Instead, you can leverage your existing expertise (gardening) in learning a new skill (vertical hydroponic gardening). The same approach can be applied in learning many new skills, including cloud technologies.
Our customers tell us that they would like to learn more about Oracle Cloud, but don’t want to start from scratch. Our customers (and most of us) are time-constrained. Moreover, many organizations have only recently started experimenting with Oracle Cloud. However, many of them use AWS and/or Microsoft Azure and are familiar with cloud-operating models.
Build on your previous experience with Azure or AWS
As part of our transferable skills strategy, we are excited to announce two new courses:
The idea behind these two courses is to help you ramp-up to Oracle Cloud faster by building on your existing cloud skillsets, knowledge and experience. These courses are short in length (~3 hours each) and can be completed in 2-3 brief sessions. Moreover, they are available for free to everyone.
We compare ~35 services each from OCI, AWS and Azure across these nine categories – that’s over 100+ services across the two courses
These courses are technical and do not include any sales or marketing pitches. Our goal with these courses is to help you get started on OCI quickly, so we compare the core-primitives of OCI with those of AWS and Azure. We compare these core building blocks:
Each of the categories have services and features compared side by side. For example, this slide from the Security Module course compares capabilities around OS and workload protection covering managed Bastions, OS patching, dedicated compute hosts, etc. Throughout the courses, we discuss how AWS and Azure services and features translate to OCI, so you can relate and build upon your existing knowledge.
One of the key challenges we faced was determining how detailed these courses should be. Any competitive discussion can go deep when you start comparing individual features – most of the cloud services have very extensive feature sets. Therefore, for the sake of brevity, we do not cover every individual feature, but do touch on the key similarities and differences.
Each of these categories include OCI services walk-throughs, because it is much easier to understand the product when you see it in action. We also realized this could be the first OCI course many learners would encounter, so we cover many how-to topics:
and more.
The idea, quite simply, is to show you how services work in OCI.
Finally, as these courses are technical in nature, we don’t discuss pricing, SLAs, support, or any of the business side of OCI or AWS/Azure. However, we do have webpages where you can learn more about OCI technical differentiation, including SLAs and Pricing: OCI v/s AWS, OCI v/s Microsoft Azure and OCI v/s Google Cloud Platform.
Get Started
The courses are available here:
If you have an existing OCI tenancy, you can use it to practice the service walkthroughs shown in these courses. If you don’t have an existing OCI account, we recommend that you open an Oracle Cloud Free Tier account in order to run these walkthroughs – for free.
Thanks for reading and good luck with your learning journey!
Ref : https://blogs.oracle.com/oracleuniversity/post/oci-training-for-aws-and-azure-architects
Discovery
Please run the ETCC report on Run FS and DB and share the output
Patch 17537119: EBS 12.2 TECHNOLOGY CODELEVEL CHECKER (ETCC)
Please run the below reports on DB & Applications side and share the results
E-Business Suite Applications Technology Stack Utility / Script To Check The Techstack Component Versions (Forms, Http Server, JDK, Framework, Database, etc) (Doc ID 601736.1)
Please share Demantra Patches
select * from version_details_history order by 4 desc;
Pease share the output from Demantra Weblogic home
$ORACLE_HOME/OPatch/opatch lsinventory
$ORACLE_HOME/OPatch/opatch lspatches
$ORACLE_HOME/OPatch/opatch lsinventory | grep –i applied
-
This document describes how to develop and deploy customizations in an Oracle E-Business Suite Release 12.2 environment. Follow thes...
-
This document also provides links to two presentations on the subject: Oracle OpenWorld presentation "Technical Upgrade Best Practice...
-
The information in this document applies to Oracle E-Business Suite Release 11 i and R12.x . The most current version of this document ...
