{"id":14285,"date":"2017-06-02T13:12:04","date_gmt":"2017-06-02T16:12:04","guid":{"rendered":"http:\/\/orabr.com\/?p=14285"},"modified":"2017-06-02T13:21:37","modified_gmt":"2017-06-02T16:21:37","slug":"-erro-pac-3","status":"publish","type":"post","link":"https:\/\/orabr.virttus.com\/?p=14285","title":{"rendered":"Erro PAC"},"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 style=\"color:#000;background-color:#fff;font-family:Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:13px;\">  <span id=\"yui_3_16_0_ym19_1_1496419506613_9562\">  <\/p>\n<div id=\"yui_3_16_0_ym19_1_1496419506613_9551\">\n<div id=\"yui_3_16_0_ym19_1_1496419506613_9552\">\n<div id=\"yui_3_16_0_ym19_1_1496419506613_9553\">Ol\u00e1 Mauricio, pode me add no skype, talvez eu consiga lhe ajudar<br id=\"yui_3_16_0_ym19_1_1496419506613_9554\" clear=\"none\">  <br id=\"yui_3_16_0_ym19_1_1496419506613_9555\" clear=\"none\">  <\/div>\n<p>  sinval.costa69<br id=\"yui_3_16_0_ym19_1_1496419506613_9556\" clear=\"none\">  <br id=\"yui_3_16_0_ym19_1_1496419506613_9557\" clear=\"none\">  <\/div>\n<p>  Att<br id=\"yui_3_16_0_ym19_1_1496419506613_9558\" clear=\"none\">  <br id=\"yui_3_16_0_ym19_1_1496419506613_9559\" clear=\"none\">  <\/div>\n<div id=\"yui_3_16_0_ym19_1_1496419506613_9560\" dir=\"ltr\">Sinval<\/div>\n<p>  <\/span>  <\/p>\n<div id=\"yui_3_16_0_ym19_1_1496419506613_9561\"><\/div>\n<div class=\"qtdSeparateBR\"><\/div>\n<div class=\"yahoo_quoted\">\n<div style=\"font-family: Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size: 13px;\">\n<div style=\"font-family: HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size: 16px;\">\n<div dir=\"ltr\"><font face=\"Arial\" size=\"2\">Em Sexta-feira, 2 de Junho de 2017 10:08, &quot;Caio Mancini caio.mancini@gmail.com &quot; &lt;&gt; escreveu:<br \/>  <\/font><\/div>\n<div class=\"y_msg_container\">\n<div id=\"yiv4449620350\">\n<div><span>&nbsp;<\/span>  <\/p>\n<div id=\"yiv4449620350ygrp-mlmsg\">\n<div id=\"yiv4449620350ygrp-msg\">\n<div id=\"yiv4449620350ygrp-text\">\n<div><\/div>\n<div>Opa.<\/div>\n<div>Pega o transaction id&nbsp;<span style=\"color: rgb(49, 49, 49);font-family: Georgia;font-size: 13px;word-spacing: 1px;background-color: rgb(255, 255, 255);\">163596 e vai na MTL TRANSACTIONS.<\/span><\/div>\n<div><font color=\"#313131\" face=\"Georgia\" size=\"2\"><span style=\"word-spacing: 1px;background-color: rgb(255, 255, 255);\">Acha o item e verifica suas configura\u00e7\u00f5es. Categorias de custo principalmente. Veja se a categoria possui associa\u00e7\u00e3o de conta cont\u00e1bil.<\/span><\/font><\/div>\n<div><font color=\"#313131\" face=\"Georgia\" size=\"2\"><span style=\"word-spacing: 1px;background-color: rgb(255, 255, 255);\">Veja o que gerou a transa\u00e7\u00e3o, PO, SO, Job&#8230; verifique se as contas que estes caras tem no setup est\u00e3o boas e v\u00e1lidas.<\/span><\/font><\/div>\n<div><font color=\"#313131\" face=\"Georgia\" size=\"2\"><span style=\"word-spacing: 1px;background-color: rgb(255, 255, 255);\"><br clear=\"none\">  <\/span><\/font><\/div>\n<div><font color=\"#313131\" face=\"Georgia\" size=\"2\"><span style=\"word-spacing: 1px;background-color: rgb(255, 255, 255);\">Por acaso isso \u00e9 uma transa\u00e7\u00e3o de transfer\u00eancia?<\/span><\/font><\/div>\n<div><font color=\"#313131\" face=\"Georgia\" size=\"2\"><span style=\"word-spacing: 1px;background-color: rgb(255, 255, 255);\">Voc\u00ea t\u00e1 com o flag do PAC Interativo marcado?<\/span><\/font><\/div>\n<div><font color=\"#313131\" face=\"Georgia\" size=\"2\"><span style=\"word-spacing: 1px;background-color: rgb(255, 255, 255);\">Caso sim, verifica se a tabela CST_LE_COST_TYPES traz alguma coisa para o tipo de custo e a legal entity que t\u00e1 rolando.<\/span><\/font><\/div>\n<div><font color=\"#313131\" face=\"Georgia\" size=\"2\"><span style=\"word-spacing: 1px;background-color: rgb(255, 255, 255);\">&nbsp;Se for de org discreta pra OPM, veja se o item est\u00e1 na lista de pre\u00e7o, se a NF foi contabilizada no AR e o processo foi fechado por completo.<\/span><\/font><\/div>\n<div><font color=\"#313131\" face=\"Georgia\" size=\"2\"><span style=\"word-spacing: 1px;background-color: rgb(255, 255, 255);\">&nbsp;<\/span><\/font><\/div>\n<div><font color=\"#313131\" face=\"Georgia\" size=\"2\"><span style=\"word-spacing: 1px;background-color: rgb(255, 255, 255);\">Geralmente nestes pontos de stmt que deram o erro \u00e9 isso que acontece.<\/span><\/font><\/div>\n<div><font color=\"#313131\" face=\"Georgia\" size=\"2\"><span style=\"word-spacing: 1px;background-color: rgb(255, 255, 255);\"><br clear=\"none\">  <\/span><\/font><\/div>\n<div><font color=\"#313131\" face=\"Georgia\" size=\"2\"><span style=\"word-spacing: 1px;background-color: rgb(255, 255, 255);\">Espero ter ajudado.<\/span><\/font><\/div>\n<div class=\"yiv4449620350yqt8087506725\" id=\"yiv4449620350yqt73492\">\n<div><font color=\"#313131\" face=\"Georgia\" size=\"2\"><span style=\"word-spacing: 1px;background-color: rgb(255, 255, 255);\"><br clear=\"none\">  <\/span><\/font>  <\/p>\n<div class=\"yiv4449620350gmail_quote\">\n<div>On Fri, Jun 2, 2017 at 8:43 AM Alex Pagliarini <a href=\"mailto:alexpa53@gmail.com\" target=\"_blank\" rel=\"nofollow\" shape=\"rect\" ymailto=\"mailto:alexpa53@gmail.com\">  alexpa53@gmail.com<\/a>  &lt;<a href=\"mailto:\" target=\"_blank\" rel=\"nofollow\" shape=\"rect\" ymailto=\"mailto:\"><\/a>&gt; wrote:<br clear=\"none\">  <\/div>\n<blockquote class=\"yiv4449620350gmail_quote\" style=\"border-left-color: rgb(204, 204, 204);border-left-width: 1px;border-left-style: solid;\"><p>  <u><\/u>  <\/p>\n<div style=\"background-color: rgb(255, 255, 255);\"><span>&nbsp;<\/span>  <\/p>\n<div id=\"yiv4449620350m_8324138966001162975ygrp-mlmsg\">\n<div id=\"yiv4449620350m_8324138966001162975ygrp-msg\">\n<div id=\"yiv4449620350m_8324138966001162975ygrp-text\">\n<div><\/div>\n<div>\n<div>\n<div>\n<div>Ol\u00e1 Mauricio, pode me add no skype, talvez eu consiga lhe ajudar<br clear=\"none\">  <br clear=\"none\">  <\/div>\n<p>  alexpagliarini53<br clear=\"none\">  <br clear=\"none\">  <\/div>\n<p>  Att<br clear=\"none\">  <br clear=\"none\">  <\/div>\n<p>  Alex<br clear=\"none\">  <\/div>\n<div><\/div>\n<\/p><\/div>\n<\/p><\/div>\n<\/p><\/div>\n<\/p><\/div>\n<div style=\"background-color: rgb(255, 255, 255);\">\n<div id=\"yiv4449620350m_8324138966001162975ygrp-mlmsg\">\n<div id=\"yiv4449620350m_8324138966001162975ygrp-msg\">\n<div id=\"yiv4449620350m_8324138966001162975ygrp-text\">\n<div><\/div>\n<div class=\"yiv4449620350gmail_extra\"><br clear=\"none\">  <\/p>\n<div class=\"yiv4449620350gmail_quote\">Em 2 de junho de 2017 13:36, Mauricio Moura  <a href=\"mailto:msmoura2003@yahoo.com.br\" target=\"_blank\" rel=\"nofollow\" shape=\"rect\" ymailto=\"mailto:msmoura2003@yahoo.com.br\">  msmoura2003@yahoo.com.br<\/a>  <span>&lt;<a href=\"mailto:\" target=\"_blank\" rel=\"nofollow\" shape=\"rect\" ymailto=\"mailto:\"><\/a>&gt;<\/span> escreveu:<br clear=\"none\">  <\/p>\n<blockquote class=\"yiv4449620350gmail_quote\" style=\"border-left-color: rgb(204, 204, 204);border-left-width: 1px;border-left-style: solid;\"><p>  <u><\/u>  <\/p>\n<div style=\"background-color: rgb(255, 255, 255);\"><span>&nbsp;<\/span>  <\/p>\n<div id=\"yiv4449620350m_8324138966001162975m_-3507522969303455206ygrp-mlmsg\">\n<div id=\"yiv4449620350m_8324138966001162975m_-3507522969303455206ygrp-msg\">\n<div id=\"yiv4449620350m_8324138966001162975m_-3507522969303455206ygrp-text\">\n<div>Senhores, bom dia!!!<br clear=\"none\">  Uma ajuda dos amigos de PAC\u2026 <br clear=\"none\">  <br clear=\"none\">  Estou com o seguinte erro abaixo descrito no fechamento do PAC.<br clear=\"none\">  <br clear=\"none\">  Algu\u00e9m j\u00e1 passou pelo erro na deriva\u00e7\u00e3o desta conta (variante entry)?<br clear=\"none\">  Estou com SR aberta e nada de solu\u00e7\u00e3o ainda\u2026<br clear=\"none\">  <br clear=\"none\">  Tks,<br clear=\"none\">  Mauricio Moura<br clear=\"none\">  <br clear=\"none\">  Processing Transaction : 163596<br clear=\"none\">  Calling Package CSTPAPBR.create_acct_lines &#8230;<br clear=\"none\">  BEGIN CSTPAPBR.create_acct_lines(:I_LEGAL_ENTITY, :I_COST_TYPE_ID, :I_COST_GROUP_ID, :I_PERIOD_ID, :I_TRANSACTION_ID, :I_EVENT_TYPE_ID, :I_TXN_TYPE_FLAG, :O_ERR_NUM, :O_ERR_CODE, :O_ERR_MSG); END;<br clear=\"none\">  CSTPAPBR.Create_acct_lines &lt;&lt;<br clear=\"none\">  i_transaction_id: 163596<br clear=\"none\">  Event type: 32-1-13<br clear=\"none\">  CSTPAPBR.create_inv_ae_lines: 0: begin &lt;&lt; transaction_id: 163596<br clear=\"none\">  CSTPAPBR.create_inv_ae_lines: 16: l_curr_rec.pri_currency = BRL; l_curr_rec.alt_currency =  <br clear=\"none\">  CSTPAPBR.create_inv_ae_lines: 16: l_curr_rec.currency_conv_rate = -1<br clear=\"none\">  Inv_cost_txn &lt;&lt;<br clear=\"none\">  CSTPAPBR.inventory_accounts: 0: begin &lt;&lt;<br clear=\"none\">  CSTPAPBR.inventory_accounts: 56: Insert element 1<br clear=\"none\">  CSTPAPBR.insert_account: 0: begin &lt;&lt; <br clear=\"none\">  CSTPAPBR.insert_account: 70: Credit: Valida\u00c1\u201eo de invent\u00b7rio 331829,42<br clear=\"none\">  CSTPAPBR.insert_account: 80: Rate or amount: 66365,8833333333333333333333333333333333<br clear=\"none\">  CSTPAPBR.insert_account: 80: return &gt;&gt; <br clear=\"none\">  CSTPAPBR.inventory_accounts: 40: No cost for element 2<br clear=\"none\">  CSTPAPBR.inventory_accounts: 40: No cost for element 3<br clear=\"none\">  CSTPAPBR.inventory_accounts: 40: No cost for element 4<br clear=\"none\">  CSTPAPBR.inventory_accounts: 40: No cost for element 5<br clear=\"none\">  CSTPAPBR.inventory_accounts: 40: Creating Variance Entry<br clear=\"none\">  CSTPALBR.dyn_proc_call : Error Calling Package<br clear=\"none\">  CSTPDPPC.dyn_proc_call : Error Calling Package<br clear=\"none\">  100CSTPAPBR.inventory_accounts70ORA-01403: dados n\u201eo encontrados<\/div>\n<\/p><\/div>\n<div style=\"color: rgb(255, 255, 255);min-height: 0px;\"><\/div>\n<\/p><\/div>\n<\/p><\/div>\n<\/p><\/div>\n<\/blockquote><\/div>\n<p>  <br clear=\"none\">  <\/div>\n<div><\/div>\n<\/p><\/div>\n<\/p><\/div>\n<\/p><\/div>\n<\/p><\/div>\n<div style=\"background-color: rgb(255, 255, 255);\">\n<div id=\"yiv4449620350m_8324138966001162975ygrp-mlmsg\">\n<div id=\"yiv4449620350m_8324138966001162975ygrp-msg\">\n<div id=\"yiv4449620350m_8324138966001162975ygrp-text\">\n<div><\/div>\n<\/p><\/div>\n<div style=\"color: rgb(255, 255, 255);min-height: 0px;\"><\/div>\n<\/p><\/div>\n<\/p><\/div>\n<\/p><\/div>\n<\/blockquote><\/div>\n<\/p><\/div>\n<\/p><\/div>\n<div dir=\"ltr\">&#8212; <br clear=\"none\">  <\/div>\n<div>Caio Mancini Oracle Manufacturing Consultant Fone: 11 98675 1205<\/div>\n<\/p><\/div>\n<div class=\"yiv4449620350yqt8087506725\" id=\"yiv4449620350yqt85811\">\n<div style=\"color: rgb(255, 255, 255);min-height: 0px;\"><\/div>\n<\/p><\/div>\n<\/p><\/div>\n<div class=\"yiv4449620350yqt8087506725\" id=\"yiv4449620350yqt23865\"><\/div>\n<\/p><\/div>\n<\/p><\/div>\n<\/p><\/div>\n<\/p><\/div>\n<\/p><\/div>\n<\/p><\/div>\n<\/p><\/div>\n<\/p><\/div>\n<\/p><\/div>\n<p>  <\/HTML><\/HTML><\/p>\n","protected":false},"excerpt":{"rendered":"<p>&nbsp; Ol\u00e1 Mauricio, pode me add no skype, talvez eu consiga lhe ajudar sinval.costa69 Att Sinval Em Sexta-feira, 2 de Junho de 2017 10:08, &quot;Caio&hellip; <\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[29],"tags":[],"class_list":["post-14285","post","type-post","status-publish","format-standard","hentry","category-base-de-conhecimentos"],"_links":{"self":[{"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=\/wp\/v2\/posts\/14285","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=14285"}],"version-history":[{"count":0,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=\/wp\/v2\/posts\/14285\/revisions"}],"wp:attachment":[{"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=14285"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=14285"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=14285"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}