This content has been marked as final. Show 6 replies
(1) Install 10gAS
(2) Install the OracleAS Interconnect Hub
(3) Install the Oracle Applications Adapter
(4) Install the Peoplesoft Adapter
Yes, you can install all on the same machine. I did this.
Do you any detail documentation and best practices on the PSFT HR & Oracle Financials integration? Any addtional information would be great as we would like to re-use best efforts.
Could you direct me to the documentation that covers these steps.
Also, are there out of the box integration between PSFT HR/PAYROLL & ORACLE Finance (i.e. GL, AP, etc. )?
I am posting one of the message i received from our global gurus and forums...
There is no built in program to take care of it from top to bottom, however half of the part needs to be done with the help of customization and the part following GL_INTERFACE will be done by OA. You can maintain PS ledger seperately , it will not have any impact on OA GL.
According to me this will be solution, please ignore this if you do not want this.
1.Define in Oracle Apps all the accounts used in PS , please keep in mind that in the charfield strucure in PS , we have Stat code and currency code BUT in OA its absent rather they are seperate fields and not part of Chartfield.So you will have to define all the accounts in OA GL minus these columns.You may use ADI to define accounts in OA.
2.All these code combinations will be mapped in OA tables , GL_CODE_COMBINATIONS and GL_CODE_COMBINATIONS_KFV without Currency segments.
3.Now you will have define an app engine , or any custom program which picks CODE_COMBINATION_ID from these tables of OA and then put in an interim table or GL_INTERFACE and
GL_INTERFACE_CONTROL. ( For which you will have to go through import process whitepaper which is the counterpart of loader program in PS).
This program will have to take care of lot many other factors also like.
--You will have to map different field of PS to OA, SETID concept is missing in OA like ENTERED_DR, ENTERED_CR, ACCOUNTED_DR , ACCOUNTED_DR etc
--In OA we have Batches which are superset of Journals, Batch is a group of Journals having same currency, Accounting date, Set of Books, Chartfield structure.So you will have to decide on this, whether you want 1 batch per Journal or you want to club many Journals under a batch,a nd like wise populate JE_BATCH_ID.
--Also as you are removing currency / stat field in PS so you will have to accordingly populate , CURRENCY_CODE in GL_INTERFACE.
--The Sets of Books you want the Journals to attach to.
--In PS we have business calendar concept, but in OA its absent.So you will have to code additional logic for that.
--You will have to define different currencies, source , categories in OA.
4.Run Journal import in OA GL.
This will populate entries in GL Main tables.
All this is for Actuals but for BUDGET , I dont know the PS architecture fully.
So you are saying it is out of the box? Ouch.
From reading this, it appears my client should plan on a manual interface for quite some time as customizations are not in our plans.
Is there any customer using BPEL and the "delivered adapters" to interface Payroll Data from PS HR 8.x to Oracle GL Financials. Same question with Demographic/Department Data to Oracle AP?
Any replies to your question? If so, please let me know .