Error Accessing the Requirements Link From the Contract File JBO-27122 ORA-01722 (Doc ID 1910374.1)

Last updated on NOVEMBER 23, 2015

Applies to:

Oracle Contract Lifecycle Management for Public Sector - Version 12.2.3 and later
Information in this document applies to any platform.

Symptoms

An unexpected error occurs when accessing the Requirements link from the
Contract File:

Error:

oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException:
JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM
(SELECT
 ca.assignment_number document_number,
 'Work Load Assignment' document_type,
 ca.assignment_id document_id,
 plc.displayed_field status,
 To_date(ca.creation_date,'DD/MM/YYYY') creation_date
FROM po_clm_assignments ca,
  po_lookup_codes plc
WHERE ca.assignment_status = plc.lookup_code
  AND plc.lookup_type = 'CLM_ASSIGNMENT_STATUSES'
  AND plc.enabled_flag = 'Y') QRSLT WHERE DOCUMENT_ID IN ( (SELECT
prl.assignment_number FROM
po_requisition_lines_all prl,
po_req_distributions_all prd,
po_distributions_all pd WHERE
prl.requisition_line_id =prd.requisition_line_id
  AND prd.distribution_id =pd.req_distribution_id  
AND pd.po_header_id = :Bind_document_id AND
'Award/IDV' = :Bind_contract_file_type) union all
(SELECT prl.assignment_number FROM
po_requisition_lines_all prl,
pon_backing_requisitions pbr WHERE
prl.requisition_header_id = pbr.requisition_header_id
  AND pbr.auction_header_id =:Bind_document_id
  AND'Solicitation' = :Bind_contract_file_type) union all (SELECT
prl.assignment_number FROM
po_requisition_lines_all prl, po_lines_all pl
  WHERE prl.po_line_id = pl.po_line_id
AND pl.po_header_id = :Bind_document_id
AND 'Award/IDV' = :Bind_contract_file_type) )
[...]
java.sql.SQLSyntaxErrorException: ORA-01722: invalid number.
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:931)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:481)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:205)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:548)

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