Download - AR IBY Integration
![Page 1: AR IBY Integration](https://reader036.vdocuments.us/reader036/viewer/2022081415/553434384a7959614e8b4ae6/html5/thumbnails/1.jpg)
AR-IBY Integration
![Page 2: AR IBY Integration](https://reader036.vdocuments.us/reader036/viewer/2022081415/553434384a7959614e8b4ae6/html5/thumbnails/2.jpg)
AGENDA
R12 Payment Processing
Funds Capture Flow
Key IBY Tables and Lookups
AR-IBY Integration (Automatic Receipts / Refunds)
IBY and AR Setups
Authorization Flow
Settlement Flow
Troubleshooting
![Page 3: AR IBY Integration](https://reader036.vdocuments.us/reader036/viewer/2022081415/553434384a7959614e8b4ae6/html5/thumbnails/3.jpg)
Oracle Payments:Oracle Payments:
Oracle Payments is a central engine to disburse and capture payments.
For electronic payments, it connects Oracle EBS products like Receivables and
Payables to financial institutions like banks and credit card processors.
Oracle Payments
![Page 4: AR IBY Integration](https://reader036.vdocuments.us/reader036/viewer/2022081415/553434384a7959614e8b4ae6/html5/thumbnails/4.jpg)
FUNDS CAPTURE IN IBY
Funds Capture is an Automated Process for Electronic Payments which includes:
Bank Account Transfer Debit Cards Credit Cards
It’s a two step process which involves: Authorization Settlement
![Page 5: AR IBY Integration](https://reader036.vdocuments.us/reader036/viewer/2022081415/553434384a7959614e8b4ae6/html5/thumbnails/5.jpg)
FUNDS CAPTURE PROCESS FLOW
RequestRequest SettlementSettlement AcknowledgementAcknowledgement
• Upstream products call Payments to authorize transaction with third party payment system
• Routing rules drive how the transaction will be processed and which third party payment system will be used
• Payments automatically queries payment system for acknowledgement of transaction success
Authorization
• Payments calls payment system in individual or batch mode to request settlement
![Page 6: AR IBY Integration](https://reader036.vdocuments.us/reader036/viewer/2022081415/553434384a7959614e8b4ae6/html5/thumbnails/6.jpg)
Process Flow of data and IBY Tables Impacted
IBY_TRXN_SUMMARIES_ALL
IBY.IBY_TRXN_CORE
![Page 7: AR IBY Integration](https://reader036.vdocuments.us/reader036/viewer/2022081415/553434384a7959614e8b4ae6/html5/thumbnails/7.jpg)
Some Important IBY tables
IBY.IBY_ECAPP : List of products integrated with IBY
IBY_TRXN_SUMMARIES_ALL : Various Product Requests captured here
![Page 8: AR IBY Integration](https://reader036.vdocuments.us/reader036/viewer/2022081415/553434384a7959614e8b4ae6/html5/thumbnails/8.jpg)
AR Specific Data in IBY
Customer Bank Creation
Credit Card Creation
IBY_EXT_BANK_ACCOUNTS
IBY.IBY_CREDITCARD_H
Automatic Receipts Creation
IBY_TRX_SUMMARIES_ALL
Credit Card Refund
![Page 9: AR IBY Integration](https://reader036.vdocuments.us/reader036/viewer/2022081415/553434384a7959614e8b4ae6/html5/thumbnails/9.jpg)
AUTOMATIC RECEIPTS FLOW(FUNDS CAPTURE)
Flag a Transaction for Automatic Receipt Application
Run Automatic Receipts Creation Request This triggers Authorization in IBY Creates a Receipt in AR with status Confirmed
Run Automatic Receipts Remittance This triggers Settlement in IBY Creates a Receipt in AR with status Remitted
![Page 10: AR IBY Integration](https://reader036.vdocuments.us/reader036/viewer/2022081415/553434384a7959614e8b4ae6/html5/thumbnails/10.jpg)
IBY Setup For Funds Capture Processing
![Page 11: AR IBY Integration](https://reader036.vdocuments.us/reader036/viewer/2022081415/553434384a7959614e8b4ae6/html5/thumbnails/11.jpg)
IBY Setup : Payment System
1. Log into Fund Capture Setup Admin Responsibility.2. Click on tasks icon for Payment System.3. Verify the Payment system with the following details:
Supported Capabilities: Check Bank Account & Credit Card under Fund Capture
![Page 12: AR IBY Integration](https://reader036.vdocuments.us/reader036/viewer/2022081415/553434384a7959614e8b4ae6/html5/thumbnails/12.jpg)
IBY Setup : Payment Method
This is the payment medium by which a third party payer say a customer chooses to remit the amount to thePayee.
![Page 13: AR IBY Integration](https://reader036.vdocuments.us/reader036/viewer/2022081415/553434384a7959614e8b4ae6/html5/thumbnails/13.jpg)
IBY Setup : Payee
The first party payee is the deploying company, or organizations within the deploying company, that receives funds from its customers, accounts, and bills receivable transactions sent to banks.
IBY_PAYEE
![Page 14: AR IBY Integration](https://reader036.vdocuments.us/reader036/viewer/2022081415/553434384a7959614e8b4ae6/html5/thumbnails/14.jpg)
IBY Setup : Credit Cards
The purpose of setting up credit card brands is to enable the credit card brands that your company accepts for payment, along with their associated authorization validity periods, in days, that your company uses.
![Page 15: AR IBY Integration](https://reader036.vdocuments.us/reader036/viewer/2022081415/553434384a7959614e8b4ae6/html5/thumbnails/15.jpg)
AR Setup For Automatic Receipts
Step 1 Define Receipt Class
Step 2 Define Receipt Method
Step 3 Assign Remittance Bank
Step 4 Setup Document Sequence
Step 5 Define Print Program for Automatic Receipts
![Page 16: AR IBY Integration](https://reader036.vdocuments.us/reader036/viewer/2022081415/553434384a7959614e8b4ae6/html5/thumbnails/16.jpg)
SET UPS – RECEIPT METHOD (BANK ACCOUNT TRANSFER)
![Page 17: AR IBY Integration](https://reader036.vdocuments.us/reader036/viewer/2022081415/553434384a7959614e8b4ae6/html5/thumbnails/17.jpg)
SET UPS – RECEIPT METHOD (CREDIT CARD)
![Page 18: AR IBY Integration](https://reader036.vdocuments.us/reader036/viewer/2022081415/553434384a7959614e8b4ae6/html5/thumbnails/18.jpg)
Remittance Bank Details
![Page 19: AR IBY Integration](https://reader036.vdocuments.us/reader036/viewer/2022081415/553434384a7959614e8b4ae6/html5/thumbnails/19.jpg)
AR Receipt Method Table
AR_RECEIPT_METHODS
![Page 20: AR IBY Integration](https://reader036.vdocuments.us/reader036/viewer/2022081415/553434384a7959614e8b4ae6/html5/thumbnails/20.jpg)
FLAGGING A TRANSACTION FOR AUTOMATIC RECEIPTS
![Page 21: AR IBY Integration](https://reader036.vdocuments.us/reader036/viewer/2022081415/553434384a7959614e8b4ae6/html5/thumbnails/21.jpg)
FLOW FOR AUTHORIZATION
FLAG TRANSACTIONS FOR AUTOMATIC RECEIPTS IN AR
RUN AUTOMATIC RECEIPTS BATCH IN AR
IBY COMES INTO PICTURE NOW
AUTHORIZATION IN IBY
SUCCESSFULFAILED
RECEIPT CREATED WITH STATUS CONFIRMED
FAILURE REASON MENTIONED
![Page 22: AR IBY Integration](https://reader036.vdocuments.us/reader036/viewer/2022081415/553434384a7959614e8b4ae6/html5/thumbnails/22.jpg)
RECEIPTS BATCH CREATION
Output File
Automatic Receipts Creation Program Output File
RA_CUSTOMER_TRX_ALL
![Page 23: AR IBY Integration](https://reader036.vdocuments.us/reader036/viewer/2022081415/553434384a7959614e8b4ae6/html5/thumbnails/23.jpg)
VERIFY THE RECEIPT BATCH CREATED
![Page 24: AR IBY Integration](https://reader036.vdocuments.us/reader036/viewer/2022081415/553434384a7959614e8b4ae6/html5/thumbnails/24.jpg)
AR TABLES IMPACTED ON AUTOMATIC RECEIPTS CREATION
AR_BATCHES_ALL
AR_CASH_RECEIPTS_ALL
This field establishesthe link to the IBY tables.
![Page 25: AR IBY Integration](https://reader036.vdocuments.us/reader036/viewer/2022081415/553434384a7959614e8b4ae6/html5/thumbnails/25.jpg)
Standard Transaction Vs Automatic Transaction
Automatic
Standard
AR_CASH_RECEIPTS_ALL
Automatic
Standard
AR_RECEIPT_METHODS
Automatic
Standard
RA_CUSTOMER_TRX_ALL
![Page 26: AR IBY Integration](https://reader036.vdocuments.us/reader036/viewer/2022081415/553434384a7959614e8b4ae6/html5/thumbnails/26.jpg)
IBY Tables
IBY_TRXN_SUMMARIES_ALL
IBY_TRANSACTION_STATUS
IBY_TRXNTYPES
IBY_TRXN_REQTYPES
![Page 27: AR IBY Integration](https://reader036.vdocuments.us/reader036/viewer/2022081415/553434384a7959614e8b4ae6/html5/thumbnails/27.jpg)
IBY Tables
IBY.IBY_TRXN_CORE
On successful authorization this table is populated with the AuthCode and the corresponding message.( This happens only in case of Credit Card Transfer )
![Page 28: AR IBY Integration](https://reader036.vdocuments.us/reader036/viewer/2022081415/553434384a7959614e8b4ae6/html5/thumbnails/28.jpg)
RECEIPT IN AR AFTER SUCCESSFUL AUTHORIZATION
![Page 29: AR IBY Integration](https://reader036.vdocuments.us/reader036/viewer/2022081415/553434384a7959614e8b4ae6/html5/thumbnails/29.jpg)
RECEIPT CURRENTLY WITH STATUS CONFIRMED
RUN REMITTANCE BATCH IN AR
IBY COMES INTO PICTURE NOW
SETTLEMENT IN IBY
SUCCESSFULFAILED
RECEIPT CREATED WITH STATUS REMITTED
FAILURE REASON MENTIONED
FLOW FOR SETTLEMENT
![Page 30: AR IBY Integration](https://reader036.vdocuments.us/reader036/viewer/2022081415/553434384a7959614e8b4ae6/html5/thumbnails/30.jpg)
Run the Remittance Batch Program
Output FileRemittance Batch Output File
![Page 31: AR IBY Integration](https://reader036.vdocuments.us/reader036/viewer/2022081415/553434384a7959614e8b4ae6/html5/thumbnails/31.jpg)
APPROVING A REMITTANCE BATCH
AR_BATCHES_ALL
ON APPROVING
![Page 32: AR IBY Integration](https://reader036.vdocuments.us/reader036/viewer/2022081415/553434384a7959614e8b4ae6/html5/thumbnails/32.jpg)
IBY TABLES ON CAPTURE
IBY_TRXN_SUMMARIES_ALL
Status : 11 : Submitted
This batch has been submitted to the payment system and is awaiting clearing information.
TrxnTypeId : 8 : Capture
Capture funds for previously authorized transaction
![Page 33: AR IBY Integration](https://reader036.vdocuments.us/reader036/viewer/2022081415/553434384a7959614e8b4ae6/html5/thumbnails/33.jpg)
IBY TABLES ON CAPTURE
IBY_TRXN_CORE
On Successful Capture Event the corresponding TRXNMID generates a record in IBY_TRXN_CORE table.
![Page 34: AR IBY Integration](https://reader036.vdocuments.us/reader036/viewer/2022081415/553434384a7959614e8b4ae6/html5/thumbnails/34.jpg)
AR TROUBLESHOOTING TIPS
Receipt Creation / Authorization
Error : No data foundSelected for Batch ID must get stamped on the transaction.Eg: The Receipt was picked by some previous batch. However the authorization was not successful.Hence on the UI the transaction is still open.However in the Backend the trx is stamped with the batch ID.In subsequent batch creation this does not get picked as there is already a batch_Id stamped.
SolutionCancel the previous Batch.Set the value for “Selected_for_batch_Id” to null
![Page 35: AR IBY Integration](https://reader036.vdocuments.us/reader036/viewer/2022081415/553434384a7959614e8b4ae6/html5/thumbnails/35.jpg)
IBY TROUBLESHOOTING TIPS
Receipt Creation / Authorization
Verify IBY_TRXN_SUMMARIES_ALL for STATUS.
With TRXNMID check for Auth Failure in IBY_TRXN_CORE table.
![Page 36: AR IBY Integration](https://reader036.vdocuments.us/reader036/viewer/2022081415/553434384a7959614e8b4ae6/html5/thumbnails/36.jpg)
?Thank You.