Oracle sales order stuck in Entered status without Receipt
Issue: Sales Order imported using interface is stuck in 'Entered' status without receipt even when prepayments exist and booking the Order is failing.
Cause: One of the reason could be length of value "order_payments_iface.check_number" /oe_payments.check_number is more than 30 characters. As this value will be used as receipt number, (AR_CASH_RECEIPTS_ALL.RECEIPT_NUMBER) which is of length 30 characters.
Correct the value from Order Payments screen and follow below approach to book the order
Navigate to Sales Order HEader information and right click, use "Retry activities in Error"
Issue: Sales Order imported using interface is stuck in 'Entered' status without receipt even when prepayments exist and booking the Order is failing.
Cause: One of the reason could be length of value "order_payments_iface.check_number" /oe_payments.check_number is more than 30 characters. As this value will be used as receipt number, (AR_CASH_RECEIPTS_ALL.RECEIPT_NUMBER) which is of length 30 characters.
Correct the value from Order Payments screen and follow below approach to book the order
Navigate to Sales Order HEader information and right click, use "Retry activities in Error"
Workflow background process runs to
clear out the record and the order status will be in booked status and
prepayment receipts will be created.
No comments:
Post a Comment