Monday, August 31, 2009

Oracle Receivable receipt application on account in R12

The receipt should be previously created in order to apply receipt on account.Following is the code to apply receipt in oracle receivable.
This is the working minimum required parameters to be passed.Put the values as per requirement.

AR_RECEIPT_API_PUB.APPLY_ON_ACCOUNT (
P_API_VERSION => 1.0,
P_INIT_MSG_LIST =>FND_APL_G_FALSE,
P_COMMIT =>FND_APL_G_FALSE,
P_VALIDATION_LEVEL =>FND_APL_G_VALID_LEVEL_FULL,
X_RETURN_STATUS => L_RETURN_STATUS,
X_MSG_COUNT => L_MSG_COUNT,
X_MSG_DATA => L_MSG_DATA,
P_CASH_RECEIPT_ID => L_RECEIPT_ID,
P_RECEIPT_NUMBER => NULL,
P_AMOUNT_APPLIED => L_AMOUNT,
P_APPLY_DATE => l_APPLY_DATE ,
P_APPLY_GL_DATE => l_APPLY_TO_GL_DATE ,
P_USSGL_TRANSACTION_CODE => NULL,
P_ATTRIBUTE_REC => AR_RECEIPT_API_PUB.ATTRIBUTE_REC_CONST,
P_GLOBAL_ATTRIBUTE_REC => AR_RECEIPT_API_PUB.GLOBAL_ATTRIBUTE_REC_CONST,
P_COMMENTS => L_COMMENTS,
P_APPLICATION_REF_NUM => NULL,
P_SECONDARY_APPLICATION_REF_ID => NULL,
P_CUSTOMER_REFERENCE => NULL,
P_CALLED_FROM => NULL,
P_CUSTOMER_REASON => NULL,
P_SECONDARY_APP_REF_TYPE => NULL,
P_SECONDARY_APP_REF_NUM => NULL,
P_ORG_ID => L_ORG_ID
);

The input variable starting from L_ is given by developer.

The receipt applied can be viewed from
receivable >receipts >receipts

No comments:

Post a Comment