comment types in JavaScript

The blog describes how to add comments in JavaScript. The JavaScript comments are helpful more to developers beacuse of below given points

  • JavaScript Comments allows to add related information about the written code or function getting called in the program
  • JavaScript Comments could be helpful in providing the program overview to help developers interpret the code logic
  • JavaScript Comments are useful when developers need to try multiple approaches to build a optimal solution for the problem
  • JavaScript Comments are useful to add Warnings
  • JavaScript Comments are useful when multiple developers work on the same program file

JavaScript Comments Types

The JavaScript Comments can be classified into 2 types

  • Single -Line Comments : The single -line comments are useful to provide the meaning for the written code to help in interpreting the logic .The single -line comments are enabled using double forward slashes (//) .
<script>  
var length=10;                         // define length
var height=20;                         //define height
var area= length * height             // calcualtes area   
document.write(area);                //prints area as 200
</script> 
  • Multi-Line Comments : The multi-line comments are useful when we need to provide more details , add specific guidelines to make it more readable and understandable. the multi -line comments are enabled using forward slash with asterisk then asterisk with forward slash /* Add Comments Here */
<script>  
/* The program define the lenght and height .
   Calcualtes the Area by multiplying lenght * height */

var length=10;                         
var height=20;                         
var area= length * height             
document.write(area);                
</script>  


How to use Constructor in React component

The blog provides the usage of Constructor in React Application. The concept of Constructor in React is similar to what we implement in other languages like C++ , Java.

What is a Constructor in React ?

The Constructor can be defined as given below

  • The constructor is used to initialize an object’s state
  • The constructor is invoked when an object is created in the class
  • The constructor is called in React when a component is mounted
  • The constructor is called using super(props)
  • this.props remains undefined if super(props) is not called in the class

How React uses constructor ?

  • Initialize the local state by assigning an object to this.state
  • Binds Event handler methods to an instance

How State should be initialized in the constructor() ?

  • The Constructor should not be called this.setState() in the constructor
  • We should use this.state to initialize the local state in the constructor

When constructor should be used in React Component ?

Usage of Constructor is not mandate for all the React Component. Constructor helps to initialize the object state before it is actually being accessed / modified. That is , when we need to set a object property or to access the object local state , then constructor should be called using super(props). 

If the super(props) is not defined in the constructor and program try to access the object value using this.props , then React will throw the error ->  ‘this’ is not allowed before super().

class App extends Component {  
    constructor(props){  
        // wrong assignment, super(props) is not defined
        this.siteName = "www.oracleappshelp.com";  
    }  
    render () {  
        return (  
            <p> Site Name : { this.props.siteName }</p>  
        );  
    }  
}
class App extends Component {  
    constructor(props){ 
      // correct  assignment                
		super(props);
        this.siteName = "www.oracleappshelp.com"; 
    }  
    render () {  
        return (  
            <p> Site Name : { this.props.siteName }</p>  
        );  
    }  
}

this.props will be undefined in the Cosntructor if super(props) is not called.

Use Constructor to bind functions in React Component

The constructor in React Component is useful when we need to bind functions as per below given example . The button clickSubmit is binded using this

constructor(props) {
  super(props);
  this.state = { count: 0 };
  this.clickSubmit = this.clickSubmit.bind(this);
}

Difference between React JS and Vue JS

The blog provides the difference between React and Vue. Although both React and Vue are the popular Java Script frameworks and provides similar functionalities like component -based Architecture, State and Props , Updating Virtual DOM but their usage depends on the specific business needs.

React Java Script FrameworkVue Java Script Framework
React is used for building reusable componentsVue is used for building reusable User
Interfaces and single page applications
React is declarative, efficient and flexible
open-source Java Script Library
Vue is an open-source library supporting
progressive framework
React was developed by Jordan Walke, a
software engineer at facebook
Vue was developed by Evan You, a former
employee at Google
React was released to public on May,2013Vue was released to public on February, 2014
React can be easily integrated with 3rd party librariesVue has limited flexibility to adapt 3rd party libraries
React uses JSX for Java Script Expression
which is generated code similar to HML
Vue provides styling similar to Angular
by separating HTML, JS, and CSS
React supports one-way binding which means
only model can update the application state
Vue supports one-way and two-way binding
which means not only model but UI field
change is bounded to model change
React support Java Script / XMLVue supports HTML/ Java Script
React provides extensive support for External
Tools (React CLI Tool for create-react-app) and
IDEs (Visual Studio Code)
Vue provides limited external tool supports
when compared to React although it also
supports Vue CLI Tool and IDEs
React being a popular library provides long term support Vue support is limited as compared to React

Difference between React JS State and Props

The blog provides the listing of differences between React JS State and React JS Props.

ReactJS State

The State is used to contain data or related information about the component in React and determines the component behavior and depicts how the data is rendered to the DOM Structure. The usage of State makes the component more dynamic and interactive. The State represents the component’s local state and can be modified inside the component or sometimes by the component directly.

ReactJS Props

Props in React are similar to properties which are read-only and are passed as argument within the component. It acts as the function arguments and allows to share data among components. Props are immutable as we cannot modify the values of props within the component. Thus , it is preferred to define the components with the State which can be updated with the change in the component.

What is common between State and Props

  • Both ReactJS State and Props can get initial value from parent Component
  • Both ReactJS State and Props can set default values inside Component
  • Both ReactJS State and Props are plain JS objects

Difference between ReactJS State and Props

React JS State React JS Props
State is used to contain data or related information about the component in ReactProps in React are similar to properties which are passed as argument within the component 
 State of the component can be modified  Props in react are read only
 State is mutableProps is immutable 
States helps in rendering the modifications with the component  Props are used to communicate between components
 State is restricted to be  accessed by child components Props can be accessed by the child component
 State holds component data Props allows to pass data using arguments between components
State cannot be used as reusable componentsProps can be used as reusable components
 State is internal to the react components Props are external used to pass arguments between components

Query to get AR Customer Receipt data in Oracle Apps R12

The blog provides the SQL Query to get Customer specific receipt details in Oracle Receivables R12

Query to get AR Customer Receipt data in Oracle Apps R12

SELECT 	ACRA.CASH_RECEIPT_ID,
DECODE (	 ACRA.TYPE,
			 'CASH', 'CASH RECEIPT RECEIPT',
			 'MISC', 'MISCELLANEOUS',
			 ACRA.TYPE
		) RECEIPT_TYPE,
		ACRA.CURRENCY_CODE,
		ACRA.DOC_SEQUENCE_VALUE RECEIPT_NUMBER,
		ACRA.RECEIPT_NUMBER REFERENCE_NUMBER,
		TRUNC (ACRA.RECEIPT_DATE) RECEIPT_DATE, 
		HP.PARTY_NAME RECEIVED_FROM,
		ACRA.MISC_PAYMENT_SOURCE,
		HCA.ACCOUNT_NUMBER CUSTOMER_NO,
		NVL (ACRA.AMOUNT, 0) ENTERED_AMOUNT,
		NVL (ACRA.AMOUNT, 0) * NVL (ACRA.EXCHANGE_RATE, 1) FUNCTIONAL_AMOUNT,
		ARM.NAME PAYMENT_METHOD,
		ABAA.BANK_ACCOUNT_NUM BANK_ACC_NUM,
		ABB.BANK_NAME,
		ABB.BANK_BRANCH_NAME,
		ACRA.COMMENTS DESCRIPTION
FROM 	AR_CASH_RECEIPTS_ALL ACRA,
		AR_RECEIPT_METHODS ARM,
		AP_BANK_ACCOUNTS_ALL ABAA,
		AP_BANK_BRANCHES ABB,
		HZ_CUST_ACCOUNTS HCA,
		HZ_PARTIES HP
WHERE 	ACRA.PAY_FROM_CUSTOMER = HCA.CUST_ACCOUNT_ID(+)
AND 	ACRA.ORG_ID = ABAA.ORG_ID(+)
AND 	HCA.PARTY_ID = HP.PARTY_ID(+)
AND 	ACRA.RECEIPT_METHOD_ID = ARM.RECEIPT_METHOD_ID
AND 	ACRA.REMITTANCE_BANK_ACCOUNT_ID = ABAA.BANK_ACCOUNT_ID
AND 	ABAA.BANK_BRANCH_ID = ABB.BANK_BRANCH_ID
AND 	HCA.CUST_ACCOUNT_ID = '<CUTOMER_ACCOUNT_ID>'
ORDER BY TRUNC (ACRA.RECEIPT_DATE), ACRA.DOC_SEQUENCE_VALUE;

Oracle AR SQL Query for Uncleared Receipt Amount Total

The blog provides the Oracle AR SQL Query for retrieving Uncleared Receipt Amount Total in Oracle apps R12

SQL Query to get Uncleared Receipt Amount Total

SELECT NVL(SUM(AR_Pay_Sch_tbl.AMOUNT_DUE_REMAINING), 0) 		unClearedReceiptTotalAmt
  FROM HZ_CUST_Agcc_tblOUNTS_ALL           			HZ_CUST_Agcc_tblT_ALL_TBL,
       AR_PAYMENT_SCHEDULES_ALL       				AR_Pay_Sch_tbl,
       AR_RECEIVABLE_APPLICATIONS_ALL 				AR_Rec_Appl_tbl,
       HZ_HZ_CUST_Agcc_tblT_ALL_TBL_SITES_ALL       HZ_CUST_AGgcc_tbl_TBLT_SITES,
       HZ_HZ_PARTY_SITES_TBLS                 		HZ_PARTY_SITES_TBL,
       HZ_Hz_loc_tblATIONS                   		Hz_loc_tbl,
       HZ_CUST_HZ_CUST_SITE_USES_TBL_ALL          	HZ_CUST_SITE_USES_TBL,
       AR_CASH_RECEIPT_HISTORY_ALL    				AR_CASH_RECPT_HIST_TBL,
       AR_CASH_RECEIPTS_ALL           				AR_CASH_RCPT_ALL_TBL,
       GL_CODE_COMBINATIONS           				gcc_tbl
 WHERE 1=1
   AND AR_Pay_Sch_tbl.CUSTOMER_ID = HZ_CUST_Agcc_tblT_ALL_TBL.CUST_Agcc_tblOUNT_ID
   AND AR_Pay_Sch_tbl.CUSTOMER_ID = HZ_CUST_Agcc_tblT_ALL_TBL.CUST_Agcc_tblOUNT_ID
   AND HZ_CUST_AGgcc_tbl_TBLT_SITES.HZ_PARTY_SITES_TBL_ID = HZ_PARTY_SITES_TBL.HZ_PARTY_SITES_TBL_ID
   AND Hz_loc_tbl.Hz_loc_tblATION_ID = HZ_PARTY_SITES_TBL.Hz_loc_tblATION_ID
   AND AR_Pay_Sch_tbl.CASH_RECEIPT_ID = AR_CASH_RCPT_ALL_TBL.CASH_RECEIPT_ID
   AND AR_CASH_RCPT_ALL_TBL.CASH_RECEIPT_ID = AR_CASH_RECPT_HIST_TBL.CASH_RECEIPT_ID
   AND AR_CASH_RECPT_HIST_TBL.Agcc_tblOUNT_CODE_COMBINATION_ID = gcc_tbl.CODE_COMBINATION_ID
   AND AR_Pay_Sch_tbl.CASH_RECEIPT_ID = AR_Rec_Appl_tbl.CASH_RECEIPT_ID
   AND HZ_CUST_SITE_USES_TBL.HZ_CUST_Agcc_tblT_ALL_TBL_SITE_ID = HZ_CUST_AGgcc_tbl_TBLT_SITES.HZ_CUST_Agcc_tblT_ALL_TBL_SITE_ID
   AND HZ_CUST_Agcc_tblT_ALL_TBL.CUST_Agcc_tblOUNT_ID = HZ_CUST_AGgcc_tbl_TBLT_SITES.CUST_Agcc_tblOUNT_ID
   AND HZ_CUST_AGgcc_tbl_TBLT_SITES.HZ_CUST_Agcc_tblT_ALL_TBL_SITE_ID = HZ_CUST_SITE_USES_TBL.HZ_CUST_Agcc_tblT_ALL_TBL_SITE_ID
   AND AR_Pay_Sch_tbl.CUSTOMER_ID = HZ_CUST_AGgcc_tbl_TBLT_SITES.CUST_Agcc_tblOUNT_ID
   AND AR_Pay_Sch_tbl.CUSTOMER_SITE_USE_ID = HZ_CUST_SITE_USES_TBL.SITE_USE_ID
   AND AR_Pay_Sch_tbl.CASH_RECEIPT_ID = AR_CASH_RECPT_HIST_TBL.CASH_RECEIPT_ID
   AND NVL(HZ_CUST_SITE_USES_TBL.STATUS, 'A') = 'A'
   AND AR_Pay_Sch_tbl.CLASS = 'PMT'
   AND AR_Rec_Appl_tbl.STATUS = 'UNAPP'
   AND AR_Pay_Sch_tbl.STATUS = 'OP'
   AND HZ_CUST_SITE_USES_TBL.SITE_USE_CODE = 'BILL_TO'
   AND HZ_CUST_Agcc_tblT_ALL_TBL.Agcc_tblOUNT_NUMBER = '<ENTER AGCC TBLOUNT NUMBER>'
   AND AR_Pay_Sch_tbl.TRX_DATE <= '<ENTER_TRX_DATE>'
   AND TRUNC(AR_Pay_Sch_tbl.GL_DATE) <= '<ENTER_GL_DATE>'
   AND AR_CASH_RECPT_HIST_TBL.STATUS NOT IN ('CLEARED') HAVING
 NVL(SUM(AR_Rec_Appl_tbl.AMOUNT_APPLIED), 0) > 0

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   ;

AR Receipt Class and Receipt Method in Oracle Receivables R12

The blog provides the steps to “How to Setup AR Receipt Classes in Oracle Receivables R12 ?”. The Receipt Classes in Oracle Receivables R12 helps in Receipt processing steps ( Receipt Confirmation, Receipt Remittance and Receipt Reconciliation.  The Receipt Method assigned to Receipt Class helps in determining the accounting for receipts in Oracle Receivables. Each Create Receipt Class should have the following defined

  • Receipt Creation Method ( Manual / Automatic)
  • Receipt Remittance Method ( Standard, Factoring, Standard and Factoring, No Remittance)
  • Receipt Payment Method

AR Receipt Classes Setup in Oracle Receivables R12

Perform the below steps on how to setup AR Receipt Classes in Oracle Apps AR R12

  • Navigate to Receipt Classes
  • Enter Receipt Name
Oracle Receivables Receipt Classes
  • Notes Receivable Receipt Class ( Select the Checkbox if Receipt to handle future payments through Check or Promissory Note Document are considered in this option. A Note could have the status ( Open, Return, Delinquent, Repurchase, Exchange)
  • Enter Creation Method ( Manual / Automatic)
  • Require Confirmation : Select Checkbox if allows automatic receipt creation to use the Receipt Class
  • Enter Remittance Method: Selection of Require Confirmation for automatic receipts, make Remittance Method as mandatory. The Remittance Methods can be classified as given below
  • Standard : Remittance account used for automatic receipts with the Receipt Class
  • Factoring : Factoring account used for automatic receipts with the Receipt Class
  • Standard and Factoring : Allows to select Remittance Account or Factoring Account regardless of the batch remittance method
  • No Remittance : If do not require receipts assigned to the receipt class to be remitted

Enter Clearance Method: The Receipts created using a payment method assigned to the receipt class rquires to be reconciled before posting them to Cash Account in the General Ledger. The Clearance Method can be classified as given below

  • Directly : Select the option if the receipts do not need to be remitted to the bank and subsequently cleared
  • By Automatic Clearing : Select the option if the receipts to be cleared using the Automatic Clearing program
  • By Matching : Select the option if the receipts to be cleared manual in Order Cash Management

Remittance Bank Accounts

Click “Bank Accounts” on Receipt Sources Windows to assign the Remittance Bank Account . Provide the below given details

S. NoGL Field NameGL Field DescriptionUser Action
1Operating UnitOperating UnitSelect OU (Operating Unit)
2Bank NameBank NameSelect Bank Name
3Account NameAccount NameSelect the Account Name
4Effective DatesEffective DateEnter the Effective Date
S. NoGL Field NameGL Field DescriptionUser Action
1CashCash Accounting FlexfieldEnter Cash Accounting segments
2BankBank Accounting FlexfieldEnter Bank Accounting segments
3Unapplied ReceiptsUnapplied Receipts Accounting FlexfieldEnter Unapplied Receipts Accounting segments
4Unidentified ReceiptsUnidentified Receipts Accounting FlexfieldEnter Unidentified Receipts Accounting segments
5On Account ReceiptsOn Account Receipts Accounting FlexfieldEnter On-Account Accounting segments
6Unearned DiscountsUnearned Discounts fieldSelect Unearned Discount Value
7Earned DiscountsEarned Discounts fieldSelect Earned Discount Value

Oracle Receivables AR Receipt Method Setup

Oracle Receivables R12 uses Payment method to determine the Customer’s Remittance Bank Account details . Oracle Receivables allows to assign multiple remittance banks to each payment method considering one bank account as the primary bank account for each currency. Payments methods can be assigned to Receipt Sources to account the manual receipts and Autolockbox in Oracle receivables.

Automatic Receipts are required to be associated with Payment Methods. The below given are the Receipt Rule to be defined for payment methods when used with automatic reeipts

  • One Per Customer : Allows to create 1 payment per person
  • One per Customer and Due Date : Allows to create 1 payment per person and Due Date. Multiple payments can be processed based on Due Date
  • One Per Site : Allows to create 1 payment per site
  • One Per Invoice : Allows to create 1 payment per invoice
  • One Per Site and Due Date : Allows to create 1 payment per site and Due Date. Multiple payments can be processed based on Due Date

Perform the below steps to setup Receipt Methods in Oracle Apps R12

  • Navigate to Receipt Classes Window
  • Enter the Receipt Class
  • Enter the New Payment Method ( shows as Printed Name field on Receipt Classes Window)
  • Receipt Maturity Date Rule ( Enter Maturity Date for Automatic Receipts where Due Date is used for payment processing)
  • Automatic Print Program ( Automatic Receipts uses receivables standard receipt print program to format the payment output)
  • Enter Effective Dates

AR Receipt API methods in Oracle Receivables R12

The blog provides the AR Receipt API methods and its usage in Oracle Receivables R12.  The Oracle Receivables used AR Receipt API for creating and updating receipts received for AR Receipts Forms and from AR Lockboxes

What functionality is provided by AR Receipt API ?

The Oracle Receivables (AR) Receipt API helps in providing the below given functionality

  • AR Receipt API allows to create Cash Receipts
  • AR Receipt API allows to create Cash Receipts and applying to the Debit item
  • AR Receipt API allows on -account application
  • AR Receipt API allows to Unapply the on-account application
  • AR Receipt API allows to Unapply Receipt to a particular AR transaction
  • AR Receipt API allows to Reverse the Receipt
  • AR Receipt API allows to perform Receipt Write -Off
  • AR Receipt API allows to create Miscellaneous Receipt
  • AR Receipt API allows to create Receipt-to-Receipt application
  • AR Receipt API allows to create Cash Receipts and on-account application

AR RECEIPT API – AR_RECEIPT_API_PUB

The AR Receipt API AR_RECEIPT_API_PUB provides the below given API call

AR Receipt API RoutineDescription
AR_RECEIPT_API_PUB.Create_CashCreates a single Cash Receipt
AR_RECEIPT_API_PUB.ApplyApplies the Cash Receipt to a particular Debit Item
AR_RECEIPT_API_PUB.Create_and_applyCreates the Cash Receipt and applies to a particular Debit Item
AR_RECEIPT_API_PUB.Unapply unapply a particular Debit Item against the Cash Receipt
AR_RECEIPT_API_PUB.Apply_on_accountCreates a on-account application for a Cash Receipt
AR_RECEIPT_API_PUB.Unapply_on_accountunapplies on-account application for a Cash Receipt
AR_RECEIPT_API_PUB.ReverseReverse the Cash Receipt
AR_RECEIPT_API_PUB.activity_applicationApplies Receipt to an activity such as Receipt Write -Off
AR_RECEIPT_API_PUB.activity_unapplicationUnapplies Receipt from an activity such as Receipt Write -Off
AR_RECEIPT_API_PUB.Create_miscCreates a Miscellaneous Receipt
AR_RECEIPT_API_PUB.apply_other_accountApplies Receipt to other account such as Claim Investigation
AR_RECEIPT_API_PUB.unapply_other_accountUnapplies Receipt from other account such as Claim Investigation
AR_RECEIPT_API_PUB.apply_open_receiptCreates a receipt-to-receipt application (payment netting)
AR_RECEIPT_API_PUB.unapply_open_receiptunapplies a receipt-to-receipt application (payment netting)
AR_RECEIPT_API_PUB.Create_apply_on_accCreates a cash receipt and an on-account application

Integration with Oracle Payments

The Receipt API uses the Oracle Payment Integration for the below given API calls

AR Receipt API Routine Integrates with Oracle Payments ?
AR_RECEIPT_API_PUB.CREATE_CASHNo
AR_RECEIPT_API_PUB.CREATE_AND_APPLYYes
AR_RECEIPT_API_PUB.CREATE_MISCNo
AR_RECEIPT_API_PUB.CREATE_APPLY_ON_ACCYes