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:

  1. What is the name of the Oracle API used to populate the Lookup Table?
    ReplyDelete
  2. APIs are:

    fnd_lookup_types_pkg.TRANSLATE_ROW
    and
    fnd_lookup_types_pkg.LOAD_ROW
    ReplyDelete