Import the transaction to Oracle EBS.

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.

• Status: Open
• Question Views: 1148
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: Oracle Database

Best Answer by Parsh Auguston

Go To Solution

Best Answer

Best Answer

Answered By Parsh Auguston 0 points N/A #144792

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.

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.

About Parsh Auguston

Questions
2

Answers
152

Best Answers
12

• Vote Up 0 Vote Down

• Posted on - 08/09/2012
• Question Category: Oracle Database

Answered By Manning Wickersham 0 points N/A #144794

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.

About Manning Wickersham

Questions
1

Answers
33

Best Answers
3

• Vote Up 0 Vote Down

• Posted on - 05/21/2013
• Question Category: Oracle Database