JBO-27122 Trying to Assign Content Items In Supplementary Data Source View In Bill Presentment Architecture Template (Doc ID 2823574.1)

Last updated on NOVEMBER 15, 2023

Applies to:

Oracle Bill Presentment Architecture - Version 12.1.3 and later
Information in this document applies to any platform.

(a) Unable to assign content items from multiple data source views on BPA template due to OAF error JBO-27122

Navigation: BPA responsibility > Templates > Query Template > Update > Next > Click on Select Content and Layout for one of the areas >

Data Source View = Customer Transaction Data Source: Customer Header View > Click GO > get error:

-or-

(b) Getting ORA-01722: invalid number error when trying to update header section with custom view

-or-

(c) When attempting to update the BPA templates after upgraded from 12.1.3. to 12.2.8, the following error can occur:

"You have encountered an unexpected error. Please contact your System Administrator for assistance."

The "JBO-27122: SQL error during statement preparation" error is also present in FND debug log file.

	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

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