Payroll and Cash Management Integration

[ahmadbilal]

I am facing a problem in R12.0.4 Payroll and Cash Management Integration I have setup Cash Management and Payroll. Create a Bank account with access to Business Group and payroll, Map it with organizational payment method but I am not able to see paid payroll transaction in Oracle Cash Management. in one of Oracle White paper (CASH MANAGEMENT PAYROLL INTEGRATION) i read that Oracle Cash Management

<b>This integration can currently only handle check form of payment. Electronic Fund Transfers (EFT) like that of NACHA are not included in the reconciliation process due to the limitation of payroll not storing an unique identifying transaction number which CE reconciles on.
</b>
I am using direct deposit method.

Please update if anyone have any solution or have material on R12 Cash Management and Payroll integration

I can view Payable and Gl transactions in Available transaction windows

[ahmadbilal]

I found some stuff Regarding payroll and Cash Management Integration.

It's a Metalink Note.

CE: Electronic Payments Made In Payroll Module Not Available In CEXCABMR
Doc ID:
Note:206373.1 Type: PROBLEM
Last Revision Date: 03-JUN-2003 Status: PUBLISHED


? fact: Oracle Cash Management
?
? fact: CEXCABMR - Enter/Reconcile Bank Statements
?
? symptom: Query on on "Available Transaction" Screen displays cheque payments only and not electronic transfer payments
?
? change: Note Role:
? Bank Reconciliation > Bank Statements > Find Screen
? This then takes you to the "Reconcile Bank Statements" form
? Press the "Review" Button which takes you to the "Bank Statement "form. Press the "Available" Button and then enter
? search criteria (Payroll) on "Find Transactions" Form
? "Find" Button which takes you to the "Available Transaction"
? Screen, which displays cheque payments only not electronic transfer payments.
?
? cause: Intended functionality
?
?
fix:

Currently, the use of Cash Management with Payroll is pretty limited at this
time.
Presently there is just one table in Payroll - PAY_CE_RECONCILED_PAYMENTS that
keeps a track of the check payments to enable reconciliation with CE.

<span id='hl' style='background-color: yellow'>The integration can currently only handle check form of payment. Electronic
Fund Transfers (EFT) are not included in the reconciliation process because
payroll does not store a unique identifying transaction number for CE to
reconcile on.
</span id='hl'>


But Still waiting for R12 Mechanism

[Alihsyed]

Dear Ahmed Bilal,
please list down the look ups you have defined for the Bank Account to enable the cash management tab and check whether the account information is exactly same as the account description you have defined in the oracle cash management/payyables Bank Account.
Thank you,
Ali.

[ahmadbilal]

Yes i have verified account ID is same as per oracle CE_bank view

[Alihsyed]

Please can you check whether you have assign a payroll account in the payment method. and it remains there after closing and saving the payment method and opening the org. payment method again in the Human Resource responsibility.

[alruwaished]

Hi dear
if your R12.0.8 does not work. I was actually testing to see BACS reconciliation , only supported from 12.1.2 or above