My Oracle Support Banner

R12:AP: iSupplier Portal Error out to Create Invoice with PO (Doc ID 2627479.1)

Last updated on JULY 16, 2022

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

Error Page
Exception Details.
 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!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.