Changing Requestor On Requisition Gives Message: JBO-27122 java.sql.SQLException: Invalid Column Index (Doc ID 2061448.1)

Last updated on OCTOBER 28, 2015

Applies to:

Oracle iProcurement - Version 12.2.4 and later
Information in this document applies to any platform.

Symptoms

Release 12.2.

When creating a requisition in iProcurement and trying to update the requestor an error occurs to contact the system administrator.

Error Page
Exception Details.
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT pec.full_name,
  pec.last_name,
  pec.first_name,
  pec.email_address,
  pec.employee_num,
  pec.location_id,
  null AS location_code,
  to_number(:1) AS inventory_organization_id,
  hr_general.get_work_phone(pec.employee_id) AS phone,
  hr_general.get_phone_number(pec.employee_id, 'WF') AS fax,
  t1.name AS hr_org,
  t2.name AS business_group,
  null AS address,
  papf.full_name AS supervisor_name,
  pec.employee_id AS requester_id
FROM per_employees_current_x pec,
  hr_all_organization_units_tl t1,
  hr_all_organization_units_tl t2,
  per_all_people_f papf
WHERE pec.location_id is null AND
  pec.business_group_id = :2 AND
  t1.organization_id = pec.organization_id AND
  t1.language = :3 AND
  t2.organization_id = pec.business_group_id AND
  t2.language = :4 AND
  papf.person_id(+) = pec.supervisor_id AND
  (trunc(sysdate) between trunc(nvl(papf.effective_start_date, sysdate)) and trunc(nvl(papf.effective_end_date, sysdate)))

UNION ALL

SELECT pec.full_name,
  pec.last_name,
  pec.first_name,
  pec.email_address,
  pec.employee_num,
  pec.location_id,
  hrlt.location_code,
  nvl(hrl.inventory_organization_id, :5) AS inventory_organization_id,
  hr_general.get_work_phone(pec.employee_id) AS phone,
  hr_general.get_phone_number(pec.employee_id, 'WF') AS fax,
  t1.name AS hr_org,
  t2.name AS business_group,
  PO_POAPPROVAL_INIT1.Get_Formatted_Address(hrl.location_id) AS address,
  papf.full_name AS supervisor_name,
  pec.employee_id AS requester_id
FROM per_employees_current_x pec,
  hr_locations_all hrl,
  hr_locations_all_tl hrlt,
  hr_all_organization_units_tl t1,
  hr_all_organization_units_tl t2,
  per_all_people_f papf
WHERE pec.location_id = hrl.location_id AND
  pec.business_group_id = :6 AND
  hrl.location_id = hrlt.location_id AND
  hrlt.language = :7 AND
  t1.organization_id = pec.organization_id AND
  t1.language = :8 AND
  t2.organization_id = pec.business_group_id AND
  t2.language = :9 AND
  papf.person_id(+) = pec.supervisor_id AND
  (trunc(sysdate) between trunc(nvl(papf.effective_start_date, sysdate)) and trunc(nvl(papf.effective_end_date, sysdate)))) QRSLT WHERE (( UPPER(FULL_NAME) like UPPER(:19) AND (FULL_NAME like :20 OR FULL_NAME like :21 OR FULL_NAME like :22 OR FULL_NAME like :23)))
.......................
## Detail 0 ##
java.sql.SQLException: Invalid column index

Error Stack:
## Detail 0 ## java.sql.SQLException: ORA-01407: cannot update ("PO"."PO_REQUISITION_LINES_ALL"."TO_PERSON_ID") to NULL ORA-06512: at line 1 at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)

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