Sairam Nimmagadda

There is   no one-to-one mapping between AR, XLA and GL. The data that actually posts to the GL is the XLA table data, not AR. Depending on the AAD rules you have defined, one row that appears in AR could become 10 in XLA_DISTRIBUTION_LINKS, but when the data is posted into the GL, the accounts of the same type and ccid are merged to a single entry. For example, a transaction could have 34 gl_dist rows, but 201 rows in ar_distribution_links, but when it actually posts, consolidates to 9 rows in gl_import_references. The main link to bind information together is the gl_sl_link_id. It will show in the gl_je_lines, gl_import_refernces and xla_ae_lines table. Also, the XLA_DISTRIBUTION_LINKS table contains the application_id, event_id, ae_header_id, ae_line_num from the XLA Tables and source_distribution_id_num_1 will be the cust_trx_line_gl_dist_id in the case of a transaction. ACTION: COMPLETE TRANSACTION : RA_CUSTOMER_TRX_ALL.CUSTOMER_TRX_ID = RA_CUST_TRX_LINE_GL_DIST_ALL.CUSTOME

Oracle Reports in csv and tsv . For the output to be displayed in Excel format. I had to do a report to display the output with Japan Characters. declare      demoDocument     xoxo_ExcelDocumentType;      documentArray    xoxo_ExcelDocumentLine := xoxo_ExcelDocumentLine();      clobDocument     CLOB;        v_file        UTL_FILE.FILE_TYPE;        lc_desc       table.column%TYPE;        lc_subject        xoxo_email.subject%TYPE;        ln_batch_id       xoxo_email.batch_id%TYPE;        lc_email_address  xoxo_email.to_address%TYPE;        lc_message        xoxo_email.text_body%TYPE;        lc_appl_name      applsys.fnd_application.application_short_name%TYPE := 'xoxo'; lc_prog_name      applsys.fnd_concurrent_programs.concurrent_program_name%TYPE := 'xoxo_BULK_EMAILER_CP';        ln_request_id     NUMBER;        ln_loop_counter   NUMBER := 1;        lc_instance       VARCHAR2(10);   BEGIN     FND_GLOBAL.APPS_INITIALIZE(USER_ID=>1872,RESP_ID=