DDA Itaú

Please apply patches 23626056:R12.JL.B and 10075589:R12.JL.B.

2.

A Equipe de Desenvolvimento liberou a solução no seguinte patch:
==============================================================================
R12.CLL Brazilian Cash Management Pack 40
==============================================================================
Update – 26176633
Product – LAD Add-on Localizations
Release – R12
==============================================================================

Por favor, aplique o patch 26176633 em um ambiente de testes e verifique os resultados. Depois migre a solução para os demais ambientes.

3.

create or replace package body JL_BR_AP_VALIDATE_COLLECTION as
/* $Header: jlbrpvcb.pls 120.6.12010000.11 2016/08/03 16:28:29 mbarrett ship $ */

ELSIF e_transf_inscription_type = 2  /* CGC */
OR e_transf_inscription_type = 99  /* Others */
THEN    /* Include one zero on the left */
SELECT   povs.vendor_site_id,
substr(pov.vendor_name,1,240)
INTO  s_vendor_site_id,
x_vendor_name
FROM  po_vendor_sites povs,
po_vendors  pov
— Bug 19670332 Start
WHERE  povs.global_attribute9 = to_char(e_transf_inscription_type)
— Bug 19670332 Start
AND  povs.global_attribute10 = substr(e_transf_inscription_number,1,9) —CORRECAO
AND  povs.global_attribute11 = substr(e_transf_inscription_number,10,4)
AND  povs.global_attribute12 = substr(e_transf_inscription_number,14,2)
AND  pov.vendor_id = povs.vendor_id
— Bug 16343574 Start
AND     trunc(nvl(povs.inactive_date,sysdate+1)) >  trunc(sysdate);
— Bug 16343574 End;