FA: SCM: INV: Shipment Lines are Backordered With Pending Transactions in Error: "The value provided for the Transaction Source Type attribute is invalid". (Doc ID 2757640.1)

Last updated on FEBRUARY 21, 2023

Applies to:

Symptoms

Sales order issue source transaction types are stuck in 'View Pending Transactions' UI, with following error -

Upon navigating to 'Manage Reservations and Picks' UI, the corresponding reservations against the item for corresponding transactions that deleted from 'View Pending Transactions' UI cannot be deleted. On trying to edit the reservations, it throws the following error.

The sales orders referencing these reservations are closed. When attempting reprocess the transactions, they still end up the same error again. The transaction type attached to the pending transaction is a seeded transaction type of Sales Order Issue transaction.

These transactions have resulted in the org having zero ATR (available to reserve) for these items. For such items the sales order cannot be progressed to reservation stage and fails with the following error in sales order orchestration.

STEPS TO REPRODUCE

1. Create a sales order.
2. Submit the sales order.
3. Sales order passes the 'Scheduling' stage and then orchestration fails.
4. See the error below when review the errors on sales order.

Error - A reservation was not created because the reservation quantity is greater than the available-to-reserve quantity.

5. Navigate to 'Manage Item Quantities'.
6. Query the item in warehouse where the sales order was created.
7. Click on the org once the item quantities are shown in UI.
8. Click 'View Availability' button.
9. See 'Available To Reserve' quantity is 0.
10. Review the reservations in 'Manage Reservations and Picks' UI.
11. See the reservations exists against multiple sales orders which are in closed status.
12. The reservations have 'Staged' check box checked.
13. Navigate to 'Manage Pending Transactions' UI.
14. Click on 'View Pending Transactions' button.
15. 'View Pending Transactions' shows the following error for these transactions.

Error - The value provided for the Transaction Source Type attribute is invalid

16. Try to delete the pending transaction.
17. Navigate to 'Manage Reservations and Picks' UI and see the reservation is not deleted.
18. Try to query the reservation for the specific sales order.
19. Expand the node and hit correct Sales order and then click Action > Edit Reservations button, see the below error.

Error - java.lang.Integer cannot be cast to java.math.BigDecimal

20. See the delete option is greyed out.
21. Now try to reprocess the transactions for one of sales order by Adding the Selected Transactions to Process in 'View Pending Transactions' UI.
22. The transactions are successfully added to be processed. The error is cleared from UI.
23. Submit 'Manage Inventory Transactions' ESS job.
24. See the same error appears back again.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.