My Oracle Support Banner

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

Last updated on FEBRUARY 25, 2019

Applies to:

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

Symptoms

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.
Why does this problem occur 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 button
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,
.
.
.
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

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.