Maximo Asset Management - Usuarios no tienen ningun material

1.- En Oracle Financial se genera una solicitud, en la cual el usuario solicita unos articulos, las mismas que no se visualizan en Maximo

2- La solicitud consta de dos cabeceras

3.- En la cabecera principal tenemos un número de OT

4.- Expando Lineas y vea las cabeceras relacionadas a los artículos

Cuando los usuarios no logran visualizar los materiales es debido a que las cabeceras no son las mismas, es decir ingresaron mal los datos en la requisición o solicitud.

5.- Verificamos en Oracle 

select fu.user_name, fu.description, PR.TYPE_LOOKUP_CODE, pr.segment1 as No_Requision, oeh.order_number as No_pedido, prl.last_update_date as transaction_date, pr.description, pr.authorization_status, pr.attribute5, pr.attribute7 AS OT_MAXIMO_CABECERA, msi.segment1||'-1', prl.item_description item_description_req,msi.description  item_description_item, prl.source_subinventory,mmt.subinventory_code,prl.unit_meas_lookup_code, prl.unit_price, prl.quantity, prl.QUANTITY_DELIVERED, mmt.QUANTITY_ADJUSTED, prl.attribute1, prl.attribute14 AS OT_MAXIMO_LINEA, mmt.TRANSACTION_SOURCE_NAME, mmt.transaction_reference, mmt.TRANSACTION_ACTION_ID, mmt.transaction_id, mmt.transaction_source_type_id,  mmt.TRANSACTION_TYPE_ID,  to_char(mmt.TRANSACTION_DATE,'DD/MON/RRRR HH24:MI:SS'),mmt.TRANSACTION_DATE, PR.CREATION_DATE, mmt.last_update_date, MMT.INVENTORY_ITEM_ID,   ROUND(MMT.ACTUAL_COST,2), MMT.TRANSACTION_QUANTITY, MMT.TRANSACTION_UOM, oel.order_quantity_uom, mta.accounting_line_type, gl.segment1||'-'||gl.segment2||'-'||gl.segment3||'-'||gl.segment4||'-'||gl.segment5||'-'||gl.segment6||'-'||gl.segment7||'-'||gl.segment8||'-'||gl.segment9||'-'||gl.segment10 as Gl_ACCOUNT, mta.reference_account,mmt.encumbrance_account, MMT.DISTRIBUTION_ACCOUNT_ID, mmt.attribute14, mmt.COSTED_FLAG
from MTL_MATERIAL_TRANSACTIONS mmt
left join MTL_TRANSACTION_ACCOUNTS mta on mta.transaction_id = mmt.transaction_id and  mta.inventory_item_id = mmt.inventory_item_id and mta.ORGANIZATION_ID = MMT.ORGANIZATION_ID
left join MTL_SYSTEM_ITEMS msi on msi.inventory_item_id = MMT.INVENTORY_ITEM_ID and MSI.ORGANIZATION_ID = MMT.ORGANIZATION_ID 
left join oe_order_lines_all oel on mmt.TRX_SOURCE_LINE_ID  =oel.LINE_ID and oel.INVENTORY_ITEM_ID = mmt.INVENTORY_ITEM_ID 
left join oe_order_headers_all oeh on oeh.HEADER_ID = oel.HEADER_ID
left join PO_REQUISITION_HEADERS_all pr on pr.requisition_header_id = oeh.source_document_id
left join PO_REQUISITION_LINES_all prl  on pr.requisition_header_id = prl.requisition_header_id and oel.INVENTORY_ITEM_ID = prl.ITEM_ID and prl.requisition_line_id = oel.source_document_line_id
left join PO_REQ_DISTRIBUTIONS_ALL prd on PRL.REQUISITION_LINE_ID = PRD.REQUISITION_LINE_ID
left join MTL_SYSTEM_ITEMS msi on msi.inventory_item_id = prl.item_id and MSI.ORGANIZATION_ID = PRL.DESTINATION_ORGANIZATION_ID 
left join FND_USER fu on fu.user_id = pr.created_by
left join gl_code_combinations gl on gl.code_combination_id = mmt.encumbrance_account--*/mta.reference_account --*/ prd.code_combination_id*/
where 
--fu.user_name = 'GRANDAD'
--oeh.order_number = '221094'
pr.segment1 in ('546310')
--Msi.segment1 in ('0000000695' ) 
--mmt.TRANSACTION_ACTION_ID in ('1','27')
--pr.attribute7 IN ('WO:OT-170084929') --OT cabecera
--prl.attribute14  IN ('WO:OT-160388356','WO:OT-170084929','WO:OT-160773485','WO:OT-160772272','WO:OT-160773492','WO:OT-160773499','WO:OT-160773502','WO:OT-160773551','WO:OT-160783696','WO:OT-160771669','WO:OT-160771920','WO:OT-160771965','WO:OT-160771966','WO:OT-160772269','WO:OT-160768634','WO:OT-160768661','WO:OT-160768662','WO:OT-160768665','WO:OT-160768674','WO:OT-160768684','WO:OT-160779747','WO:OT-160779827','WO:OT-160779830','WO:OT-160779988','WO:OT-160780101','WO:OT-160779970','WO:OT-160916184','WO:OT-161140324','WO:OT-161140345','WO:OT-161140445','WO:OT-161140720','WO:OT-161140724','WO:OT-161137313','WO:OT-161137293','WO:OT-161137298','WO:OT-161137343','WO:OT-161137422','WO:OT-161137329','WO:OT-161143667','WO:OT-161143675','WO:OT-161143695','WO:OT-161143709','WO:OT-161143719','WO:OT-161143722','WO:OT-161152952','WO:OT-161152955','WO:OT-161152912','WO:OT-161152917','WO:OT-161152920','WO:OT-161152937','WO:OT-161214656','WO:OT-161214923','WO:OT-161215303','WO:OT-161215339','WO:OT-161215381','WO:OT-161215263','WO:OT-161190328','WO:OT-161190333','WO:OT-161190343','WO:OT-161190348','WO:OT-161192257','WO:OT-161192754','WO:OT-161192784','WO:OT-161192833','WO:OT-161192841','WO:OT-161146639','WO:OT-161146646','WO:OT-161146664','WO:OT-161146675','WO:OT-161149690','WO:OT-161149699','WO:OT-161192760','WO:OT-161192764','WO:OT-161149714','WO:OT-161149722','WO:OT-161149878','WO:OT-161190304','WO:OT-161218853','WO:OT-161218924','WO:OT-161218947','WO:OT-161218977','WO:OT-161218436','WO:OT-161218919','WO:OT-161299432')  /*--OT linea*/ --and mmt.transaction_source_name is null
--and pr.attribute5 = 'MANTENIMIENTO'
--and mmt.TRX_SOURCE_LINE_ID = '1841562'
--mmt.transaction_source_name = 'WO:OT-171228902'--IN ('WO:OT-160388356','WO:OT-170084929','WO:OT-160773485','WO:OT-160772272','WO:OT-160773492','WO:OT-160773499','WO:OT-160773502','WO:OT-160773551','WO:OT-160783696','WO:OT-160771669','WO:OT-160771920','WO:OT-160771965','WO:OT-160771966','WO:OT-160772269','WO:OT-160768634','WO:OT-160768661','WO:OT-160768662','WO:OT-160768665','WO:OT-160768674','WO:OT-160768684','WO:OT-160779747','WO:OT-160779827','WO:OT-160779830','WO:OT-160779988','WO:OT-160780101','WO:OT-160779970','WO:OT-160916184','WO:OT-161140324','WO:OT-161140345','WO:OT-161140445','WO:OT-161140720','WO:OT-161140724','WO:OT-161137313','WO:OT-161137293','WO:OT-161137298','WO:OT-161137343','WO:OT-161137422','WO:OT-161137329','WO:OT-161143667','WO:OT-161143675','WO:OT-161143695','WO:OT-161143709','WO:OT-161143719','WO:OT-161143722','WO:OT-161152952','WO:OT-161152955','WO:OT-161152912','WO:OT-161152917','WO:OT-161152920','WO:OT-161152937','WO:OT-161214656','WO:OT-161214923','WO:OT-161215303','WO:OT-161215339','WO:OT-161215381','WO:OT-161215263','WO:OT-161190328','WO:OT-161190333','WO:OT-161190343','WO:OT-161190348','WO:OT-161192257','WO:OT-161192754','WO:OT-161192784','WO:OT-161192833','WO:OT-161192841','WO:OT-161146639','WO:OT-161146646','WO:OT-161146664','WO:OT-161146675','WO:OT-161149690','WO:OT-161149699','WO:OT-161192760','WO:OT-161192764','WO:OT-161149714','WO:OT-161149722','WO:OT-161149878','WO:OT-161190304','WO:OT-161218853','WO:OT-161218924','WO:OT-161218947','WO:OT-161218977','WO:OT-161218436','WO:OT-161218919','WO:OT-161299432')
--like 'WO:OT-161304728'--= 'WO:OT-150531883'--= 'WO:OT-151008837' --OT mtl_trans
and mta.accounting_line_type in ('35', '2', '10')
--AND MMT.TRANSACTION_TYPE_ID in ('15','34','129','130', '123', '128') 
--and mmt.transaction_date BETWEEN('15-NOV-2017')AND('16-NOV-2017') 
--AND PR.CREATION_DATE not BETWEEN('1-JAN-2015')AND('21-MAY-2015')
--and prl.quantity <>  prl.quantity_delivered
--and mmt.transaction_id = '11687403'
--and mta.reference_account is null
--AND MMT.TRANSACTION_SOURCE_TYPE_ID = '12'
--and mmt.transaction_source_type_id not in ('100','13')
--AND gl.segment3 = '40110'
--AND GL.SEGMENT4 = '8502'
--and mmt.costed_flag is not null
--and mmt.organization_id ='121'
order by mmt.transaction_source_name, msi.segment1, mmt.transaction_date, mmt.TRANSACTION_QUANTITY

En los resultados observamos que las OT no son las mismas

Solución: El mismo usuario debe generar la devolución del material en el sistema y se debe generar otra solicitud ingresando la OT correcta.