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.
Vitualized reporting in EBS prints different
- madmax
- Rank: DBA Pleno
- Posts: 293
- Joined: Wed, 13 Dec 2006 5:02 pm
- Location: São Paulo
- Contact:
________________________________
Douglas - Madmax.
Douglas - 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.
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.
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 ...
-
- Rank: Analista Sênior
- Posts: 153
- Joined: Tue, 27 May 2008 1:31 pm
- Location: Rio de Janeiro - RJ
Alex Silva
Analista de Sistemas
11i.10 Applications Developer Implementation Champion
11i.10 E-Business Suite Integration Champion
Analista de Sistemas
11i.10 Applications Developer Implementation Champion
11i.10 E-Business Suite Integration Champion
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,
You will be able to choose the output form of your report. XML, PDF, HTML or RTF.
Give a survey on.
Sincerely,
-
- Rank: Analista Sênior
- Posts: 153
- Joined: Tue, 27 May 2008 1:31 pm
- Location: Rio de Janeiro - RJ
Alex Silva
Analista de Sistemas
11i.10 Applications Developer Implementation Champion
11i.10 E-Business Suite Integration Champion
Analista de Sistemas
11i.10 Applications Developer Implementation Champion
11i.10 E-Business Suite Integration Champion
Adds "Administrator XML Publisher"
- madmax
- Rank: DBA Pleno
- Posts: 293
- Joined: Wed, 13 Dec 2006 5:02 pm
- Location: São Paulo
- Contact:
________________________________
Douglas - Madmax.
Douglas - 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]
I create a package and place the procedure inside the packages separated by modules and an Oracle standard that we use here.
.
ABS. [/ Code]
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
Thanks
- madmax
- Rank: DBA Pleno
- Posts: 293
- Joined: Wed, 13 Dec 2006 5:02 pm
- Location: São Paulo
- Contact:
________________________________
Douglas - Madmax.
Douglas - Madmax.
CEESS_1.
follows an example to follow as template.
Anything we are aí. : Wink:
ABS.
follows an example to follow as template.
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;
ABS.
-
- Information
-
Who is online
Users browsing this forum: No registered users and 1 guest