Database tables named "ECMImport_<something>" will typically have been created by running a business adapter import named "<something>". These tables are created to hold raw data that is extracted by the business adapter from the source database or file it imports from.
So in you case, it sounds like you need to look for your business adapter import named "LMS_Details" and run it.
(Did my reply solve the question? Click "ACCEPT AS SOLUTION" to help others find answers faster. Liked something? Click "KUDO". Anything expressed here is my own view and not necessarily that of my employer, Flexera.)
Database tables named "ECMImport_<something>" will typically have been created by running a business adapter import named "<something>". These tables are created to hold raw data that is extracted by the business adapter from the source database or file it imports from.
So in you case, it sounds like you need to look for your business adapter import named "LMS_Details" and run it.
(Did my reply solve the question? Click "ACCEPT AS SOLUTION" to help others find answers faster. Liked something? Click "KUDO". Anything expressed here is my own view and not necessarily that of my employer, Flexera.)
I have to import the raw data to the EMCImport_ from that I would like to update in another table using business importer. then I would like to review the oracle report.
@MANOJKUMAR_K - This must be a Custom Solution that was created for you at some time in the past, likely during your implementation.
As a Custom Solution, this means that it is not a standard feature of FNMS and it is likely that anyone here in the Community would be able to assist you.
You will need to investigate and find out who created your custom Business Adapter and custom SQL Report and get them to assist you.
