EBS : Font And Links Have Changed After Patching in OAF pages

Error:
Arabic heading fonts in the OAF pages are bigger, in english it is working fine

Solution:
1. Shutdown all services

2. Take a backup of the image and styles cache
 cp -pr $OA_HTML/cabo/images/cache $OA_HTML/cabo/images/cache_date
 cp -pr $OA_HTML/cabo/styles/cache $OA_HTML/cabo/styles/cache_date

3. Remove the files under the styles/cache  
 cd $OA_HTML/cabo/styles/cache
 rm -rf *

4. Remove the files under the images/cache
 cd $OA_HTML/cabo/images/cache
 rm -rf *

5. Compile the jsp files
 cd $FND_TOP/patch/115/bin 
 perl ojspCompile.pl --compile --flush -p 2

6. Start the application services

Reference : R12: Font And Links Have Changed After Patching (Doc ID 1348791.1)

EBS : All OAF pages turns blue after bouncing

Error:

Getting Dark Blue color on OA  Framework pages after stopping the instance for Backup 

Solution:

Clear the Cabo Cache

1. Images and style sheets can be corrupted or out of sync in the cabo caches,
you may need to clear the related directories after backup:

• $OA_HTML/cabo/images/cache
• $OA_HTML/cabo/styles/cache

2. Restart the apache and adoacore

Refernce: How To Clear Caches (Apache/iAS, Cabo, Modplsql, Browser, Jinitiator, Java, Portal, WebADI) for E-Business Suite? (Doc ID 742107.1)

EBS : Checking the INVALID indexes for a particular tablespace and rebuilding it

Here we check for APPS_TS_QUEUES tablespace and rebuild the indexes

select index_name,status from dba_indexes where tablespace_name='APPS_TS_QUEUES' and STATUS != 'VALID';

Above query gives the indexes which are INIVALID in APPS_TS_QUEUES tablespace

select 'alter index 'owner'.'index_name' rebuild;' from dba_indexes where tablespace_name='APPS_TS_QUEUES' and STATUS != 'VALID';

Get the output from the above query and run to rebuild it

EBS : HR-PAY-ROLL run performance related Note-Ids and URL-links

How Do I Improve Payroll Performance? (Doc ID 219306.1)

TIPS FOR IMPROVING PAYROLL PERFORMANCE (Doc ID 1079475.6)

Oracle Human Resources (HRMS) Payroll PAY_ACTION_PARAMETERS Comprehensive Overview (Doc ID 549367.1)

How to Determine the Best Setting for the THREADS Parameter in the Pay_Action_Parameters Table (Doc ID 359354.1)

https://blogs.oracle.com/mandalika/entry/e_business_suite_role_of

https://community.oracle.com/thread/2612218

Extremely Slow Performance On Payroll Calculation Process (Doc ID 1944756.1)

Useful metalink Ids

How To Purge E-Mail Notifications From The Workflow Queue So The E-Mail Is Not Sent (Doc ID 372933.1)

Concurrent Processing - CP Analyzer Sample SQL Statements Including Date Range Parameters from Doc 1411723.1- Concurrent Processing - CP Analyzer for E-Business Suite (Doc ID 1499538.1)

Oracle E-Business Suite Applications DBA and Technology Stack Release Notes for R12.AD.C.Delta.9 and R12.TXK.C.Delta.9 (Doc ID 2233485.1)

Cloning Oracle E-Business Suite Release 12.2 (AD-TXK Delta 6 or Lower Codelevel) with Rapid Clone (Doc ID 2047809.1)

How to Address Issues Where AWR Data Uses Significant Space in the SYSAUX Tablespace (Doc ID 287679.1)

Oracle E-Business Suite Installation and Upgrade Notes Release 12 (12.1.1) for Linux x86-64 (Doc ID 761566.1)

Concurrent Processing - CP Analyzer Sample SQL Statements Including Date Range Parameters from Doc 1411723.1- Concurrent Processing - CP Analyzer for E-Business Suite (Doc ID 1499538.1)

Cloning Oracle Applications Release 12 with Rapid Clone (Doc ID 406982.1)

Database Preparation Guidelines for an E-Business Suite Release 12.1 Upgrade (Doc ID 761570.1)

Oracle E-Business Suite Release 12.1.3 Readme (Doc ID 1080973.1)

R11i / R12 : Requesting Translation Synchronization Patches (Doc ID 252422.1)

How to Disable the FYI Workflow Notification Auto close "AutoClose FYI" So That The Users Can Close Them Manually (Doc ID 1634776.1)

Database Initialization Parameters for Oracle E-Business Suite Release 12 (Doc ID 396009.1)

What Are Root.sh And OrainstRoot.sh Scripts In A Standalone RDBMS Installation? (Doc ID 1493121.1)

Database Initialization Parameters for Oracle E-Business Suite Release 12 (Doc ID 396009.1)

Automatic Tuning of Undo_retention Causes Space Problems (Doc ID 420525.1)

Compatibility Matrix for Export And Import Between Different Oracle Versions [Video] (Doc ID 132904.1)

Client / Server Interoperability Support Matrix for Different Oracle Versions (Doc ID 207303.1)

Concurrent Processing - Troubleshooting Concurrent Request ORA-20100 errors in the request logs (Doc ID 261693.1)

Oracle E-Business Suite Installation and Upgrade Notes Release 12 (12.2) for Linux x86-64 (Doc ID 1330701.1)

Configuring and Managing Oracle E-Business Suite Release 12.1.x Application Tiers for Oracle RAC (Doc ID 1311528.1)

Master Note for Real Application Clusters (RAC) Oracle Clusterware and Oracle Grid Infrastructure (Doc ID 2108593.2)

Starting With Oracle JDBC Drivers - Installation, Certification, and More! (Doc ID 401934.1)

EBS : Patchset level query

select fpi.patch_level,
fa.application_short_name,
fa.application_id
from fnd_product_installations fpi,
fnd_application fa
where fa.application_short_name = '&PATCHSET_SHORT_NAME'
and fa.application_id = fpi.application_id;

Note: Provide the patchset_short_name as input

EBS : Gather Schema Statistics failed with ORA-20001: invalid column name or duplicate

Error:

In GATHER_SCHEMA_STATS , schema_name= ALL percent= 10 degree = 8 internal_flag= NOBACKUP
stats on table AQ$_WF_CONTROL_P is locked
stats on table FND_CP_GSM_IPC_AQTBL is locked
stats on table FND_SOA_JMS_IN is locked
stats on table FND_SOA_JMS_OUT is locked
Error #1: ERROR: While GATHER_TABLE_STATS:
object_name=GL.JE_BE_LINE_TYPE_MAP***ORA-20001: invalid column name or duplicate columns/column groups/expressions in method_opt***
Error #2: ERROR: While GATHER_TABLE_STATS:
object_name=GL.JE_BE_LOGS***ORA-20001: invalid column name or duplicate columns/column groups/expressions in method_opt***
Error #3: ERROR: While GATHER_TABLE_STATS:
object_name=GL.JE_BE_VAT_REP_RULES***ORA-20001: invalid column name or duplicate columns/column groups/expressions in method_opt***



Solution:
Step 1: Identify duplicate rows

select table_name, column_name, count(*) from FND_HISTOGRAM_COLS group by table_name, column_name having count(*) > 1;

SQL> conn apps/apps
Connected.
SQL> select table_name, column_name, count(*) from FND_HISTOGRAM_COLS group by table_name, column_name having count(*) > 1;

  TABLE_NAME                     COLUMN_NAME                      COUNT(*)
------------------------------ ------------------------------ ----------
JE_FR_DAS_010                  TYPE_ENREG                              2
JE_FR_DAS_010_NEW              TYPE_ENREG                              2
JE_BE_LINE_TYPE_MAP            SOURCE                                  2
JE_BE_LOGS                     DECLARATION_TYPE_CODE                   2
JG_ZZ_SYS_FORMATS_ALL_B        JGZZ_EFT_TYPE                           2
JE_BE_VAT_REP_RULES            LINE_TYPE                               2
JE_BE_VAT_REP_RULES            SOURCE                                  2
JE_BE_VAT_REP_RULES            VAT_REPORT_BOX                          2

8 rows selected.

Step 2: Use above results on the following SQL to delete duplicates

delete from FND_HISTOGRAM_COLS where table_name = '&TABLE_NAME' and  column_name = '&COLUMN_NAME'and rownum=1;
commit;

delete from FND_HISTOGRAM_COLS where table_name = 'JE_FR_DAS_010' and  column_name = 'TYPE_ENREG' and rownum=1;
delete from FND_HISTOGRAM_COLS where table_name = 'JE_FR_DAS_010_NEW' and  column_name = 'TYPE_ENREG' and rownum=1;
delete from FND_HISTOGRAM_COLS where table_name = 'JE_BE_LINE_TYPE_MAP' and  column_name = 'SOURCE' and rownum=1;
delete from FND_HISTOGRAM_COLS where table_name = 'JE_BE_LOGS' and  column_name = 'DECLARATION_TYPE_CODE' and rownum=1;
delete from FND_HISTOGRAM_COLS where table_name = 'JG_ZZ_SYS_FORMATS_ALL_B' and  column_name = 'JGZZ_EFT_TYPE' and rownum=1;
delete from FND_HISTOGRAM_COLS where table_name = 'JE_BE_VAT_REP_RULES' and  column_name = 'LINE_TYPE' and rownum=1;
delete from FND_HISTOGRAM_COLS where table_name = 'JE_BE_VAT_REP_RULES' and  column_name = 'SOURCE' and rownum=1;
delete from FND_HISTOGRAM_COLS where table_name = 'JE_BE_VAT_REP_RULES' and  column_name = 'VAT_REPORT_BOX' and rownum=1;


Step 3 : Submit the Gather schema statistics again

Reference (Doc ID 781813.1)

EBS : ORA-2001 unabled to call fnd_ldap_wrapper.create_user due

Error:

Unable to call fnd_ldap_wrapper.create_user due to the following reason
ORA-2001 unabled to call fnd_ldap_wrapper.create_user due to the following reason
An unexpected error occured. please concact your system Administrator

While creating new users in non SSO environment

Solution:

• Set the Profile Option "Applications SSO Type" to "SSWA"
• Save your settings
• Bounce Apache Services for changes to take place
• Retest the issue

Reference : ( Doc ID 863410.1)