Home » Applications » Oracle Fusion Apps & E-Business Suite » gl import error
gl import error [message #397778] Mon, 13 April 2009 20:48 Go to next message
bananaman
Messages: 71
Registered: March 2009
Member
hi!
I'm having trouble using the import program of GL to transfer the records from the interface table. Using the Payables Transfer to GL program, I was able to successfully transfer the input to the gl interface table. But upon importing the said input using the GL import program, it produced 'error' as its status in Request window. Attached with this is the log file of the said import program. What is the problem with this?

regards,
bananaman
  • Attachment: a.txt
    (Size: 9.64KB, Downloaded 1698 times)
gl import [message #397780 is a reply to message #397778] Mon, 13 April 2009 21:09 Go to previous messageGo to next message
bananaman
Messages: 71
Registered: March 2009
Member
Will it create a duplicate entry if the same batch is imported using the import program in GL from the interface table?
Re: gl import [message #397880 is a reply to message #397780] Tue, 14 April 2009 06:50 Go to previous messageGo to next message
vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH
Senior Member
I don't see any error in the output. It has imported the batch "APSSCMAR041309 4596 Payables 61344: A 5800" successfully into 1 header and 14 lines.
Do you see any error in the log file?

By
Vamsi
Re: gl import [message #398350 is a reply to message #397880] Thu, 16 April 2009 01:43 Go to previous messageGo to next message
bananaman
Messages: 71
Registered: March 2009
Member
No I don't but before running the import program, i have encountered an error while creating entries in Payables. It says 'ora-01654: unable to extend index...' Does it affect the import program? I tried to generate the 'Payables Accounting Entries Report' and I was able to see the entries I created. It is just that, these don't reflect in GL as 'Unposted' since it flashed an error status. Upon adjusting the tablespace attribute to resolve the ora-01654 error and rerunning the import program, I was able to successfully ran it successfully and saw the entries in GL as unposted. Does this mean that the said error has affected the import program for this to display that it successfully transferred the entries even if it does not perce?
Re: gl import [message #398377 is a reply to message #398350] Thu, 16 April 2009 02:24 Go to previous messageGo to next message
vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH
Senior Member
I think you are using 11i. Please post the release next time onwards. Have a look at the Forum Guide also.
Still I didn't understand your problem.
Are you saying After transferring to GL and running Journal Import, you see the GL data as unposted?
(Or)
You are suspecting that the data went to GL multiple times?

By
Vamsi
Re: gl import [message #398438 is a reply to message #398377] Thu, 16 April 2009 04:54 Go to previous messageGo to next message
bananaman
Messages: 71
Registered: March 2009
Member
Yes I'm using the 11i.. Here's the problem. I was able to transfer the entries from Payables to GL inteface table, but upon running the Journal import program, it generated a status 'error' in the Request window. When I looked at the log file, I found that no error existed (based on the attached file of this topic). I also tried to see the 'Payables Accounting Entries Report' and found out that the entries were there, so I expected that I'll be able to post those entries using the Post Journals window. But unfortunately, the entries (i.e. unposted batch)that I was supposed to post were not there.

I'm suspecting, it could be the ora-01654 error that occured, triggered the import program to cause the import error.

So the question is, does ora-01654 error that occured prior to transferring the entries from Payables to GL interface table, really has something to do with the import error?
Re: gl import [message #398441 is a reply to message #398438] Thu, 16 April 2009 05:07 Go to previous messageGo to next message
vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH
Senior Member
Quote:
When I looked at the log file, I found that no error existed (based on the attached file of this topic).
I think the one you have uploaded is "output" file of Journal Import.

But I don't think ora-01654 has caused this mismatch, as you got this error before the Journal Import. And till the time you run Journal Import, you have the data in gl_interface. There could be some other reason. Check the Log again.

By
Vamsi
Re: gl import [message #398447 is a reply to message #398441] Thu, 16 April 2009 05:26 Go to previous messageGo to next message
bananaman
Messages: 71
Registered: March 2009
Member
here it is.. pls check
thanks..
  • Attachment: log.txt
    (Size: 5.15KB, Downloaded 2215 times)
Re: gl import [message #398450 is a reply to message #398447] Thu, 16 April 2009 05:32 Go to previous messageGo to next message
vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH
Senior Member
I misunderstood it. Journal Import has erred out because of the error you have mentioned.
Quote:
*****************************************************
sqlcaid: sqlabc: 0 sqlcode: -1654 sqlerrml: 70
sqlerrmc:
ORA-01654: unable to extend index GL.GL_IMPORT_REFERENCES_N3 by 16 in
sqlerrp: sqlerrd: 0 14 0 0 0 538976288
sqlwarn: sqltext:
*****************************************************SHRD0044: Process logging off database and exiting ...
It seems it is quiet possible that Journal Import has transferred the data in the gl_interface to GL headers and lines and couldn't post because of this error. Oracle Support may help you better on this.

By
Vamsi
Re: gl import [message #398455 is a reply to message #398450] Thu, 16 April 2009 05:40 Go to previous messageGo to next message
bananaman
Messages: 71
Registered: March 2009
Member
I guess the ora-01654 error that I'm talking about has something to do about this because after the error that I mentioned has been resolved, I was able to rerun the journal import program successfully with the entries displayed as unposted. By the way, I have another question, if in case I never encountered any problem with the import program and ran it successfully, is it possible to have a duplicate entry if I rerun the import program using the same batch?
Re: gl import [message #398457 is a reply to message #398455] Thu, 16 April 2009 05:52 Go to previous messageGo to next message
vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH
Senior Member
I don't think so.
Once it pushes the data from gl_interface to GL headers and Lines, it stamps the status in the gl_interface.
In some cases it deletes the data, which has successfully processed.
Hence you shouldn't get any duplicates in normal scenario. If you find any, that could be a bug.

By
Vamsi

[Updated on: Thu, 16 April 2009 05:53]

Report message to a moderator

Re: gl import [message #398459 is a reply to message #398457] Thu, 16 April 2009 05:57 Go to previous message
bananaman
Messages: 71
Registered: March 2009
Member
thanks a lot!!!
Previous Topic: problem with fnd_message.question
Next Topic: migrating 11i data to r12
Goto Forum:
  


Current Time: Tue Dec 24 20:23:58 CST 2024