My Oracle Support Banner

PBCS: Data Management in PBCS Unable to Load Text Type Data (Doc ID 2094164.1)

Last updated on APRIL 01, 2019

Applies to:

Oracle Planning and Budgeting Cloud Service - Version 15.12.34 and later
Information in this document applies to any platform.

Symptoms

Data Management in PBCS cannot load Text Type Data.

When loading the Text Type Data from the file-based source to the target of Planning in PBCS, execution log results 'Rows Rejected' and it loads only numeric data.

Ex)
1. Load the following Sample data.
  V10,FY30,M01,M1,IN001,LOCAL_CUR,ICP_None,PJ_None,PR_None,PRD001,S001_X,DEPT_None,ADJ,CLT_01,100,200,300,400
  UD1,UD2,UD3,UD4,ACCOUNT,UD6,UD7,UD8,UD9,UD10,ENTITY,UD12,UD13,UD14,Data1,Data2,Data3,Data4

  - 100,200,300,400 are numeric data.
  - Data1,Data2,Data3,Data4 are text type data

2. Results of execution log.
  Rows Loaded: 1
  Rows Rejected: 1

3. It loads only numeric data.
  Rows Loaded:
  V10,FY30,M01,M1,IN001,LOCAL_CUR,ICP_None,PJ_None,PR_None,PRD001,S001_X,DEPT_None,ADJ,CLT_01,100,200,300,400

  Rows Rejected:
  UD1,UD2,UD3,UD4,ACCOUNT,UD6,UD7,UD8,UD9,UD10,ENTITY,UD12,UD13,UD14,Data1,Data2,Data3,Data4

 

 

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.