You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Need a worked example of sample EBS SQL queries for loading Asset Categories

edited May 18, 2020 1:09PM in Assets 2 comments

Summary

Need a worked example of sample EBS SQL queries for loading Asset Categories

Content

Hi,

We are moving setups related information from EBS to Fusion via CSV load.

I have a requirement to load asset categories. I do not have the neccessary SQL queries to extract data from EBS to load to Fusion.

There are 4 different CSVs that we need to upload to load asset category.

FA_ASSET_CATEGORY, FA_ASSET_CATEGORY_BOOKS, FA_ASSET_CATEGORY_TRANSLATION and ORA_FA_ASSET_CATEGORY_BOOK_DEF

Need help with the same.

Can anyone please provide sample working extraction queries from EBS.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!