{"id":18666,"date":"2019-07-19T14:00:34","date_gmt":"2019-07-19T17:00:34","guid":{"rendered":"https:\/\/orabr.com\/?p=18666"},"modified":"2019-07-20T08:34:17","modified_gmt":"2019-07-20T11:34:17","slug":"dda-itau-3","status":"publish","type":"post","link":"https:\/\/orabr.virttus.com\/?p=18666","title":{"rendered":"DDA Ita\u00fa"},"content":{"rendered":"<p><HTML><HTML><\/p>\n<div><span style=\"display: none;\">\u00a0<\/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 dir=\"ltr\">\n<div class=\"gmail_default\" style=\"font-family: tahoma,sans-serif; font-size: small; color: #000000;\">Ol\u00e1,<\/div>\n<div class=\"gmail_default\" style=\"font-family: tahoma,sans-serif; font-size: small; color: #000000;\"><\/div>\n<div class=\"gmail_default\" style=\"font-family: tahoma,sans-serif; font-size: small; color: #000000;\">Segue. Bom trabalho!<\/div>\n<div class=\"gmail_default\" style=\"font-family: tahoma,sans-serif; font-size: small; color: #000000;\"><\/div>\n<div class=\"gmail_default\" style=\"font-family: tahoma,sans-serif; font-size: small; color: #000000;\"><\/div>\n<div class=\"gmail_default\" style=\"font-family: tahoma,sans-serif; font-size: small; color: #000000;\">1.<\/p>\n<p>Please apply patches 23626056:R12.JL.B and 10075589:R12.JL.B.<\/p>\n<p>2.<\/p>\n<p>A Equipe de Desenvolvimento liberou a solu\u00e7\u00e3o no seguinte patch:<br \/>\n==============================================================================<br \/>\nR12.CLL Brazilian Cash Management Pack 40<br \/>\n==============================================================================<br \/>\nUpdate &#8211; 26176633<br \/>\nProduct &#8211; LAD Add-on Localizations<br \/>\nRelease &#8211; R12<br \/>\n==============================================================================<\/p>\n<p>Por favor, aplique o patch 26176633 em um ambiente de testes e verifique os resultados. Depois migre a solu\u00e7\u00e3o para os demais ambientes.<\/p>\n<p>3.<\/p>\n<p>create or replace package body JL_BR_AP_VALIDATE_COLLECTION as<br \/>\n\/* $Header: jlbrpvcb.pls 120.6.12010000.11 2016\/08\/03 16:28:29 mbarrett ship $ *\/<\/p>\n<p>ELSIF e_transf_inscription_type = 2 \u00a0\/* CGC *\/<br \/>\nOR e_transf_inscription_type = 99 \u00a0\/* Others *\/<br \/>\nTHEN \u00a0 \u00a0\/* Include one zero on the left *\/<br \/>\nSELECT \u00a0 povs.vendor_site_id,<br \/>\nsubstr(pov.vendor_name,1,240)<br \/>\nINTO \u00a0s_vendor_site_id,<br \/>\nx_vendor_name<br \/>\nFROM \u00a0po_vendor_sites povs,<br \/>\npo_vendors \u00a0pov<br \/>\n&#8212; Bug 19670332 Start<br \/>\nWHERE \u00a0povs.global_attribute9 = to_char(e_transf_inscription_type)<br \/>\n&#8212; Bug 19670332 Start<br \/>\nAND \u00a0povs.global_attribute10 = substr(e_transf_inscription_number,1,9) &#8212;CORRECAO<br \/>\nAND \u00a0povs.global_attribute11 = substr(e_transf_inscription_number,10,4)<br \/>\nAND \u00a0povs.global_attribute12 = substr(e_transf_inscription_number,14,2)<br \/>\nAND \u00a0pov.vendor_id = povs.vendor_id<br \/>\n&#8212; Bug 16343574 Start<br \/>\nAND \u00a0 \u00a0 trunc(nvl(povs.inactive_date,sysdate+1)) &gt; \u00a0trunc(sysdate);<br \/>\n&#8212; Bug 16343574 End;<\/p>\n<\/div>\n<div class=\"gmail_default\" style=\"font-family: tahoma,sans-serif; font-size: small; color: #000000;\"><\/div>\n<div class=\"gmail_default\" style=\"font-family: tahoma,sans-serif; font-size: small; color: #000000;\"><\/div>\n<div class=\"gmail_default\" style=\"font-family: tahoma,sans-serif; font-size: small; color: #000000;\">Abs,<\/div>\n<div class=\"gmail_default\" style=\"font-family: tahoma,sans-serif; font-size: small; color: #000000;\">Lucas<\/div>\n<div class=\"gmail_default\" style=\"font-family: tahoma,sans-serif; font-size: small; color: #000000;\"><\/div>\n<\/div>\n<div class=\"gmail_quote\">\n<div class=\"gmail_attr\" dir=\"ltr\">Em qui, 18 de jul de 2019 \u00e0s 14:24, Dagmar Izar <a href=\"mailto:dagmar_izar@yahoo.com.br\">dagmar_izar@yahoo.com.br<\/a> &lt;&gt; escreveu:<\/div>\n<blockquote class=\"gmail_quote\" style=\"margin: 0px 0px 0px 0.8ex; border-left: 1px solid #cccccc;\">\n<div style=\"background-color: #ffffff;\">\n<div id=\"gmail-m_3551155850229100218ygrp-mlmsg\">\n<div id=\"gmail-m_3551155850229100218ygrp-msg\">\n<div id=\"gmail-m_3551155850229100218ygrp-text\">\n<div class=\"gmail-m_3551155850229100218ydp2be0146yahoo-style-wrap\" style=\"font-family: 'Helvetica Neue',Helvetica,Arial,sans-serif; font-size: 13px;\">\n<div>\n<div dir=\"ltr\">Oi Lucas,<\/div>\n<div dir=\"ltr\"><\/div>\n<div dir=\"ltr\">Voce teria os numeros desses patches, por favor?<\/div>\n<div><\/div>\n<div class=\"gmail-m_3551155850229100218ydp2be0146signature\">\n<div><span style=\"color: #0000bf; font-family: verdana, helvetica, sans-serif;\"><span style=\"font-size: small;\"><i><b>Dagmar Izar\u00a0<\/b><\/i><\/span><\/span><\/div>\n<div><span style=\"font-family: verdana, helvetica, sans-serif;\"><span style=\"font-size: small;\"><span style=\"color: #0000bf;\"><i>Consultora Oracle\u00a0EBS Financials<\/i><\/span><\/span><\/span><\/div>\n<div><span style=\"color: #0000bf; font-family: verdana, helvetica, sans-serif; font-size: small;\"><i>* <a href=\"mailto:dagmar_izar@yahoo.com.br\" target=\"_blank\" rel=\"noopener noreferrer\">dagmar_izar@yahoo.com.br<\/a><br \/>\n( +55 11 99909-7109)<\/i><\/span><\/div>\n<div style=\"color: #0000bf; font-size: 13px; font-family: verdana,helvetica,sans-serif; background-color: transparent; font-style: italic;\"><span style=\"color: #0000bf; font-family: verdana, helvetica, sans-serif; font-size: small;\"><i>Skype: dagmar.izar<\/i><\/span><\/div>\n<div><i><\/i><\/div>\n<\/div>\n<\/div>\n<div><\/div>\n<div><\/div>\n<\/div>\n<div id=\"gmail-m_3551155850229100218yahoo_quoted_3617961397\" class=\"gmail-m_3551155850229100218yahoo_quoted\">\n<div style=\"font-family: 'Helvetica Neue',Helvetica,Arial,sans-serif; font-size: 13px; color: #26282a;\">\n<div>Em quinta-feira, 18 de julho de 2019 14:20:07 BRT, Lucas Monteiro <a href=\"mailto:l2m.lucas@gmail.com\" target=\"_blank\" rel=\"noopener noreferrer\">l2m.lucas@gmail.com<\/a> &lt;&gt; escreveu:<\/div>\n<div><\/div>\n<div><\/div>\n<div>\n<div id=\"gmail-m_3551155850229100218yiv9588503921\">\n<div>\n<div id=\"gmail-m_3551155850229100218yiv9588503921ygrp-mlmsg\">\n<div id=\"gmail-m_3551155850229100218yiv9588503921ygrp-msg\">\n<div id=\"gmail-m_3551155850229100218yiv9588503921ygrp-text\">\n<div dir=\"ltr\">\n<div dir=\"ltr\">\n<div class=\"gmail-m_3551155850229100218yiv9588503921gmail_default\" style=\"font-family: tahoma,sans-serif; font-size: small; color: #000000;\">Boa tarde Marcos,<\/div>\n<div class=\"gmail-m_3551155850229100218yiv9588503921gmail_default\" style=\"font-family: tahoma,sans-serif; font-size: small; color: #000000;\"><\/div>\n<div class=\"gmail-m_3551155850229100218yiv9588503921gmail_default\" style=\"font-family: tahoma,sans-serif; font-size: small; color: #000000;\">Resolvi esse problema aplicando os \u00faltimos patches de localiza\u00e7\u00e3o para DDA e cadastrando ag\u00eancia\/conta conforme arquivo (dados header Ita\u00fa 0000, etc).<\/div>\n<div class=\"gmail-m_3551155850229100218yiv9588503921gmail_default\" style=\"font-family: tahoma,sans-serif; font-size: small; color: #000000;\"><\/div>\n<div class=\"gmail-m_3551155850229100218yiv9588503921gmail_default\" style=\"font-family: tahoma,sans-serif; font-size: small; color: #000000;\">Abs,<\/div>\n<div class=\"gmail-m_3551155850229100218yiv9588503921gmail_default\" style=\"font-family: tahoma,sans-serif; font-size: small; color: #000000;\">Lucas<\/div>\n<\/div>\n<div class=\"gmail-m_3551155850229100218yiv9588503921gmail_quote\">\n<div class=\"gmail-m_3551155850229100218yiv9588503921gmail_attr\" dir=\"ltr\">Em qua, 17 de jul de 2019 \u00e0s 22:50, Marcos Marques <a href=\"mailto:wmcouto@yahoo.com.br\" target=\"_blank\" rel=\"nofollow noopener noreferrer\" shape=\"rect\">wmcouto@yahoo.com.br<\/a> &lt;&gt; escreveu:<\/div>\n<blockquote class=\"gmail-m_3551155850229100218yiv9588503921gmail_quote\" style=\"margin: 0px 0px 0px 0.8ex; border-left: 1px solid #cccccc;\">\n<div style=\"background-color: #ffffff;\">\n<div id=\"gmail-m_3551155850229100218yiv9588503921gmail-m_-7000114595806841104ygrp-mlmsg\">\n<div id=\"gmail-m_3551155850229100218yiv9588503921gmail-m_-7000114595806841104ygrp-msg\">\n<div id=\"gmail-m_3551155850229100218yiv9588503921gmail-m_-7000114595806841104ygrp-text\">\n<p>Boa noite!<\/p>\n<div id=\"gmail-m_3551155850229100218yiv9588503921gmail-m_-7000114595806841104yMail_cursorElementTracker_1563414349705\"><\/div>\n<div id=\"gmail-m_3551155850229100218yiv9588503921gmail-m_-7000114595806841104yMail_cursorElementTracker_1563414349855\">Algu\u00e9m poderia me enviar mapeamento do DDA para que eu posso validar o mapeamento que fiz.<\/div>\n<div id=\"gmail-m_3551155850229100218yiv9588503921gmail-m_-7000114595806841104yMail_cursorElementTracker_1563414391931\"><\/div>\n<div id=\"gmail-m_3551155850229100218yiv9588503921gmail-m_-7000114595806841104yMail_cursorElementTracker_1563414392715\">Estou enfrentando um problema com a os dados banc\u00e1rios da empresa cliente. Esses s\u00e3o informados com zeros no arquivo e o programa n\u00e3o recupera os valores defaults informados no mapeamento.<\/div>\n<div id=\"gmail-m_3551155850229100218yiv9588503921gmail-m_-7000114595806841104yMail_cursorElementTracker_1563414475886\"><\/div>\n<div id=\"gmail-m_3551155850229100218yiv9588503921gmail-m_-7000114595806841104yMail_cursorElementTracker_1563414476437\">Atenciosamente.<\/div>\n<div id=\"gmail-m_3551155850229100218yiv9588503921gmail-m_-7000114595806841104yMail_cursorElementTracker_1563414479562\"><\/div>\n<div id=\"gmail-m_3551155850229100218yiv9588503921gmail-m_-7000114595806841104yMail_cursorElementTracker_1563414480270\">Marcos Couto Marques<br clear=\"none\" \/><br clear=\"none\" \/><\/p>\n<div id=\"gmail-m_3551155850229100218yiv9588503921gmail-m_-7000114595806841104ymail_android_signature\"><a id=\"gmail-m_3551155850229100218yiv9588503921gmail-m_-7000114595806841104ymail_android_signature_link\" href=\"https:\/\/go.onelink..me\/107872968?pid=InProduct&amp;c=Global_Internal_YGrowth_AndroidEmailSig__AndroidUsers&amp;af_wl=ym&amp;af_sub1=Internal&amp;af_sub2=Global_YGrowth&amp;af_sub3=EmailSignature\" target=\"_blank\" rel=\"nofollow noopener noreferrer\" shape=\"rect\">Enviado do Yahoo Mail no Android<\/a><\/div>\n<\/div>\n<\/div>\n<div style=\"color: #ffffff; min-height: 0px;\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/blockquote>\n<\/div>\n<\/div>\n<\/div>\n<div style=\"color: #ffffff; min-height: 0px;\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div style=\"color: #ffffff; height: 0px;\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/blockquote>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<p><\/HTML><\/HTML><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u00a0 Ol\u00e1, Segue. Bom trabalho! 1. Please apply patches 23626056:R12.JL.B and 10075589:R12.JL.B. 2. A Equipe de Desenvolvimento liberou a solu\u00e7\u00e3o no seguinte patch: ============================================================================== R12.CLL&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-18666","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\/18666","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=18666"}],"version-history":[{"count":1,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=\/wp\/v2\/posts\/18666\/revisions"}],"predecessor-version":[{"id":18682,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=\/wp\/v2\/posts\/18666\/revisions\/18682"}],"wp:attachment":[{"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=18666"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=18666"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=18666"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}