Oracle Applications :CRM:Service Contracts Import Part -1

List of Interface Tables:

OKS_HEADERS_INTERFACE

This table must be populated with all Header details,along with the batch                        number.Header_interface_id is the primary key to all the other interface tables.

OKS_LINES_INTERFACE

             This table must be populated with the line details,with proper header_interface_id .

Line_interface_id is the primary key.Populate the Header_interface_id from oks_headers_interface.

OKS_COVERED_LEVELS_INTERFACE

             This table should be populated with all covered level details.covered_level_interface_id is the primary key.Populate line_interface_id from the oks_lines_interface.

OKS_USAGE_COUNTERS_INTERFACE

               This table must be populated with the counter details. Usage_counter_interface_id is the primary key for this table.Line_interface_id must be populated from oks_lines_interface.

OKS_SALES_CREDITS_INTERFACE

                    This should be populated with the sales credit details.sales_credits_interface_id being the primary key.Header_interface_id should correspond to the oks_headers_interface

OKS_NOTES_INTERFACE

                      Populate this table with required notes information. Notes_interface_id is the primary key.The header_interface_id and line_interface_id should be populated corresponding to the header_interface_id of the oks_headers_interface table and line_interface_id from the oks_lines_interface.