My Oracle Support Banner

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

Last updated on FEBRUARY 21, 2019

Applies to:

Oracle Procurement Contracts - Version 11.5.10 to 11.5.10 [Release 11.5]
Information in this document applies to any platform.


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:

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=<Item key> actid=<act id> funcmode=RUN, ORA-20100: File <filename>.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, <item key>,< act id>,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".




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.