My Oracle Support Banner

Unexpected Error Clicking On Organization Link (Doc ID 1553020.1)

Last updated on SEPTEMBER 27, 2019

Applies to:

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

Symptoms

In iSupplier Portal, when user navigates from Banking Details to organization, an unexpected error occurs:

Error

oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: select pv.vendor_name, pv.vendor_id, pv.party_id, pv.segment1,
psm.mapping_id as mapping_id, hp.party_name as Hz_Party_Name,
hp.DUNS_NUMBER_C, parent.vendor_name as parent_vendor_name,
parent.segment1 as parent_supplier_number, hp.known_as as Hz_party_alias ,
decode(pv.organization_type_lookup_code,'INDIVIDUAL',pv.individual_1099,
'FOREIGN INDIVIDUAL',pv.individual_1099, hp.jgzz_fiscal_code) as tax_payer_id,
decode(pv.federal_reportable_flag, 'Y', ait.DESCRIPTION, 'y', ait.description, '') as type_1099,
pv.vat_registration_num as tax_reg_no,
zptp.country_code as tax_country_code,
pv.ORGANIZATION_TYPE_LOOKUP_CODE
from ap_suppliers pv, hz_relationships hzr,
fnd_user fu, pos_supplier_mappings psm,
hz_parties hp, ap_suppliers parent,
ap_income_tax_types ait, zx_party_tax_profile zptp, hz_party_usg_assignments hpua
where pv.party_id = hzr.object_id
and hzr.object_type = 'ORGANIZATION'
and hzr.subject_id = fu.person_party_id
and hzr.subject_type = 'PERSON'
and hzr.relationship_type = 'CONTACT'
and hzr.relationship_code = 'CONTACT_OF'
and hzr.object_id = hp.party_id
and fu.user_id = :1
and (hzr.end_date is null or hzr.end_date > sysdate)
and hzr.status = 'A'
and ( pv.end_date_active is null or pv.end_date_active > sysdate )
and psm.vendor_id (+) = pv.vendor_id
and pv.parent_vendor_id = parent.vendor_id (+)
and ait.INCOME_TAX_TYPE (+) = pv.type_1099
and zptp.party_id (+) = pv.party_id
and zptp.party_type_code(+) = 'THIRD_PARTY'
and zptp.rep_registration_number(+) = pv.vat_registration_num
and hpua.party_id = fu.person_party_id
and hpua.status_flag = 'A'
and hpua.party_usage_code = 'SUPPLIER_CONTACT'
and (hpua.effective_end_date is null OR hpua.effective_end_date > sysdate)
jsp.runtimev2.JspServlet.internalService(JspServlet.java:594)
....
....
## Detail 0 ###
java.sql.SQLException: Missing IN or OUT parameter at index:: 1
at oracle.jdbc.driver.OraclePreparedStatement.processCompletedBindRow(OraclePreparedStatement.java:1783)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3444)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3493)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1491)
at oracle.jbo.server.QueryCollection.buildResultSet(QueryCollection.java:860)
at oracle.jbo.server.QueryCollection.executeQuery(QueryCollection.java:669)
...
...

 


Steps To Reproduce

1. User logs in into iSupplier Portal.
2. User selects Banking Details link.
3. Without changing any value, user selects Organization link.
4. Observe the Unexpected Error.


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.