JBO-27122 Error Occurs While Clicking Review Icon for Prospective Supplier Registration Requests (Doc ID 2082625.1)

Last updated on NOVEMBER 25, 2015

Applies to:

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

Symptoms

On : 12.1.3 version, Supplier Registration Issues

When attempting to click review icon from Prospective Supplier Registration page
the following error occurs.

ERROR
-----------------------
 oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation.
Statement: SELECT ROWNUM Num,tbl.* FROM ( SELECT CASE WHEN pos.action_code IN
('SUBMIT') THEN fnd_message.get_string('POS','POS_PROSPECTIVE_SUPPLIER') ELSE
( SELECT full_name FROM per_all_people_f WHERE person_id = from_user AND
TRUNC(sysdate) BETWEEN effective_start_date(+) AND effective_end_date(+)) END
FromUserName, ( SELECT full_name FROM per_all_people_f WHERE person_id =
to_user AND TRUNC(sysdate) BETWEEN effective_start_date(+) AND
 effective_end_date(+) ) ToUserName, fnd.MEANING Action, pos.ACTION_DATE
ActionDate, pos.NOTE Note, Decode ( pos.action_code, 'PENDING_APPROVAL', 'Y',
'N' ) is_current_approver FROM pos_action_history pos, fnd_lookup_values fnd
WHERE pos.action_code = fnd.LOOKUP_CODE AND fnd.lookup_type =
'POS_REG_STATUSES' AND fnd.LANGUAGE = USERENV('LANG') AND
nvl(fnd.enabled_flag, 'N') = 'Y' AND SYSDATE BETWEEN
NVL(fnd.START_DATE_ACTIVE, SYSDATE - 1) AND NVL(fnd.END_DATE_ACTIVE, SYSDATE
+ 1) --AND pos.action_code <> 'DRAFT' AND OBJECT_ID = :1 ORDER BY
ACTION_DATE,sequence_num ) tbl ORDER BY Num desc;

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Move to Responsibility: Supplier Management Administrator
2. Supplier Home - To do lists
3. Prospective Supplier Registrations
4. Locate Supplier Name and Click: Review icon

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