Import Tool Returns FATAL ERROR When Importing New Data

(Doc ID 2232219.1)

Last updated on DECEMBER 18, 2017

Applies to:

Oracle Agile Product Collaboration - Version and later
Information in this document applies to any platform.


Actual Behavior

Import tool is getting a FATAL ERROR when importing item data. Customers are unable to update the items with the new values.

Expected Behavior

Import tool to complete without error.

Steps to Reproduce:

  1. Start Import Wizard
  2. Select Import file: test.xlsx
  3. Choose Excel File Configuration Options
    • Template Type: Level template
    • Selected Worksheet: Sheet1
    • Location of Header Row: 1
    • Location of Last Row: N/A
  4. Modify Preferences as followed tab: Parsing and Validation
    • Multilist Delimiter Character: semicolon (;)
    • Cascade Delimiter Character: Vertical bar (|)
    • Whitespace Validation Action: Strip
    • Case Validation Action: Convert
    • Length Validation Action: Truncate
    • Blank Data Action: Retain Data tab: Business Rule
    • Smart Rules Warning Violation Behavior: Accept objects
    • Reference Designator Quantity Mismatch Behavior: Accept
    • Behavior upon non-existing objects: Accept
    • Change Mode: Redlining
    • Redline Mode Behavior: New/Redlined items onto the change
    • BOM & AML import behavior: Import assys, amls and component
    • Multi Row Update Mode: Complete Replace
    • Price Quantity Break Default: No
    • Sourcing Project Qty Rollup: Yes
    • Reference Designator Range Character: -
    • Reference Designator Delimiter Character: comma (,)
  5. Click Save and then Next
  6. Select Content Options Select mapping file: NewMapFile_5_.xml Data Mapping :
    • Use a saved mapping file: NewMapFile_5_.xml
    Data Transformation
    • No transformations are necessary
    Redline Options
    • - Use the following Change for redlining: TIA-E-RIL000006
  7. Click Next - no further changes in screen Specify Attribute Mapping
  8. Click Next - no further changes in screen Review Import Definition
  9. Click: Import
  10. Receive error "Fatal error"


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