Posts from the ‘EBS’ Category

Invoice validation pending standby

One of the request running long time with pending standby. so it will conflict with some request

Solution :

select * from fnd_concurrent_requests where concurrent_program_id in
(SELECT p.concurrent_program_id FROM FND_CONCURRENT_PROGRAM_SERIAL s, fnd_concurrent_programs_tl p WHERE
(s.to_run_application_id in (select application_id from fnd_concurrent_programs_tl where user_concurrent_program_name=’Invoice Validation’))
and
(s.to_run_concurrent_program_id in (select concurrent_program_id from fnd_concurrent_programs_tl where user_concurrent_program_name=’Invoice Validation’))
and s.running_concurrent_program_id=p.concurrent_program_id)
and phase_code <> ‘C’;

Kill the blocking concurrent request. then it will work

update fnd_concurrent_requests set phase_code=’C’ , status_code=’X’ where request_id=’10358051′;

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

code : UMX|FND_FLEX_VSET_ALL_PRIVS_ROLE

run workflow background engine after assigned

Oracle E-Business Suite 12.2.10 Now Available

https://blogs.oracle.com/ebstech/oracle-e-business-suite-12210-now-available

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

refer

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

REST ISG_SERVICE_EXECUTION_ERROR getting error

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”: {
“Code”: “ISG_SERVICE_EXECUTION_ERROR”,
“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

https://blogs.oracle.com/ebstech/new-oa-framework-1229-bundle-2-now-available

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

refer :

https://blogs.oracle.com/ebs/extended-support-fee-waiver-for-oracle-database-121-and-112-for-oracle-e-business-suite