Uncosted Material Transactions Issues (Costed_Flag = 'E'):
SELECT 'UNCOSTED TXNS',
organization_id,
transaction_id,
TO_CHAR(creation_date,'DD-MON-YY HH24:MI:SS') creation_date,
request_id,
transaction_set_id,
transaction_group_id,
costed_flag, error_code, error_explanation, mmt.*
FROM mtl_material_transactions mmt
WHERE costed_flag IN ('E','N');
1. Error Code: Error in obtaining the transfer price
Resolution: Add the item to the source price list and re-process (by Material cost transaction worker).
_______________________
_______________________
Source: ORDER ENTRY
The stuck transaction can be viewed by using the below query:
SELECT * FROM Mtl_Transactions_Interface WHERE Lock_Flag = 1
2. Error Code: 100
Error Explanation: failure:Ele_Acct( 40 ): 100 Error populating code combination segments
Resolution:
SELECT 'UNCOSTED TXNS',
organization_id,
transaction_id,
TO_CHAR(creation_date,'DD-MON-YY HH24:MI:SS') creation_date,
request_id,
transaction_set_id,
transaction_group_id,
costed_flag, error_code, error_explanation, mmt.*
FROM mtl_material_transactions mmt
WHERE costed_flag IN ('E','N');
1. Error Code: Error in obtaining the transfer price
Resolution: Add the item to the source price list and re-process (by Material cost transaction worker).
_______________________
_______________________
Source: ORDER ENTRY
The stuck transaction can be viewed by using the below query:
SELECT * FROM Mtl_Transactions_Interface WHERE Lock_Flag = 1
2. Error Code: 100
Error Explanation: failure:Ele_Acct( 40 ): 100 Error populating code combination segments
Resolution:
0 comments:
Post a Comment