When Using Primavera Gateway to Import Data Into P6 Using the File Provider the Process Completes Successfully but No Data Is Created in P6 (Doc ID 2284443.1)

Last updated on JULY 07, 2017

Applies to:

Primavera Gateway - Version 16.1.0.0 and later
Information in this document applies to any platform.

Symptoms

When trying to import data from a file into P6, the synchronization shows as completing successfully but no data is imported into P6. For example, when trying to import a resource hierarchy from a csv file into P6 no resources are created in P6.

STEPS
-----------------------
An example of this issue can be reproduced at will with the following steps:

       1. In Gateway create a CSV File Provider using File Upload.

       2. Create a CSV that contains the fields and data that will be imported into P6. For example,

ON,Resource,,,,,,,,,,,
FH,OfficePhone,DefaultUnitsPerTime,ObjectId,Title,ResourceType,CalendarName,EmailAddress,Name,LocationName,Id,EmployeeId,ParentObjectId
DR,,0,-100,,Labor,Calendar1,,Resource 01,,R01,,
DR,,0,-101,,Labor,Calendar1,,Resource 011,,R011,,-100
DR,,0,-102,,Labor,Calendar1,,Resource 012,,R012,,-100
DR,,0,-103,,Labor,Calendar1,,Resource 011A,,R011A,,-101
DR,,0,-104,,Labor,Calendar1,,Resource 011B,,R011B,,-101
DR,,0,-105,,Labor,Calendar1,,Resource 012A,,R012A,,-102
DR,,0,-106,,Labor,Calendar1,,Resource 012B,,R012B,,-102

        3. Create a Master Business Flow that maps Resources

        4. Create a synchronization using the new Business Flow and upload the CSV created in Step #1.

        5. See that the data is never loaded in the Convert from Source To Gateway format step.

 

Changes

 

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