Posts by Hemanth Kumar

User Provisioning from SSO to EBS is Failing after a Maintenance

Issue: SSO is unable to establish a connection to EBS as the APPS password is wrongly updated. —— Error: ——- [2015-11-25T11:45:23.966-05:00] [wls_ods2] [ERROR] [DIP-20050] [oracle.dip.prodapp_calif_I] [tid: prodapp_calif_I] [userId: <anonymous>] [ecid:…

Read More

Retry Errored Workflow Activities in Oracle EBS

You can retry all errored activities for the specific item type, or you can choose to retry only activities for a particular work item of that item type, activities for…

Read More

OPP Fails To Pick Up Concurrent Requests With Error ‘Unable to find an Output Post Processor service to post-process request

CAUSE : ———- Incorrect data is present in the OPP queue table AQ$FND_CP_GSM_OPP_AQTBL_S, which occurs when the concurrent managers are not shutdown correctly. A quick sql query shows orphaned OPP…

Read More

Redolog Switch Rate by Date and Hour

set linesize 300; set pagesize 1000; spool rac_redo_switch_rate.log set heading off; select ‘******************************************************’ from dual; select ‘**** Redolog Switch Rate by Date and Hour ****’ from dual; select ‘******************************************************’ from…

Read More

EBS User account unable to Autheticate in an SSO Integrated environment

Issue: —— In an EBS-SSO integrated environment – The user Account is active in EBS and the SSO account is provisioned, but still unable to authenticate from the EBS-OAM login…

Read More

Resending Failed Workflow Notifications

Check the status of WF Mailer : ———————————– SQL> select component_status from apps.fnd_svc_components where component_id = (select component_id from apps.fnd_svc_components where component_name = ‘Workflow Notification Mailer’); Find the Failed/Errored Notifications…

Read More