Archive for the ‘Oracle EBS Application’ Category

RC-00110: Fatal: Error occurred while relinking of ApplyDBTechStack

June 27th, 2021, posted in Oracle EBS Application
Share

Error :

/u01/oradr/db_1/appsutil/clone/bin/../jre/bin/java -Xmx600M -DCONTEXT_VALIDATED=true  -Doracle.installer.oui_loc=/u01/oradr/db_1/oui -classpath /u01/oradr/db_1/appsutil/clone/jlib/xmlparserv2.jar:/u01/oradr/db_1/appsutil/clone/jlib/ojdbc5.jar:/u01/oradr/db_1/appsutil/clone/jlib/java:/u01/oradr/db_1/appsutil/clone/jlib/oui/OraInstaller.jar:/u01/oradr/db_1/appsutil/clone/jlib/oui/ewt3.jar:/u01/oradr/db_1/appsutil/clone/jlib/oui/share.jar:/u01/oradr/db_1/appsutil/clone/jlib/oui/srvm.jar:/u01/oradr/db_1/appsutil/clone/jlib/ojmisc.jar   oracle.apps.ad.clone.ApplyDBTier -e /u01/oradr/db_1/appsutil/TEST_azuredr.xml -stage /u01/oradr/db_1/appsutil/clone   -showProgress APPS Password : Log file located at /u01/oradr/db_1/appsutil/log/TEST_azuredr/ApplyDBTier_03271654.log \      0% completed       RC-00110: Fatal: Error occurred while relinking of ApplyDBTechStack ERROR while running Apply… Tue Mar 27 16:55:27 2018 ERROR: Failed to execute /u01/oradr/db_1/appsutil/clone/bin/adclone.pl

Cause :

log file reveled the information

"Perl lib version (5.10.1) doesn't match executable version (v5.10.0) at /usr/lib64/perl5/Config.pm line 50.
Compilation failed in require at /u01/oradr/db_1/appsutil/clone/ouicli.pl line 35.
BEGIN failed--compilation aborted at /u01/oradr/db_1/appsutil/clone/ouicli.pl line 35."

Solution :

set perl to verion 5.10.0 as below and rerun the clone

export PERL5LIB=/u01/oradr/db_1/perl/lib/5.10.0:/u01/oradr/db_1/perl/lib/site_perl/5.10.0:/u01/oradr/db_1/appsutil/perl

export PATH=/u01/oradr/db_1/perl/bin:$PATH
Share

ORA-39083: Object type PROCACT_SYSTEM failed to create with error

June 20th, 2021, posted in Oracle, Oracle EBS Application, Oracle Queries
Share

Error

Processing object type DATABASE_EXPORT/SYSTEM_PROCOBJACT/PRE_SYSTEM_ACTIONS/PROCACT_SYSTEM
>>> Cannot set an SCN larger than the current SCN. If a Streams Capture configuration was imported then the Apply that processes the captured messages needs to be dropp
ed and recreated. See My Oracle Support article number 1380295.1.
ORA-39083: Object type PROCACT_SYSTEM failed to create with error:

ORA-20000: Incompatible version of Workspace Manager Installed

Cause

Version of the Oracle Workspace Manager (OWM) in the source and target are not same.

Solution

Ignore the following errors, if IMPDP is importing all other components and data successfully:

To move the workspaces from the 11.2.0.3 or 11.2.0.4 SOURCE db, the FULL db export must be generated with the parameter “VERSION=12”.

If the SOURCE database is older than 11.2.0.3, e.g. 11.2.0.2 or 11.1.0.7, the database will first need to be upgraded to 11.2.0.3 or 11.2.0.4

Share

Workflow Notification Mailer Setup in Oracle Apps R12/12i

May 16th, 2021, posted in Oracle EBS Application
Share

On popular demand from readers, I am going to cover Workflow Notification Mailer in Oracle Applications R12/12i.
Workflow notification mailer setup in R12 is similar to 11i ( In both release 11i (OWF.H and higher in 11i) & R12 are Java Mailer)
* Previous version of Notification Mailer in 11i was based on C also called as C Mailer

Things To Note :
1. You use Oracle Application Manager (OAM) to configure Workflow Notification Mailer.
2. There are two kind of Notification (Outbound & Inbound) in Workflow Mailer
3. For Outbound Notification, CM (Concurrent Manager) node should be able to connect to SMTP (Simple Mail Transfer Protocol) server/relay.
4. For Inbound Notification (Optional), CM node should be able to connect to IMAP (Internet Message Access Protocol) Server.
5. Log file for Workflow Mailer Notification are at $APPLCSF/$APPLLOG/FNDC*.txt
6. Workflow Notification Mailer in background run as Concurrent Manager (Workflow Mailer ServiceWorkflow Agent Listener Service)
7. If you don’t wish to send mail notification to end user (from Dev/Test instance) then configure Test Address in configuration screen.


Step to configure Workflow Notification Mailer :

1. Login to Apps R12 with System Administrator Reponsibility
2. under Workflow : Oracle Applications Manager click on Workflow Manager

oracle apps,Oracle dba,Oracle application,oracle mail setup.oracle apps dba,

If this is first time you are configuring Workflow Notification Mailer in Oracle Apps R12/12i you will see Notification Mailers as unavailable as shown in screenshot

Click on Notification Mailers

 

oracle apps,Oracle dba,Oracle application,oracle mail setup.oracle apps dba,

 

In next screen (as shown below, click on Edit Button)

oracle apps,Oracle dba,Oracle application,oracle mail setup.oracle apps dba,

Here you have option to select Inbound notification setup or Just outgoing Notification Setup.

oracle apps,Oracle dba,Oracle application,oracle mail setup.oracle apps dba,

 

Provide SMTP Server Name (ensure that CM node should be able to connect to SMTP Server or SMTP Relay)

 

oracle apps,Oracle dba,Oracle application,oracle mail setup.oracle apps dba,

 

Uncheck Inbound Processing (from above screen), if you don’t wish to configure Inbound Notification Mailer.

If you wish to configure Inbound Notification as well then ensure IMAP Server should be configured with a valid user (create InboxProcessed Discard folder for this User)

Click on Apply button to finish configuration, at this stage Notification Mailer will test SMTP Server & IMAP Server connectivity.

For Advanced setup, click on Advanced at top right of configuration screen.

Metalink Notes for Notification Mailer
1. 453137.1 Oracle Workflow Best Practices Release 12 and Release 11i
2. 274764.1 Oracle Workflow Cartridge Workflow Java Mailer Setup Test
3. 433359.1 Tracking Workflow Notification Event Messages
4. 456921.1 Queries Related to Alert and Mailer Integration Post RUP4
5. 454706.1 How to Stop mails from Workflow Notification Mailer

Share

Hide Username And Password in URL for Oracle FORMS

February 1st, 2021, posted in Oracle EBS Application
Share

Username & password which is presented in addressbar like this :

For example the address is like this :

http://test.domain.com:7778/forms/frmservlet?form=login_testform.fmx&userid=username/[email protected]

This shows that security is very low !!!

However, if all your users use the same username/password, you could specify this information in the FORMSWEB.CFG file; for example:

Go to you servers form configuration :

C:\DevSuiteHome_1\forms\server

And go and do this :

# Forms runtime argument: database connection details
userlogin: userid=username/[email protected]%*

For now the address will be like this :

http://test.domain.com:7778/forms/frmservlet?form=login_testform.fmx&userlogin

You can also set the value in this file instead of setting it in URL.

Here is what URL look like

http://test.domain.com:7778/forms/frmservlet?config=ogidev_f

and here is some setting you can set in the config file

Code: [Select all] [Show/ hide]Hide Username & Password in URL for Oracle FORMS,Oracle FORMS,Hide Username and Password,form,formsweb.cfg
[ogidev_f]
envfile=OGIDEV_F.env
separateFrame=True
form=sag00m01.fmx
userid=user/[email protected]
otherparams=p_code_lang_ora=F
logo=no
width=800
height=600
Share

How To Update EBS XML Publisher Temporary Directory

January 5th, 2021, posted in Oracle EBS Application, Oracle Queries
Share
SQL> select value from apps.XDO_CONFIG_VALUES WHERE  property_code = 'SYSTEM_TEMP_DIR';
VALUE
--------------------------------------------------------------------------------
/u1/appl/SHAIK1/wrongdir_tmp



SQL> update apps.XDO_CONFIG_VALUES set value='/u01/share/temp' WHERE  property_code = 'SYSTEM_TEMP_DIR';
1 row updated.


SQL> commit;
Commit complete.



SQL> select value from apps.XDO_CONFIG_VALUES WHERE  property_code = 'SYSTEM_TEMP_DIR';
VALUE
--------------------------------------------------------------------------------
/u01/share/temp

Reference:-
How To Find the EBS XML Publisher Temporary Directory Via SQL? (Doc ID 1189723.1)

 

https://sites.google.com/site/shareapps4u/learning-topic/xml-publisher/how-to-use-xml-bursting-to-send-xml-report-via-email?tmpl=%2Fsystem%2Fapp%2Ftemplates%2Fprint%2F&showPrintDialog=1

Share