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');