Home » Applications » Oracle Fusion Apps & E-Business Suite » Error for define supplier's product and service (EBS R12.1.1)
Error for define supplier's product and service [message #441572] Tue, 02 February 2010 00:20 Go to next message
sword_111
Messages: 5
Registered: February 2010
Junior Member
Hi
I have met a error when i define supplier's product and service.
Path
Purchasing superuser>supply base>supplier
The following is the error message.
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.
/forum/fa/7402/0/
  • Attachment: supplier.jpg
    (Size: 54.12KB, Downloaded 2836 times)
Re: Error for define supplier's product and service [message #441596 is a reply to message #441572] Tue, 02 February 2010 01:43 Go to previous messageGo to next message
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
Re: Error for define supplier's product and service [message #441696 is a reply to message #441596] Tue, 02 February 2010 13:33 Go to previous message
vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH
Senior Member
Quote:
could somebody share Patch 8761137:R12.POS.B?
No.
No one is supposed to do so.

By
Vamsi
Previous Topic: AR API
Next Topic: PO Documents Numbering..!!
Goto Forum:
  


Current Time: Thu Apr 25 17:00:07 CDT 2024