Vitualized reporting in EBS prints different

[ceess_1]

Hello friends, I have a problem and I would like the help of you, I created a report and his output in the concurrent is like .txt when being viewed in the EBS it is OK, but when the user selects copying to copy it loses all the formatting of columns And lines, someone has gone through this and has an idea of ??how I can solve this problem.

Thank you in advance.

[madmax]

Hello CEESS_1

The reports here most are in txt for being faster and easier to export to Excel.

Well let's go there Here we exported as follows:


1 - The user must right-click and save as

2 - Save the file to a location as txt

3 - Open Excel and locate the TXT file
The Import Wizard will appear Excel, inform delimited and advance.

4 - Choose others and place as a column separator (;) Point and Virgula Click on Next

5 - Select all columns and choose text format, Click Finish.

ready is imported to Excel.

I hope I have helped.

[ceess_1]

So Douglas in this case is after the report is generated, here does not enable this option, in your case the concurrent is as reports or as a PL / SQL procedure? You have an email for me to send you the print of the screens I think it's easier to understand ...

[alexrsilva]

Why do not you use XML Publisher?
You will be able to choose the output form of your report. XML, PDF, HTML or RTF.

Give a survey on.

Sincerely,

[ceess_1]

But then I'm going to have this default in the EBS ?? Or do I have to have a development tool aside?

[alexrsilva]

Adds "Administrator XML Publisher"

[madmax]

So cess_1 the reports that I have in txt are PL / SQL procedure.

I create a package and place the procedure inside the packages separated by modules and an Oracle standard that we use here.
.


ABS. [/ Code]

[ceess_1]

beleza, that way you said I think it's better tb .. man by chance you would not have one to send me by email so I can use as an example? My email is ceess_1@hotmail.com

Thanks

[madmax]

CEESS_1.

follows an example to follow as template.

Select all

 
CREATE OR REPLACE PACKAGE XX_OM_ACOMP_PKG AS 
 
Procedure XX_REL_ACOMP (ERRBUF  OUT VARCHAR2 
                                       ,RETCODE    OUT NUMBER 
                                       . 
. 
. 
. 
. 
 
                                      ); 
End XX_OM_ACOMP_FISIC_FINANC_PKG; 
 
 
 
CREATE OR REPLACE PACKAGE BODY XX_OM_ACOMP_FISIC_FINANC_PKG AS 
PROCEDURE XX_REL_ACOMP_FISIC_FINANC (ERRBUF  OUT VARCHAR2 
                                     ,RETCODE    OUT NUMBER 
                                     . 
. 
. 
. 
. 
. 
                                     ) AS 
 
 
--- Variaveis: 
  v_linha                          VARCHAR2(2000); 
  v_valor_tot_linha                VARCHAR2(50); 
  v_SITUACAO                       VARCHAR2(50); 
. 
. 
. 
. 
. 
   
  
 
 
--> CURSOR SELECT PRINCIPAL  
cursor c_nf is 
 
SELECT ……………………; 
 
---------------------------------------------------------------------- 
     
 
    Begin 
       -- Abre o Aquivo para Gravação 
       DBMS_OUTPUT.ENABLE(9000000000); 
      fnd_file.put_line(fnd_file.log,'========================================================================================'); 
      fnd_file.put_line(fnd_file.log,'Abre Arquivo para Gravação ' || to_char(sysdate, 'dd-mon-yy HH:mi:ss')); 
      fnd_file.put_line(fnd_file.log,'Valores dos parametros inseridos: '); 
      fnd_file.put_line(fnd_file.log,'Data da Ordem = ' || to_char(P_DT_INI) || ' FINAL = ' || to_char(P_DT_FIM)); 
      fnd_file.put_line(fnd_file.log,'Cliente Inicial = ' || to_char(P_CLIENTE_INI) || ' FINAL = ' || to_char(P_CLIENTE_FIM)); 
. 
. 
. 
. 
. 
. 
fnd_file.put_line(fnd_file.log,'========================================================================================'); 
    Exception 
      When Others Then 
        raise_application_error(-20080,sqlerrm || ' Problemas na abertura do arquivo '); 
    End; 
 
  
  -- Monta o Titulo do Relatorio 
   v_linha :=        ''    ||';' 
                 || '' || ';' 
                 || '' || ';' 
                 || '' || ';' 
                 || 'Relatório XXXXXXXXXXXXXXXXXXX' || ';' 
                 || '' || ';' 
                 || '' ; 
 
 
    Begin 
     Fnd_File.Put_Line(Fnd_File.Output, v_linha); 
    Exception 
      When Others Then 
        fnd_file.put_line(fnd_file.output,'Problemas na gravacao do arquivo'); 
        raise_application_error(-20030,sqlerrm ||' Problemas na gravacao do arquivo '); 
    End; 
 
 
 
  -- Monta os Campos Do Cabeçalho  
 
  v_linha :=        'Número'    ||';'              --1 
                 || 'Data' || ';'                  --2 
                 || 'Transação' || ';'             --3 
                 || 'OC Cliente' || ';'            --4 
                 || 'Nota Fiscal' || ';'           --5 
                 || 'Código' || ';'                --6 
                 || 'Local' || ';'                 --7 
                 . 
. 
. 
. 
. 
. 
. 
. 
. 
. 
. 
. 
. 
                 || 'Total' || ';'                 --20 
                 || 'Recebido' || ';'              --21 
                 || 'Cancelado' || ';'             --22 
                 || 'Saldo' || ';'                 --23 
                 || 'Valor Total OV' || ';'          --23                           
                 || 'Pagamento ' || ';'            --24 
                 || 'Vencimento ' || ';'           --25 
                 || 'Pagamento ' || ';'            --26 
                 || 'Situacao' ;                   --27 
 
 
    Begin 
     Fnd_File.Put_Line(Fnd_File.Output, v_linha); 
    Exception 
      When Others Then 
        fnd_file.put_line(fnd_file.output,'Problemas na gravacao do arquivo'); 
        raise_application_error(-20030,sqlerrm ||' Problemas na gravacao do arquivo '); 
    End; 
 
 
  
   
    --- Processa os registros do cursor --- 
      For v_nf in c_nf loop 
 
        Exit When c_nf%NotFound; 
         
         
 
       --- Formata o layout do CSV --- 
        v_linha :=  v_nf.Numero   ||';'                --1 
                  || v_nf.Date_Ordem ||';'             --2 
                  || v_nf.Transacao ||';'              --3 
                  || v_nf.OC_CLIENTE ||';'             --4 
                  || v_nf.Nota_Fiscal||';'             --5 
. 
. 
. 
. 
. 
. 
. 
. 
. 
. 
. 
. 
. 
 
                  || v_nf.Condicao_Pagamento ||';'     --24  
                  || V_DATA_VENCTO ||';'             --25 
                  || v_nf.ULTIMO_PAGAMENTO ||';'       --26  
                  || v_nf.SITUACAO ;                   --27 
   
        --- Grava o registr 
 
        begin 
            Fnd_File.Put_Line(Fnd_File.Output, v_linha); 
        Exception 
          When Others Then 
            dbms_output.put_line('Problemas na gravacao do arquivo header '); 
            fnd_file.put_line(fnd_file.output,'Problemas na gravacao do arquivo' ); 
            raise_application_error(-20030, sqlerrm || ' Problemas na gravacao do arquivo '); 
        End; 
 
      --- Fecha o Loop CURSOR 1 
        End Loop; 
         
 
 END XX_REL_ACOMP_FISIC_FINANC; 
 
End XX_REL_ACOMP; 

Anything we are aí. : Wink:

ABS.