My Oracle Support Banner

While Generating CSV file for 'Import Projects' FBDI file getting an error run-time '1004' error. Impossible to set the property 'NumberFormat' for range class (Doc ID 2390523.1)

Last updated on NOVEMBER 11, 2019

Applies to:

Oracle Fusion Project Foundation Cloud Service - Version 11.13.17.11.0 and later
Information in this document applies to any platform.

Symptoms

On : 11.13.17.11.0 version, Other Issues

Import Project

Hi,

I am having a serious problem with the template that allows to import projects.

Infact everytime I populate the fields in a massive way the system generates this error: ' run-time '1004' error. Impossible to set the property 'NumberFormat' for range class.'

I am using templates related to R13 (Template for R17D in Production environment and Template for R18A in Development environment) but the error is always the same.

If I use the template related to R12 this error doesn't appear and the csv file is generated in the correct way. I have to import 300000 projects and 600000 tasks so it's really really important that the spreadsheet works in the correct way.

Attached the file of R12 and R13.

Looking forward to hearing from you.



ERROR
-----------------------

' run-time '1004' error. Impossible to set the property 'NumberFormat' for range class.'




STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. I am using templates related to R13 (Template for R17D in Production environment and Template for R18A in Development environment) but the error is always the same.

If I use the template related to R12 this error doesn't appear and the csv file is generated in the correct way. I have to import 300000 projects and 600000 tasks so it's really really important that the spreadsheet works in the correct way.


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot load the projects using FBDI

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.