OraFAQ Forum: Oracle Fusion Apps & E-Business Suite » Error for define supplier's product and service

Home » Applications » Oracle Fusion Apps & E-Business Suite » Error for define supplier's product and service (EBS R12.1.1)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Error for define supplier's product and service [message #441572]

Tue, 02 February 2010 00:20

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 3188 times)

Report message to a moderator

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

Report message to a moderator

Re: Error for define supplier's product and service [message #441696 is a reply to message #441596]

Tue, 02 February 2010 13:33

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

Report message to a moderator

Previous Topic:	AR API
Next Topic:	PO Documents Numbering..!!

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat May 03 00:07:08 CDT 2025