Minimum column required for receipt creation (oracle receivable) r12

This is the minimum requirement for recipt creation.The code can be used for both identified recceipt and unidentified recipt.
For identified put customer id and customer site use id
and for unidentified receipt creation put null for these two column.

AR_RECEIPT_API_PUB.CREATE_CASH(
P_API_VERSION => 1.0
,P_INIT_MSG_LIST => FND_API.G_FALSE
,P_COMMIT => FND_API.G_FALSE
,P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL
,X_RETURN_STATUS => L_RETURN_STATUS
,X_MSG_COUNT => L_MSG_COUNT
,X_MSG_DATA => L_MSG_DATA
,P_USR_CURRENCY_CODE => NULL
,P_CURRENCY_CODE => 'USD'
,P_USR_EXCHANGE_RATE_TYPE => NULL
,P_EXCHANGE_RATE_TYPE => NULL
,P_EXCHANGE_RATE => NULL
,P_EXCHANGE_RATE_DATE => NULL
,P_AMOUNT => L_AMOUNT
,P_FACTOR_DISCOUNT_AMOUNT => NULL
,P_RECEIPT_NUMBER => L_RECEIPT_NUMBER
,P_RECEIPT_DATE => L_RECEIPT_DATE
,P_GL_DATE => L_GL_DATE
,P_MATURITY_DATE => NULL
,P_POSTMARK_DATE => NULL
,P_CUSTOMER_ID => l_customer_id-------null if unidentified
,P_CUSTOMER_NAME => NULL
,P_CUSTOMER_NUMBER => NULL
,P_CUSTOMER_BANK_ACCOUNT_ID => NULL
,P_CUSTOMER_BANK_ACCOUNT_NUM => NULL
,P_CUSTOMER_BANK_ACCOUNT_NAME => NULL
,P_PAYMENT_TRXN_EXTENSION_ID => NULL
,P_LOCATION => NULL
,P_CUSTOMER_SITE_USE_ID => l_customer_site_use_id----------null for unidenfied
,P_DEFAULT_SITE_USE =>'Y'
,P_CUSTOMER_RECEIPT_REFERENCE => NULL
,P_OVERRIDE_REMIT_ACCOUNT_FLAG => NULL
,P_REMITTANCE_BANK_ACCOUNT_ID => NULL
,P_REMITTANCE_BANK_ACCOUNT_NUM => NULL
,P_REMITTANCE_BANK_ACCOUNT_NAME => NULL
,P_DEPOSIT_DATE => NULL
,P_RECEIPT_METHOD_ID => NULL
,P_RECEIPT_METHOD_NAME => L_RECEIPT_METHOD_NAME
,P_DOC_SEQUENCE_VALUE => NULL
,P_USSGL_TRANSACTION_CODE => NULL
,P_ANTICIPATED_CLEARING_DATE => NULL
,P_CALLED_FROM => NULL
,P_COMMENTS => L_COMMENTS
,P_ISSUER_NAME => NULL
,P_ISSUE_DATE => NULL
,P_ISSUER_BANK_BRANCH_ID => NULL
,P_ORG_ID => l_ORG_ID
,P_INSTALLMENT => NULL
,P_CR_ID =>L_RECEIPT_ID
);

You can go to receivable>receipts>receipts in order to view the receipt created.
you can query the receipt by its receipt number.Here the inputcolumn starting from l_ are
the inputs given from staging table.


cheers!!