My Oracle Support Banner

FA:SCP: OTBI Reports Not Returning Results for Some Supply Plans (Doc ID 2781323.1)

Last updated on MAY 06, 2022

Applies to:

Oracle Fusion Planning Central Cloud Service - Version 11.13.21.01.0 and later
Information in this document applies to any platform.

Symptoms

OTBI Reports Not Returning Results for Some Supply Plans.  For example, seeded report "Order Details by Item"

The following error noticed in MscAnalyticETL child job of the plan run.

Inside populate_analytic_tables 
in populating msc_analytic_items ORA-0000: normal, successful completion
Exception occured in populating msc_analytic_items ORA-12899: value too large for column ??? (actual: 33, maximum: 32)
Exception occured in populating msc_analytic_end_demands ORA-12899: value too large for column ??? (actual: 33, maximum: 32)

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.