My Oracle Support Banner

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

Last updated on FEBRUARY 19, 2021

Applies to:

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


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,
  decode(pte.broadcast_flag,'G',PON_THREAD_DISC_PKG.GET_RECIPIENTS_LIST(pte.from_id,pte.entry_id,pte.MESSAGE_TYPE)) recipient_list,
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
  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))
(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))
(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)
  ((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(
at oracle.apps.fnd.framework.OAException.wrapperException(
at oracle.apps.fnd.framework.OAException.wrapperInvocationTargetException(

## 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.




To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.