AR Facturacion Argentina
Interfaz de salida
Utiliza interfaces para la generacion XX Customizaciones → Interfaces de Salida
Nombre: XX_AR_FE_AR_INTERBANK
Descripcion: XX AR Factura Electronica para Argentina
Concurrentes
Generacion
XX AR Proceso de Generacion de Factura Electronica Argentina
XXIOPGEN
XX_INTOUT_GEN_PK.conc_generate_interface
Recepcion
XX AR Proceso de Recepcion de Factura Electronica Argentina
XXARFEPR
XX_AR_FE_RECS_PK.process_interface
Impresion
XX AR Proceso de Generacion de Facturas
XXARINVG (abrev)
XDODTEXE
XML Data Template
XBOL_XXARINVG.xml
Bursting
XXARINVG_BCF.xml
Template
XXARARSP
XBOL_XXARARSP_en.rtf
Juego de concurrentes
XX AR AR Proceso Factura Electronica
Lo componen los concurrentes de generacion y de recepcion
Publisher
Viene de cnc XX AR Proceso de Generacion de Facturas
XML Data Template
XBOL_XXARINVG.xml
Bursting
XXARINVG_BCF.xml
Template
XXARARSP
XBOL_XXARARSP_en.rtf
El data template llama a
SIEMPRE BUSCAR CODIGO EN ESTE PAQUETE
antes
XX_AR_FE_INTERBANKING_INT_PK.process_interface('N','N',p_date_format =>:p_date_format, p_char1 => :p_char1, p_char6 => :p_char6, p_char3 => :p_char3,
p_char4=> :p_char4, p_char7 => :p_char7, p_char8 => :p_char8, p_char9 =>:p_char9,
p_number1 => :p_interface_id , p_date1=> :p_date1, p_char12 =>:p_char12);
END;
despues
XX_AR_FE_INTERBANKING_INT_PK.generic_data_replace(
p_draft_mode => 'N', p_debug_flag => 'N', p_interface_id => :p_interface_id );
END;
Directorios
XML
/utldir/fact_elec/OU_101
/utldir/xx_ar_inv_gen/out /utldir/xx_ar_inv_gen/tmp
Paquetes utiles
XX_AR_XXARINVG_PK
XX_AR_FE_AR_INTERBANK
XX_OM_SALES_PK → nace la factura
--FCE Argentina
from xx_ar_fe_trx trx, apps.ra_customer_trx_all rct, apps.fnd_concurrent_requests fcr
where trx.customer_Trx_id = rct.customer_trx_id
and fcr.request_id = trx.SEND_REQUEST_ID
and rct.org_id = 101
and rct.trx_date >= SYSDATE-20
group by trx.SEND_REQUEST_ID, trx.status, fcr.ARGUMENT23
order by 1
/
--AR a OM
rctt.type document_type,
rctt.attribute2 collection_type,
ooh.orig_sys_document_ref OSDR_FROM,
ooh.attribute16 OSDR_TO_PP,
ooh.attribute17 OSDR_TO_PD,
ool.ordered_item,
rctl.unit_selling_price,
rctl.GROSS_UNIT_SELLING_PRICE,
xaea_l.attribute48,
xaea_l.attribute50
FROM xx_ar_reg_invoice_request xarir,
ra_customer_trx_all rct,
ra_customer_trx_lines_all rctl,
oe_order_lines_all ool,
xx_all_extra_attributes xaea_l,
oe_order_headers_all ooh,
xx_all_extra_attributes xaea_h,
ra_cust_trx_types_all rctt
WHERE rctl.customer_trx_id = rct.customer_trx_id
AND xarir.customer_trx_id(+) = rct.customer_trx_id
AND rctl.line_type = 'LINE'
AND ool.line_id(+) = TO_NUMBER(rctl.interface_line_attribute6)
AND xaea_l.source_id_char1(+) = TO_CHAR(ool.line_id)
AND xaea_l.source_table(+) = 'OE_ORDER_LINES'
AND ooh.header_id(+) = ool.header_id
AND xaea_h.source_id_char1(+) = TO_CHAR(ooh.header_id)
AND xaea_h.source_table(+) = 'OE_ORDER_HEADERS'
AND rctt.cust_trx_type_id = rct.cust_trx_type_id
AND rctt.org_id = rct.org_id
AND rct.customer_trx_id = 282003310
/
--OM hacia AR
rct.customer_trx_id,
rctt.type document_type,
rctt.attribute2 collection_type,
rctt.name,
ooh.orig_sys_document_ref OSDR_FROM,
ooh.attribute16 OSDR_TO_PP,
ooh.attribute17 OSDR_TO_PD
FROM apps.xx_ar_reg_invoice_request xarir,
apps.ra_customer_trx_all rct,
apps.ra_customer_trx_lines_all rctl,
apps.oe_order_lines_all ool,
apps.xx_all_extra_attributes xaea_l,
apps.oe_order_headers_all ooh,
apps.xx_all_extra_attributes xaea_h,
apps.ra_cust_trx_types_all rctt
WHERE rctl.customer_trx_id = rct.customer_trx_id
AND xarir.customer_trx_id(+) = rct.customer_trx_id
AND rctl.line_type = 'LINE'
AND to_char(ool.line_id) = rctl.interface_line_attribute6
AND xaea_l.source_id_char1(+) = TO_CHAR(ool.line_id)
AND xaea_l.source_table(+) = 'OE_ORDER_LINES'
AND ooh.header_id(+) = ool.header_id
AND xaea_h.source_id_char1(+) = TO_CHAR(ooh.header_id)
AND xaea_h.source_table(+) = 'OE_ORDER_HEADERS'
AND rctt.cust_trx_type_id = rct.cust_trx_type_id
AND rctt.org_id = rct.org_id
and ooh.header_id = 80603324
/
Reprocesado:
FROM ra_customer_trx_all
WHERE CUSTOMER_TRX_ID = 547553358
SET ATTRIBUTE9 = NULL , global_attribute17 = null
WHERE CUSTOMER_TRX_ID = 547553358


Comentarios
Publicar un comentario