ISupplier Page Export Functionality Is in Error: JBO-27122

(Doc ID 2369565.1)

Last updated on MARCH 05, 2018

Applies to:

Oracle iSupplier Portal - Version 12.1 to 12.2 [Release 12.1 to 12.2]
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Other Issues

When attempting to export orders,
the following error occurs.

ERROR
-----------------------
Error Page
Exception Details.
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation.
Statement: SELECT * FROM (select 'Select_flag',
poh.po_num,
poh.comments,
poh.creation_date,
poh.po_release_id,
to_char(null) agent_name,
poh.currency_code,
to_char(0) as amount,
poh.ACCEPTANCE_DUE_DATE,
poh.vendor_id,
poh.po_header_id,
poh.agent_id,
poh.type_lookup_code,
poh.type_name,
poh.vendor_contact_id,
poh.vendor_site_id,
poh.acceptance_required_flag,
poh.approved_date,
poh.revision_num,
to_char(null) PO_STATUS_CODE ,
to_char(null) PO_STATUS_DISP ,
poh.org_name,
poh.attribute1,
poh.attribute2,
poh.attribute3,
poh.attribute4,
poh.attribute5,
poh.attribute6,
poh.attribute7,
poh.attribute8,
poh.attribute9,
poh.attribute10,
poh.attribute11,
poh.attribute12,
poh.attribute13,
poh.attribute14,
poh.attribute15,
poh.attribute_category,
decode(poh.po_release_id,null,'PosHdrAttach','PosRelAttach') as SwitchAttach,
'N' as retrieve_flag,
poh.CANCEL_FLAG,
poh.CLOSED_CODE,
poh.FROZEN_FLAG,
poh.USER_HOLD_FLAG,
poh.global_agreement_flag,
to_char(null) consigned_consumption_flag,
poh.vendor_name,
poh.vendor_site_code,
poh.po_release_id po_release_id2,
poh.vendor_number ,
poh.vendor_id vendor_id2, org_id,
poh.segment1,
poh.release_num,
to_char(null) business_document_type,
to_char(null) business_document_id,
to_char(null) business_document_version,
0 as ship_to_location_id,
security_level_code,
access_level_code
from pos_view_po_summary_v poh
where poh.type_name <> 'Blanket Agreement') QRSLT WHERE (( ORG_NAME like :1 AND VENDOR_NAME = :2) AND ( (((agent_id = 19038) OR ( ( (access_level_code IS NULL OR access_level_code = 'FULL') OR (access_level_code = 'VIEW_ONLY' AND 'VIEW_ONLY' NOT IN ('MODIFY','FULL')) OR (access_level_code = 'MODIFY' AND 'VIEW_ONLY'<> 'FULL')) AND ( (security_level_code = 'PUBLIC') OR (security_level_code IN ('PRIVATE', 'PURCHASING', 'HIERARCHY') AND EXISTS ( SELECT 'Employee is in approval path of this document' FROM PO_ACTION_HISTORY POAH WHERE POAH.employee_id = 19038 AND POAH.object_type_code IN ('PO', 'PA') AND POAH.object_id = po_header_id) ) OR (security_level_code = 'PURCHASING' AND EXISTS ( SELECT 'User is a BUYER' FROM po_agents poa WHERE poa.agent_id = 19038 AND SYSDATE BETWEEN NVL(POA.start_date_active, SYSDATE) AND NVL(POA.end_date_active, SYSDATE + 1)) ) OR (security_level_code = 'HIERARCHY' AND EXISTS ( SELECT 'User exists in the HIERARCHY' FROM (SELECT org_id poeh_org_id, position_structure_id, employee_id, superior_id FROM po_employee_hierarchies) poeh, (SELECT org_id psp_org_id, security_position_structure_id FROM po_system_parameters_all) psp WHERE poeh.superior_id = 19038 AND psp.psp_org_id = org_id AND poeh.employee_id = agent_id AND poeh.position_structure_id = NVL(psp.security_position_structure_id,-1) )) ) ) )) and mo_global.check_access(ORG_ID) = 'Y' )) ORDER BY approved_date desc
at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:912)
at oracle.apps.fnd.framework.webui.OAPageErrorHandler.prepareException(OAPageErrorHandler.java:1169)
at oracle.apps.fnd.framework.webui.OAPageErrorHandler.processErrors(OAPageErrorHandler.java:1435)
.
.
at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)
at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)
at java.lang.Thread.run(Thread.java:745)
## Detail 0 ##
java.sql.SQLException: Invalid column type
at oracle.jdbc.driver.OraclePreparedStatement.setObjectCritical(OraclePreparedStatement.java:8516)
at oracle.jdbc.driver.OraclePreparedStatement.setObjectInternal(OraclePreparedStatement.java:8034)
at oracle.jdbc.driver.OraclePreparedStatement.setObjectInternal(OraclePreparedStatement.java:8767)
at oracle.jdbc.driver.OraclePreparedStatement.setObject(OraclePreparedStatement.java:8748)

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Navigation : Login -> Orders -> Export



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