My Oracle Support Banner

BPA: Have Encountered Unexpected Error. Please Contact System Administrator For Assistance (Doc ID 3071358.1)

Last updated on MARCH 06, 2025

Applies to:

Oracle Receivables - Version 12.2.12 and later
Information in this document applies to any platform.

Symptoms

When attempting to upload a new external template in Bill Management (BPA) the following error occurs:

ERROR
-----------------------

You have encountered an unexpected error. Please contact your system administrator for assistance.



The issue can be reproduced at will with the following steps:
Responsibility: Bill Presentment Super User
Navigation: Bill Management > Filter through Primary data source with "Oracle Receivables"
1. Select the update icon for an existing template
2. Click "Clear" to remove the template
3. Upload a new template and click next
4. The error shows up


The JBO error can be found in the FND Debug/Java stack

FND Debug and Java stack error shows the following error:

JBO-27122: SQL error during statement preparation.

SELECT * FROM (SELECT item.item_id,
item.item_name,
NVL(item.item_code, item.item_name) item_code,
item.seeded_application_id,
item.display_level,
NVL(item.data_source_id,-99) data_source_id ,
Item.SEEDED_APPLICATION_ID||':'||
NVL(Item.DATA_SOURCE_ID,-99)||':'||
item.DISPLAY_LEVEL DATA_SOURCE_KEY,
LENGTH(NVL(item.item_code, item.item_name))
length_item_code,
DS.source_line_type template_format
FROM ar_bpa_items_vl item,
AR_BPA_DATA_SOURCES_b ds
WHERE NVL(item.display_enabled_flag,'N') = 'Y'
AND NVL(flexfield_item_flag,'N') = 'N'
AND item_type <> 'I'
AND item.data_source_id = ds.data_source_id(+)
UNION ALL
SELECT item.item_id,
item.item_name,
NVL(item.item_code, item.item_name) item_code,
item.seeded_application_id,
item.display_level,
-98 data_source_id ,
Item.SEEDED_APPLICATION_ID||':'||
-98||':'||
item.DISPLAY_LEVEL DATA_SOURCE_KEY,
LENGTH(NVL(item.item_code, item.item_name))
length_item_code,
null as template_format
FROM ar_bpa_items_vl item
WHERE NVL(item.display_enabled_flag,'N') = 'Y'
AND NVL(flexfield_item_flag,'N') = 'Y') QRSLT WHERE (DISPLAY_LEVEL NOT IN ('T','D') AND SEEDED_APPLICATION_ID = :1:2,:3, )) ORDER BY DECODE(SEEDED_APPLICATION_ID, 222,1, -1, 3, 2), DECODE(DISPLAY_LEVEL,'H',1,'L',2), ITEM_CODE"

 

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.