1. Scheduled Processes for SCM
  2. Import Product Genealogy FBDI

Import Product Genealogy FBDI

Oracle Fusion Cloud Maintenance enables you to create product genealogy instance and structures in bulk using a File-Based Data Import (FBDI).

Product genealogy enables you to capture and view the genealogy data for various transactions related to lot control enabled and serialized products and components. The transactions can be inventory transactions, work order operation transactions, and work order material transactions. You can track the product genealogy data throughout the complete life cycle starting from raw material to finished product and then to the customer.

Note: For more details, refer to the File-Based Data Import for SCM guide.

When to Use

The Import Product Genealogy process is used to:

  • Create and update genealogy instances
  • Update a genealogy instance component structure
  • Create transaction history

The following are the major steps involved in the import process:

  • Download and update the latest spreadsheet for your update.
  • Transfer data to the interface tables.
  • Run the import product genealogy scheduled process.
  • Verify the process output logs.

Download and Update the Spreadsheet

Download the spreadsheet template that's available in the File-Based Data Import for SCM guide. Update the spreadsheet with the import data.

The spreadsheet template organizes the information in these tabs:

  • Import Batch: Enables you to create the import batch in which the genealogy records are grouped for processing.
  • Genealogy: Enables you to provide the details used to create and update genealogy history

Transfer Data to the Interface Tables

On the General Instructions tab, click the Generate CSV File button to transfer the data into a .ZIP file with one or more .CSV files. Use the Load Interface File for Import scheduled process to upload the .ZIP file to the server for transferring the data to the interface tables. The scheduled process is also accessible from the Tasks pane on the Maintenance Management landing page.

Run the Import Product Genealogy Scheduled Process

The next step is to run the Import Produce Genealogy scheduled process to transfer the data from interface tables to the production tables. The process will reference the import batch number defined in the uploaded spreadsheet.

Review the output logs from the import process. If any errors where encountered, they will be contained in a separate log file.

Purge Batch Data from Import Interfaces

The upload or import of data may result in a warning or error status sue to issues with the data. When this occurs, the data can't be further processed from the interface tables. In such a case, the asset administrator can run the Purge Records from Interface process to delete the asset data from the interface tables from all or just a specific import process. The scheduled process can be run on demand or setup on a schedule as required by your business processes.

Privileges Required

Verify that you have the following privileges to upload the FBDI files using the Load Interface File for Import scheduled process:

  • Privileges:
    • FUN_FSCM_FILE_TO_INTERFACE_PRIV
    • FUN_FSCM_LOAD_INTERFACES_PRIV
    • FND_MANAGE_FILE_IMPORT_AND_EXPORT_PRIV
    • FUN_FSCM_TRANSFER_FILE_PRIV
  • Privilege: CSE_IMPORT_PRODUCT_GENEALOGY_PRIV

Specifications

Use these specifications when you run the scheduled process.

Specification Description
Job Type Adhoc, you only run after importing an FBDI file for a unique import batch number.
Frequency As needed, after importing the FBDI file.
Time of Day Any time.
Duration Typically, less than a few minutes, depending on the volume of data being created or updated.
Compatibility There should be only one instance of the job running at any one time for a unique import batch number. A new job should only be submitted for another unique batch number after the previous one has completed, and the output logs have been reviewed.

Parameters

The process will typically be run adhoc by selecting the batch number.

Parameter Optional or Required Description Parameter Value Special Combinations Required
Batch (number) Required The unique import batch number in which the meter readings records are grouped for processing in the interface tables. A list of values will display all batch numbers that are ready for import. None

Troubleshooting Information

Try this:

  • Import file creation:
    • You must create the file directly from the source Excel template by following the instructions on the first tab of the file. This will create a .ZIP file that is used for import.
  • File import using the Load Interface File for Import scheduled process:
    • You can schedule a new adhoc process to select and load the file into the interface tables.
    • You can view the status of the Load Interface File for Import process on the Scheduled Processes UI.
    • The process will spawn multiple child processes to transfer the .ZIP file and load data from each of the .CSV files contained in the .ZIP file.
    • If any of the processes end in Warning or Error status, review their output logs. You may need to correct the data in the import file, define a new unique batch number, and start the process again by uploading the new .ZIP file.
  • File processing using the Import Maintenance Work Definitions schedule process:
    • You can schedule a new adhoc process to select and load the file into the interface tables.
    • You can view the status of the Import Maintenance Work Definitions process on the Scheduled Processes UI.
    • The process will spawn a child process to import the data and process it from the interface tables.
    • If any of the processes end in Warning or Error status, review their output logs. You may need to correct the data in the import file, define a new unique batch number, and start the process again by uploading the new .ZIP file and then processing the file.

Related Topics