My Oracle Support Banner

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

Last updated on NOVEMBER 08, 2019

Applies to:

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


On : 12.1.3 version, Workflow Issues

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

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

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'.


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.