My Oracle Support Banner

When Opening Requisition Approval Notification JBO-27122 Error Occurs (Doc ID 2257468.1)

Last updated on MAY 03, 2017

Applies to:

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

Symptoms

On 12.1.3 version when attempting to open notifications for Purchase Requisitions an error occurs

Exception Details.
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: select document_id, approver, sequence_num,
  approval_status, approval_status_label, approval_date,
  notes, business_group_name, css_style, rownum,
  approver_email, approval_group_name,
  approver_display_name, action_sort_column
from (
select document_id, approver, sequence_num,
  approval_status,
  approval_status_label, approval_date,
  notes, business_group_name,
  decode(approval_status, 'PENDING', 'OraDataText', 'OraInstructionText') as css_style,
  approver_email,
  nvl2( approval_group_id, por_ame_approval_list.get_approval_group_name(approval_group_id),'') as approval_group_name,
  null as approver_display_name,
  decode(approval_status, 'SUBMIT',1, 'SUBMIT CHANGE',1,
  'RESERVE',2, 'APPROVE',3, 'REJECT',4, 'NO ACTION',5, 'PENDING',6, 7) as action_sort_column
from por_approval_status_lines_v
where document_id = :1
order by approval_date, action_sort_column, sequence_num
)
at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:912)



STEPS
The issue can be reproduced at will with the following steps:
1. Open Notification to approve Requisition
2. Error occurs

 

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