Opening Message In Sourcing Discussion Is Completed With Error (Doc ID 1981398.1)

Last updated on JUNE 01, 2016

Applies to:

Oracle Sourcing - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On Applications 12.1.3 :

When attempting to open the message in sourcing discussion , the following error occurs.

-- Error
oracle.apps.fnd.framework.OAException: Application: FND, Message Name: FND_GENERIC_MESSAGE. Tokens: MESSAGE = oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT pte.entry_id,
pd.pk1_value,
....
  decode(pte.broadcast_flag,'G',PON_THREAD_DISC_PKG.GET_RECIPIENTS_LIST(pte.from_id,pte.entry_id,pte.MESSAGE_TYPE)) recipient_list,
ptr.to_id
FROM pon_thread_entries pte,
pon_threads pt,
pon_discussions pd,
pon_auction_headers_all auh,
pon_neg_team_members pntm,
pon_te_recipients ptr,
  pon_scoring_teams pst
WHERE
  pst.team_id(+) = pte.scoring_team_id and
pte.entry_id = :2 and
ptr.entry_id=pte.entry_id and
((pte.FROM_ID = :3 and pte.from_id <> ptr.to_id and pte.broadcast_flag <> 'Y' and pte.broadcast_flag <> 'G' and (pte.message_type='INTERNAL' OR pte.from_company_id <> ptr.to_company_id) and
  (pte.message_type='INTERNAL' OR pte.from_company_id <> auh.trading_partner_id and ptr.to_id=auh.trading_partner_contact_id))
  OR
(ptr.TO_ID = :4 and pte.from_id <> ptr.to_id and pte.broadcast_flag <> 'Y' and pte.broadcast_flag <> 'G' and (pte.message_type='INTERNAL' OR pte.from_company_id <> ptr.to_company_id))
OR
(ptr.TO_ID <> :5 and pte.from_id <> ptr.to_id and pte.broadcast_flag <> 'Y' and pte.broadcast_flag <> 'G' and ptr.to_company_id <> auh.trading_partner_id)
OR
  ((pte.broadcast_flag = 'Y' and pte.from_id = ptr.to_id) or (pte.broadcast_flag = 'G' and ptr.to_id=:6))
) and
pte.discussion_id = pd.discussion_id and
pt.discussion_id = pd.discussion_id and
pt.thread_number = pte.thread_number and
pd.entity_name = 'PON_AUCTION_HEADERS_ALL' and
to_number(pd.pk1_value) = auh.auction_header_id
AND pntm.USER_ID (+) = :7
AND pntm.auction_header_id(+)=auh.auction_header_id;
at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:912)
at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:886)
at oracle.apps.fnd.framework.OAException.wrapperInvocationTargetException(OAException.java:1009)

## Detail 0 ##
java.sql.SQLException: ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at "APPS.PON_THREAD_DISC_PKG", line 488

 -- Steps
The issue can be reproduced at will with the following steps.
1. In Sourcing, search for the RFQ and click on the hyperlink for unread messages
2.Click on the message for one of the senders and see the errors.


Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms