Error While Changing Formula Status From New To Approved For General Use (Doc ID 2173364.1)

Last updated on AUGUST 18, 2016

Applies to:

Oracle Process Manufacturing Product Development - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Workflow Issues

When attempting to change formula status from 'New' to 'Approved For General Use' the following error occurs:

ERROR
-----------------------
APP-FND-01934: ORA-20002: 6012: XML Gateway Aborted: 'ORA-01003: No statement parsed - ECX_ACTIONS.BIND_PROC_VARIABLES'. For further details, see the log corresponding to FND-Logging AFLOG MODULE Name: 'Please ensure that FND-Logging is enabled for module ecx.plsql.%'. in package EDR_PSIG_RULE Procedure PSIG_RULE


STEPS
-----------------------
The issue can be reproduced at will with the following steps:


1. Responsibility: Formulator

2. Navigation: Formulas

3. Create or query new formula

4. Change formula status from 'New' to 'Approved For General Use'.

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