Error In PONAWARD Workflow When RFQ Is CPA Output With No Lines

(Doc ID 2382082.1)

Last updated on APRIL 03, 2018

Applies to:

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

Symptoms

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.

ERROR
-----------------------

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

STEPS
-----------------------
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


Changes

 

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