Project and Portfolio Management Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

How can I load the rows from my Interface tables to Actual Tables.

Highlighted
Mahen M
Honored Contributor

How can I load the rows from my Interface tables to Actual Tables.

Hi,
I have rows inserted to KNTA_USERS_INT table, I want these tables entered to KNTA_USERS. What should I do for this.

I hope we need to run a report, But not exactly sure, Please advice.

Regards,
Mahendran M
7 REPLIES
Shravan Kathuri
Senior Member

Re: How can I load the rows from my Interface tables to Actual Tables.

I think you need to run the "Import Users" report which is there in "Administrative" category.

Mahen M
Honored Contributor

Re: How can I load the rows from my Interface tables to Actual Tables.

What are the columns which are mandatory?

If I want to make this as a part of WF, How can I do it?

Regards,
Mahendran M
Shravan Kathuri
Senior Member

Re: How can I load the rows from my Interface tables to Actual Tables.

If you want to run it as wf func, you need to write pl/sql code which executes Run_Derive_And_Validate and Run_Import procedures of knta_user_int package.Probably you will get info from these 2 proc's to run from wf.
Mahen M
Honored Contributor

Re: How can I load the rows from my Interface tables to Actual Tables.

Wow, This explains something... Can you tell me the procedure names and the Interface Table names for all the User releted Interface tables?

Regards,
Mahendran M
Shravan Kathuri
Senior Member

Re: How can I load the rows from my Interface tables to Actual Tables.

Hi Mahendran,

Only those 2 knta_users and knta_users_int
are required for user load.
Erik Cole
Honored Contributor

Re: How can I load the rows from my Interface tables to Actual Tables.

Mahendran,

The "Open Interface Guide and Reference" in PPM help will give you the specifics on required fields, etc for the interface tables.

Also, look at the Commands tab of the Import Users report in the workbench and you will see the SQL procedures that Shravan is referring to and their input parameters.
Mahen M
Honored Contributor

Re: How can I load the rows from my Interface tables to Actual Tables.

Thanks for the info Erik, I will see it.

Regards,
Mahendran M
//Add this to "OnDomLoad" event