My Oracle Support Banner

Error In PONAWARD Workflow When RFQ Is CPA Output With No Lines (Doc ID 2382082.1)

Last updated on FEBRUARY 24, 2019

Applies to:

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


On : 12.1.3 version, Awards

When attempting to send an award decision from PONAUCT workflow from a RFQ with a CPA (Contract Purchase Agreement) output, with no lines on the RFQ,
the following error occurs.


ORA-20002: 3240: Error '-20002 - ORA-20002: 3103: Attribute 'TP_TIME_ZONE' does not exist for item 'PONAWARD/xxxxxx-xxxxxx'. ' in 'PLSQLCLOB' API 'pon_auction_pkg.GEN_AWARD_EVENT_NOLINES_BODY' ORA-06512: at "APPS.WF_NOTIFICATION", line 5512 ORA-06512: at line 6

The issue can be reproduced at will with the following steps:
1- RFQ is CPA output with lines - No issue experienced
2- RFQ is CPA output without lines


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.