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.
On 12.1.3 version when attempting to open notifications for Purchase Requisitions an error occurs
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,
select document_id, approver, sequence_num,
decode(approval_status, 'PENDING', 'OraDataText', 'OraInstructionText') as css_style,
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
where document_id = :1
order by approval_date, action_sort_column, sequence_num
The issue can be reproduced at will with the following steps:
1. Open Notification to approve Requisition
2. Error occurs
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