Welcome

Welcome to HandsonERP.com

This site provides video based training of Oracle Financials.
Learn concepts and functionality in a step by step manner.

Login

HandsonERP - Oracle E-Business Suite Training
Welcome, Guest
Please Login or Register.    Lost Password?
Please post inquiries related to lessons content here. All questions and inquiries related to the website should be submitted directly using Contact form in the top menu.
Go to bottom Post Reply Favoured: 0
TOPIC: Re:Interfacing with JDE
#4094
anandjs2 (User)
Fresh Boarder
Posts: 11
graphgraph
User Offline Click here to see the profile of this user
Interfacing with JDE 11 Years, 3 Months ago  
In the US instance: Currently we have inventory purchasing activity done through GEAC which transfers the information to JDE (Canadian Instance) in a different reporting currency.

We plan to go live with US and then implement Canada. Canada is using JDE. Now, After we go live with oracle AP, would it be possible to interface AP directly with JDE and transfer accounting/journal information to JDE or does it have to be interfaced with GL for the same information to be passed to JDE?

This if from a functional standpoint.

Please advice. Thanks

Note: I'm not sure if its okay to discuss topics outside of lessons here. please advice if its acceptable.
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#4100
handsonerp (Admin)
Admin
Posts: 1989
graph
User Offline Click here to see the profile of this user
Re:Interfacing with JDE 11 Years, 3 Months ago  
The forum is dedicated to discuss lesson related inquiries and due to the shortage of time resources this policy is strictly followed.

I can share my thoughts on how accounting data is usually extracted from AP and could be transferred to external systems as pertains to the topics covered.

In R12 the AP module simply pass accounting events to SLA module.

The accounting is created by SLA module and accounting entries are then transferred from SLA to General Ledger module.
All this is covered in SLA videos.

Therefore the two logical places to pick up accounting data are: SLA table XE% and GL tables GL%.
GL tables makes up the best place to pick up the entries from as this way you only retrieve what is posted in GL and hence reflected in financial statements.
select * from gl_je_headers a, gl_je_lines b
where je_source = 'Payables'
and status = 'P' -- Posting flag
and ledger_id = <X>
(The SQL is written on the fly and not tested).
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#4102
anandjs2 (User)
Fresh Boarder
Posts: 11
graphgraph
User Offline Click here to see the profile of this user
Re:Interfacing with JDE 11 Years, 3 Months ago  
That was along the same line as I was thinking. Thanks a lot for the help :)

PS: Do you know of any good forums where I can raise these kind of concerns in the future? I do follow some of them, but it would be really helpful if you could suggest some.
 
Report to moderator   Logged Logged  
 
Last Edit: 2013/01/28 23:03 By anandjs2.
  The administrator has disabled public write access.
#4123
handsonerp (Admin)
Admin
Posts: 1989
graph
User Offline Click here to see the profile of this user
Re:Interfacing with JDE 11 Years, 2 Months ago  
Sorry for the late reply.
There are tons of forums out there. I have not tried them so I cannot say which one are better. forums.oracle.com and ittoolbox.com seems to be decent ones.
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
Go to top Post Reply
Powered by FireBoardget the latest posts directly to your desktop