Solution to OracleEBS "handling material handling ticket" error

OracleEBSldquo; handling material handling ticket rdquo; error Solution

Oracle EBS ldquo; handling material handling ticket rdquo; error Solution

This chapter describes how to handle the "handling material handling tickets" error?
Main signs:
1. If this option is selected, pressing "process" does not work.
2. "View/update allocation (U)" cannot be viewed )"
3. "Source sub-stock" is empty.
For example:

In the face of such records, I checked the information related to handling, such as the order line status, shipping transaction processing status, whether there was any receivables, and whether there were biological transactions, follow the steps below to check:
The following actual data is used as an example:
Item No.: 181810101356
Sales ORDER: 2010001862.20 domestic sales \. Sales ORDER. ORDER ENTRY
Order line: 1.1
1. Check that the shipping transaction status with the corresponding order line is "connected" and the next step is "not applicable ".

2. Check that the order line status is "closed"

Order line status

Select oeh. ORDER_NUMBER, -- Order Number
OEL. FLOW_STATUS_CODE, -- order row status
OEL. SHIPPED_QUANTITY, -- shipping quantity
OEL. LINE_ID, -- order line ID
OEL. Line_Number -- order line number
FROM OE_ORDER_LINES_ALL OEL, OE_ORDER_HEADERS_ALL OEH
Where oel. LINE_ID IN
(SELECT MTL_TXN_REQUEST_LINES_V.TXN_SOURCE_LINE_ID
FROM MTL_TXN_REQUEST_LINES_V
WHERE organization_id = '20140901'
AND-1 =-1
And (mtl_txn_request_lines_v.move_order_type! = 6 AND
Mtl_txn_request_lines_v.line_status in (3, 7, 9 )))
And oeh. HEADER_ID = OEL. HEADER_ID

3. check whether there are materials for transaction processing?

Material Transaction Processing

Select *
From MTL_MATERIAL_TRANSACTIONS Mt
WHERE Mt. Source_Line_Id IN
(Select distinct TXN_SOURCE_LINE_ID
FROM MTL_TXN_REQUEST_LINES_V
WHERE organization_id = '20140901'
AND-1 =-1
And (mtl_txn_request_lines_v.move_order_type! = 6 AND
Mtl_txn_request_lines_v.line_status in (3, 7, 9 )))
And Mt. SOURCE_CODE = 'order ENTRY'

4. check whether any receivables are processed?

Receivables

SELECT trxl. interface_line_attribute1, -- Order Number
Trxl. interface_line_attribute3, -- delivery order No.
Trxl. interface_line_attribute6, -- order line ID
Trxl. quantity_invoiced -- invoice quantity
FROM Ra_Customer_Trx_Lines_All trxl
WHERE trxl. interface_line_attribute6 in
(SELECT MTL_TXN_REQUEST_LINES_V.TXN_SOURCE_LINE_ID
FROM MTL_TXN_REQUEST_LINES_V
WHERE organization_id = '20140901'
AND-1 =-1
And (mtl_txn_request_lines_v.move_order_type! = 6 AND
Mtl_txn_request_lines_v.line_status in (3, 7, 9 )))
Order by line_number

5. After the above analysis, the corresponding order line and shipment transaction processing has been closed, plus the material transaction processing and receivables transaction processing. Indicates that the corresponding line of the order has been completed from the sales registration --> pick database --> transportation --> shipment confirmation --> receivables and so on, this indicates that the records for handling the material handling ticket can be canceled or deleted. However, I suggest you cancel it. For some reasons, the status of the Materials Handling ticket can be changed from "pre-approval" to "canceled"

And then save it. The system will automatically process it. You can also use SQL to directly modify it in the background:

Update mtl_txn_request_lines l
Set l. line_status = 5 -- old is 7
Where l. line_id = 658478;

Note: This method is only used as the test parameter. You can use PROD only when the UAT test is OK.