When you are starting the DB-Tier Configuration script during an E-Business Suite Clone, you see following failure : RC-00118: Error occurred during creation of database

Error:

When you are starting the DB-Tier Configuration script during an E-Business Suite Clone, you see following failure :
...

getConnectionUsingAppsJDBCConnector() -->
  APPS_JDBC_URL='null'
  Trying to get connection using SID based connect descriptor
getConnection() -->
  sDbHost    :
  sDbDomain  :
  sDbPort    :
  sDbSid     :
  sDbUser    : APPS
  Trying to connect using SID...
getConnectionUsingSID() -->
  JDBC URL: jdbc:oracle:thin:@:
  Exception occurred: java.sql.SQLException: Io exception: The Network Adapter could not establish the connection
  Trying to connect using SID as ServiceName
getConnectionUsingServiceName() -->
  JDBC URL: jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=))(CONNECT_DATA=(SERVICE_NAME=)))
  Exception occurred: java.sql.SQLException: Io exception: The Network Adapter could not establish the connection
  Trying to connect using SID as ServiceName.DomainName
getConnectionUsingServiceName() -->
  JDBC URL: jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=))(CONNECT_DATA=(SERVICE_NAME=.)))
  Exception occurred: java.sql.SQLException: Io exception: The Network Adapter could not establish the connection
  Connection could not be obtained; returning null

RC-00118: Error occurred during creation of database
Raised by oracle.apps.ad.clone.ApplyDatabase
...


Relevent env:

Oracle Applications Manager - Version 11.5.10.2 to 12.1.3 [Release 11.5.10 to 12.1]
Oracle Applications Technology Stack - Version 11.5.10.2 to 12.1.3 [Release 11.5.10 to 12.1]
Oracle Applications DBA - Version 11.5.10.2 to 12.1.3 [Release 11.5.10 to 12.1]
Information in this document applies to any platform.


Cause:

DNS is not set properly.

Solutions:

Check that DNS is working properly as given below.

nslookup .

You can use the /etc/hosts also if you are using it for resolving the names.



Follow this document for more details.

' adcfgclone dbTier' fails with error 'RC-00118' Error occurred during creation of database - 'Raised by oracle.apps.ad.clone.ApplyDatabase' (Doc ID 1299429.1)

How to generate the XML Debug Logs (Output Post Processor) for 'Payment Register'.

How to generate the XML Debug Logs (Output Post Processor) for 'Payment Register'.


1. Create the temp directory in $XDO_TOP
On the applications tier move to $XDO_TOP
 - create a temp directory - mkdir temp
 - set the permissions - chmod 777 temp
 - Use pwd and copy this directory location - it will be used in step 2


[applmgr@hostname ~]$ cd $XDO_TOP
[applmgr@hostname 12.0.0]$ mkdir temp


2. Create the Debug Config file
On the Applications Tier - change to $OA_JRE_TOP/bin - cd $OA_JRE_TOP/bin
- Execute this command - ./java -verbose | grep jre | grep 'java.lang.Runtime '
   -In the results - the complete path is present showing where the rt.jar resides
   - change to this directory - this is where the xdedebug.cfg should be created
- Use vi to create a new file called xdodebug.cfg

Enter these two lines:
LogLevel=STATEMENT
LogDir=complete_path_to_$XDO_TOP/temp directory you created


[applmgr@hostname 12.0.0]$ cd $OA_JRE_TOP/bin
[applmgr@hostname bin]$ ./java -verbose | grep jre | grep 'java.lang.Runtime '
[Loaded java.lang.Runtime from /app/apps/tech_st/10.1.3/appsutil/jdk/jre/lib/rt.jar]
[applmgr@hostname bin]$ cd /app/apps/tech_st/10.1.3/appsutil/jdk/jre/lib/
[applmgr@hostname lib]$ vi xdodebug.cfg
[applmgr@hostname lib]$ vi xdodebug.cfg
[applmgr@hostname lib]$ cat xdodebug.cfg
LogLevel=STATEMENT
LogDir=/app/apps/apps_st/appl/xdo/12.0.0/temp
[applmgr@hostname lib]$




3. Restart the Middle tier
cd $INST_TOP/admin/scripts
./adstopall.sh apps/apps
./adstrtall.sh apps/apps



4. Engage PO Output for Communication - using standard style sheet

Purchasing - Reports/Run
 - Pass in the parameters to print the purchase order
 - Leave the Debug parameter as the default
 - Submit the request

5. Retrieve the logs

Move to $XDO_TOP/temp
 - Here there are files crearted, please collect these and put into a zip file.

Process to generate EBS PL/SQL profiler for a concurrent program.

Process to generate EBS PL/SQL profiler for a concurrent program.

Setup the profile option
• Responsibility: System Administrator
• Navigate: Profiles > System
• Select check box for User (User level) and provide the user name
• Query Profile Option Concurrent: Allow Debugging
• Click Find button

Set profile to Yes on the User level. (Otherwise Debug Options is not active under Submit Request Screen)

Run Concurrent Program with pl/sql profiler option setup
• Logon to the Responsibility that runs the Concurrent Program
• Select the concurrent program on Name field and provide necessary Parameters in the Submit Request screen
• (In this doc., Assume We have active user as an example concurrent program.)
• In the Submit Request Screen, click on Debug Options button.
• Select the Checkbox for PL/SQL Profiler
• And then click OK button.


How to generate pl/sql profiler output for the concurrent program under EBS? (Doc ID 808005.1)

Cconcurrent Manager cleaning scripts

SELECT  concurrent_queue_name manager,
concurrent_process_id pid,
process_status_code pscode
FROM    fnd_concurrent_queues fcq, fnd_concurrent_processes fcp
WHERE   fcq.concurrent_queue_id = fcp.concurrent_queue_id
AND     fcq.application_id = fcp.queue_application_id
AND     process_status_code not in ('K', 'S')
AND     concurrent_queue_id=;


If it returen something


UPDATE fnd_concurrent_queues
SET control_code = NULL
WHERE control_code not in ('E', 'R', 'X')
AND control_code IS NOT NULL
AND     concurrent_queue_id=


select * from fnd_concurrent_processes where concurrent_queue_id=;

no rows selected

UPDATE fnd_concurrent_queues
SET running_processes = 0, max_processes = 0 where concurrent_queue_id=;

1 row updated.

SELECT concurrent_queue_name manager,
control_code ccode
FROM fnd_concurrent_queues
WHERE control_code not in ('E', 'R', 'X')
AND control_code IS NOT NULL AND concurrent_queue_id=;

no rows selected

SELECT concurrent_queue_name manager,control_code ccode FROM fnd_concurrent_queues where concurrent_queue_id= ;

MANAGER                        C
------------------------------ -
Invoice_Processing_Manager

1 row selected.

UPDATE fnd_concurrent_queues SET target_node = null where  concurrent_queue_id=;

1 row updated.

commit;

Commit complete.

Running concurrent requests in Oracle Apps EBS (11i,R12)

Set Pages 1000
Set head on
Column Manager   Format A12
Column Request   Format 999999999
Column Program   Format A30
Column User_Name Format A15
Column Started   Format A15
Column OSprocess Format A9
Column SPID      Format A9
Column LocalProcess Format A9
prompt Managers that are currently running a request;
prompt ;
Select /*+ RULE */ substr(Concurrent_Queue_Name,1,12) Manager,
       Request_Id Request, User_name,
       Fpro.OS_PROCESS_ID OSprocess,
      fcr.oracle_process_id LocalProcess,
       substr(Concurrent_Program_Name,1,35) Program, Status_code,
       To_Char(Actual_Start_Date, 'DD-MON-YY HH24:MI') Started
  from apps.Fnd_Concurrent_Queues Fcq, apps.Fnd_Concurrent_Requests Fcr,
      apps.Fnd_Concurrent_Programs Fcp, apps.Fnd_User Fu, apps.Fnd_Concurrent_Processes Fpro
 where
       Phase_Code = 'R' And
       Status_Code <> 'W' And
       Fcr.Controlling_Manager = Concurrent_Process_Id       And
      (Fcq.Concurrent_Queue_Id = Fpro.Concurrent_Queue_Id    And
       Fcq.Application_Id      = Fpro.Queue_Application_Id ) And
      (Fcr.Concurrent_Program_Id = Fcp.Concurrent_Program_Id And
       Fcr.Program_Application_Id = Fcp.Application_Id )     And
       Fcr.Requested_By = User_Id
       order by Started
/

Concurrent request details

set line 300
set pages 200
select r.request_id, s.inst_id,s.sid, s.serial#, s.status,
 substr(r.oracle_process_id, 1, 13) "REQUEST OS",
 r.status_code,r.phase_code, substr(fp.OS_PROCESS_ID, 1, 13) "CM OS ID"
from apps.fnd_concurrent_requests r,
 apps.fnd_concurrent_processes fp,
 gv$session s,
 gv$process p
where r.controlling_manager = fp.concurrent_process_id and
 r.oracle_process_id = p.spid and
 s.inst_id = p.inst_id and
 p.addr = s.paddr and
 r.request_id in (&reqid) order by r.request_id;

Concurrent Manager monitoring scripts

set line 200
set pages 100
col "Concurrent Manager's Name" format a60
spool comcurrent_manger_status.lst
SELECT b.USER_CONCURRENT_QUEUE_NAME AS "Concurrent Manager's Name",
       a.max_processes AS "TARGET Processes",
       a.running_processes AS "ACTUAL Processes",
       'Mismatch' Status
FROM apps.fnd_concurrent_queues a,apps.FND_CONCURRENT_QUEUES_VL b
 WHERE a.CONCURRENT_QUEUE_NAME = b.CONCURRENT_QUEUE_NAME
 and a.max_processes <> a.running_processes;

SELECT b.Pending_Standby,
       b.Pending_Normal,
       b.name AS "Concurrent Manager's Name",
       a.max_processes AS "TARGET Processes",
       a.running_processes AS "ACTUAL Processes",
       b.Running_Normal
  FROM apps.fnd_concurrent_queues a,
       (  SELECT c.USER_CONCURRENT_QUEUE_NAME Name,
                 c.CONCURRENT_QUEUE_NAME,
                 SUM (
                    DECODE (d.PHASE_CODE,
                            'P', DECODE (d.STATUS_CODE, 'Q', 1, 0),
                            0))
                    Pending_Standby,
                 SUM (
                    DECODE (d.PHASE_CODE,
                            'P', DECODE (d.STATUS_CODE, 'I', 1, 0),
                            0))
                    Pending_Normal,
                 SUM (
                    DECODE (d.PHASE_CODE,
                            'R', DECODE (d.STATUS_CODE, 'R', 1, 0),
                            0))
                    Running_Normal
            FROM apps.FND_CONCURRENT_QUEUES_VL c, apps.FND_CONCURRENT_WORKER_REQUESTS d
           WHERE     c.concurrent_queue_id = d.concurrent_queue_id
                 AND d.Requested_Start_Date <= SYSDATE
        GROUP BY c.USER_CONCURRENT_QUEUE_NAME, c.CONCURRENT_QUEUE_NAME) b
 WHERE a.CONCURRENT_QUEUE_NAME = b.CONCURRENT_QUEUE_NAME;

Sso_forced_auth In SSO After Inactivity In R12 EBS After Upgrade From 11i

Sso_forced_auth In SSO After Inactivity In R12 EBS After Upgrade From 11i

After 11i to R12 upgrade login pafte is facing the below error.
Error: sso_forced_auth

Product Version: 12.1.3 version, OID SSO Technologies
Solution:
It is recomended not to change default behaviour but if you want to change SSO Paranoid need to be disabled following steps will help.
Steps to disable SSO Paranoid mode:

Update the Context File as given below:
  1.1. Login to Oracle E-Business Suite as the sysadmin user .
  1.2. System Administration (responsibility) > Oracle Applications Manager >Autoconfig
  1.3. Edit Parameters for Applications Tier row
  1.4. Search bar select OA_VAR then enter 's_oacore_jvm_start_options' in the search field and click Go
  1.5. Add following text to the end of the current value:  ' -Doracle.apps.fnd.sso.forcedAuth=false'
  1.6. Save
Run autoconfig in all application tiers
Restart all application tier services.

For more info follow below doc.
Error: Sso_forced_auth In SSO After Inactivity In R12 EBS After Upgrade From 11i (Doc ID 1512429.1)

Error While using the Microsoft Internet Explorer 8 or IE 8 to access your Release 12.1.x E-Business-Suite Instances

Error While using the Microsoft Internet Explorer 8 or IE 8 to access your Release 12.1.x E-Business-Suite Instances

Giving the below error
....
Unable to authenticate session
 ...

When we going to use multiple instance in a browser. Mainly after logging out form production and logging into Developemnt or Test instance.

Soln.

To retain the use of multiple sessions to the same Oracle E-Business Suite environment with IE8 and higher please use one of the workarounds below to ensure each browser session remains independent;

 

1.Open a new explorer window using its own session cookie by selecting File -> New Session from the Menu Bar in an existing browser window. (IE9 Users may have to enable the Menu Bar first by right clicking the browser header frame and selecting Menu Bar.)
2.Run from the command line adding the -noframemerging parameter e.g. Start -> Run -> iexplore -noframemerging
3.Create a new IE8 icon adding the -noframemerging parameter e.g.
4.Start -> Program Files
5.Right click on the Internet Explorer icon and select Properties
6.Add -noframemerging to the end of the link in the Target field e.g."C:\Program Files\Internet Explorer\iexplore.exe" -noframemerging
7.Click the OK button to close the window
8.This icon may then be copied to the desktop if desired

How to check mwa.cfg file in R12 EBS

How to check mwa.cfg file in R12 EBS

 

[oratest@EBS-TEST-APP1 ~]$ cd $INST_TOP/admin/install/

[oratest@EBS-TEST-APP1 install]$ strings -a mwa.cfg | grep Log
################## Logging ######################################
# Log directory. Should be pointing to the standard
# System Log file name.
mwa.SystemLog=system.log
# LogLevel: Different log levels can be set for obtaining
mwa.LogLevel=error
mwa.EnableLogRotation=Yes
# when log file exceeds MaxLogFileSize
mwa.MaxLogFileSize=10000000
[oratest@EBS-TEST-APP1 install]$

Use the below query to find the sid and other details of specifice database module running(programs)

Use the below query to find the sid and other details of specifice database module running(programs)

select /*+ CHOOSE*/
s.sid,
s.serial#,
substr(s.username, 1, 6),
s.status,
substr(s.module, 1, 25),
substr(s.action, 1, 30),
s.last_call_et
from v$session s, v$process p
where p.addr = s.paddr and s.sid = nvl('&sid', s.sid) and
p.spid = nvl('&spid', p.spid) and
nvl(s.process, -1) = nvl('&ClientPid', nvl(s.process, -1)) and
s.module = '%&Module_name%';

Oracle EBS INVENTORY QUIZ.................. Part 1

INVENTORY QUIZ


1.Repeat any Japanese you may have learned and what does it mean?


2.When your cursor has highlighted a menu navigation choice, what two stroke key sequence will show a list of all 'executable forms'?


3.Why can't you perform a miscellaneous transaction (receipt or issue) against the item - GO GREEN BAY?


4.What are the Oracle Inventory attributes settings to correctly identify an item as a kanban item? Don't list the routine Inventory item attributes that are for normal items, i.e. stockable, transactable, etc.


5.Of the three - Discrete, Repetitive, or MRP/MPS - which never employs the usage of Kanbans?


6.What is the last time this kanban item saw transactional activity: TOMS CANNY KANBAN ITEM?

Oracle EBS INVENTORY QUIZ.................... Part 2

INVENTORY QUIZ


1.What Item has the two words GREEN BAY embedded in it?


2.What is the On Hand quantity for this item?


3.Which sub-inventory is holding this on hand quantity?


4.Can this item be built in WIP?


5.Is this item purchasable?


6.What are the digits of the second segment (account segment) of the material overhead account in the costing info tab of the organization parameters for the PET Modality?

Forms wont launch with R12 when using MS Internet Explorer v6.0.29

Symptoms
On 12.0.3 in Production: Only when using when using Internet Explorer 6.0.29, when launching any core forms function the forms launcher screen comes up but the form is not launched. Pressing F5 to refresh or relaunching the page will allow the form to launch

The problem is not apparent with IE 6.0.28

EXPECTED BEHAVIOR
Expect form to launch first time

STEPS
The issue can be reproduced at will with the following steps:
1. Login to eBusiness R12 using IE 6.0.2900.2180.xpsp_sp2_rtm.040803-2158
2. Launch forms function
3. Forms will not launch the first time, so have to press F5 or launch the form again

BUSINESS IMPACT
The issue has the following business impact:
Due to this issue, users have to press F5 to launch forms the first time

The same PC can launch forms for Release 11i with no problem




Changes
The PC has just been upgraded from earlier version of IE 6 (v6.0.28)
Cause
Internet Explorer issue with processing ActiveX

Version 6.0.2900.2180.xpsp_sp2_rtm.040803-2158 of IE had trouble in processing ActiveX and Javascript when a new window is opened


Solution
To implement the solution, please execute the following steps:

1. Download the latest version of Internet Explorer 6 or Internet Explorer 7

2. Re-test for the problem