Error Page during ECO Creation, When Adding Two Or More Lines To Change Request (Doc ID 2012726.1)

Last updated on AUGUST 25, 2017

Applies to:

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

Symptoms

On : 12.1.3 version, Change Management

ACTUAL BEHAVIOR
---------------
Problem with Change Request - Error Page

Creating ECO by Change request. When adding 2 or more Lines to Change Request, cannot open new Engineering Change Order by action: Add to Change Order.

More details are included in attached file.

Please explain, why problem occurs when there is 2 or more lines in Change Request?
(ECO can be opened only for one lines included in the Change Request)

 

EXPECTED BEHAVIOR
-----------------------
Expect to use Change Request without error page

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Choose Development Manager responsibility change Management Create Change Request
2. Add Lines
3. Save for Later.
4. Submit
5. Change status for Line 10 and 20 from Open to Completed
6. Choose an action: Add to Change Order
7. Click Continue buton
8. See error page:

Error Page
Exception Details.
 oracle.apps.fnd.framework.OAException:
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement
preparation. Statement: SELECT * FROM (SELECT ChangeLineVLEO.ROW_ID,
  ChangeLineVLEO.CHANGE_LINE_ID,
  ChangeLineVLEO.CREATED_BY,
  ChangeLineVLEO.CREATION_DATE,
  ChangeLineVLEO.LAST_UPDATED_BY,
  ChangeLineVLEO.LAST_UPDATE_DATE,
  ChangeLineVLEO.LAST_UPDATE_LOGIN,
  ChangeLineVLEO.REQUEST_ID,
  ChangeLineVLEO.PROGRAM_ID,
  ChangeLineVLEO.PROGRAM_APPLICATION_ID,
  ChangeLineVLEO.PROGRAM_UPDATE_DATE,
  ChangeLineVLEO.SEQUENCE_NUMBER,
  ChangeLineVLEO.CHANGE_TYPE_ID,
  ChangeLineVLEO.STATUS_CODE,
  ChangeLineVLEO.ASSIGNEE_ID,
  ChangeLineVLEO.ORIGINAL_SYSTEM_REFERENCE,
  ChangeLineVLEO.NAME,
  ChangeLineVLEO.DESCRIPTION,
  ChangeLineVLEO.CHANGE_ID,
  ChangeLineVLEO.NEED_BY_DATE,
  ChangeLineVLEO.SCHEDULED_DATE,
  ChangeLineVLEO.IMPLEMENTATION_DATE,
  ChangeLineVLEO.CANCELATION_DATE,
  ChangeLineVLEO.APPROVAL_STATUS_TYPE,
  ChangeLineVLEO.APPROVAL_DATE,
  ChangeLineVLEO.APPROVAL_REQUEST_DATE,
  ChangeLineVLEO.ROUTE_ID,
  ChangeLineVLEO.REQUIRED_FLAG,
  ChangeLineVLEO.COMPLETE_BEFORE_STATUS_CODE,
  ChangeLineVLEO.START_AFTER_STATUS_CODE,
  change_types.type_name change_type,
  ltrim(hzp.PARTY_NAME,'* ') ASSIGNEE,
  status_lookup.MEANING STATUS,
  'N' select_flag,
  0 show_hide_detail,
  null padded_subject,
  null subject_to_url,
  ecs1.STATUS_NAME COMPLETE_BEFORE_STATUS_NAME,
  ecs2.STATUS_NAME START_AFTER_STATUS_NAME,
  'N' as detail_attr,
  change_types_b.subject_id,
  estl.subject_name,
  'N' as multi_select_attr,
  
Eng_change_line_util.Get_concatenated_subjects(ChangeLineVLEO.change_id,
 ChangeLineVLEO.change_line_id, change_types_b.subject_id) as
Concatenated_Subject,
nvl((SELECT ECAV.DESCRIPTION
FROM ENG_CHANGE_ACTIONS_VL ECAV
WHERE ECAV.OBJECT_ID1=ChangeLineVLEO.change_id
AND ECAV.OBJECT_ID2= ChangeLineVLEO.change_line_id
AND ECAV.OBJECT_NAME='ENG_NEW_ITEM_REQUEST_LINES'
AND ECAV.ACTION_ID = (SELECT MAX (ACTION_ID)
FROM ENG_CHANGE_ACTIONS_VL ECAV1
WHERE ECAV1.OBJECT_ID1=ECAV.OBJECT_ID1
AND ECAV1.OBJECT_ID2= ECAV.OBJECT_ID2
AND ECAV1.OBJECT_NAME='ENG_NEW_ITEM_REQUEST_LINES'))
,'') NEW_ITEM_COMMENTS
,Eng_change_line_util.Get_Concatenated_Subjects_URL(ChangeLineVLEO.change_id,
 ChangeLineVLEO.change_line_id) as ConcatenatedSubjectUrl,
'status'||ChangeLineVLEO.status_code as status_status_code
FROM ENG_CHANGE_LINES_VL ChangeLineVLEO,
  eng_change_order_types change_types_b,
  ENG_CHANGE_ORDER_TYPES_TL change_types,
  HZ_PARTIES hzp,
  fnd_lookup_values status_lookup,
  eng_change_statuses_tl ecs1,
  eng_change_statuses_tl ecs2,
  eng_subjects_tl estl
WHERE ChangeLineVLEO.CHANGE_TYPE_ID =
change_types.CHANGE_ORDER_TYPE_ID(+)
  and ChangeLineVLEO.ASSIGNEE_ID = hzp.PARTY_ID(+)
  and ChangeLineVLEO.STATUS_CODE = status_lookup.LOOKUP_CODE
  and status_lookup.lookup_type = decode( (SELECT route_type_code
  FROM eng_change_routes
  WHERE route_id =
ChangeLineVLEO.route_id )
  , 'NOTIFICATION',
'ENG_DIST_LINE_STATUSES',
  'ENG_CHANGE_LINE_STATUSES')
  and status_lookup.language = USERENV('LANG')
  and ChangeLineVLEO.COMPLETE_BEFORE_STATUS_CODE = ecs1.status_code (+)
  and ChangeLineVLEO.START_AFTER_STATUS_CODE = ecs2.status_code (+)
  and estl.subject_id(+) = change_types_b.subject_id
  and estl.language(+) = userenv('LANG')
  and estl.language(+) = userenv('LANG')
  and ecs1.language(+) = userenv('LANG')
  and ecs2.language(+) = userenv('LANG')
  and change_types.language(+) = userenv('LANG')
  and
change_types.CHANGE_ORDER_TYPE_ID=change_types_b.CHANGE_ORDER_TYPE_ID(+))
 QRSLT WHERE (SEQUENCE_NUMBER <> :1) ORDER BY SEQUENCE_NUMBER

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