AR Receipt Source creation in Oracle Receivables R12

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   ;