Page 1 of 1

No Data found in gl_interface

Posted: Sat Mar 01, 2008 10:31 am
by roy
Data inserted into gl_interface table.

I row created. - successful.

the inserted data can be seen through Sql*Plus.
Using Toad the same data cannot be viewed. Why?

confused. Thinking some is wrong with Toad

I use Journal>import >Run (after setting the source info)

When I view the concurrent Request it 'completed' 'warning'

I view the Diagnostics - it shows 'no data in interface table'.

confused.

Request assistance

rm<center></center>

Posted: Sat Mar 01, 2008 11:52 am
by admin
May be the data is not saved as you need to apply commit after insertion like,

sql > insert.....
sql > commit;

hope will solve your problem. thanks

Posted: Sat Mar 01, 2008 10:06 pm
by roy
THE STEPS FOLLOWED AS PER DOC 11i - V4.1

COMMIT - DID NOT HELP.

THE QUERY DOES SHOW CREDIT AND DEBIT ENTERY [INSERTED] NO PROBLEM.

THE SOURCE IS DEFINED AS - XX CUSTOM PAYROLL

PROCESS COMPLED WITH WARNING.

NO DATA FOUND IN GL_INTERFACE

ROY

Posted: Sun Mar 02, 2008 12:46 am
by admin
Pl send me all the steps in a word file including queries and data. thanks