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

Last updated on APRIL 10, 2017

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

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