Thursday, October 13, 2011

Unable to send emails from BPEL in SOA 10.1.3.4

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com
Problem: Unable to send emails from BPEL in SOA 10.1.3.4


Symptoms:
BPEL is not able to sent the notification mails

The configuration file ns_emails.xml must contains at least two entries of type :

1. The default one.
A default e-mail account is specified in the e-mail configuration file. This account is
used when there is no account specified to which to send an e-mail notification. This
account is also used for task-related notifications. A default e-mail account must
always be specified in the configuration file.

2. The user email account.
Which contains the parameters required for the final user email.





Log files:
ns_email.xml.
EmailAccount>
IT_MAIL

Oracle BPM
mail_address


smtpip
25


server
25
imap
mail_address
password
false
Inbox
100






Solution:



1. Using an email client application check the the Account Settings for the email account that is required to be the notification sender. For example:

Account Name : John.Smith
Email Address : John.Smith@company.com
Outgoing Server: EMAIL_SERVER.company.com
Outgoing Server port: 25
Outgoing Server protocol: SMTP
Incomming Server Name: EMAIL_SERVER@company.com
Incomming Port : 110
Server Type : IMAP
User Name: John.Smith

2. Edit the middle tier file $MIDTIER_HOME/bpel/system/services/config/ns_emails.xml and setup as indicated below:

a) Change the NotificationMode to EMAIL:



b) Define the parameters for the default account, for example:

default

BPEL Administrator
administrator@.company.com

EMAIL_SERVER.company.com
25

EMAIL_SERVER.company.com
110
IMAP
administrator
'email account password here'
false
Inbox
1



c) Define the parameters for the additional email account by appending the file ns_emails.xml with an additional structure. For example:


John.Smith

BPEL Process Notificator
john.smith@company.com

EMAIL_SERVER.company.com
25

EMAIL_SERVER.company.com
110
imap
John.Smith
'John's email password'
false
Inbox
1



NOTE: Do not forget to include the password for the email account.


d) Once finished the setup, the ns_emails.xml configuration file should have an structure like below:



default email setup here......

Other email user setup here....

3. Save the file with the changes.

4. Using Jdeveloper open your BPEL process and double click in your EMAIL activity. Fill the Email parameters according with your own data. In this example, the Email activity Dialog screen should be filled as follow:

a ) From Account: John.Smith

Notice that this entry must match the entry in the ns_emails.xml file for
the non default email account setup.

b) "To:" must be filled with the target email address.

c) Include at lest the eMail subject and body text.

5. Save the changes for the whole project.

6. Deploy again the BPEL process to contain the recent modifications.

7. Run the process from the BPEL console. This time you will receive your email. The Email sender will be identified by the string contained in the tag. In the example this name is "BPEL Process Notificator".
8. Have the email recipient create an email messaging channel under User Messaging Preferences to identify the email address.

http://:/sdpmessaging/userprefs-ui

For more details:

http://download.oracle.com/docs/cd/E15523_01/doc.1111/e13807/app_ns_applications.htm#CAXMGGIE

OR

Simply use the Email activity in the BPEL process to send directly to the recipient's email address.
9. If the above do not help, Apply MLR #10 and retest.


10. The correct configuration setting is





Default



Your Name

*Your Email: ***@***.com*




*mail.***.com*

25




*mail.***.com*

993

IMAP

***@***.com

***

true

Inbox

1










also

Add the following property to wf_config.xml (in SOA_HOME\bpel\system\services\config directory):



Then the BPEL server will send notification every 1 minute. More detail about this configuration to see http://download.oracle.com/docs/cd/B31017_01/integrate.1013/b28981/notif.htm#sthref1678 (14.2.1 Reliable Notification Service).

3. Re-start all SOA Suite services. (opmnctl startall)

After the BPEL process invoke any E-mail notification activity and if we can’t receive any E-mail notification, we need to check the BPELNOTIFICATION table (ORABPEL database schema). And delete any error data in this table, then correct the E-mail notification setting through above steps and re-start all SOA Suite services.




References:

Note ID 468644.1, Not Able To Send Email From The BPEL Process.
Note ID 1087642.1 Email Not Received Using Email Notification from BPEL
Get Oracle Certifications for all Exams
Free Online Exams.com
Posted by at 1:44 PM 6 comments

American English upgrade patch driver failed while perform upgrade Release 11i to 12.0.4 on

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com
Problem: American English upgrade patch driver failed while perform upgrade Release 11i to 12.0.4 on
ORA-24816: Expanded non LONG bind data supplied after actual LONG or LOB column


Symptoms:
On : 12.0.4 version, ISSUES WITH FUNCTIONALITY OF AD UTILITIES

When attempting to apply 12.0.4 upgrade driver (6394500) the following error occurs.

ERROR
-----------------------
A database error occurred:
ORA-24816: Expanded non LONG bind data supplied after actual LONG or LOB column
Log files:
u6394500.log

ATTENTION: All workers either have failed or are waiting:

FAILED: file payzzcncprg00514.ldt on worker 1.
FAILED: file bomprg.ldt on worker 2.
FAILED: file jg12acp.ldt on worker 3.
FAILED: file pqpzzcncprg00025.ldt on worker 4.

adwork001.log

Loading data using FNDLOAD function.
FNDLOAD APPS/***** 0 Y UPLOAD @FND:patch/115/import/afcpprog.lct @PAY:patch/115/import/US/payzzcncprg00514.ldt -

Connecting to APPS......Connected successfully.

Calling FNDLOAD function.

Returned from FNDLOAD function.

Log file: /u01/oracle/R12/apps/apps_st/appl/admin/VIS/log/US_payzzcncprg00514_ldt.log
Error calling FNDLOAD function.

US_payzzcncprg00514_ldt.log

A database error occurred:
ORA-24816: Expanded non LONG bind data supplied after actual LONG or LOB column

Solution:



NLS_LANG (application system env variable) differed from that of NLS_CHARACTERSET DB parameter.
Set NLS_LANG to match db characterset (UTF8)
Setting NLS_LANG correctly allows FNDLOAD to complete without error.
apply patch 6333519



Get Oracle Certifications for all Exams
Free Online Exams.com
Posted by at 1:44 PM 0 comments

Can both JRE and JInitiator used for e-Business suite and how?

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com



Problem: Can both JRE and JInitiator used for e-Business suite and how?

Solution:

You make 1 default (JRE or Jiniator) and use the other one via the config parameter in the Forms launch URL.


It is recommended that either JRE or a single version of JInitiator is used to access a single Oracle E-Business Suite instance.
Note: JRE1.6.0_10 and higher uses 'patch-in-place' mode when installling higher releases by default. This means that the new install will patch into the same directory that the old version used, overwriting it. To maintain multiple versions with these releases requires install using 'static' mode'. For further information please see the Java Runtime Environment Windows Installation for JavaSE 6u10 link in the plug-ins release notes.

There may be occasions where it is desirable to test and compare changes in functionality or security across different plug-in versions in a test system. Users may access the same Oracle E-Business Suite instance using different JRE client plug-in versions from separate desktop clients with certain exceptions as outlined below.
Discoverer 4i Users

Discoverer 4i users cannot use multiple JRE plug-in versions to access the same E-Business Suite instance. Only the default plug-in version set for that particular Oracle E-Business Suite instance can be used.
Workflow Users

Workflow users running Oracle E-Business Suite 11i with 11i.ATG_PF.H.RUP3 (patch 4334965) and earlier cannot use multiple JRE plug-in versions to access the workflow applet in the same Oracle E-Business Suite environment. In earlier releases the JRE plug-in version is called from the WF_RESOURCES table which only holds the values for the default JRE plug-in version for that particular environment.
Note: This will only affect Workflow users when accessing any area of the product that connects through the applet i.e. if viewing a 'Status Diagram' through 'Status Monitor'. This will not affect users simply initiating a workflow through an HTML product as this would not use the JRE plug-in.

Workflow users running Oracle E-Business Suite 11i with 11i.ATG_PF.H.RUP4 (patch 4676589) or higher may access the same Oracle E-Business Suite instance using different JRE client plug-in versions from separate desktop clients. After this release the WF_RESOURCES table is no longer used, instead the java plug-in version is called from the appsweb.cfg file on the application server.

JRE and JInitiator plug-in versions can coexist and also be run simultaneously on the same desktop client, if All of the following conditions are true:

* Internet Explorer is being used
* Each JRE/JInitiator instance is started in a separate Internet Explorer session

Note: The mixing of different plug-in streams in this way should not be used on production systems as JRE fixes may not always be backward compatible with the old JInitiator technology. Java 1.3 which JInitiator 1.3.x is built upon is also no longer supported by Sun.
Firefox Browser




If using a Firefox browser, it is not possible to run multiple JRE/JInitiator versions simultaneously from the same desktop client. These browsers use a single cookie session which restricts usage to a single Java version per desktop client at a time. To access environments using different JRE/JInitiator versions from the same desktop client, the previous browser session must be completely closed down and a new one started before running another JRE/JInitiator version. You may still access the same Oracle E-Business Suite environment simultaneously using different JRE/JInitiator versions, but only by using separate desktop clients.(Each desktop client would use a specific JRE/JInitiator version).
Adding Additional Java Plug-in Versions

The txkSetPlugin script outlined in Apply the Interoperability Patch section above, is only run for the version of JRE/JInitiator that you wish to have as your default Plug-in.To add additional JRE/JInitiator versions, follow the steps below.
Adding a JRE Version

Using JRE 1.5.0_13 as an example.

1. Copy the j2se15013.exe file to your $OA_HTML directory to allow user download of the plug-in at runtime. (The sun_plugin_url parameter below denotes the plug-in file name and download directory).

2. Take a backup copy of your original $FND_TOP/admin/template/appsweb.cfg file.

3. Add the following information under [myExtensions] at the bottom of your $FND_TOP/admin/template/appsweb.cfg file.

(substitute the environment values as appropriate to your own environment. The connectMode and serverPort settings can be copied from your 'appsweb' file as required.)

[J15013]
connectMode=socket
serverPort=9001
sun_plugin_classid=clsid:CAFEEFAC-0015-0000-0013-ABCDEFFEDCBA
sun_plugin_version=1.5.0_13
sun_plugin_url=http://ap123.us.oracle.com:8001/OA_HTML/j2se15013.exe
sun_plugin_mimetype=application/x-java-applet;jpi-version=1.5.0_13
sun_plugin_legacy_lifecycle=false
plugin=jdk
;

4. Enter the forms URL against the ICX: Forms Launcher profile at user level for the appropriate E-Business Suite user. (If required, you may set up a new user through the System Administrator Responsibility for this). In this example, logging in as this user will cause JRE 1.5.0_13 to be used as the plug-in instead of the default version.

The name you used in the update above under step 3, ie [J15013] must be referenced as the 'config' parameter like the example below:
http://ap123.us.oracle.com:8001/dev60cgi/f60cgi?config=J15013

5. Run autoconfig to filter the changes through to the runtime version of appsweb.cfg.
Adding a Jinit Version




Using jinit 1.3.1.30 as an example.

1. Copy the jinit13130.exe file to your $OA_HTML directory to allow user download of the plug-in at runtime. (The jinit_name parameter below denotes the plug-in file name and download directory).

2. Take a backup copy of your original $FND_TOP/admin/template/appsweb.cfg file.

3. Add the following information under [myExtensions] at the bottom of your $FND_TOP/admin/template/appsweb.cfg file.

(substitute the environment values as appropriate to your own environment. The connectMode and serverPort settings can be copied from your 'appsweb' file as required.)

Example 1 using socket mode:-

[J13130]
connectMode=socket
serverPort=9001
jinit_name=jinit13130.exe
jinit_classid=clsid:CAFECAFE-0013-0001-0030-ABCDEFABCDEF
jinit_ver_name=Version=1,3,1,30
jinit_mimetype=application/x-jinit-applet;version=1.3.1.30
plugin=jinit
;

Example 2 using Formservlet mode:-




[J13130]
serverURL=/forms/formservlet
jinit_name=jinit13130.exe
jinit_classid=clsid:CAFECAFE-0013-0001-0030-ABCDEFABCDEF
jinit_ver_name=Version=1,3,1,30
jinit_mimetype=application/x-jinit-applet;version=1.3.1.30
plugin=jinit
;

4. Enter the forms URL against the ICX: Forms Launcher profile at user level for the appropriate E-Business Suite user. (If required, you may set up a new user through the System Administrator Responsibility for this). In this example, logging in as this user will cause JInitiator 1.3.1.30 to be used as the plug-in instead of the default version.

The name you used in the update above ie [J13130] must be referenced as the 'config' parameter as below:
http://ap123.us.oracle.com:8001/dev60cgi/f60cgi?config=J13130

5. Run autoconfig to filter the changes through to the runtime version of appsweb.cfg.
References:
Deploying Sun JRE (Native Plug-in) for Windows Clients in Oracle E-Business Suite 11i [ID 290807.1]
Get Oracle Certifications for all Exams
Free Online Exams.com
Posted by at 1:43 PM 0 comments

IS LVM (Logical Volume Manager) supported on windows 2008 and Linux 5.0 on 11gR2

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com
Problem: IS LVM (Logical Volume Manager) supported on windows 2008 and Linux 5.0 on 11gR2


Solution:
Supported storage options for RAC on Linux are:

Oracle Automatic Storage Management (Oracle ASM)
Network File System (NFS)

When using ASM, Although you can specify a logical volume as a device in an Oracle Automatic Storage Management disk group, Oracle does not recommend their use. Logical volume managers can hide the physical disk architecture, preventing Oracle Automatic Storage Management from optimizing I/O across the physical devices. They are not supported with Oracle RAC.
Please Refer:
Chapter 3 - Configuring Storage for Grid Infrastructure for a Cluster and Oracle Real Application Clusters (Oracle RAC)
Oracle® Grid Infrastructure Installation Guide 11g Release 2 (11.2) for Linux
http://download.oracle.com/docs/cd/E11882_01/install.112/e10812/storage.htm#CDECEBGH




Chapter 3 - Configuring Storage for Grid Infrastructure for a Cluster and Oracle RAC
Oracle® Grid Infrastructure Installation Guide 11g Release 2 (11.2) for Microsoft Windows
http://download.oracle.com/docs/cd/E11882_01/install.112/e10817/storage.htm#CDECEBGH

For Windows, the storage options available are:

Oracle ASM
OCFS for Windows

When using ASM, Although you can specify a logical volume as a device in an Oracle Automatic Storage Management disk group, Oracle does not recommend their use. Logical volume managers can hide the physical disk architecture, preventing Oracle Automatic Storage Management from optimizing I/O across the physical devices. They are not supported with Oracle RAC.

Please Refer:
Chapter 3 - Configuring Storage for Grid Infrastructure for a Cluster and Oracle RAC
Oracle® Grid Infrastructure Installation Guide 11g Release 2 (11.2) for Microsoft Windows
http://download.oracle.com/docs/cd/E11882_01/install.112/e10817/storage.htm#CDECEBGH

For Windows and Linux, In order for OCFS2 to work it requires a standard block device to be made available. Hence LVM is not supported.

Enterprise Linux Support team does not provide support for Logical Volume Manager (LVM) for clustered environments and support is provided for single node situations only.
Reference:
Note 423207.1 == > Enterprise Linux Support for GFS, LVM and LVM2

It is recommended to use ASM.



References:
http://download.oracle.com/docs/cd/E11882_01/install.112/e10817/storage.htm#CDECEBGH
Note 423207.1 == > Enterprise Linux Support for GFS, LVM and LVM2
http://download.oracle.com/docs/cd/E11882_01/install.112/e10817/storage.htm#CDECEBGH
http://download.oracle.com/docs/cd/E11882_01/install.112/e10812/storage.htm#CDECEBGH
Get Oracle Certifications for all Exams
Free Online Exams.com
Posted by at 1:42 PM 0 comments

ORA-07445: exception encountered: core dump [€] [SIGSEGV] [unknown code] [0x3A000000020] [] []

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com
Problem: ORA-07445: exception encountered: core dump [€] [SIGSEGV] [unknown code] [0x3A000000020] [] []




Log files:
Alert.log
-----------
ORA-07445: exception encountered: core dump [€] [SIGSEGV] [unknown code] [0x3A000000020] [] []
Thu Aug 12 09:28:56 2010
PMON failed to acquire latch, see PMON dump
Thu Aug 12 09:29:01 2010
Errors in file /u03/app/oracle/admin/qntmp/udump/qntmp_ora_16329.trc:
ORA-07445: exception encountered: core dump [€] [SIGSEGV] [unknown code] [0x3A000000020] [] []

Trace file
------------
ksedmp: internal or fatal error
ORA-07445: exception encountered: core dump [] [SIGSEGV] [unknown code] [0x000001004] [] []
ORA-07445: exception encountered: core dump [] [SIGSEGV] [unknown code] [0x3A000000020] [] []
----- Call Stack Trace -----

ksedst <- ksedmp <- ssexhd <- sigreturn <- kgscDump <- kxsDumpCursors <- curdmp <- ksedmp <- ssexhd <- sigreturn <- kghimkdmp <- kghidmp_new <- kghidmp <- kgherror <- kghfru_internal <- 028 <- kghfru <- kghfex <- kghfrx <- kghfrunp <- kghfnd <- kghalo <- ksp_param_handle_al <- loc <- kspcrec <- loc <- ksucre <- ksucresg <- kpolna <- kpogsk <- opiodr <- ttcpip <- opitsk <- opiino <- opiodr <- opidrv <- sou2o <- opimai_real <- main <- $START$ Solution:


This bug is fixed on 10.2.0.4 patchset or you can apply only patch 5476873

10.2.0.4 patchset
---------------------------
To implement the solution, please execute the following steps:
1) Please download and review the readme for Patch.6810189.
2) Please apply Patch.6810189 in a test environment.
3) Please retest the issue.
4) If the issue is resolved, please migrate the solution as appropriate to other environments.

patch 5476873
----------------------
To implement the solution, please execute the following steps:
1) Please download and review the readme for Patch.5476873.
2) Please apply Patch.5476873 in a test environment.
3) Please retest the issue.
4) If the issue is resolved, please migrate the solution as appropriate to other environments.



References:

BUG 5476873 INSTANCE CRASH DUE TO PMON HITTING ORA-601 AND ORA-600[KSUDLP1]
Get Oracle Certifications for all Exams
Free Online Exams.com
Posted by at 1:41 PM 0 comments

How can Siebel SADMIN password be changed on Unix?.

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com



Problem: How can Siebel SADMIN password be changed on Unix?.

Solution:





Following is the sequence of steps taken to change the SADMIN password only.
Note: It is not necessary to change the Unix password in \etc\passwd file unless the user wants to keep the login password synchronized with the Siebel server. Step: 1: End all client sessions
Step: 2: Shut down the Siebel Server
Ensure the environment is correctly set.
If not, in the Siebel_root directory type in the following commands:
ksh
. ./siebenv.sh
env | grep ROOT
Output should be the Siebel root.
To shut down the servers, use command:
//bin/stop_server all Step: 3: Change Password in Siebel Gateway server
Use the following ‘srvrmgr’ command to change the password at the Siebel Enterprise Level:
First Login at the Enterprise Level:
srvrmgr -g -e -u -p
At the srvrmgr prompt type:
Srvrmgr> change Enterprise param Password= Step: 4: Change Password in database
Change the database password for ‘SADMIN’ using the standard commands for the particular database. For the exact syntax, refer to the database administrator or database documentation. Step: 5: Shut down gateway server
Use command:
\\stop_ns Step: 6: Restart the Gateway Server
Use command:
\\start_ns Step: 7: Start Siebel servers
Use command:
\\start_server all Step: 8: Verify
Verify the password change by connecting to Server Manager using the following command:
srvrmgr -g -e -s -u SADMIN -p ‘New password’
User should be able to log as SADMIN with the new password.
The steps above assume that the application is configured using database authentication and the password parameter was not changed at Component level


References:

How can Siebel SADMIN password be changed on Unix? (Doc ID 476303.1).
Get Oracle Certifications for all Exams
Free Online Exams.com
Posted by at 1:40 PM 0 comments

How To configure the Siebel Management Server and Siebel Management Agent logging behavior

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com



Problem: How To configure the Siebel Management Server and Siebel Management Agent logging behavior


Solution:




1. Navigate to the .properties file:
On the Siebel Management Server, navigate to the CMSLogging.properties file in the following location: \MgmtSrvrInstallDir\config\CMSLogging.properties.
On the Siebel Management Agent environment, navigate to the AgentLogging.properties file in the following location: Siebel_Management_Agent_Root\agent\config\AgentLogging.properties
2. To configure the log level, set the com.siebel.adm.mgmtsrvr.deploy.deploymgr.level property in the .properties file to the appropriate level. See the following table for the values.
An inheritance behavior is based on the log level setting; that is, if you select INFO level, the WARNING and SEVERE level log details are also recorded.
3 To configure the log file cycling, set the java.util.logging.FileHandler.count property in the CMSLogging.properties file to an integer value greater than 0.




Get Oracle Certifications for all Exams
Free Online Exams.com
Posted by at 1:40 PM 0 comments

in 11.5.10.2, when the public api CS_ServiceRequest_PUB.Create_ServiceRequest is called with the datastructure service_request_rec_type, a service request is created, but the account number is not entered.

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com
Problem:

in 11.5.10.2, when the public api CS_ServiceRequest_PUB.Create_ServiceRequest is called with the datastructure service_request_rec_type, a service request is created, but the account number is not entered.

EXPECTED BEHAVIOR
---------------------------------
When a Service Request is created via the UI, the user is able to enter the customer information, including the account number. When the Service Request is created via the API, the same field should be populated when passed. This includes the account number
Service Request created via the XXCRM_SR_CREATE_RCPT_REV_PKG.pkb package (which calls the CS_ServiceRequest_PUB.Create_ServiceRequest) is not populating the account number field.




Symptoms:

1) create a script to call the public API CS_ServiceRequest_PUB.Create_ServiceRequest
2) pass party, account and service request information to the script
3) execute the script
4) check the Service Request UI - Service request is created for the correct party, but the account number is not populated


Log files:

DATA USED TO CALL API
=====================
"ORG_ID" "ORGANIZATION_ID" "ROW_ID" "CASH_RECEIPT_ID" "SET_OF_BOOKS_ID" "CURRENCY_CODE" "RECEIPT_NUMBER" "RECEIPT_DATE" "REVERSAL_DATE" "DEPOSIT_DATE" "MATURITY_DATE" "REVERSAL_CATEGORY" "REVERSAL_REASON_CODE" "REVERSAL_COMMENTS" "LOCATION_ID" "AMOUNT" "REMITTANCE_BANK_ACCOUNT_ID" "PAY_FROM_CUSTOMER" "ACCOUNT_NAME" "ACCOUNT_NUMBER" "PARTY_ID" "PARTY_TYPE" "PARTY_NAME" "PHONE_NUMBER" "INVENTORY_ITEM_ID" "PROPERTY_CODE" "PROPERTY_DESCRIPTION" "CATEGORY_SET_NAME" "CATEGORY_SET_DESCRIPTION" "CATEGORY_CODE" "CATEGORY_ID" "CATEGORY_SET_ID" "BANK_NAME" "BANK_BRANCH_NAME" "BANK_ACCOUNT_NUM" "TERRITOTY_ID"
208.00 208.00 AAAJjIACJAABussAAF 500,705.00 1,001.00 AED 8989 07/12/2010 00:00:00 07/12/2010 00:00:00 07/12/2010 00:00:00 REV SIGNATURE 106546 1,000.00 130,301.00 2,164,424.00 AHMED ABDALLA ALFEEL 94227 3,903,718.00 PERSON AHMED ABDALLA ALFEEL 971506160919 160,466.00 ICL1-CHI-A01-207 ICCH-0A001X002007-A Inventory Inventory Category Set IC Leasing 667.00 1.00 HSBC Bank Middle East Dubai Main Branch 021-089347-002 748
208.00 208.00 AAAJjIACJAABvR8AAK 500,725.00 1,001.00 AED 1 07/20/2010 00:00:00 07/20/2010 00:00:00 07/20/2010 00:00:00 REV SIGNATURE 113283 1,000.00 130,301.00 2,022,513.00 Alaa Tarabay 81950 3,744,116.00 PERSON ALAA YEHYA TARABAY 97143050340 177,929.00 ICL1 -FRA-R18-WR ICL1 -FRA-R18-WR Inventory Inventory Category Set IC Leasing 667.00 1.00 HSBC Bank Middle East Dubai Main Branch 021-089347-002 748
208.00 208.00 AAAJjIACPAAA3UrAAH 500,685.00 1,001.00 AED 1221 07/11/2010 00:00:00 07/11/2010 00:00:00 07/11/2010 00:00:00 REV SIGNATURE 106546 1,000.00 130,301.00 30,031.00 AHMED ABDELAZIZ MEKAWY SALAMA 88371 47,447.00 PERSON AHMED ABDELAZIZ MEKAWY SALAMA 971503622816 160,466.00 ICL1-CHI-A01-207 ICCH-0A001X002007-A Inventory Inventory Category Set IC Leasing 667.00 1.00 HSBC Bank Middle East Dubai Main Branch 021-089347-002 748



Solution:




The cause of this issue is that the account_number field, retrieved from the HZ_CUST_ACCOUNTS table is being used to populate the customer_number field in the CS_ServiceRequest_PUB.service_request_rec_type datastructure. Instead, the cust_account_id should be retrieved from the HZ_CUST_ACCOUNTS table and used to populate the account_id field on the CS_ServiceRequest_PUB.service_request_rec_type datastructure.

To address this issue, you will need to update the code in the package XXCRM_SR_CREATE_RCPT_REV_PJG.pkb

1) in the cursor lcu_main, retrieve the hca.cust_account_id from the HZ_CUST_ACCOUNTS table, along with the account_number and account_name
2) in the main loop, replace the line

lrec_service_request_rec_type.customer_number := rec.account_number;

with the line

lrec_service_request_rec_type.account_id := rec.cust_account_id;

3) retest the issue
4) Migrate the solution as appropriate to other environments.



Get Oracle Certifications for all Exams
Free Online Exams.com
Posted by at 1:40 PM 0 comments

Is it certified to use UTL_ENCODE.BASE64_ENCODE to convert the RAW hash password and is there any known issue?

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com



Problem: Is it certified to use UTL_ENCODE.BASE64_ENCODE to convert the RAW hash password and is there any known issue?
application passwords are stored as SHA-1 hashed text in the database and using a custom DB plugin, synch this into OID.
Using DBMS_CRYPTO.HASH(UTL_I18N.STRING_TO_RAW(, 'AL32UTF8'), DBMS_CRYPTO.HASH_SH1) ; to hash passwords.

How to create new users and passwords directly in OID using SHA-1 when OID uses BASE64
And how to convert the earlier SHA-1 hashed passwords into this BASE64 format.


Solution:


Certified is a large term, there is no any Certification process for this kind of topic.

I made this test:

begin
dbms_output.put_line(DBMS_CRYPTO.HASH(UTL_I18N.STRING_TO_RAW('fiction5', 'AL32UTF8'), typ=>DBMS_CRYPTO.HASH_SH1));
dbms_output.put_line(UTL_ENCODE.BASE64_ENCODE(DBMS_CRYPTO.HASH(UTL_I18N.STRING_TO_RAW('fiction5', 'AL32UTF8'), typ=>DBMS_CRYPTO.HASH_SH1)));
dbms_output.put_line(UTL_ENCODE.BASE64_DECODE('6F5037425A54786B676335775677353430732B364F306753492F453D'));
end;
/

A0FEC1653C6481CE70570E78D2CFBA3B481223F1
6F5037425A54786B676335775677353430732B364F306753492F453D
A0FEC1653C6481CE70570E78D2CFBA3B481223F1

For the UTL_ENCODE the input string is a RAW
SQL> desc utl_encode
FUNCTION BASE64_DECODE RETURNS RAW
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
R RAW IN
FUNCTION BASE64_ENCODE RETURNS RAW
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
R RAW IN

as DBMS_CRYPTO.HASH is returning a RAW, I don't see any issue to use it.

The problem comes from the fact that Oracle SHA1 implementation is oracle's own based on SHA1 algorithm.
The hashing key may not be same across vendors/product if it has to be a secure one.

As now you need to create the user and passwords directly in OID, You can use Enterprise User Feature and Map the Oracle Users identified globally with the OID users.





Get Oracle Certifications for all Exams
Free Online Exams.com
Posted by at 1:39 PM 0 comments

Not able to upload to em grid oms repository from agents

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com

Problem: Not able to upload to em grid oms repository from agents





./emctl upload agent Oracle Enterprise Manager 10g Release 5 Grid Control 10.2.0.5.0. Copyright (c) 1996, 2009 Oracle Corporation. All rights reserved. --------------------------------------------------------------- EMD upload error: Failed to upload file B0000214.xml: HTTP error. Response received: ERROR-400|ORA-06502: PL/SQL: numeric or value error: hex to raw conversion error ORA-06512: at "SYSMAN.EM_POLICY", line 2176 ORA-06512: at "SYSMAN.EM_VIOLATION_CHECKS", line 791 ORA-04088: error during execution of trigger 'SYSMAN.EM_VIOLATION_CHECKS'


Log files:
emoms.trc
010-07-22 13:19:52,415 Thread-464 ERROR upload: Failed to upload file B0000214.xml: HTTP error.
Response received: ERROR-400|ORA-06502: PL/SQL: numeric or value error: hex to raw conversion error
ORA-06512: at "SYSMAN.EM_POLICY", line 2176
ORA-06512: at "SYSMAN.EM_VIOLATION_CHECKS", line 791
ORA-04088: error during execution of trigger 'SYSMAN.EM_VIOLATION_CHECKS'

Solution:



Hanging policy upload int he repository
Remove the hanging policy manually

1. Check if you have Patch 8538082 installed for your Grid Control.
This patch is also part of the PSU patchsets.
Please see:
Note.1139563.1 Ext/Pub 10.2.0.5.4 Grid Control Patch Set Update (PSU) for the newest patchset.

2. 1. Stop the OMS: emctl stop oms

2. Update the <>/sysman/config/emoms.properties for the OMS(s) and add the following line:
em.loader.enableMetadataCache=FALSE

3. Login as user sysman with sqlplus and run:
SELECT DISTINCT target_type, START_TYPE_META_VER
FROM mgmt_policies
WHERE POLICY_GUID = HEXTORAW('C733EA1CFA96377F492528E305462C9D');

with the data from the last query run:
DELETE FROM mgmt_metadata_sets
WHERE where table_name='MGMT_POLICIES'
AND target_type=
AND type_meta_ver=

4. Start the OMS: emctl start oms

5. execute the following fro the agent:
stop the agent
rm the file /sysman/emd/lastupld.xml
start the agent
emctl upload




References:

Note.1139563.1 Ext/Pub 10.2.0.5.4 Grid Control Patch Set Update



Get Oracle Certifications for all Exams
Free Online Exams.com
Posted by at 1:39 PM 0 comments

APP-AR-11526: Please define all periods in which revenue is to be recognized or credited. Note that revenue cannot be recognized or credited in closed and close pending periods.

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com
Problem: APP-AR-11526: Please define all periods in which revenue is to be recognized or credited. Note that revenue cannot be recognized or credited in closed and close pending periods.

On : 11.5.10.2 version, Transactions Related

When attempting to save an Credit Memo for an Invoice, the following error occurs.

ERROR
-----------------------
APP-AR-11526: Please define all periods in which revenue is to be recognized or credited. Note that revenue cannot be recognized or credited in closed and close pending periods.


Symptoms:
The issue can be reproduced at will with the following steps:
(R) Receivables
> Transactions / Transactions screen
> Try to save an Credit Memo


Solution:



1. Get the scripts to implement the solution from
Note 455691.1 : AutoInvoice & Transaction Workbench Error: Please Define All Periods In Which Revenue Is To Be Recognized Or Crediteds
2. From Note 455691.1:
-------------------

11.5
First Fix in
Bug 4278110 Autoinvoice rejects credit memos against specific transactions with a message indicating that 'All periods are not open..'
This same rejection is raised in both forms and autoinvoice.

Second fix in Unpublished bug: Bug 8627857 AutoInvoice Import erroring out for an RMA Order

Third fix in Bug 4357664 Error processing credit memo with Prorate rule method

Recommended Patches:
11i.AR.N: Patch 9449431
11i.AR.O: Patch 8402113

Fixed Files:
11i.AR.N:
ARTECMMB.pls 115.67.15103.3
arpltgld.sql 115.13.15103.1

11i.AR.O:
ARTECMMB.pls 115.67.15104.17


References:
Note 455691.1 : AutoInvoice & Transaction Workbench Error: Please Define All Periods In Which Revenue Is To Be Recognized Or Crediteds
Get Oracle Certifications for all Exams
Free Online Exams.com
Posted by at 1:38 PM 4 comments

How do you insert an image dynamically in Bi Publisher 5.6.3 as since the application of ATG RUP7 which upgraded BI Publisher to 5.6.3, this cannot be done?

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com
Problem:
How do you insert an image dynamically in Bi Publisher 5.6.3 as since the application of ATG RUP7 which upgraded BI Publisher to 5.6.3, this cannot be done?
Not able to insert image dynamically in XML Publisher after 5.6.3 upgrade


Symptoms:

Not able to insert image dynamically in XML Publisher after RUP7 is applied. XML version got upgraded to 5.6.3 after RUP7.

Earlier when XML publisher was on 5.6.0 the below syntax was working
url:{IMAGE_LOCATION}
url:{concat(SERVER,'/',IMAGE_DIR,'/',IMAGE_FILE)}
url:{concat('${OA_MEDIA}','/',IMAGE_FILE)}

Solution:



Images can still be inserted dynamically in BI Publisher 5.6.3, the available options are in the documentation. Please see the Oracle® XML Publisher Report Designer's Guide Release 12 Part No. B31410-01 Page 2-18, the following is a link to that documentation:

http://download-west.oracle.com/docs/cd/B40089_02/current/acrobat/120xdorg.pdf

Use one of the documented methods as shown in the referenced documentation.

References:
http://download-west.oracle.com/docs/cd/B40089_02/current/acrobat/120xdorg.pdf



Get Oracle Certifications for all Exams
Free Online Exams.com
Posted by at 1:38 PM 1 comments

After upgrading from 10.1.3.1 to 10.1.3.4 OAS ,

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com

Problem:    
After upgrading from 10.1.3.1 to 10.1.3.4 OAS , 
an application (working fine in 10.1.3.1 ) is deployed into 10.1.3.4 oc4j .

The application is working well . 
But when invoking the DLLFileMonitor.jsp page ;

Then the following error occurs : 

JspServlet: unable to dispatch to requested page: Exception:oracle.jsp.parse.JspParseException: /jsp/dischargeloadlist/DLLFileMonitor.jsp: Line # 21, var url = '<html:rewrite action="/getFileErr"/>' Error: Attribute: action is not a valid attribute name




Symptoms:
As you can see the openFileErrs 
in the DLLFileMonitor.jsp file is called in : 
at line 214 : 

<c:choose>
<c:when test="${file.processStatus == 'R'}">
<display:column titleKey="dischargeloadlist.amend.fileErr" sortable="false" headerClass="tableHeader" 
class="tableRowDisplay" style="text-align:center">
<a href="javascript:openFileErrs('<bean:write name="file" property="fileRef"/>','<bean:write name="file" property="portCode"/>')"> ${file.fileErrCode}</a>
</display:column>
</c:when>
<c:otherwise>
<display:column property="fileErrCode" titleKey="dischargeloadlist.amend.fileErr" sortable="false" headerClass="tableHeader" 
class="tableRowDisplay" style="text-align:center"/>
</c:otherwise>
</c:choose>


Looking for this patern in the knowledge base , i have found : 
Bug 9349903 OJSPC FAILS TO TRANSLATE JSP CUSTOM TAGS

where there is a rediscovery information 

Rediscovery Information:
Problem 1
- Set req_time_introspection to init-param for JSP Servlet.
- Use name-from-attribute in a result.
- Use tag like this:
<c:choose>
<c:when test="${choosetest}">
<mo:FragmentTest resultName="result"/>
</c:when>
<c:otherwise>
<mo:FragmentTest2 resultName="result"/>
</c:otherwise>
</c:choose>
- 'result' may not be declared correctly and it fails to compile
generated java code.

Solution:



Bug 9349903 OJSPC FAILS TO TRANSLATE JSP CUSTOM TAGS

which occurs on 10.1.3.4 oc4j. 

One of the symptom of the bug is :
- Use tag like this:
<c:choose>
<c:when test="${choosetest}">
<mo:FragmentTest resultName="result"/>
</c:when>
<c:otherwise>
<mo:FragmentTest2 resultName="result"/>
</c:otherwise>
</c:choose>
- 'result' may not be declared correctly and it fails to compile
generated java code.
.

Which looks similar to the code in DLLFileMonitor.jsp .
1.       Apply the patch 9349903 
2. Undeploy the application ports.ear
3. Confirm there NO application folder for ports under ../j2ee/<OC4J_NAME>/application-deployments/ , if there please delete it.
4. Deploy the application again.
5. Retest the issue
2.       Remove Tags libraries which are deprecated.
used the following parameters which are depreciated
Old:
<%@ taglib uri="http://jakarta.apache.org/struts/tags-bean" prefix="bean"%>
<%@ taglib uri="http://jakarta.apache.org/struts/tags-html" prefix="html"%>
<%@ taglib uri="http://jakarta.apache.org/struts/tags-logic" prefix="logic"%>

Replace these lines with the following
<%@ taglib uri="/WEB-INF/struts-bean.tld" prefix="bean"%>
<%@ taglib uri="/WEB-INF/struts-html.tld" prefix="html"%>
<%@ taglib uri="/WEB-INF/struts-logic.tld" prefix="logic"%>


Get Oracle Certifications for all Exams
Free Online Exams.com
Posted by at 1:37 PM 0 comments

Upgrade to R12.1.1 failed with while running IGSAD4495730A.sql with error ORA-20100: Error due to ORA-06502: PL/SQL: numeric or value error: character to

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com
Problem:

Upgrade to R12.1.1 failed with while running IGSAD4495730A.sql with error ORA-20100: Error due to ORA-06502: PL/SQL: numeric or value error: character to
number conversion error


Symptoms:

sqlplus -s APPS/***** @/ezwr12/apps/apps_st/appl/igs/12.0.0/patch/115/sql/IGSAD4495730A.sql
DECLARE
*
ERROR at line 1:
ORA-20100: Error due to ORA-06502: PL/SQL: numeric or value error: character to
number conversion error
ORA-06512: at line 149

From Note.1127593.1 Ext/Pub R12.1 Oracle Financials Pre-Upgrade Patch Supplemental List for EBS CUP:
R12.1: Oracle Financials Pre-Upgrade Patch Supplemental List for EBS CUP

The following Release 12.1 Oracle Financials pre-upgrade patches should be applied on top of the EBS Consolidated Upgrade Patch (see Doc ID 798258.1). These pre-upgrade patches apply to the Oracle Financials Release 11i to Release 12.1 upgrade.

Patch is therefore post upgrade requirement.

Bug: 8871012 definitely references: 12.0 8871012:R12.CE.B Standalone
as a solution to the problem when the upgrade script fails.
Intention must be to skip the script and apply 8871012:R12.CE.B later.
The bug update isn't clear.


Solution:




It appears that patch 8871012:R12.CE.B is a post upgrade solution. I apologise for any confusion.

1. Stop the patch 8871012:R12.CE.B

2. Reinstate the upgrade driver files as directed in note 175485.1

3. Once the upgrade driver is restarted use adctrl hidden option number 8 to skip the script cecestmt.sql

4. Once the upgrade driver is finished and the upgrade complete, then apply 8871012:R12.CE.B as a post upgrade solution.

. Use adctrl hidden option number 8 to skip the script cecestmt.sql

. Once the upgrade driver is finished and the upgrade complete, then apply 8871012:R12.CE.B as a post upgrade solution.


References:


Bug 8871012. documents the problem.
++ 1. Description
-> Upgrade process was failing because of the technical error
-> in cecestmt.sql.
-> The statement numbers when appended with org_id resulted in
-> more than 50 chars

-> The statement number column was having a length of
-> varchar2(50) when appened with the org_id, the length
-> exceeded the 50 characters.
Get Oracle Certifications for all Exams
Free Online Exams.com
Posted by at 1:26 PM 0 comments

Siebel 8.0.0.8 with Windows 7 supportability

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com
Problem: Siebel 8.0.0.8 with Windows 7 supportability


Symptoms:

If we upgrade all PCs to windows 7, could we still use Siebel tools & Siebel client by launching Siebel tools & client with compatibility mode of Windows XP(from Windows 7 Operating System).

Solution:




FIRSTLY, regarding the workaround of using the windows XP and the compatibility mode for Windows 7 is not a listed nor documented nor certified by Siebel. So to confirm to you that Siebel do not support such compatibility mode i.e. with compatibility mode of Windows XP (from Windows 7 Operating System) using Siebel 8.0.0.8 version. Further, please note that there is no deviation or any workaround available for such supported platform deployment.


SECONDLY, as you are already aware of the exact support information, once again I would like to suggest you to please find and refer to the latest SRSP Guide (Siebel System Requirements and Supported Platforms Version 8.0, Rev. Q), posted on My Oracle Support site (MOS). I believe this SRSP guide would answer all your requested information.

According to the above latest SRSP Guide, the following information is documented and/or listed:

******************************************
SRSP Guide ((SRSP Guide = Siebel System Requirements and Supported Platforms Version 8.0, Rev. Q) >> Client Environment Requirements >> Requirements for Employee Applications (PAGE 30)

1. Using add-in toolbars with these browsers is not supported, as some add-in toolbars have been found to cause character corruption and other serious problems.

2. Note that Microsoft Internet Explorer 7.0 is supported as of the 8.0.0.2 Fix Pack.

3. Note that Microsoft Internet Explorer 8.0 is supported as of the 8.0.0.8 Fix Pack.

4. Note that Microsoft Vista is supported as of the 8.0.0.3 Fix Pack.

5.| Note that Microsoft Windows 7 is supported as of the 8.0.0.9 Fix Pack.
******************************************

Particularly the Point # 5 confirms about the Siebel Support for Windows 7 for Siebel Release 8.0.x Version.

In summary, please note that you should adhere to all of the supported version and information as documented under the SRSP GUIDE (Siebel System Requirements and Supported Platforms Version). Any deviation to this guide is not a supported platform.

Further, please note that there is no deviation or any workaround available for such supported platform deployment.
So please ensure that any Siebel Client Installations you intend to use with Windows 7 should be upgraded to Siebel release 8.0.0.9 fix pack as documented under the SRSP Guide.
Siebel Versions and builds must be the same level in a Siebel environment to be supported. If your client is not at the same level and encounter any Siebel specific issues, we will ask you to reproduce the same behavior against Siebel supported environment to offer any workaround or fix. In other words, if we believe that a behavior could be linked to the fact that build numbers are different (not windows 7 supported Siebel release version). Then we will ask you to reproduce it on a certified platform.

Finally, additional information and/or future reference links information – Just in case if you are not aware of this then – Where to find the SRSP Guides?: They are posted on My Oracle Support site and the links for the same are as follows:

(i) Here is the direct link for the SRSP Guide (Lists all the Siebel Release versions, 6.0, 7.0, 8.0, 8.1 etc..)
LINK = http://download.oracle.com/docs/cd/E11886_01/srsphomepage.html

(ii) Next, here is the direct link for downloading the Siebel Release 7.8.2.x Version SRSP Guide:
http://download.oracle.com/docs/cd/E11886_01/V8/CORE/core_8_0.html
http://download.oracle.com/docs/cd/E11886_01/V8/CORE/SRSP_80/SRSP_80TOC.html
http://download.oracle.com/docs/cd/E11886_01/V8/CORE/SRSP_80/SRSP_80.pdf

(iii) Then, here is the important posting which has all the useful links about the Siebel Documentations, SRSP Guides etc..

POSTING = 941755.1 - Where to find the Siebel CRM documentation

For your convenience, I have also attached a copy of the latest SRSP (SRSP80.pdf) to this service request for your quick reference.

Further, I have also linked the above posting (941755.1) to this SR for your future reference purpose.

I believe the above information answers your question, however if you have any further questions please do not hesitate to ask.

Lastly, please let me know if you require further assistance with this or if I can close this service request.


References:


http://download.oracle.com/docs/cd/E11886_01/srsphomepage.html
http://download.oracle.com/docs/cd/E11886_01/V8/CORE/core_8_0.html
http://download.oracle.com/docs/cd/E11886_01/V8/CORE/SRSP_80/SRSP_80TOC.html
http://download.oracle.com/docs/cd/E11886_01/V8/CORE/SRSP_80/SRSP_80.pdf
Get Oracle Certifications for all Exams
Free Online Exams.com
Posted by at 1:26 PM 0 comments

Not able to start one of the database instance using sqlplus after it is aborted on 10.2.0.3, HP-UX Itanium, v 11.31

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com
Problem: Not able to start one of the database instance using sqlplus after it is aborted on 10.2.0.3, HP-UX Itanium, v 11.31


Log files:

FileComment
----------------------
12186: socket(AF_INET, SOCK_DGRAM, 0) = 13
12186: setsockopt(13, SOL_SOCKET, SO_REUSEADDR, 0x9fffffffffff2978, 4) = 0
12186: bind(13, 0x6000000000364b70, 16) = 0
12186: getsockname(13, 0x9fffffffffff2980, 0x9fffffffffff2970) = 0
12186: getpeername(13, 0x9fffffffffff2980, 0x9fffffffffff2970) ERR#235 ENOTCONN
12186: getsockopt(13, SOL_SOCKET, SO_SNDBUF, 0x9fffffffffff29d0, 0x9fffffffffff29d4) = 0
12186: getsockopt(13, SOL_SOCKET, SO_RCVBUF, 0x9fffffffffff29d0, 0x9fffffffffff29d4) = 0
12186: fcntl(13, F_SETFD, 1) = 0
12186: ioctl(13, FIONBIO, 0x9fffffffffff2b1c) = 0
12186: gettimeofday(0x9fffffffffff1970, NULL) = 0
12186: access("/tmp/.oracle", F_OK) = 0
12186: chmod("/tmp/.oracle", 01777) ERR#1 EPERM
12186: socket(AF_UNIX, SOCK_STREAM, 0) = 15
12186: access("/tmp/.oracle/sprocr_local_conn_0_PROC", F_OK) = 0
12186: connect(15, 0x9fffffffffff1390, 94) = 0
12186: fcntl(15, F_SETFD, 1) = 0
12186: sigaction(SIGPIPE, 0x9fffffffffff1590, 0x9fffffffffff15c0) = 0
12186: gettimeofday(0x9fffffffffff1970, NULL) = 0
12186: gettimeofday(0x9fffffffffff1970, NULL) = 0
12186: ioctl(15, FIONBIO, 0x9fffffffffff2abc) = 0
12186: write(15, "\0\0\00 \001\00101\001\0\0\0\001".., 48) = 48
12186: gettimeofday(0x9fffffffffff2e20, NULL) = 0
12186: poll(0x60000000003635c8, 2, -1) = 1
12186: gettimeofday(0x9fffffffffff2e20, NULL) = 0
12186: poll(0x60000000003635c8, 2, -1) [sleeping]


Solution:



This issue is matching for OS bug QX:QXCR1000940361
so, applying the patch PHKL_40208 (and other recommended patches) should help resolving the issue here.

Recommended patches
PHKL_38762
PHKL_40208
PHKL_38733
PHKL_38623




References:


Note 2059882.102 "PROTECTIONS INCORRECT ON /TMP/.ORACLE IPC SOCKET FILES AFTER /TMP RESTORE"
Note 434062.1 "Listener Fails To Start With IPC Permission Errors (TNS-12546 TNS-12555 TNS-00516 TNS-00525)"
Get Oracle Certifications for all Exams
Free Online Exams.com
Posted by at 1:26 PM 0 comments

How to define/call oracle db stored procedures in OBIEE?

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com



Problem:

How to define/call oracle db stored procedures in OBIEE?

Solution:




1) You cannot use oracle stored procedures in OBIEE. You need to rewrite the procedure as an oracle function instead.
The information on why and how is documented in the following bookshelf note:
Oracle Business Intelligence Server Administration Guide > Creating and Administering the Physical Layer in an Oracle BI Repository > Using Stored Procedures with an Oracle Database

http://download.oracle.com/docs/cd/E10415_01/doc/bi.1013/b31770.pdf

Here is an extract of the bookshelf note for your reference:
Using Stored Procedures with an Oracle Database
Stored Procedures within Oracle do not return result sets. Therefore they cannot be initiated from within Oracle BI. You need to rewrite the procedure as an Oracle function, use it in a select statement in the Administration Tool initialization block, and then associate it with the appropriate Oracle BI session variables in the Session Variables dialog box.
The function uses the GET_ROLES function and takes a user Id as a parameter and returns a semicolon delimited list of group names.
The following is an example of an initialization SQL string using the GET_ROLES function that is associated with the USER, GROUP, DISPLAYNAME variables:
select user_id, get_roles(user_id), first_name || ' ' || last_name
from csx_security_table
where user_id = ':USER' and password = ':PASSWORD'

2) Also If you have OBIEE 10.1.3.3 or above you can use BI built-in EVALUATE function to call user-defined functions in database.
This function is intended for scalar and analytic calculations.

Syntax: EVALUATE('DB_Function(%1)', )

Example: SELECT e.lastname,sales.revenue,EVALUATE('dense_rank() over(order by %1 )',sales.revenue) FROM sales s, employee e;




Get Oracle Certifications for all Exams
Free Online Exams.com
Posted by at 1:25 PM 0 comments

Questions on How to upgrade and patch CRS,ASM and Database components in different homes on the same server.

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com



Problem: Questions on How to upgrade and patch CRS,ASM and Database components in different homes on the same server.


Solution:




Assume you have 3 Oracle Homes on the same server and you want to upgrade them from 10.2.0.3 to 10.2.0.4.4, some worries might arise:
1. ASM Version is 10.2.0.3
2. CRS Version is 10.2.0.3
3. Database Version is 10.2.0.3

1. Is it necessary to upgrade all components (crs,asm,db) to I can just upgrade the database only to 10.2.0.4 and if so in which order?
Answer:
You must upgrade all Oracle home in following sequence.
CRS first
ASM second
RDBMS last
You can upgrade all above 3 Oracle homes together in same scheduled downtime window or upgrade it separately one-by-one.
CRS can be upgraded in rolling so doesn’t require cluster wide downtime.
Upgrading from 10.2.0.3 to 10.2.0.4.4 is a two step process.
viz:
A) upgrade to patch set 10.2.0.4 (refer to patch set README for steps to apply patch set)
B) apply PSU-4 to make it 10.2.0.4.4 (refer to patch README for steps to apply)
Note.
1) CRS PSU is different from RDBMS PSU
2) Both the PSU can be applied in rolling

You can find patch (PSU) numbers for CRS and RDBMS in doc :
Note 756671.1 Title: Oracle Recommended Patches -- Oracle Database
2. How does the ASM database upgrade works? What are the steps?
a. ASM upgrade requires just installing the patchset software and then applying the PSU,
b. There is nothing you need to do for upgrading ASM except installing the software binaries in ASM HOME, the internl ASM metadata gets upgraded automatically when you startup ASM with new patched binaries.
3. Can I keep ASM home and ASM database to 10.2.0.3 only and upgrade only CRS and database Home.
a. No, you cannot have ASM running in lower version and RDBMS database running with higher version.


References:
Note 756671.1 Title: Oracle Recommended Patches -- Oracle Database
Get Oracle Certifications for all Exams
Free Online Exams.com
Posted by at 1:25 PM 0 comments

when running in a cluster with multiple processes/nodes, session is lost because the mod_oc4j cannot route to the "correct" OC4J node/process

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com



Problem: when running in a cluster with multiple processes/nodes, session is lost because the mod_oc4j cannot route to the "correct" OC4J node/process
Wanting to set the "secure" and "httponly" flags for the session cookie, a servlet filter like the following has been created:

public final void doFilter(final ServletRequest servletRequest,
final ServletResponse servletResponse, final FilterChain filterChain)
throws IOException, ServletException {

final HttpServletRequest request = (HttpServletRequest) servletRequest;
final HttpServletResponse response = (HttpServletResponse) servletResponse;

if (!response.containsHeader("SET-COOKIE")) {
final String sessionId = request.getSession().getId();
final String contextPath = request.getContextPath();
String secure = "";
if (request.isSecure()) {
secure = "; Secure";
}
response.setHeader("SET-COOKIE", "JSESSIONID=" + sessionId
+ "; Path=" + contextPath + "; HttpOnly" + secure);
}

filterChain.doFilter(servletRequest, response);

}

This works quite well as long as the OC4J instance consists of only one process, but when running in a cluster with multiple processes/nodes, the jvmroute information is not contained in the so-generated cookie, and thus the session is lost because the mod_oc4j cannot route to the "correct" OC4J node/process.




Symptoms:
OC4J generates the session cookie at committing the request -- i.e. at the latest possible moment, and generates it in a way that is independent / beyond all other cookies which are set with setCookie() or setHeader()
The mechanics how the "jvmroute" is used for it -- even the jvmroute information at all is not accessible at the application level (=filter level).

As a conclusion from that, you cannot use a servlet filter to generate the session cookie -- you need to leave the creation of the session cookie to OC4J.


Solution:





Issue is due to bug 5908683 ADD SUPPORT FOR "HTTPONLY" ATTRIBUTE ON SESSION COOKIE
Specify the cookie domain like ".oracle.com; HttpOnly"

In order to add the "secure" flag you can use the set-secure attribute, documented in

Oracle® Containers for J2EE Servlet Developer's Guide
10g (10.1.3.1.0)
Part Number B28959-01
B Web Module Configuration Files
http://download.oracle.com/docs/cd/B32110_01/web.1013/b28959/xmlfiles.htm#CJAGCICC


In order to set the "HttpOnly" flag there is no direct support for it, but to configure the cookie-domain setting like "your.domain.com; HttpOnly" would do the trick, and setting the cookie path in a similar way like "/myapp/; HttpOnly" would work, too.


Surely this is better supported by the WebLogic Server, which has many more settings in order to configure the session cookie, see

Oracle® Fusion Middleware Developing Web Applications, Servlets, and JSPs for Oracle WebLogic Server
11g Release 1 (10.3.3)
Part Number E13712-02
B weblogic.xml Deployment Descriptor Elements
session-descriptor
http://download.oracle.com/docs/cd/E14571_01/web.1111/e13712/weblogic_xml.htm#WBAPP587



References:
http://download.oracle.com/docs/cd/E14571_01/web.1111/e13712/weblogic_xml.htm#WBAPP587

http://download.oracle.com/docs/cd/B32110_01/web.1013/b28959/xmlfiles.htm#CJAGCICC
Get Oracle Certifications for all Exams
Free Online Exams.com
Posted by at 1:25 PM 5 comments

11g Grid Control: Using 'opmnctl startall | status | stopall' in OMS_HOME Fails with "opmnctl: ORACLE_INSTANCE is not set"

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com
Problem: 11g Grid Control: Using 'opmnctl startall | status | stopall' in OMS_HOME Fails with "opmnctl: ORACLE_INSTANCE is not set"


Symptoms:
cd /opmn/bin>
./opmnctl startall
opmnctl: ORACLE_INSTANCE is not set.

opmnctl status requires that ORACLE_INSTANCE be correctly set in your
environment.

Make sure you are using ORACLE_INSTANCE/bin/opmnctl, or set ORACLE_INSTANCE
in your environment.

Solution:



n the 11.1.0.1 Grid Control release, "opmnctl" is not a valid command for starting the OMS as the 11g OMS is deployed in Weblogic server unlike 10g version which is deployed on an OC4J.

opmnctl utility should be used to start the OMS only in the 10g versions of Grid Control nad not in the 11g Grid Control version.

Grid Control 11.1.0.1 uses "emctl" command to start Grid Control:

cd OMS_HOME/bin
./emctl start oms

This will start the Grid Control 11.1.0.1 OMS as well as starting the necessary Weblogic processes needed by the OMS.



References:
11g Grid Control: Using 'opmnctl startall | status | stopall' in OMS_HOME Fails with "opmnctl: ORACLE_INSTANCE is not set" [ID 1160335.1]
Get Oracle Certifications for all Exams
Free Online Exams.com
Posted by at 1:25 PM 0 comments

ORA-02289: sequence does not exist

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com
Problem:



SQL> exec DBMS_STREAMS_ADM.ADD_SCHEMA_RULES (SCHEMA_NAME => 'DPPDEC',
STREAMS_TYPE => 'APPLY',
STREAMS_NAME => 'APPLY_DEC_PROC',
QUEUE_NAME => 'APP_DEC_QUEUE',
INCLUDE_DML => TRUE,
INCLUDE_DDL => TRUE,
SOURCE_DATABASE => 'PDPP.DUBAIWORLD.AE');
BEGIN DBMS_STREAMS_ADM.ADD_SCHEMA_RULES (SCHEMA_NAME => 'DPPDEC',STREAMS_TYPE => 'APPLY',STREAMS_NAME => 'APPLY_DEC_PROC',QUEUE_NAME => 'APP_DEC_QUEUE',INCLUDE_DML => TRUE,INCLUDE_DDL => TRUE,SOURCE_DATABASE => 'PDPP.DUBAIWORLD.AE'); END;

*
ERROR at line 1:
ORA-02289: sequence does not exist
ORA-06512: at "SYS.DBMS_STREAMS_ADM_UTL_INVOK", line 289
ORA-06512: at "SYS.DBMS_STREAMS_ADM", line 439
ORA-06512: at "SYS.DBMS_STREAMS_ADM", line 397
ORA-06512: at line 1

Log files:
strmp1_ora_1057.log
PARSE ERROR #64:len=58 dep=2 uid=0 oct=3 lid=0 tim=105769277631 err=2289
SELECT "STRMADMIN"."AQ$_APP_DEC_TAB_N".NEXTVAL FROM DUAL
EXEC #20:c=170000,e=629520,p=0,cr=343,cu=0,mis=1,r=0,dep=1,og=4,tim=105769279603
ERROR #20:err=2289 tim=10830774




Solution:





10046 revealed the sequence it is looking for is AQ$_APP_DEC_TAB_N...

It looks like the previous cleanup didn't go thru properly and that might have left the queue_tables and it's associated object inconsistent...

Manually drop is needed for the queue table since It looks like the previous cleanup didn't go thru properly and that might have left the queue_tables and it's associated object inconsistent...

-Manually drop queue table AQ$_APP_DEC_TAB_N using DBMS_AQADM.drop_queue_table('q_table','force=>true)
-Then try to recreate the apply process


Get Oracle Certifications for all Exams
Free Online Exams.com
Posted by at 1:24 PM 0 comments

Unable to Void payment. On Querying No Invoices appear.

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com



Problem: Unable to Void payment. On Querying No Invoices appear.

Solution:




Payment entries were not updated in ap_accounting_events_all
The following SQL identified the invalid / incorrect data:
select * from ap_accounting_events_all
where source =138784
INSERT entries in to ap_accounting_events_all as below
Step # 1
========
This script should insert one row.

INSERT INTO ap_accounting_events_all
(ACCOUNTING_EVENT_ID,
EVENT_TYPE_CODE,
ACCOUNTING_DATE,
EVENT_NUMBER,
EVENT_STATUS_CODE,
SOURCE_TABLE,
SOURCE_ID,
CREATION_DATE,
CREATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_LOGIN,
PROGRAM_UPDATE_DATE,
PROGRAM_ID,
PROGRAM_APPLICATION_ID,
REQUEST_ID,
ORG_ID,
CANNOT_ACCOUNT_FLAG)
VALUES (
261153
, 'PAYMENT'
,'04-JUL-2010'
,1
,'CREATED'
,'AP_CHECKS'
,138784
,SYSDATE
,-1
,SYSDATE
, -1
, -1
, SYSDATE
, -1
, -1
, -1
, 181/* Org_id */
, NULL);

--- 63 rows should be inserted

COMMIT;
Step # 2
========

1. Perform action plan in TEST instance.

create table sr_21626050_600_apid1 as
select * from AP_INVOICE_PAYMENTS_ALL
where posted_flag='S'
and CHECK_ID =138784
and invoice_id in(216589,216590,216591,216592,216593,216594
,216595,216596,216597,216598,216600,216601
,216602,216624,216625,216626,216627,216821
,216822,216823,217136,217137,217138,217139
,217140,217141,217142,217143,217144,217145
,217146,217147,217148,217149,217150,217151
,217152,217153,217154,217155,217156,217157
,217158,217159,217160,217161,217162,217163
,217164,217165,217167,217168,217169,217170
,217171,217172,217173,217174,217175,217176
,217177,217178,217179)
and org_id=181;

select count(*) from sr_21626050_600_apid1;

-- 63 row should be selected


Update AP_INVOICE_PAYMENTS_ALL
set posted_flag='N'
where posted_flag='S'
and CHECK_ID=138784
and invoice_id in(216589,216590,216591,216592,216593,216594
,216595,216596,216597,216598,216600,216601
,216602,216624,216625,216626,216627,216821
,216822,216823,217136,217137,217138,217139
,217140,217141,217142,217143,217144,217145
,217146,217147,217148,217149,217150,217151
,217152,217153,217154,217155,217156,217157
,217158,217159,217160,217161,217162,217163
,217164,217165,217167,217168,217169,217170
,217171,217172,217173,217174,217175,217176
,217177,217178,217179)
and org_id=181;

-- 63 row should be updated.

If you are satisfied with the results issue commit

commit;




Step # 2
========
1. AP period is in closed state,reopen it first

2. Run the payables accounting process for period JUL-10
Get Oracle Certifications for all Exams
Free Online Exams.com
Posted by at 1:23 PM 0 comments
Subscribe to: Posts (Atom)