Receipt Workbench Error: After Changing Receipt Method Name, When Creating a Prepayment, Error is Raised: A payment failure hold has been applied against this order.
(Doc ID 1108263.1)
Last updated on FEBRUARY 20, 2019
Oracle Receivables - Version 12.1.2 and later Information in this document applies to any platform.
The following messages are received when booking an order:
Create_Prepayment: The document sequence number was used to default the receipt the receipt number. Payment processing for 1.08 failed. A payment failure hold has been applied against this order. Order has been booked.
The debug file shows:
OEXVPPYB: before calling AR Create_Prepayment: 1823 OEXVPPYB: receipt_method_id is: 1001 OEXVPPYB: p_approval_code is: OEXVPPYB: p_trxn_extension_id is: OEXVPPYB: org_id is: 85 OEXVPPYB: payment_set_id is: OEXVPPYB: AFTER AR CREATE_PREPAYMENT CASH_RECEIPT_ID IS: OEXVPPYB: AFTER AR CREATE_PREPAYMENT PAYMENT_SET_ID IS: OEXVPPYB: AFTER AR CREATE_PREPAYMENT CHECK NUMBER IS: OEXVPPYB: AFTER AR CREATE_PREPAYMENT x_payment_response_error_code IS: OEXVPPYB: AFTER AR CREATE_PREPAYMENT approval_code IS: OEXVPPYB: AFTER AR CREATE_PREPAYMENT x_msg_count IS: 2 OEXVPPYB: AFTER AR CREATE_PREPAYMENT RETURN STATUS IS: E Error message from AR API: The document sequence number was used to default the receipt number. LEAVING OE_MSG_PUB.ADD_TEXT Error message from AR API: Create_Prepayment : The document sequence number was used to default the receipt number. LEAVING OE_MSG_PUB.ADD_TEXT EXITING OE_PREPAYMENT_PV.CREATE_RECEIPT. OEXVPPYB: After calling Create_Receipt API, return status is: E after create_receipt, applying payment failure hold. OEXVPPYB: IN APPLY PREPAYMENT HOLDS OEXVPPYB: HEADER ID : 1823 OEXVPPYB: HOLD ID : 14 OEXVPPYB: CHECKING IF REQUESTED PREPAYMENT HOLD ALREADY APPLIED OEXVPPYB: IN CHECK FOR PREPAYMENT HOLD IN OE_HOLDS_PUB.CHECK_HOLDS CHECKING HOLD ON HEADER ID: 1823 ENTERING OE_SYS_PARAMETERS.VALUE Going to get the value for ONT_CASCADE_HOLD_NONSMC_PTO ENTERING OE_SYS_PARAMETERS_PVT.VALUE 85 Parameter value exists. PARAMETER VALUE: NO HOLDS FOUND FOR HEADER ID: 1823 EXITING OE_HOLDS_PUB.CHECK_HOLDS
Also noticed that when creating a Manual Receipt using the same Receipt Method used by Prepayment, the Document Number is not populated.
The name associated to the receipt method was modified.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!