Attempting to Approve the Contracts Terms Template, it is Stuck in Pending Approval Status OKCTPAPP User-Defined-Exception in OKC_TERMS_TMPL_APPROVAL_PVT (Doc ID 780291.1)

Last updated on JULY 11, 2016

Applies to:

Oracle Procurement Contracts - Version 11.5.10 to 11.5.10 [Release 11.5]
Information in this document applies to any platform.
Checked for relevance on 15-Nov-13Checked for relevance on 15-Nov-13

Symptoms

When attempting to approve a contract template, the user approves the notification but the template gets stuck in "Pending Approval" status and the following error shows in workflow:

Error:
Workflow errors: OKCTPAPP

Failed Activity: Approve Template
Activity Type: Function
Error Message: User-Defined-Exception
Error Stack: OKC_TERMS_TMPL_APPROVAL_PVT.create_production_publicatio(ItemType=OKCTPAPP ItemKey=4222 actid=176702 funcmode=RUN, ORA-20100: File o0063105.tmp creation for FND_FILE failed.
You will find more information on the cause of the error in request log. in Package OKC_XPRT_UTIL_PVT Procedure create_production_publication)
Wf_Engine_Util.Function_Call(OKC_TERMS_TMPL_APPROVAL_PVT.APPROVE_TEMPLATE, OKCTPAPP, 4222,176702,RUN)

Steps To Reproduce:
1. Using Contracts Terms Library Admin responsibility
2. Create a contract template, using default layout, Expert enabled
3. Add sections and clause
4. Submit for approval
5. Approve the notification
6. The status of the template is stuck in "Pending Approval".

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