Allocations Run in a Batch Fail with 'ORA-01480: Trailing Null Missing from STR Bind Value' (Doc ID 1451766.1)

Last updated on AUGUST 07, 2017

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 7.2.9 and later
Oracle Financial Services Profitability Management - Version 5.6 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

In Oracle Financial Services Analytical Applications (OFSAA), when you run a large number of Profitability Management (PFT) Allocations using a regular Batch or a Simplified Batch, Allocations fail after reaching a certain task number (ex. Task10, Task100, etc.) with the following error message in the $FIC_DB_HOME/log/FusionApps/ofspa.xxxxxxxx.log:

Module Logging OFS errors: (203105) Oracle drv_oci error: OCI Function: [4] - oexec(),
oexn() SQL Function: [3] -
INSERT Oracle Error: ORA- 01480: trailing null missing
from STR bind value Driver Function: drv_oci::Execute() SQL
Statement:
insert into FSI_MESSAGE_LOG(BATCH_RUN_ID, PROCESS_ID, SEQUENCES,
MSG_TIMESTAMP, MESSAGE_CD, MSG_SEVERITY_CD,
CONTEXT_SPECIFIC_TEXT)
values (:BATCH_RUN_ID, :PROCESS_ID, :SEQUENCES, :MSG_TIMESTAMP,
:MESSAGE_CD, :MSG_SEVERITY_CD, :CONTEXT_SPECIFIC_TEXT )


Module Logging OFS errors: (203055) Error Bound Parameters: :BATCH_RUN_ID =
OFSAAIN_Task100_TP_ALLOC_LEDGER_CHARGE_CREDIT_20111218_
:PROCESS_ID = 210189 :SEQUENCES = 2 :MSG_TIMESTAMP = 02/ 29/ 2012
15:43:46 :MESSAGE_CD = 20005 :MSG_SEVERITY_CD = 40
:CONTEXT_SPECIFIC_TEXT = ???(203105) Oracle drv_oci error: SQL
statement.

Module Logging OFS errors: (203055) Error Executing SQL statement.

If you run the Allocations individually (outside of the batch), no error occurs.

The error can occur in different situations.  For example, it can occur when running a Simplified Batch that includes over 100+ Allocations where the 100th Task fails.  However, you also get the same error when running a standard batch with 10 tasks where the 10th task fails.

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