In this forum Oracle Applications DBA's, System Administrators & Developers can share their knowledge/issues.
-
roy
- Posts: 73
- Joined: Mon Aug 28, 2006 12:46 pm
- Location: USA
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
Users browsing this forum: No registered users and 7 guests