Skip to content

yum install package compilation issue

I created a local repository in redhat 7.6 and then i am trying to install the package but i am getting the dependency issue.

Error :

[root@ebs-117-41 Packages]# yum install glibc-2.17-222.el7.i686
Loaded plugins: langpacks, product-id, search-disabled-repos, subscription-manager
This system is not registered with an entitlement server. You can use subscription-manager to register.
Resolving Dependencies
–> Running transaction check
—> Package glibc.i686 0:2.17-222.el7 will be installed
–> Processing Dependency: glibc-common = 2.17-222.el7 for package: glibc-2.17-222.el7.i686
–> Processing Dependency: for package: glibc-2.17-222.el7.i686
–> Processing Dependency: for package: glibc-2.17-222.el7.i686
–> Running transaction check
—> Package glibc.i686 0:2.17-222.el7 will be installed
–> Processing Dependency: glibc-common = 2.17-222.el7 for package: glibc-2.17-222.el7.i686
—> Package nss-softokn-freebl.i686 0:3.34.0-2.el7 will be installed
–> Finished Dependency Resolution
Error: Package: glibc-2.17-222.el7.i686 (customrepo)
Requires: glibc-common = 2.17-222.el7
Installed: glibc-common-2.17-260.el7.x86_64 (@anaconda/7.6)
glibc-common = 2.17-260.el7
Available: glibc-common-2.17-222.el7.x86_64 (customrepo)
glibc-common = 2.17-222.el7
You could try using –skip-broken to work around the problem
You could try running: rpm -Va –nofiles –nodigest


Solution :

By mistake I created a local repository with lower version of redhat. so that it’s not compatible when i try to install rpm packages. After i corrected the repository version, it’s okay to install.

In case, If you still continue to see the error after you created the repository with correct version, you need to clean.


yum clean all

then execute

yum repolist

Now We can able to install rpm packages on the server using local repository.




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

Java webstart at EBS 12.2.9

I upgraded EBS Version from 12.1.3 to 12.2.9. After upgraded, i planned to setup the Java webstart for EBS 12.2.9 version. As such, i review the document (Doc ID 2188898.1), this document clearly explained about how to setup the java webstart on EBS.


There was many patches noted to apply on EBS version for java webstart. But my case, I have already upgraded to latest version. so all the patches are included whichever required.


Section : 4.2.2 Oracle Forms 10g Technology Patch for Oracle E-Business Suite Release 12.2

the document noted to apply the patch Patch 25441839 but Patch 26825525 already applied during upgrade activity. so no need to apply the patch 25441839 (Doc ID 2554599.1).

you need to follow further steps for Java webstart setup.

New JRE 1.8.0 & 1.7.0 Certification with EBS Releases 12.2 and 12.1



java.lang.SecurityException: User: ASADMIN authentication failed

When i trying to undeploy the REST service in UAT and deploy again, i am getting the below error.


java.lang.SecurityException: User: ASADMIN authentication failed

Solution :

verify the asadmin given credential correct and roles also.

Run the txkISGConfigurator.xml utility with “ebsSetup” argument.

refer :  Installing Oracle E-Business Suite Integrated SOA Gateway, Release 12.2 (Doc ID 1311068.1)

Section 2: Configuring Oracle E-Business Suite Integrated SOA Gateway for REST Services


sysadmin user not logging in r12

I am trying to logging in sysadmin user of one of our UAT system, It’s simply loading but not logging in.

I checked the sysadmin user credentials valid. Yes it’s Valid.


select fnd_web_sec.validate_login(‘SYSADMIN’,’password’) from dual;


Solution :

I checked any blocking session in database, Yes it’s there . So I kill those sessions afterwards  I can able to login.

select l1.sid, ‘ IS BLOCKING ‘, l2.sid
from v$lock l1, v$lock l2 where l1.block =1 and l2.request > 0
and l1.id1=l2.id1 and l1.id2=l2.id2


File export not saved oracle apps r12

Suddenly We couldn’t able to save the file after we did export.


Solution :


Check your database any one of tablespace space issue in alert log file and add datafile.

APP-FND-00706: Routine FDFADF: Detected a data error

During Payment voucher creation, users getting the below issue.

After click Ok, users getting below error




Workaround :

Increase open_cursor parameter in database and start a new session to do the payment voucher, it’s working now.


After we log a SR, Oracle has provided a patch to apply the patch for fixing the issue.


After Upgrading To 12.2.9 Forms Fail: “Error APP-FND-00706: Routine Detected A Data Error” (Doc ID 2629037.1)