Error APP-FND-01934: ORA-20002: 6012: XML Gateway Process Aborted: 'ORA-00904: "RECIPE_YIELD" (Doc ID 2213923.1)

Last updated on DECEMBER 13, 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, Product Development Recipes

When attempt to change Recipe status from 'New' to 'Approved for General Use', saw Error dialogue with message:

ERROR
APP-FND-01934: ORA-20002: 6012: XML Gateway process aborted: 'ORA-00904: "RECIPE_YIELD": invalid identifier - ECX_UTILS.LOAD_OBJECTS'.
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. change Recipe status from 'New' to 'Approved for General Use',
2. saw the error.

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