My Oracle Support Banner

How To Setup and Process Non Real Time Credit Card Payments From Starting Point and Ending the Full Cycle (Doc ID 1540904.1)

Last updated on NOVEMBER 09, 2023

Applies to:

Oracle Receivables - Version 12.0.0 and later
Information in this document applies to any platform.



The objective of this document is to provide step by step instructions on the required setup and processing of Non Real Time Credit Card cycle.
The document will walk through all the setup required in Cash Management (CE),  Receivables (AR), and Payments (IBY).

 Then go through all the processing stages in detail for all the relevant modules.

 The document will list all the relevant database tables at each stage and showing the data at table level by running simple select statements (SQL). At the end of the document there will be a table for setup and processing showing which database tables were used and their usage.

Please provide your input, ideas, gaps and suggestions so we can further enhance this note by posting to the community thread


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
 A. Setup Overview
 B. Setup Detail Flow
 B1. Create Internal Bank
 B1a. Create Bank Branch:
 B1b. Create Bank Account
 B2. Create Receipt Class/Method
 B3. Create Payment Dummy Setup
 B4. Create/Update Customer
 C. Process Overview
 D. Process Detail Flow
 D1. Create Sales Order
 D2. Create Invoice
 D2a. Run AutoInvoice
 D2b. Check Invoice
 D3. Create Receipt
 D4. Create Remittance Batch
 D5. Create Settlement
 D6.  Reconcile Receipt
 E. Technical Flow/ SQL & Tables
 E1. Technical Flow/ SQL & Tables - Setup Detail Flow SQL
 E1a. Technical Flow/ SQL  - Create Bank
 E1b. Technical Flow/ SQL  - Create Bank Branch Information
 E1c. Technical Flow/ SQL  - Create Bank Account, Address & Contacts
 E2. Technical Flow/  SQL & Tables - Create Receipt Class/Method SQL
 E3. Technical Flow/ SQL  - Create  Payment Dummy Setup
 E4. Technical Flow/ SQL  - Create/Update Customer
 E5. Technical Flow/  Tables - Setup Tables
 E6. Techinical Flow/SQL & Tables Processing Detail
 E7. Techinical Flow/Processing Tables
 E7a. Technical Flow/ SQL  - Create Sales Order
 E7b. Technical Flow/ SQL  - Check Workflow Background Process
 E8. Technical Flow/ SQL - Check Invoice
 E9. Technical Flow/ SQL - Create Receipt
 E10. Technical Flow/ SQL  - Create Remittance Batch
 E11. Technical Flow/ SQL  - Create Settlement
 E12. Technical Flow/ SQL  -  Reconcile Receipt
 E13. Technical Flow/ Tables - Process Tables
  F. Diagnostics / Trouble Shooting
 F1a. Diagnostics:
 F1b. Information Centers:
 F1c. How to Obtain Trace and Debugs:
 F1d. Troubleshooting:

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.