Sequence Type Collection Elements Are Not Generated Automatically (Doc ID 748592.1)

Last updated on JULY 05, 2015

Applies to:

Oracle Quality - Version 11.5.10.2 and later
Information in this document applies to any platform.
***Checked for relevance 05-Jul-2015***




Symptoms

When attempting to Implement Disposition Actions by importing WIP Scrap via API, the Check Periodic Alert program is failing with the following errors:

ERROR
ERROR at line 1:
ORA-00904: "SEQUENCE": invalid identifier
ORA-06512: at "APPS.QA_PARENT_CHILD_PKG", line 2310
ORA-06512: at "APPS.QA_PARENT_CHILD_PKG", line 2387
ORA-06512: at "APPS.QA_SOLUTION_DISPOSITION_PKG", line 3758
ORA-06512: at "APPS.QA_SOLUTION_DISPOSITION_PKG", line 705
ORA-06512: at line 2
APP-ALR-04020: Oracle Alert was unable to execute "&VALUE". Check that this file exists and that its read protection is set correctly.

-- Steps To Reproduce:
The issue can be reproduced at will with the following steps:
1. check the request Check Periodic Alert

OR

When attempting to open Nonconformance Plan in QA Workbench the following error occurs:

java.sql.SQLException: ORA-00904: "SEQUENCE": invalid identifier
ORA-06512: at "APPS.QA_PARENT_CHILD_PKG", line 3820

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