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 JUNE 08, 2016

Applies to:

Oracle Receivables - Version 12.1.2 and later
Information in this document applies to any platform.
Checked for relevance on 19-Jul-2013



Symptoms

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.

Changes

The name associated to the receipt method was modified.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms