Tuesday, April 7, 2009

Oracle API to populate Lookup Table from CSV fle.

Oracle API to populate FND Lookup Table from CSV file.

This task can be useful if your business users have a habit to keep their business rules data in MS Excel.

Here all will come together - reading file, split string and calling Oracle APIs.


To be Continued..

2 comments:

Anonymous said...

What is the name of the Oracle API used to populate the Lookup Table?

Mark Mestetskiy said...

APIs are:

fnd_lookup_types_pkg.TRANSLATE_ROW
and
fnd_lookup_types_pkg.LOAD_ROW

Post a Comment