Skip to content

Posts from the ‘EBS’ Category

Why EBS URL not working after changed IP Address

Why EBS URL not working after changed IP Address?


Your system was configured using HOSTNAME of the machine, you plan to change the IP address of that machine, you changed and restarted the application also, Still Application URL not working, Why?

Stop the application & run autoconfig on the system and start the application, it will work.


Capture FND log error message

Step 1:

select max(log_sequence) from fnd_log_messages

Note the sequence number

Step 2:

Log in as a system administator

Profile –> System

FND: Debug Log Enabled –> Yes

FND: Debug Log Level  –> Statement or options

FND: Debug Log Module –> %


Step 3:

Reproduce the issue


Step 4:

select max(log_sequence) from fnd_log_messages


Step 5:

select * from fnd_log_messages where log_sequence between “first one” and ” last sequence”


Spool the file and analyze the log file if you can able to find any issue with this file.


RC-00203 RC-50004 AC-00005

I am trying to clone one of our production machines after I upgraded the database to  This clone machine prepared by Veeam Backup. I think the below solution is applicable for VM clone also. Here While I am doing steps, I am getting below issue

done: Port Pool 65 is free
Report file located at /appsutil/out/portpool.lst
RC-00203: Unable to create/write to file /appsutil/out/portpool.lst.
Complete port information available at /appsutil/out/portpool.lst
RC-50004: Error occurred in CloneContext:
AC-00005: No write permissions for creating the Context file – /appsutil/temp.xml
Raised by
Check Clone Context logfile /u01/app/oracle/db/tech_st/12c/appsutil/clone/bin/CloneContext_0220023028.log for details.

ERROR: Context creation not completed successfully.
For additional details review the file /tmp/adcfgclone_23246.err if present.


Solution :

What I did


  1. I run on both application & database tier
  2. System Team Clone the machine using Veeam Backup
  3. Then I restored the database using backup copy, then I rename the database.
  4. Now I ran steps, I am getting above issue.

On Database Tier node,

1. Set the ORACLE_HOME Path  environment on database tier, Database SID should be a new SID (renamed one)

2. Change hostname & IP address on new server

3. Set TNS_ADMIN Path –>

(copy the Production TNS _ADMIN path, to New path & modify the tnsnames.ora & listener.ora with new SID & hostname)

4. Start the listener

5. Once listener started, create a context file using by


6. run auto config


7. Database configuration part finished

8. Go to application tier,

perl appsTier


Can’t locate ADX/util/ in @INC

When  I am trying to change hostname for EBS environment,  I used below command to remove server, I am getting below issues

[oraprod@ebsprodcl appsutil]$ ls
bin html install java LEBPROD_ebsprodleb.xml log media out perl scripts sql temp template
[oraprod@ebsprodcl appsutil]$ perl ./bin/ appspass=hqa523AceGr0uP contextfile=/u01/app/oracle/db/tech_st/12c/appsutil/LEBPROD_ebsprodleb.xml -removeserver
Can’t locate ADX/util/ in @INC (@INC contains: /u01/app/oracle/db/tech_st/12c/perl/lib/site_perl/5.14.1/x86_64-linux-thread-multi /u01/app/oracle/db/tech_st/12c/perl/lib/site_perl/5.14.1 /u01/app/oracle/db/tech_st/12c/perl/lib/5.14.1/x86_64-linux-thread-multi /u01/app/oracle/db/tech_st/12c/perl/lib/5.14.1 .) at ./bin/ line 82.
BEGIN failed–compilation aborted at ./bin/ line 82.

Solution :

Please check the perl path

& Environment also was set.



export PATH

. /u01/app/oracle/db/tech_st/12c/EBSPROD_ebsprodleb.env


The security token could not be authenticated or authorized

Client received SOAP Fault from server: The security token could not be authenticated or authorized Please see the server log to find more detail regarding the exact cause of the failure.Error while calling Oracle web service.


SOAP Wsdl granted user password might be changed. Please check


Concurrent program migration

If your developer asked you to migrate concurrent program from dev or UAT to production, As a system administrator you need to do follow steps


Example :

Concurrent Program :

Concurrent program name : XX Report for Statement

Shortcut : xx_rep_stat

Application : XX Custom Application


XML Publisher :

Data definition code : xx_rep_stat

Template (rtf) :  XX Report for Statement.rtf


rdf file on the custom top

Report File (rdf): xx_rep_stat.rdf

Step 1: 
On development

System Administrator — > Concurrent  –> Program –> define

Query — > “XX Report for Statement”

Download the ldt file on application tier :


How to find out application short name :

SELECT fa.application_id “Application ID”,
fat.application_name “Application Name”,
fa.application_short_name “Application Short Name”,
fa.basepath “Basepath”
FROM fnd_application fa,
fnd_application_tl fat
WHERE fa.application_id = fat.application_id
AND fat.language = USERENV(‘LANG’) and fat.application_name =’XX Custom Application’
— AND fat.application_name = ‘Payables’ — <change it>
ORDER BY fat.application_name;

The output — > “XXREP”

Once downloaded ldt file, you please copy to production application server which is concurrent program running server. If its linux, you please use SCP to transfer the file or winscp

Step 2:

On development,

Download the Template

XML Publisher Administrator — >

Query code –> ” xx_rep_stat”

Download the rtf and save it on your desktop

Step 3:

On Production,

Upload the ldt file on production server which you’re copied ldt file.

FNDLOAD apps/apps O Y UPLOAD $FND_TOP/patch/115/import/afcpprog.lct xx_rep_stat.ldt

Once uploaded, you please check on your application whether its uploaded or not


System Administrator — > Concurrent  –> Program –> define

Query — > “XX Report for Statement”


Step 4: 

Transfer the “xx_rep_stat.rdf” file from development custom top report to production custom top report location

Step 5: 

On production application,

Create data definition and template as same as development

–> create data definition

Once Done Data definition,

–> create Template

Here you please upload that Template file which you’re downloaded from development.

Example :

Create Data Definition :


Create Template


Step 6:

Please check with your developer any Objects you need to migrate to production which is related to this report.

If yes, please migrate those objects also from development to production


Step 7: 

Add your report file to related request group


Unable to See the Legal Entity List of Values in the Bank Account Owner Field

A user was tried to select the legal entity list of values in the bank account, It does not appear in LOV.


Solution :

you can review the below support document

R12: CE: Unable to See the Legal Entity List of Values in the Bank Account Owner Field (Doc ID 415529.1)

Note:  I selected “Payable Role” instead of Cash Management

DATA MASKING on EBS 12.1.3 with Enterprise Manager

Please follow the step by step document of Data masking on EBS 12.1.3


user not able to view responsibility in oracle apps

As a system administrator, you please submit the below request

Workflow Directory Services User/Role Validation


Optional run If it does not work after done above steps

Synchronize WF LOCAL tables

Find out completed concurrent request of SID

Script for find out completed concurrent request of particular SID

,a.phase_code,a.status_code,a.request_id, d.sid, d.serial# ,d.osuser,d.process , c.SPID
FROM apps.fnd_concurrent_requests a, apps.fnd_concurrent_processes b, v$process c, v$session d
WHERE a.controlling_manager = b.concurrent_process_id AND = b.oracle_process_id
AND b.session_id=d.audsid and d.sid= 242
order by a.REQUEST_DATE