Rxi Reports Complete in Error With 'get_summary_info_stmt' and ORA-01480 (Doc ID 1499519.1)

Last updated on MARCH 24, 2016

Applies to:

Oracle Assets - Version 12.0.0 to 12.1.3 [Release 12 to 12.1]
Information in this document applies to any platform.
Rxi reports

Symptoms

When attempting to run Rxi reports such as the FARXBK module: RXi: Fixed Assets Book, the following error occurs.

ERROR
-----------------------
Publishing concurrent program OFA : RXFABK.
Publishing request ID 4398996.
Its not a BIDI char set
Its not a BIDI language
Error executing cursor.
ORA-01480: trailing null missing from STR bind value
ORA-01480: trailing null missing from STR bind value
ERROR: Unable to execute cursor in farxplsf(get_summary_info_stmt)
ORA-01480: trailing null missing from STR bind value

This error affects all Rxi reports.

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