Lockbox interface

Lockbox interface, AskHareesh blog for oracle apps

Lockbox interface

AutoLockbox lets us automatically process receipts that are sent directly to the bank instead of manually feeding them in Oracle Receivables.

AutoLockbox is a three step process:
  1. Import: During this step, Lockbox reads and formats the data from your bank file into interface table AR_PAYMENTS_INTERFACE_ALL using a SQL *Loader script.
  2. Validation: The validation program checks data in this interface table for compatibility with Receivables. Once validated, the data is transferred into QuickCash tables (AR_INTERIM_CASH_RECEIPTS_ALL and AR_INTERIM_CASH_RCPT_LINES_ALL).
  3. Post QuickCash: This step applies the receipts and updates your customer’s balances.
Pre-Requisites:
  • Banks
  • Receipt Class
  • Payment Method
  • Receipt Source
  • Lockbox
  • Transmission format
  • AutoCash Rule sets
Interface tables:
  • AR_PAYMENTS_INTERFACE_ALL (Import data from bank file)
  • AR_INTERIM_CASH_RECEIPTS_ALL
  • AR_INTERIM_CASH_RCPT_LINES_ALL (Validate data in interface table and place in quick cash tables)
Base Tables:
  • AR_CASH_RECEIPTS
  • AR_RECEIVABLES_APPLICATIONS
  • AR_ADJUSTMENTS
  • AR_DISTRIBUTIONS_ALL
  • AR_PAYMENT_SCHEDULES_ALL
Concurrent program:
  • Lockbox
Validations:
  • Check for valid record type, transmission record id.
  • Validate sum of the payments within the transmission.
  • Identify the lockbox number (no given by a bank to identify a lockbox).
Important Columns:
Some important columns that need to be populated in the interface tables:
AR_PAYMENTS_INTERFACE_ALL:
  • STATUS
  • RECORD_TYPE
  • LOCKBOX_NUMBER
  • BATCH_NAME
  • TRANSIT_ROUTING_NUMBER
  • ACCOUNT
  • CHECK_NUMBER
  • REMITTANCE_AMOUNT
  • DEPOSIT_DATE
  • ITEM_NUMBER
  • CURRENCY_CODE
  • DEPOSIT_TIME


*/