The blog provides the steps to create Oracle Receivables R12 AR Receipt Batch Sources. The Receipt batch sources provides the default value for the Receipt Class, Receipt Methods and Remittance Bank Account fields that are added as part of Receipt Batch. Oracle Receivables allows to accept the default value or can be created as per user requirement.
Receipt Batch sources can use manual or automatic batch numbering as defined in the setup
When receipt batch source is selected for Receipt Creation, Oracle Receivables automatically uses the Cash, Unapplied, Unidentified, On-Account, and Earned and Unearned Discount account to the Receipt Payment Method.
Prerequisites for Receipt Batch Source
The below setup should be available before you define a Receipt Batch Source
- Define Banks
- Define Receipt Classes
- Define Receipt Methods
How to Create a Receipt Source in Oracle Receivables R12 ?
Perform the below steps to define a Receipt Source in Oracle AR R12
- Navigate to AR -> setup -> Receipt -> Receipt source
- Select an OU (Operating Unit)
- Enter the Receipt Class
- Enter the Receipt Method (Optional)
- Enter Bank Account
- Manual Batch Numbering ( Select if Receipt Batch Numbers to be entered manually)
- Automatic Batch Numbering ( Select if Receipt Batch Numbers are entered by System)
- Enter Start Date ( Date from when Receipt Source becomes Active)
- Enter End Date ( Date when Receipt Source becomes Inactive)
Oracle Receivables SQL to get AR Receipt Sources Data Extract
SELECT HOU.NAME OPERATING_UNIT ,AR_BATCH_SOURC_AR_LOOKUPS_TBLL_TBL.NAME ,AR_BATCH_SOURC_AR_LOOKUPS_TBLL_TBL.DESCRIPTION ,AR_LOOKUPS_TBL.MEANING RECEIPT_SOURCE_TYPE ,AR_RECEIPT_CLS_TBL.NAME RECEIPT_CLASS ,AR_RECEIPT_MTHDS_TBL.NAME PAYMENT_METHOD ,CE_BANK_ACCTS_TBL.BANK_ACCOUNT_NAME BANK_ACCOUNT ,AR_LOOKUPS_TBL1.MEANING BATCH_NUMBERING ,AR_BATCH_SOURC_AR_LOOKUPS_TBLL_TBL.LAST_BATCH_NUM LAST_NUMBER ,AR_BATCH_SOURC_AR_LOOKUPS_TBLL_TBL.START_DATE_ACTIVE EFFECTIVE_START_DATE ,AR_BATCH_SOURC_AR_LOOKUPS_TBLL_TBL.END_DATE_ACTIVE EFFECTIVE_END_DATE FROM AR_BATCH_SOURCES_AR_LOOKUPS_TBLL AR_BATCH_SOURC_AR_LOOKUPS_TBLL_TBL ,HR_OPERATING_UNITS HOU ,AR_LOOKUPS AR_LOOKUPS_TBL ,AR_RECEIPT_CLASSES AR_RECEIPT_CLS_TBL ,AR_RECEIPT_METHODS AR_RECEIPT_MTHDS_TBL ,AR_LOOKUPS AR_LOOKUPS_TBL1 ,CE_BANK_ACCOUNTS CE_BANK_ACCTS_TBL WHERE 1=1 AND AR_BATCH_SOURC_AR_LOOKUPS_TBLL_TBL.ORG_ID=HOU.ORGANIZATION_ID AND HOU.ORGANIZATION_ID=NVL(:P_ORG_ID,HOU.ORGANIZATION_ID) AND AR_LOOKUPS_TBL.LOOKUP_CODE(+)=AR_BATCH_SOURC_AR_LOOKUPS_TBLL_TBL.TYPE AND AR_LOOKUPS_TBL.LOOKUP_TYPE(+)='BATCH_TYPE' AND AR_RECEIPT_CLS_TBL.RECEIPT_CLASS_ID(+)=AR_BATCH_SOURC_AR_LOOKUPS_TBLL_TBL.DEFAULT_RECEIPT_CLASS_ID AND AR_RECEIPT_MTHDS_TBL.RECEIPT_METHOD_ID(+)=AR_BATCH_SOURC_AR_LOOKUPS_TBLL_TBL.DEFAULT_RECEIPT_METHOD_ID AND AR_LOOKUPS_TBL1.LOOKUP_CODE(+)=AR_BATCH_SOURC_AR_LOOKUPS_TBLL_TBL.AUTO_BATCH_NUMBERING AND AR_LOOKUPS_TBL1.LOOKUP_TYPE(+)='BATCH_NUMBERING' AND CE_BANK_ACCTS_TBL.BANK_ACCOUNT_ID(+)=AR_BATCH_SOURC_AR_LOOKUPS_TBLL_TBL.REMIT_BANK_ACCT_USE_ID ;