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|
|F1b. Information Centers:|
|F1c. How to Obtain Trace and Debugs:|