Asked By
Josh Pikee
0 points
N/A
Posted on - 06/20/2012
Â
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.
Import the transaction to Oracle EBS.
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.
-
First make sure that you backup all of your data just in case something bad happens and data might get corrupted.
-
From where you want to import the transactions, copy the transactions or an excel file and then save it.
-
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.
-
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.
Import the transaction to Oracle EBS.
Hello Josh,
First, backup all your data in case something wrong happens that may lead to the corruption of your data. Then copy the transactions on an Excel file and save it. Go to the oracle feature that says import and select "Excel file format". Browse the Excel file that you created earlier, open it and the transaction will work. For the auto-fill, just make a trigger for it that will does this automatically.
