Login Error oracle.apps.fnd.framework.OAException: No data found for region

Error:-

ON: user ID = 0: responsibility ID = ]:oracle.apps.fnd.framework.OAException: Application: FND, Message Name: FND_NO_REGION_DATA. Tokens: REGIONCODE = /oracle/apps/fnd/framework/navigate/webui/NewHomePG;
        at oracle.apps.fnd.framework.webui.JRAD2AKMapper.getRootMElement(JRAD2AKMapper.java:564)
        at oracle.apps.fnd.framework.webui.OAWebBeanFactoryImpl.getWebBeanTypeDataFromJRAD(OAWebBeanFactoryImpl.java:3276)
        at oracle.apps.fnd.framework.webui.OAWebBeanFactoryImpl.getRootApplicationModuleClass(OAWebBeanFactoryImpl.java:2994)
        at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1157)
        at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:586)
        at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:474)
        at _pages.__oa._jspService(__oa.java:233)
        at weblogic.servlet.jsp.JspBase.service(JspBase.java:34)
Exception:
oracle.adf.mds.MetadataDefException: Unable to find component with absolute reference = /oracle/apps/fnd/framework/navigate/webui/NewHomePG, XML Path = null. Please verify that the reference is valid and the definition of the component exists either on the File System or in the MDS Repository.
/oracle/apps/fnd/framework/navigate/webui/NewHomePG<Line 44, Column 92>: XML-20124: (Fatal Error) An attribute cannot appear more than once in the same start tag.
        at oracle.adf.mds.adapters.DBAdapter.getElementData(DBAdapter.java:353)
        at oracle.adf.mds.internal.MetadataManagerBase.findElement(MetadataManagerBase.java:1287)

Solution:-

To implement the solution, please execute the following steps:
1. Copy NewHomePG.xml to $JAVA_TOP/oracle/apps/fnd/framework/navigate/webui/

 cp $FND_TOP/mds/framework/navigate/webui/NewHomePG.xml $JAVA_TOP/oracle/apps/fnd/framework/navigate/webui/

2. Go to Java top

 cd $JAVA_TOP

3. Import the file NewHomePG.xml using XMLImporter command
 
 java oracle.jrad.tools.xml.importer.XMLImporter $JAVA_TOP/oracle/apps/fnd/framework/navigate/webui/NewHomePG.xml -username apps -password <appspwd> -dbconnection "(DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST=<Hostname>)(PORT=<port number>))  (CONNECT_DATA= (SERVICE_NAME=TEST) (INSTANCE_NAME=TEST)))" -rootdir $JAVA_TOP

4. Retest the issue.

5. Migrate the solution as appropriate to other environments.

How To Run SQL Tuning Advisor For A Sql_id

It provides tuning recommendations that can be done that query to improve performance.

Suppose the sql id is – 5pp28g92z5ygg

1. Create Tuning Task

DECLARE

l_sql_tune_task_id VARCHAR2(100);

BEGIN

l_sql_tune_task_id := DBMS_SQLTUNE.create_tuning_task (

sql_id => '5pp28g92z5ygg',

scope => DBMS_SQLTUNE.scope_comprehensive,

time_limit => 500,

task_name => '5pp28g92z5ygg_tuning_task11',

description => 'Tuning task1 for statement 5pp28g92z5ygg');

DBMS_OUTPUT.put_line('l_sql_tune_task_id: ' || l_sql_tune_task_id);

END;

/

2- Execute Tuning task

EXEC DBMS_SQLTUNE.execute_tuning_task(task_name => '5pp28g92z5ygg_tuning_task11');

3- Get the Tuning advisor report.

set long 65536

set longchunksize 65536

set linesize 100

select dbms_sqltune.report_tuning_task('5pp28g92z5ygg_tuning_task11') from dual;

4- Get list of tuning task present in database

SELECT TASK_NAME, STATUS FROM DBA_ADVISOR_LOG WHERE TASK_NAME ;

5- Drop tuning Task

execute dbms_sqltune.drop_tuning_task('5pp28g92z5ygg_tuning_task11');

The table FND_INSTALL_PROCESSES created by AD Administration already exists.

 Issue:

During adop phase I faced the below error.

The table FND_INSTALL_PROCESSES created by AD Administration already exists.

Cause:

adadmin session was open to compile apps schema objects but it was stuck.

Solution:

1. Now take the backup of the FND_INSTALL_PROCESSES table

Connect as applsys because FND_INSTALL_PROCESS is owned by applsys schema.

Sqlplus applsys/<password>

create table fnd_Install_processes_23Feb22 as select * from fnd_Install_processes;

2. Check the both tables should have the same number of rows

SQL> select count(*) from fnd_Install_processes_23Feb22;

SQL> select count(*) from fnd_Install_processes;

3.. In same way take the backup of the AD_DEFERRED_JOBS table from applsys schema

sqlplus applsys/<password>

SQL>create table AD_DEFERRED_JOBS_23Feb22 as select * from AD_DEFERRED_JOBS;

4. Now backup the .rf9 files located at below path directory

$APPL_TOP/admin/$TWO_TASK/restart directory

Here adpatch session must be ended and the cursor should be back at the UNIX prompt.

$echo $ORACLE_SID or $TWO_TASK

cd $APPL_TOP/admin/$TWO_TASK

cp restart restart_23FEB

5. DROP the FND_INSTALL_PROCESSES table and the AD_DEFERRED_JOBS table.

sqlplus applsys/<password>

drop table FND_INSTALL_PROCESSES;

drop table AD_DEFERRED_JOBS;

6. Restart adop patch

Oracle cloud infrastructure 2021 architect associate 1z0-1072 dumps free

All Real Exam Questions with Answers (highlighted in RED)

Q1:

Q2:

Q3:

Q4:

Q5:

Q6:

Q7:

Q8:

Q9:

Q10:

Q11:

Q12:

Q13:

Q14:

Q15:

Q16:

Q17:

Q18:

Q19:

Q20:

Q21:

Q22:

Q23:

Q24:

Q25:

Q26:

Q27:

Q28:

Q29:

Q30:

Q31:

Q32:

Q33:

Q34:

Q35:

Q36:

Q37:

Q38:

Q39:

Q40:

Q41:

Q42:

Q43:

Q44:

Q45:

Q46:

Q47:

Q48:

Q49:

Q50:

Q51:

Q52:

Q53:

Q54: