R12:AP: iSupplier Portal Error out to Create Invoice with PO
(Doc ID 2627479.1)
Last updated on AUGUST 06, 2020
Applies to:Oracle Payables - Version 12.2.3 and later
Information in this document applies to any platform.
iSupplier portal error out to Create Invoice with PO
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (select Q.*,
nvl(to_char(length(TRIM(TRANSLATE(q.po_number_display, '0123456789', ' ')))), 'NUM') po_num_is_numeric,
nvl(to_char(length(TRIM(TRANSLATE(q.line_num, '0123456789', ' ')))), 'NUM') po_linenum_is_numeric
The issue can be reproduced at will with the following steps:
1. Navigate to iSupplier Portal>> Create Invoices
2. Enter Purchase Order Number, matched Invoice
3. Click the [Go] button to Create Invoice with PO
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!