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.
Friday, August 08, 2014
Difference in GL Interface and GL Interface History Structure
Labels:
Oracle General Ledger
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment