Skip to content

Posts from the ‘EBS’ Category

Unable to connect to the mail account. Check the host, user name, password and connection security

When we trying to configure workflow, the following error we’re getting

Unable to connect to the mail account. Check the host, user name, password and connection security

We checked that IMAP, SMTP port opened already. but still we’re getting the issue

Solution :

Functional Administrator – Clear cache and then bounce the service. its working now.

Unable to load resource jar files in ebs 12.2

We’re facing the some of the users are trying to open the forms after login ebs 12.2.9 with jre1.8.0_271, the forms are not pop up and says ” unable to load resource fndforms.jar and like other jar files”.

we have checked the group policy for trusted websites added, yes its added

We have checked the java exception site list policy, yes its there.

But still we’re facing the issues for some of the users. so its not a problem of java. it should be something blocking the site to reach servers whenever load jar files.

Yes finally, we got it. Our company firewall blocking rule is blocking JAR files by default. For EBS we have to allow JAR files.

Flexfield role assign to user in EBS 12.2

User Management

select user

assign the below role to user


run workflow background engine after assigned

Oracle E-Business Suite 12.2.10 Now Available


Best Practices for Minimizing Oracle E-Business Suite Release 12.2.n Upgrade Downtime


Best Practices for Minimizing Oracle E-Business Suite Release 12.2.n Upgrade Downtime (Doc ID 1581549.1)


When we’re trying to post the data using REST service after we add some parameter in existing package, we’re getting the error while post


“ISGServiceFault”: {
“Message”: “Error while executing service”,
“Resolution”: “System error, please see service log trace for details”,
“ServiceDetails”: {
“ServiceName”: “XXACE_AP_INV_CMS_SOA_PKG”,
“OperationName”: “xxace_main”,
“InstanceId”: “0”


Log in error while deploy REST service

PLS-00306: wrong number or types of arguments in call to ‘HAS_DEFAULT’
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored


Solution :

Functional Administrator –> clear cache

restart service

undeploy and deploy the service again

Now we can able to post data


EBS 12.2 Only Allow Access to Oracle WebLogic Server Administration Ports from Trusted Hosts

When i am trying to access the weblogic server console from one of client machine, I am getting the below error



Solution :


If you have applied the Critical Patch Update (CPU) released in April 2019, then you can use the context variable s_wls_admin_console_access_nodes to specify the trusted hosts used by administrators that require access to the Oracle WebLogic Server Administration Console and Fusion Middleware Control. Set this context variable to a list of trusted hosts that are allowed to access the consoles using the Oracle WebLogic Server Administration ports.


Run file system, we need to add the client ip or hostname lists in context file

<s_wls_admin_console_access_nodes oa_var=”s_wls_admin_console_access_nodes”>10.0.XX.XX</s_wls_admin_console_access_nodes>

run autoconfig

stop and start service

Now we can able to reach the weblogic server console URL

adop phase=fs_clone

New OA Framework 12.2.9 Bundle 2 Available

Please refer


Extended Support Fee Waiver for Oracle Database 12.1 and 11.2 for Oracle E-Business Suite

refer :


List of users with responsibilities

decode(a.END_DATE,NULL,’ACTIVE’,’INACTIVE’) Status,a.start_date,a.end_date,a.last_logon_date,d.internal_location
FROM apps.fnd_responsibility_vl frv,apps.FND_USER a,apps.FND_USER_RESP_GROUPS_all b,apps. per_all_people_f d,apps.FND_RESPONSIBILITY_TL res,PER_JOBS_VL e,
per_all_assignments_f f
d.person_id=f.person_id and
b.responsibility_id = res.responsibility_id
and a.USER_ID=b.USER_ID and b.RESPONSIBILITY_ID=frv.RESPONSIBILITY_ID and a.employee_id=d.person_id
and sysdate between d.effective_start_date and d.effective_end_Date
and sysdate between nvl(frv.start_date,sysdate) and nvl(frv.end_date,sysdate)
AND f.job_id = e.job_id
group by d.employee_number,a.USER_NAME,frv.responsibility_name, d.full_name,b.START_DATE,b.end_date,decode(a.END_DATE,NULL,’ACTIVE’,’INACTIVE’),
ORDER BY d.full_name