Lockbox
Default lockbox configurations are created during the banks and bank accounts onboarding process.
Review and update these configurations to meet your lockbox processing requirements. If you self-manage or already have banks and bank accounts in Oracle Fusion, configure your lockbox settings using standard Oracle Fusion implementation processes.
If you need custom attribute fields in the ORA_BAI2_EXTENDED_GENERIC format, a separate Lockbox Statement of Work (SOW) is required. Configure the custom attributes using standard Oracle Fusion implementation processes.
Predefined Configurations
Review these predefined configurations for each relevant business unit:
- Receivables system options
- Default accounting for lockbox receipts
- Receipt class, receipt methods, and remittance banks
- Lockbox and transmission format
- ORA_BAI2_EXTENDED_GENERIC is the only transmission format supported by the integration
- This format uses the control file: arlockboximportgenbai2.ctl
Setup Requirements
Follow the implementation workbook for additional lockbox configuration.
- Receipt source naming convention: For user-created receipt sources, use this
naming convention:
- JPM_LB_Acct Ending_XXXX_<BU Name>_<ar_batch_source_s>
- XXXX: Last four digits of the bank account
- BU Name: Truncate to the first 19 characters, if needed
- ar_batch_source_s: Six-character sequence
- Example: JPM_LB_Acct Ending_4101_Vision Operations_23132
- JPM_LB_Acct Ending_XXXX_<BU Name>_<ar_batch_source_s>
- Create the lockbox for each lockbox number:
- Lockbox set: Enter the Common Set or a specific reference data set.
- Lockbox number: Enter a unique identifier for the lockbox.
- Receipt source: Select a receipt source. The selected source populates the bank, bank account, accounting flexfield (general ledger account code combination), and receipt method.
- Batch size: Enter 100.
- Bank origination number: Required from the bank to match the lockbox file.
- Accounting date source: Select Import Date (the date you import lockbox receipts).
- Complete any remaining fields as required.
Manage Receipts Lockbox File
The Embedded Banking process automatically processes lockbox files received from the bank, as long as the lockbox number and bank origination number match the values in the file.
Coordinate with the bank on the file delivery frequency. You can review lockbox file processing results in the Manage Receipts page.