No Data found in gl_interface

In this forum Oracle Applications DBA's, System Administrators & Developers can share their knowledge/issues.
Post Reply
roy
Posts: 73
Joined: Mon Aug 28, 2006 12:46 pm
Location: USA

No Data found in gl_interface

Post 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>
admin
Posts: 2096
Joined: Fri Mar 31, 2006 12:59 am
Location: Pakistan
Contact:

Post 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
roy
Posts: 73
Joined: Mon Aug 28, 2006 12:46 pm
Location: USA

Post 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
admin
Posts: 2096
Joined: Fri Mar 31, 2006 12:59 am
Location: Pakistan
Contact:

Post by admin »

Pl send me all the steps in a word file including queries and data. thanks
Post Reply

Who is online

Users browsing this forum: No registered users and 1 guest