{"id":14281,"date":"2017-06-02T10:08:32","date_gmt":"2017-06-02T13:08:32","guid":{"rendered":"http:\/\/orabr.com\/?p=14281"},"modified":"2017-06-02T12:10:46","modified_gmt":"2017-06-02T15:10:46","slug":"-erro-pac-2","status":"publish","type":"post","link":"https:\/\/orabr.virttus.com\/?p=14281","title":{"rendered":"Erro PAC"},"content":{"rendered":"

<\/p>\n

 <\/span> <\/p>\n
\n
<\/p>\n
\n
Opa.<\/div>\n
Pega o transaction id 163596 e vai na MTL TRANSACTIONS.<\/span><\/div>\n
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
Veja o que gerou a transa\u00e7\u00e3o, PO, SO, Job… verifique se as contas que estes caras tem no setup est\u00e3o boas e v\u00e1lidas.<\/span><\/font><\/div>\n

<\/span><\/font><\/div>\n
Por acaso isso \u00e9 uma transa\u00e7\u00e3o de transfer\u00eancia?<\/span><\/font><\/div>\n
Voc\u00ea t\u00e1 com o flag do PAC Interativo marcado?<\/span><\/font><\/div>\n
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
 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
 <\/span><\/font><\/div>\n
Geralmente nestes pontos de stmt que deram o erro \u00e9 isso que acontece.<\/span><\/font><\/div>\n

<\/span><\/font><\/div>\n
Espero ter ajudado.<\/span><\/font><\/div>\n

<\/span><\/font> <\/p>\n
\n
On Fri, Jun 2, 2017 at 8:43 AM Alex Pagliarini alexpa53@gmail.com<\/a> <<\/a>> wrote: <\/div>\n

<\/u> <\/p>\n

 <\/span> <\/p>\n
\n
\n
\n
\n
\n
\n
Ol\u00e1 Mauricio, pode me add no skype, talvez eu consiga lhe ajudar<\/p><\/div>\n

alexpagliarini53<\/p><\/div>\n

Att<\/p><\/div>\n

Alex <\/div>\n<\/p><\/div>\n<\/p><\/div>\n<\/p><\/div>\n<\/p><\/div>\n

\n
\n
\n
\n
<\/p>\n
Em 2 de junho de 2017 13:36, Mauricio Moura msmoura2003@yahoo.com.br<\/a> <<\/a>><\/span> escreveu: <\/p>\n

<\/u> <\/p>\n

 <\/span> <\/p>\n
\n
\n
\n

Senhores, bom dia!!!
Uma ajuda dos amigos de PAC\u2026 <\/p>\n

Estou com o seguinte erro abaixo descrito no fechamento do PAC.<\/p>\n

Algu\u00e9m j\u00e1 passou pelo erro na deriva\u00e7\u00e3o desta conta (variante entry)?
Estou com SR aberta e nada de solu\u00e7\u00e3o ainda\u2026<\/p>\n

Tks,
Mauricio Moura<\/p>\n

Processing Transaction : 163596
Calling Package CSTPAPBR.create_acct_lines …
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;
CSTPAPBR.Create_acct_lines <<
i_transaction_id: 163596
Event type: 32-1-13
CSTPAPBR.create_inv_ae_lines: 0: begin << transaction_id: 163596
CSTPAPBR.create_inv_ae_lines: 16: l_curr_rec.pri_currency = BRL; l_curr_rec.alt_currency =
CSTPAPBR.create_inv_ae_lines: 16: l_curr_rec.currency_conv_rate = -1
Inv_cost_txn <<
CSTPAPBR.inventory_accounts: 0: begin <<
CSTPAPBR.inventory_accounts: 56: Insert element 1
CSTPAPBR.insert_account: 0: begin <<
CSTPAPBR.insert_account: 70: Credit: Valida\u00c1\u201eo de invent\u00b7rio 331829,42
CSTPAPBR.insert_account: 80: Rate or amount: 66365,8833333333333333333333333333333333
CSTPAPBR.insert_account: 80: return >>
CSTPAPBR.inventory_accounts: 40: No cost for element 2
CSTPAPBR.inventory_accounts: 40: No cost for element 3
CSTPAPBR.inventory_accounts: 40: No cost for element 4
CSTPAPBR.inventory_accounts: 40: No cost for element 5
CSTPAPBR.inventory_accounts: 40: Creating Variance Entry
CSTPALBR.dyn_proc_call : Error Calling Package
CSTPDPPC.dyn_proc_call : Error Calling Package
100CSTPAPBR.inventory_accounts70ORA-01403: dados n\u201eo encontrados<\/p>\n<\/p><\/div>\n

<\/div>\n<\/p><\/div>\n<\/p><\/div>\n<\/p><\/div>\n<\/blockquote><\/div>\n

<\/div>\n<\/p><\/div>\n<\/p><\/div>\n<\/p><\/div>\n<\/p><\/div>\n

\n
\n
\n
\n<\/p><\/div>\n
<\/div>\n<\/p><\/div>\n<\/p><\/div>\n<\/p><\/div>\n<\/blockquote><\/div>\n<\/p><\/div>\n
— <\/div>\n
Caio Mancini Oracle Manufacturing Consultant Fone: 11 98675 1205<\/div>\n<\/p><\/div>\n

<\/HTML><\/HTML><\/p>\n","protected":false},"excerpt":{"rendered":"

  Opa. Pega o transaction id 163596 e vai na MTL TRANSACTIONS. Acha o item e verifica suas configura\u00e7\u00f5es. Categorias de custo principalmente. Veja se a… <\/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-14281","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\/14281","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=14281"}],"version-history":[{"count":0,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=\/wp\/v2\/posts\/14281\/revisions"}],"wp:attachment":[{"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=14281"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=14281"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=14281"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}