R12 Indian Localization Table Changes


R11

R12
--------

--------
JA_IN_RA_CUST_TRX_TAX_LINES

JAI_AR_TRX_TAX_LINES

JA_IN_TAX_CODES

JAI_CMN_TAXES_ALL

JA_IN_RA_CUSTOMER_TRX_LINES

JAI_AR_TRX_LINES

JA_IN_RG23_PART_I (TRANSACTION_ID)

JAI_CMN_RG_23AC_I_TRXS (TRANSACTION_SOURCE_NUM)

JA_IN_RG23_PART_II (RECEIPT_ID, TRANSACTION_ID)

JAI_CMN_RG_23AC_II_TRXS (RECEIPT_REF, TRANSACTION_SOURCE_NUM)

JA_IN_PLA (DR_INVOICE_ID, TRANSACTION_ID)

JAI_CMN_RG_PLA_TRXS (DR_INVOICE_NO, TRANSACTION_SOURCE_NUM)

PO_VENDORS

AP_SUPPLIERS

PO_VENDOR_SITES

AP_SUPPLIER_SITES_ALL

JA_IN_PO_VENDOR_SITES

JAI_CMN_VENDOR_SITES

JA_IN_RECEIPT_TAX_LINES

JAI_RCV_LINE_TAXES

JA_IN_PO_LINE_LOCATION_TAXES

JAI_PO_TAXES

JA_IN_SO_LINES

JAI_OM_OE_SO_LINES

JA_IN_SO_TAX_LINES

JAI_OM_OE_SO_TAXES

JA_IN_57F4

JAI_PO_OSP_HDRS

JA_IN_57F4_LINES

JAI_PO_OSP_LINES

JA_IN_FIN_YEAR_INFO

JAI_CMN_FIN_YEARS

JA_IN_HR_ORGANIZATION_UNITS

JAI_CMN_INVENTORY_ORGS

JA_IN_RTV

JAI_RCV_RTV_DTLS

JA_IN_MTL_SYSTEM_ITEMS

JAI_INV_ITM_SETUPS

JA_IN_RG_I (TRANSACTION_ID)

JAI_CMN_RG_I_TRXS (TRANSACTION_SOURCE_NUM)

JA_IN_RG_BALANCES

JAI_CMN_RG_BALANCES

JA_IN_CUSTOMER_ADDRESSES

JAI_CMN_CUS_ADDRESSES

JA_IN_SO_PICKING_LINES

JAI_OM_WSH_LINES_ALL

JA_IN_RCV_JOURNALS_B

JA_IN_AP_TAX_DISTRIBUTIONS

JAI_RCV_JOURNAL_ENTRIES

JAI_AP_MATCH_INV_TAXES

Comments

Post a Comment

Popular posts from this blog

Queries For Oracle Interface Errors Records.

Below are the queries to get the error records information while processing interface data. AP Invoices:   SELECT    airl.last_update_date process_date,    HU.NAME,   nvl(ail.invoice_line_id,aii.invoice_id) process_id,   'AP' module,   'Import AP Invoice' interface_name,   aii.source source,   NVL(SUBSTR( ail.dist_code_concatenated,1,instr(ail.dist_code_concatenated,'.',1,1)-1),'ALL') company,   'ERROR' status,   ail.line_type_lookup_code ,   airl.parent_table ,   ail.description ,   NVL(ail.distribution_set_name,dist_code_concatenated) ,   pvsa.vendor_site_code ,   listagg(NVL(airl.reject_lookup_code,'AP_INV_ERROR') ,';') within group (order by NVL(airl.reject_lookup_code,'AP_INV_ERROR')) error_code,   listagg(flv.meaning,';')  within group (order by NVL(flv.meaning,'AP_INV_ERROR'))error_summary,   NULL error_details,   pv.vendor_name ,   pv.segment1 ,   aii.invoice_amount,   aii.i
Read more

Customising PO Output For Communication Report in Oracle Purchasing

Image
PO Print PDF Report: Oracle EBS provided  a standard functionality to print the PO report directly from the PO form itself by clicking tools menu and view PDF option. Once we select that option output will be rendered in PDF format in the browser instantly. Internally it will run the concurrent program 'PO Output For Communication'. This concurrent program is of JAVA type which will uses the seeded package  'PO_COMMUNICATION_PVT'  for generating the XML data and later this XML data will be processed and formatted by using the XSL template of data definition 'Standard Purchase Order Data Source' in case of standard PO's. Oracle by default will provide one standard BI publisher template for this. In case if we want to have custom layout for this report we can build a new template for the same data definition and this template has to be used while doing the setup for PO Document types. Creating Custom Template and Setup this for PO Document type: To c
Read more

Oracle APPS Useful Queries

                       ACCOUNT PAYABLES Payable Open Interface Rejection:   SELECT ail.* FROM AP_INVOICES_INTERFACE ai ,   ap_invoice_lines_interface ail ,   ap_interface_rejections AIR WHERE ai.GROUP_ID='EO_AUG-13_010813_443' AND ai.status    ='REJECTED' AND ai.invoice_id=ail.invoice_id   --and ail.dist_code_concatenated='66810-00-999-00000000-00000000-00000-FI100' AND air.parent_id = DECODE(air.parent_table,'AP_INVOICES_INTERFACE',AI.INVOICE_ID,'AP_INVOICE_LINES_INTERFACE',ail.invoice_line_id,NULL) ORDER BY 2; AP Invoices Query: /*+INDEX (AP_INVOICES_ALL [XXDG_TEST]) */ SELECT  apia.invoice_id,        alc.displayed_field "Invoice Type",        apia.invoice_num "Invoice Number",        apia.invoice_date "Invoice Date",        apia.gl_date   "Invoice GL Date",        nvl(apia.VOUCHER_NUM,doc_sequence_value)"Voucher Number",        apia.description inv_Description,  
Read more