Home > Solution Categories > Database > Oracle Database > Import the transaction to Oracle EBS.
Question
No of visitors who read this post: 264
Category: Oracle Database
Type: Question
Author: Josh Pikee
No votes yet

Hi,

I want to import the transaction to Oracle EBS. And along with that I would also like to use the auto fill function to fill the legal values of the various COA / Key flex fields. Can this be achieved?

I’m planning to do this because our operating system on the source have some flex field values that are very unpredictable. We would like to be very careful about this as we want to protect the transactions with missing segment value to go to EBS.

Please give any suggestions. Thank you.

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.

#

Submitted by Parsh Auguston on Thu, 2012-08-09 14:31. Comment Id: 76586

You can surely do the importing stuff but the other auto fill thing is a bit messy and there is no simple way for it to do.

  1. First make sure that you backup all of your data just in case something bad happens and data might get corrupted.
  2. From where you want to import the transactions, copy the transactions or an excel file and then save it.
  3. Now go to the oracle feature which says import. In it, select the Excel file format and browse to the location of the excel file which we just created. Open it and it is all done.
  4. About the auto fill, you have to make a trigger for it that does this automatically or you have to define the properties of that particular attribute.
Previous Previous Page
90 of 233
Next Page Next