Data Extract for Item Extensible Flexfields - Oracle RODS

This article explains how to extract Item Extensible Flexfields (EFF) data from Oracle Fusion using Oracle RODS.

1. Navigate to Flexfield Management

Go to Setup and Maintenance -->  Search, and search for Manage Extensible Flexfields.




2. Deploy the Item Flexfield
Search for the Item Flexfield code EGO_ITEM_EFF.
Select it and click Deploy Flexfield to publish its attributes to RODS business views.


3. Open Data Extraction
In Oracle Fusion, navigate to Tools --> Data Extraction.


4. Create a New Data Extract
Click to create a new data extract definition.


5. Configure Extract Details & Select Attributes
  • Enter a Name and Description for the extract.
  • Specify an Initial Extract Date if required. 
  • Under the Product Lifecycle Management category, select Item extended attribute views.
  • Choose the specific attributes you want to include in the extract.




6. Schedule the Extract
Set up the schedule options for running the data extract job.


7. Verify & Download Extracted Data
Monitor the scheduled job to confirm successful completion, then download the generated data files.




No comments:

Post a Comment