Friday, August 08, 2014

Difference in GL Interface and GL Interface History Structure

I was running Journal import and found that insert into GL_Interface_history is very slow. After completion of Journal import program, it moves records from GL_Interface table to GL_Interface_History table. I was looking for certain column in GL_INTERFACE_HISTORY but could not find it, so i wanted to compare structure of both tables. I did not know any better way, so i used following sql to see the differences between two tables. By ordering the result by 2, i get column that are not in GL_INTERFACE_HISTORY.

1 comment:

  1. Thanks for the given information you are providing content very usefull to users.
    Learn Complete GL Interface Program in Oracle Apps R12 Actual cost of this course is 3,200/- But now Kuncham Software Solutions Pvt ltd is giving you Free access. Limited period offer Hurry-up Enroll Now at Udemy.

    Hurry-Up Enroll Now and get Free Access to the Entire Course