| Loading FND_FLEX_VALUES from text file [message #186175] |
Sun, 06 August 2006 17:38  |
gjones30
Messages: 5
Registered: July 2006
|
Junior Member |
|
|
|
Is there a way to load the FND_FLEX_VALUES table from a text file. We not moving from one instance to another which would entail using FNDLOAD. This is a new install and we have defined an independent value set and would like to define the valid values for the set. These values are contained in a flat-file. Is their an API or other loader available? Can we do a direct table update to FND_FLEX_VALUES and FND_FLEX_VALUES_TL?
|
|
|
|
|
|
 Re: Loading FND_FLEX_VALUES from text file [message #186533 is a reply to message #186175] |
Tue, 08 August 2006 06:33  |
David.K.Dickson
Messages: 413
Registered: October 2005
Location: Surrey, England
|
Senior Member |
|
|
Personally, I would recommend DataLoad. If your users can use Excel, they use DataLoad. All of the data is loaded through the Oracle Forms with the full validation that this provides.
The "Classic" version is free and uses Windows' Copy & Paste.
The "Professional" version, which is modestly priced, uses Oracle Forms' Record and Playback facilities and runs on the server. It is fast and ideal for large volumes and repetitive tasks. I have used "Professional" to load over 2,700 Cross-segment Validation Rule Elements into each of 14 Sets of Books, making a total of some 30,000 Elements in just over 4.25 hours, which is a rate of nearly 7,200 per hour. Having proved that this worked in TEST, I then repeated it in UAT and PROD just by FTP-ing the file to the appropriate server and logging in to the Oracle Applications with the appropriate Responsibility, which then ran the load for me.
 HTH
David
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
