Collect Planning Data - Scheduled (ESS) Process Fails With:- ORGANIZATIONS : ORA-01722: invalid number (Doc ID 2226145.1)

Last updated on FEBRUARY 20, 2017

Applies to:

Oracle Fusion Order Management Cloud Service - Version 11.1.11.1.0 and later
Oracle Fusion Planning Central Cloud Service - Version 11.1.11.1.0 and later
Oracle Fusion Global Order Promising - Version 11.1.11.1.0 and later
Information in this document applies to any platform.
***KM Review - Dec 2016 - Checked for Relevance***

Symptoms

Executing the - Collect Planning Data -  task completes with an error, this is shown in the ESS process Log file:

ORGANIZATIONS : ORA-01722: invalid number

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