|
Re: Error for define supplier's product and service [message #441596 is a reply to message #441572] |
Tue, 02 February 2010 01:43 |
sword_111
Messages: 5 Registered: February 2010
|
Junior Member |
|
|
I have find the issue is a bug of EBS.
could somebody share Patch 8761137:R12.POS.B?
Thanks
The following is the details about the bug.
Applies to:
Oracle Payables - Version: 12.1.1 - Release: 12.1
Information in this document applies to any platform.
Symptoms
Comments
--------
=== ODM Issue Clarification ===
Using release 12.1.1 - attempting to enter the products and services tab gives errors.
Error:
The setup of the Products and Services section for Supplier Profile Management has not been completed properly. No value has been assigned to the Products and Services setup profile option. An administrator will need to define the profile value to complete the setup.
Cause
It was consider that where clasue will never be null. So the query building was wrong. Now we are considering where can be null also so changed query based on that.
This is explained in Bug. 8611906 ERROR COMES WHEN CLICKING TAB PRODUCTS & SERVICES.
Solution
To implement the solution, please execute the following steps:
1. Download and review the readme and pre-requisites for Patch 8761137:R12.POS.B
Note: This patch is not available as of December 2009. Please contact Support to request for the password of this patch if it is necessary.
2. Ensure that you have taken a backup of your system before applying
the recommended patch.
3. Apply the patch in a test environment.
4. Confirm the following file versions:
java/profile/server/ProductServiceTreeWalker.java 120.0.12000000.5
java/supplier/components/server/ProductServiceTree 120.5.12000000.2
eWalker.java
java/profile/server/ProductServiceMetaData.java 120.2.12000000.5
patch/115/sql/POSPSUTB.pls 120.5.12000000.10
patch/115/sql/POSPSUTS.pls 120.5.12000000.3
patch/115/xdf/pos_products_services_gt.xdf 120.0.12000000.5
You can use the commands like the following:
strings -a $XX_TOP/filename |grep '$Header'
5. Retest the issue.
6. Migrate the solution as appropriate to other environments.
8761137:R12.POS.B
|
|
|
|