{"id":8920,"date":"2015-09-28T20:18:35","date_gmt":"2015-09-28T19:48:35","guid":{"rendered":"http:\/\/www.orabr.com\/?p=8920"},"modified":"2015-09-29T10:16:38","modified_gmt":"2015-09-29T13:16:38","slug":"-ERRO-RECEBIMENTO-DE-REQUISICAO-INTERNA-4","status":"publish","type":"post","link":"https:\/\/orabr.virttus.com\/?p=8920","title":{"rendered":"ERRO RECEBIMENTO DE REQUISI\u00c7\u00c3O INTERNA"},"content":{"rendered":"<p><HTML><HTML><\/p>\n<div>  <span style=\"display:none\">&nbsp;<\/span>    <!--~-|**|PrettyHtmlStartT|**|-~-->  <\/p>\n<div id=\"ygrp-mlmsg\" style=\"position:relative;\">\n<div id=\"ygrp-msg\" style=\"z-index: 1;\">  <!--~-|**|PrettyHtmlEndT|**|-~-->        <\/p>\n<div id=\"ygrp-text\" >\n<div class=\"WordSection1\">\n<p class=\"MsoNormal\"><span lang=\"PT-BR\" style=\"font-size:11.0pt;color:#1F497D;\">Bom dia Galera&#8230; obrigado pelo retorno de todos!!<o><\/o><\/span><\/p>\n<p class=\"MsoNormal\"><span lang=\"PT-BR\" style=\"font-size:11.0pt;color:#1F497D;\"><o>&nbsp;<\/o><\/span><\/p>\n<p class=\"MsoNormal\"><span lang=\"PT-BR\" style=\"font-size:11.0pt;color:#1F497D;\">Neste caso, foi feito apenas um shipment&#8230;<o><\/o><\/span><\/p>\n<p class=\"MsoNormal\"><span lang=\"PT-BR\" style=\"font-size:11.0pt;color:#1F497D;\"><o>&nbsp;<\/o><\/span><\/p>\n<p class=\"MsoNormal\"><span lang=\"PT-BR\" style=\"font-size:11.0pt;color:#1F497D;\">Para entendimento do racioc\u00ednio:<o><\/o><\/span><\/p>\n<p class=\"MsoListParagraph\">< ![if !supportLists]><span style=\"font-size:11.0pt;color:#1F497D;\"><span>1)<span style=\"font:7.0pt &quot;Times New Roman&quot;;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <\/span><\/span><\/span>< ![endif]><span style=\"font-size:11.0pt;color:#1F497D;\">Recuperei o shipment_line_id pela tabela cll_f189_invoice_lines;<o><\/o><\/span><\/p>\n<p class=\"MsoListParagraph\">< ![if !supportLists]><span style=\"font-size:11.0pt;color:#1F497D;\"><span>2)<span style=\"font:7.0pt &quot;Times New Roman&quot;;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <\/span><\/span><\/span>< ![endif]><span style=\"font-size:11.0pt;color:#1F497D;\">Com este shipment_line_id, recuperei o shipment_header_id na tabela rcv_shipment_lines;<o><\/o><\/span><\/p>\n<p class=\"MsoListParagraph\">< ![if !supportLists]><span lang=\"PT-BR\" style=\"font-size:11.0pt;color:#1F497D;\"><span>3)<span style=\"font:7.0pt &quot;Times New Roman&quot;;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <\/span><\/span><\/span>< ![endif]><span lang=\"PT-BR\" style=\"font-size:11.0pt;color:#1F497D;\">Com este shipment_header_id, recuperei o registro na tabela rcv_shipment_headers, e esta n\u00e3o est\u00e1 com o receipt_num;<o><\/o><\/span><\/p>\n<p class=\"MsoNormal\"><span lang=\"PT-BR\" style=\"font-size:11.0pt;color:#1F497D;\"><o>&nbsp;<\/o><\/span><\/p>\n<p class=\"MsoNormal\"><span lang=\"PT-BR\" style=\"font-size:11.0pt;color:#1F497D;\">Em um passo seguinte, fiz:<o><\/o><\/span><\/p>\n<p class=\"MsoListParagraph\">< ![if !supportLists]><span lang=\"PT-BR\" style=\"font-size:11.0pt;color:#1F497D;\"><span>1)<span style=\"font:7.0pt &quot;Times New Roman&quot;;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <\/span><\/span><\/span>< ![endif]><span lang=\"PT-BR\" style=\"font-size:11.0pt;color:#1F497D;\">Pelo n\u00famero do RI(receipt_num) e Organiza\u00e7\u00e3o de recebimento(ship_to_org_id), recuperei um registro na tabela rcv_shipment_headers;<o><\/o><\/span><\/p>\n<p class=\"MsoListParagraph\">< ![if !supportLists]><span lang=\"PT-BR\" style=\"font-size:11.0pt;color:#1F497D;\"><span>2)<span style=\"font:7.0pt &quot;Times New Roman&quot;;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <\/span><\/span><\/span>< ![endif]><span lang=\"PT-BR\" style=\"font-size:11.0pt;color:#1F497D;\">Este registro \u00a0recuperado n\u00e3o continha correspondente na tabela rcv_shipment_lines<o><\/o><\/span><\/p>\n<p class=\"MsoNormal\"><span lang=\"PT-BR\" style=\"font-size:11.0pt;color:#1F497D;\"><o>&nbsp;<\/o><\/span><\/p>\n<p class=\"MsoNormal\"><span lang=\"PT-BR\" style=\"font-size:11.0pt;color:#1F497D;\">Conclus\u00e3o: O n\u00famero do recebimento(receipt_num) est\u00e1 gravado em um registro da tabela rcv_shipment_headers que n\u00e3o est\u00e1 relacionado com nenhum registro na rcv_shipment_lines.<o><\/o><\/span><\/p>\n<p class=\"MsoNormal\"><span lang=\"PT-BR\" style=\"font-size:11.0pt;color:#1F497D;\"><o>&nbsp;<\/o><\/span><\/p>\n<p class=\"MsoNormal\"><span lang=\"PT-BR\" style=\"font-size:11.0pt;color:#1F497D;\">Datafix:<o><\/o><\/span><\/p>\n<p class=\"MsoNormal\"><span lang=\"PT-BR\" style=\"font-size:11.0pt;color:#1F497D;\"><o>&nbsp;<\/o><\/span><\/p>\n<p class=\"MsoListParagraph\">< ![if !supportLists]><span lang=\"PT-BR\" style=\"font-size:11.0pt;color:#1F497D;\"><span>1)<span style=\"font:7.0pt &quot;Times New Roman&quot;;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <\/span><\/span><\/span>< ![endif]><span lang=\"PT-BR\" style=\"font-size:11.0pt;color:#1F497D;\">Atualizei o n\u00famero do RI(receipt_num) no registro correto na rcv_shipment_headers;<o><\/o><\/span><\/p>\n<p class=\"MsoListParagraph\">< ![if !supportLists]><span lang=\"PT-BR\" style=\"font-size:11.0pt;color:#1F497D;\"><span>2)<span style=\"font:7.0pt &quot;Times New Roman&quot;;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <\/span><\/span><\/span>< ![endif]><span lang=\"PT-BR\" style=\"font-size:11.0pt;color:#1F497D;\">Atualizei o registro que continha o n\u00famero do RI na rcv_shipment_headers com null.<o><\/o><\/span><\/p>\n<p class=\"MsoNormal\"><span lang=\"PT-BR\" style=\"font-size:11.0pt;color:#1F497D;\"><o>&nbsp;<\/o><\/span><\/p>\n<p class=\"MsoNormal\"><span lang=\"PT-BR\" style=\"font-size:11.0pt;color:#1F497D;\">Rodei a aprova\u00e7\u00e3o do RI e o processo continuou normalmente.<o><\/o><\/span><\/p>\n<p class=\"MsoNormal\"><span lang=\"PT-BR\" style=\"font-size:11.0pt;color:#1F497D;\"><o>&nbsp;<\/o><\/span><\/p>\n<p class=\"MsoNormal\"><span lang=\"PT-BR\" style=\"font-size:11.0pt;color:#1F497D;\">Mas ainda n\u00e3o descobri a causa\/raiz do erro!!!<o><\/o><\/span><\/p>\n<p class=\"MsoNormal\"><span lang=\"PT-BR\" style=\"font-size:11.0pt;color:#1F497D;\"><o>&nbsp;<\/o><\/span><\/p>\n<p class=\"MsoNormal\"><span lang=\"PT-BR\" style=\"font-size:11.0pt;color:#1F497D;\">Obrigado pela ajuda e informa\u00e7\u00f5es compartilhadas meus amigos!<o><\/o><\/span><\/p>\n<p class=\"MsoNormal\"><span lang=\"PT-BR\" style=\"font-size:11.0pt;color:#1F497D;\"><o>&nbsp;<\/o><\/span><\/p>\n<p class=\"MsoNormal\"><span lang=\"PT-BR\" style=\"font-size:11.0pt;color:#1F497D;\">Abra\u00e7o!<o><\/o><\/span><\/p>\n<p class=\"MsoNormal\"><span lang=\"PT-BR\" style=\"font-size:11.0pt;color:#1F497D;\">Cleyton Wada<o><\/o><\/span><\/p>\n<p class=\"MsoNormal\"><span lang=\"PT-BR\" style=\"font-size:11.0pt;color:#1F497D;\"><o>&nbsp;<\/o><\/span><\/p>\n<p class=\"MsoNormal\"><span lang=\"PT-BR\" style=\"font-size:11.0pt;color:#1F497D;\"><o>&nbsp;<\/o><\/span><\/p>\n<p class=\"MsoNormal\"><span lang=\"PT-BR\" style=\"font-size:11.0pt;color:#1F497D;\"><o>&nbsp;<\/o><\/span><\/p>\n<p class=\"MsoNormal\"><span lang=\"PT-BR\" style=\"font-size:11.0pt;color:#1F497D;\"><o>&nbsp;<\/o><\/span><\/p>\n<p class=\"MsoNormal\"><span lang=\"PT-BR\" style=\"font-size:11.0pt;color:#1F497D;\"><o>&nbsp;<\/o><\/span><\/p>\n<p class=\"MsoNormal\"><span lang=\"PT-BR\" style=\"font-size:11.0pt;color:#1F497D;\"><o>&nbsp;<\/o><\/span><\/p>\n<p class=\"MsoNormal\"><span lang=\"PT-BR\" style=\"font-size:11.0pt;color:#1F497D;\"><o>&nbsp;<\/o><\/span><\/p>\n<p class=\"MsoNormal\"><span lang=\"PT-BR\" style=\"font-size:11.0pt;color:#1F497D;\"><o>&nbsp;<\/o><\/span><\/p>\n<div>\n<div style=\"border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in;\">\n<p class=\"MsoNormal\"><b><span lang=\"PT-BR\" style=\"font-size:10.0pt;\">De:<\/span><\/b><span lang=\"PT-BR\" style=\"font-size:10.0pt;\"> <a href=\"mailto:\"><\/a> [mailto:<a href=\"mailto:\"><\/a>] <br \/><b>Enviada em:<\/b> Monday, September 28, 2015 4:58 PM<br \/><b>Para:<\/b> <br \/><b>Assunto:<\/b>   Erro Recebimento de Requisi\u00e7\u00e3o Interna<o><\/o><\/span><\/p>\n<\/div>\n<\/div>\n<p class=\"MsoNormal\"><o>&nbsp;<\/o><\/p>\n<p class=\"MsoNormal\">&nbsp; <o><\/o><\/p>\n<div id=\"ygrp-mlmsg\">\n<div id=\"ygrp-msg\">\n<div id=\"ygrp-text\">\n<div>\n<p class=\"MsoNormal\">Fala Cleyton.<o><\/o><\/p>\n<div>\n<p class=\"MsoNormal\">S\u00f3 \u00e9 poss\u00edvel receber os itens que constam no mesmo shipment_header_id da Ordem Interna. Se foram feitos v\u00e1rios shipments, voc\u00ea deve receber linha por linha.<o><\/o><\/p>\n<\/div>\n<div>\n<p class=\"MsoNormal\">Grato,<o><\/o><\/p>\n<\/div>\n<div>\n<p class=\"MsoNormal\" style=\"margin-bottom:12.0pt;\">Louren\u00e7o<o><\/o><\/p>\n<div>\n<div class=\"MsoNormal\" align=\"center\" style=\"text-align:center;\">\n<hr size=\"2\" width=\"100%\" align=\"center\" id=\"stopSpelling\"\/><\/div>\n<p class=\"MsoNormal\">To: <a href=\"mailto:\"><\/a><a href=\"mailto:\"><\/a><br \/>From: <a href=\"mailto:\"><\/a><a href=\"mailto:\"><\/a><\/p>\n<p>Subject:   Erro Recebimento de Requisi\u00e7\u00e3o Interna<\/p>\n<p>&nbsp; <o><\/o><\/p>\n<div id=\"ecxygrp-mlmsg\">\n<div id=\"ecxygrp-msg\">\n<div id=\"ecxygrp-text\">\n<p class=\"MsoNormal\"><o>&nbsp;<\/o><\/p>\n<div>\n<p class=\"MsoNormal\" style=\"margin-bottom:12.0pt;\">Ol\u00e1 Cleyton, de acordo com o note abaixo este \u00e9 o comportamento esperado:<\/p>\n<p>Unable to Receive Multiple Lines of Internal Requisition &quot;You Have Selected Shipments Belonging To Different Internal Orders&quot; (Doc ID 1333758.1)<o><\/o><\/p>\n<div style=\"border-bottom:solid #C4D1E6 1.0pt;padding:0in 0in 0in 0in;background:#777773;\">\n<h2 style=\"background:#777773;padding:0in;\"><span style=\"font-size:12.0pt;color:white;text-transform:uppercase;\">CAUSE<o><\/o><\/span><\/h2>\n<\/div>\n<p class=\"MsoNormal\"><span style=\"color:black;\">This is expected behavior.<\/p>\n<p>The warning message indicates that it is not possible to receive different ISO shipments in one receipt. The shipments should be received separately. This is a restriction of the system.&nbsp;<\/p>\n<p>This is explained in the following bugs<br \/><\/span><a href=\"https:\/\/support.oracle.com\/epmos\/faces\/BugDisplay?parent=DOCUMENT&amp;sourceId=1333758.1&amp;id=12602419\" target=\"_blank\"><span>Bug 12602419<\/span><\/a><span style=\"color:black;\">&nbsp; INTRANSIT RECEIPTS ERROR-YOU HAVE SELECTED SHIPMENTS BELONGING TO DIFFERENT IO and related to Enhancement Request&nbsp;<\/span><a href=\"https:\/\/support.oracle.com\/epmos\/faces\/BugDisplay?parent=DOCUMENT&amp;sourceId=1333758.1&amp;id=3840654\" target=\"_blank\"><span>Bug 3840654<\/span><\/a><span style=\"color:black;\">&nbsp;INCORRECT TEXT ASSOCIATED WITH RCV_INTORD_MISMATCH_SHIPMENTS RCVRCERC.<\/p>\n<p>The Enhancement Request is still open to determine if the error message should be changed<br \/>as this situation can occur for the same: Internal Order (when Ship Confirm is performed multiple times + for the same Internal Order\/Internal Order Line).<br \/>The message should be something like this:<br \/>You have selected shipments belonging to different Internal Order Deliveries.<br \/>You can only receive lines belonging to the same delivery.&nbsp;<\/span><\/p>\n<p>At,<br \/>Danilo<o><\/o><\/p>\n<div>\n<table class=\"MsoNormalTable\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\" width=\"100%\" style=\"width:100.0%;\" id=\"ecxkmPgTpl:r1:0:tl5\">\n<tr>\n<td style=\"padding:0in 0in 0in 0in;\"><\/td>\n<\/tr>\n<\/table>\n<\/div>\n<\/div>\n<div>\n<p class=\"MsoNormal\"><o>&nbsp;<\/o><\/p>\n<div>\n<p class=\"MsoNormal\">2015-09-28 16:43 GMT-03:00 &#8216;Cleyton Wada&#8217; <a href=\"mailto:ctcwada@yahoo.com.br\"><\/a><a href=\"mailto:ctcwada@yahoo.com.br\">ctcwada@yahoo.com.br<\/a>  &lt;<a href=\"mailto:\" target=\"_blank\"><\/a><a href=\"mailto:\"><\/a>&gt;:<o><\/o><\/p>\n<div>\n<p class=\"MsoNormal\" style=\"background:white;\">&nbsp; <o><\/o><\/p>\n<div>\n<div>\n<div>\n<p class=\"MsoNormal\" style=\"background:white;\"><o>&nbsp;<\/o><\/p>\n<div>\n<p class=\"ecxmsonormal\" style=\"background:white;\"><span lang=\"PT-BR\" style=\"font-size:11.0pt;color:#1F497D;\">Diga l\u00e1 PessoALL, tudo bem?<\/span><o><\/o><\/p>\n<p class=\"ecxmsonormal\" style=\"background:white;\"><span lang=\"PT-BR\" style=\"font-size:11.0pt;color:#1F497D;\">&nbsp;<\/span><o><\/o><\/p>\n<p class=\"ecxmsonormal\" style=\"background:white;\"><span lang=\"PT-BR\" style=\"font-size:11.0pt;color:#1F497D;\">Estou tentando receber uma Requisi\u00e7\u00e3o Interna pelo RI, mas ao aprovar estou me deparando com o erro abaixo: <\/span><o><\/o><\/p>\n<p class=\"ecxmsonormal\" style=\"background:white;\"><span lang=\"PT-BR\" style=\"font-size:11.0pt;color:#1F497D;\">&nbsp;<\/span><o><\/o><\/p>\n<p class=\"ecxmsonormal\" style=\"background:white;\"><b><span style=\"font-size:11.0pt;color:#1F497D;\">&#8220;you have selected shipments belonging to different internal orders. Only shipments from the same internal order are allowed on a receipt<\/span><\/b><span style=\"font-size:11.0pt;color:#1F497D;\">&#8221;.<\/span><o><\/o><\/p>\n<p class=\"ecxmsonormal\" style=\"background:white;\"><span style=\"font-size:11.0pt;color:#1F497D;\">&nbsp;<\/span><o><\/o><\/p>\n<p class=\"ecxmsonormal\" style=\"background:white;\"><span lang=\"PT-BR\" style=\"font-size:11.0pt;color:#1F497D;\">Algu\u00e9m j\u00e1 passou por este erro?<\/span><o><\/o><\/p>\n<p class=\"ecxmsonormal\" style=\"background:white;\"><span lang=\"PT-BR\" style=\"font-size:11.0pt;color:#1F497D;\">&nbsp;<\/span><o><\/o><\/p>\n<p class=\"ecxmsonormal\" style=\"background:white;\"><span lang=\"PT-BR\" style=\"font-size:11.0pt;color:#1F497D;\">Obrigado &amp; Abra\u00e7o!<\/span><o><\/o><\/p>\n<p class=\"ecxmsonormal\" style=\"background:white;\"><span lang=\"PT-BR\" style=\"font-size:11.0pt;color:#1F497D;\">Cleyton Wada<\/span><o><\/o><\/p>\n<\/div>\n<p class=\"MsoNormal\" style=\"background:white;\"><o>&nbsp;<\/o><\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<p class=\"MsoNormal\"><o>&nbsp;<\/o><\/p>\n<\/div>\n<p class=\"MsoNormal\"><o>&nbsp;<\/o><\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div>\n<p class=\"MsoNormal\"><span style=\"color:white;\"><o><\/o><\/span><\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/p><\/div>\n<p>               <\/HTML><\/HTML><\/p>\n","protected":false},"excerpt":{"rendered":"<p>&nbsp; Bom dia Galera&#8230; obrigado pelo retorno de todos!! &nbsp; Neste caso, foi feito apenas um shipment&#8230; &nbsp; Para entendimento do racioc\u00ednio: < ![if !supportLists]>1)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&hellip; <\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[56],"tags":[77,99,105,76,103,104,97,98,107,102,108,72,100,85,87,59,89,101,106,46,84],"class_list":["post-8920","post","type-post","status-publish","format-standard","hentry","category-oracle","tag-adf","tag-applications","tag-atg-financials","tag-banco-de-dados","tag-dadabase","tag-dba","tag-duvidas-e-repostas-oracle-vagas","tag-ebs","tag-etl","tag-fusion","tag-hyperion","tag-java","tag-odi","tag-oracle-apex","tag-oracle-forms","tag-oracle-oportunidades","tag-oracle-reports","tag-people-soft","tag-plsql-bi","tag-soa","tag-supply-chain"],"_links":{"self":[{"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=\/wp\/v2\/posts\/8920","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=8920"}],"version-history":[{"count":0,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=\/wp\/v2\/posts\/8920\/revisions"}],"wp:attachment":[{"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=8920"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=8920"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=8920"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}