BILLETS

Dicas do Oracle Forms Builder - Blocos, Itens, LOV, Canvas, Triggers, comandos, PLL, d2kwutil, FMB, Alert, menus, etc
Post Reply
japanfelipe
Rank: Estagiário Pleno
Rank: Estagiário Pleno
Posts: 4
Joined: Tue, 12 Jan 2010 4:15 pm
Location: jundiai - SP

Personnel,

I need a help to agree bank boleters from Banco Itau, Bradesco and Brazil.

Someone Te Layout, Bar Ecodigo Generator or something of the genre.

Thanks
alexrsilva
Rank: Analista Sênior
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

Before you start programming, you have to see which portfolio you will program.
I have already done these implementations for these banks, but I did with a specific portfolio, which is the shared wallet.
You must know how to do something and then have to redo.

Sincerely,
japanfelipe
Rank: Estagiário Pleno
Rank: Estagiário Pleno
Posts: 4
Joined: Tue, 12 Jan 2010 4:15 pm
Location: jundiai - SP

Banco do Brasil
Portfolio 17

Itau
Portfolio 109

Bradesco
Portfolio 009



Would you like to give a help ??
alexrsilva
Rank: Analista Sênior
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

Yes, what do you need?
has the documentation of BB and Itaú.
The other is the real, but I have all the fonts to go helping you in whatever it takes.
I do not know if you have to attach files here.
If you do not give, I'll send you email.

Sincerely,
japanfelipe
Rank: Estagiário Pleno
Rank: Estagiário Pleno
Posts: 4
Joined: Tue, 12 Jan 2010 4:15 pm
Location: jundiai - SP

If possible send me the documentation and fonts by email.

japanfelipe@hotmail.com
japanfelipe@gmail.com


I will be very grateful.

I will request the company that informs the bank and ask for manuals or something of the genre, but I already want to go stirring before to see if it is possible.

And as for the bar code as you solved, because I saw that of some problems ..

Thanks,


Felipe M
alexrsilva
Rank: Analista Sênior
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

I forgot to ask which standard CNAB will you use?

240 or 400?

Do you want part of the code?

We generate the bar code image with Java (JSP).

Sincerely,
alexrsilva
Rank: Analista Sênior
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

Bar code generation was done with [url=http://jbars.sourceforge.net/]Jbars
thebranco
Rank: Programador Sênior
Rank: Programador Sênior
Posts: 61
Joined: Tue, 04 Aug 2009 7:29 pm
Location: santa cruz das palmeiras

I liked this subject he interests me!
If possible send in my email também!

Thanks

Embrace

White
alexrsilva
Rank: Analista Sênior
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

White,
Sorry for the delay in response.
follows a [URL [http://blogs.oracle.com/xmlpublisher/fi ... inting.pdf]link has this also [url=http://download.oracle.com/docs/cd/E128 ... ode002.htm]link .

Sincerely,
alexrsilva
Rank: Analista Sênior
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

After adding the JBARS in Oracle, compile this code

Select all

 
create or replace and compile java source named barcode as 
import java.io.*; 
import javax.swing.*; 
import org.jbars.*; 
import java.awt.image.*; 
import java.awt.*; 
import oracle.sql.*; 
import oracle.jdbc.*; 
class Barcode { 
	public Barcode() { 
		super(); 
	} 
public static BLOB code(String code,String type, String sizeY) throws java.sql.SQLException, Exception{ 
    OracleConnection conn = (OracleConnection) new OracleDriver().defaultConnection(); 
    conn.setAutoCommit(false); 
    BLOB blob = BLOB.createTemporary(conn, true, BLOB.DURATION_SESSION); 
		String imageFormat = Barcode.JPG; 
		String quietZone = null; 
		// Create Barcode 
		Barcode barcode = null; 
		if (type.equalsIgnoreCase("CODE128")) { 
			barcode = new Barcode128(); 
		} 
		if (type.equalsIgnoreCase("CODE93")) { 
			barcode = new Barcode93(); 
		} 
		if (type.equalsIgnoreCase("INTER25")) { 
			barcode = new BarcodeInter25(); 
		} 
		if (barcode == null) { 
			System.out.println("Unknow barcode type: " + type); 
			System.exit(1); 
		} 
                Color barColorColor; 
                        barColorColor = Color.black; 
                Color textColorColor; 
                        textColorColor = Color.black; 
                double angle = 0; 
                barcode.setFontSize(10); 
		barcode.setTextAlignment(Barcode.ALIGN_CENTER); 
		barcode.setCode(code); 
			byte[] file=null; 
			if(imageFormat.equals(Barcode.PNG)){ 
				file= barcode.createPNG(Integer.parseInt(sizeY), 
					barColorColor, textColorColor, angle); 
			} 
			else if(imageFormat.equals(Barcode.JPG)){ 
				file= barcode.createJPG(Integer.parseInt(sizeY), 
						barColorColor, textColorColor, angle); 
			} 
			else{ 
				System.out.println("Unknow image format: " + imageFormat); 
				System.exit(1); 
			} 
			//FileOutputStream os = new FileOutputStream(new File(fileName)); 
                        OutputStream os = blob.getBinaryOutputStream(); 
			os.write(file); 
			os.flush(); 
			os.close(); 
           return blob; 
	} 
} 
can call it thus

Select all

 
FUNCTION generate_barcode( p_code IN VARCHAR2  -- Números do código de barras 
                                  , p_tipo IN VARCHAR2  --'CODE128','CODE93' ou 'INTER25' 
                                                       --passe CODE128 
                                  , p_size IN VARCHAR2 -- Tamanho da imagem, eu utilizo 50 
         ) RETURN BLOB 
AS LANGUAGE JAVA NAME 'Barcode.code(java.lang.String, java.lang.String,java.lang.String ) return oracle.sql.BLOB'; 
He returns the image of the barcode.
esaito
Rank: Estagiário Sênior
Rank: Estagiário Sênior
Posts: 8
Joined: Wed, 06 Apr 2011 3:56 pm
Location: Lins-sp

Alex, good afternoon

I have the following problem:
I'm riding a forms to generate bradesco white collection text file in CNAB 400 format, I already have lay-out, But I have some doubts. If it were possible how to send me the text file generated by your application so I can see how the format is in the text file? I would like to see também the forms, so that I can have a north to follow, because only lay-out leaves some confused things, and since I'vê never worked with it before I'd like to have some information.

Thanks.
alexrsilva
Rank: Analista Sênior
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

Yes he has.
Just can not be around here. Here it does not let attach files.

Sincerely,
esaito
Rank: Estagiário Sênior
Rank: Estagiário Sênior
Posts: 8
Joined: Wed, 06 Apr 2011 3:56 pm
Location: Lins-sp

Alex, thank you for the immediate response.

could you send it to my email?
evandro.saito@tanger.com.br
alexrsilva
Rank: Analista Sênior
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

Sent.
esaito
Rank: Estagiário Sênior
Rank: Estagiário Sênior
Posts: 8
Joined: Wed, 06 Apr 2011 3:56 pm
Location: Lins-sp

Alex, thank you.

I received the file and I will be taking the doubts by email.
Odair
Rank: Estagiário Júnior
Rank: Estagiário Júnior
Posts: 2
Joined: Sat, 06 Sep 2008 1:05 pm
Location: Osasco-SP
Odair Melo

Alex,

I have the same problem ...... can you send it to me too?

osmelo@yahoo.com

Thanks.
alexrsilva
Rank: Analista Sênior
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

Sent.
If you need some help with the bar code generation, just let us know.

Sincerely,
rcd_tech@hotmail.com
Rank: Programador Pleno
Rank: Programador Pleno
Posts: 42
Joined: Thu, 08 Sep 2011 1:13 pm
Location: SP

Good afternoon,

Galera, I have the need to generate tickets.

I did in the Oracle Reports 10 The report of the Reports and there even I can generate the railway bar code.

Now I have to do all the generation algorithm for completing this ticket.

Can anyone help me sending me manual of garanation, layout and everything else?

If you have ready in FMB or Bank Object would be perfect.

Thank you in advance.

E-mail: rcd_tech@hotmail.com

Att,
Ricardo Miranda
alexrsilva
Rank: Analista Sênior
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

Ricardo,
What is the bank to use?
Which CNAB?
Want to create the ticket from air generation to forms generating so PDFs?

Sincerely,
User avatar
dr_gori
Moderador
Moderador
Posts: 5024
Joined: Mon, 03 May 2004 3:08 pm
Location: Portland, OR USA
Contact:
Thomas F. G

Você já respondeu a dúvida de alguém hoje?
https://glufke.net/oracle/search.php?search_id=unanswered

If you are sending attachments, send to handwriter glufke.net
then I will attach this topic! (so you do not need to send everyone individually): "
rcd_tech@hotmail.com
Rank: Programador Pleno
Rank: Programador Pleno
Posts: 42
Joined: Thu, 08 Sep 2011 1:13 pm
Location: SP

Then Alex,

already thanking his attention.

Not yet which CNAB but Logo discover.

I will generate ticket for different banks.

If you do not want to send me what you have for me to take a look?

E-mail: rcd_tech@hotmail.com

Att,
Ricardo Miranda
rcd_tech@hotmail.com
Rank: Programador Pleno
Rank: Programador Pleno
Posts: 42
Joined: Thu, 08 Sep 2011 1:13 pm
Location: SP

As I did the ticket layout on Oracle Reports, if anyone wants the layout as well, I'll go, so a hand wash the other.

Alex,

I am waiting for his response.

Thanks.

E-mail: rcd_tech@hotmail.com

Att,
Ricardo Miranda
rcd_tech@hotmail.com
Rank: Programador Pleno
Rank: Programador Pleno
Posts: 42
Joined: Thu, 08 Sep 2011 1:13 pm
Location: SP

So Alex,

CNAB is a layout pattern to send a lot to the correct bank and the bank that generates the tickets?

That's not what I want.

I want my system to send the ticket via registered or not registered only, I do not want to send a file to the bank to generate the ticket, my system needs to generate the ticket understands?

I do not know if it became clear.

Att,
Ricardo Miranda
alexrsilva
Rank: Analista Sênior
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

To generate the ticket you will depend on what each bank asks to go to the bar code and the tickets.
Usually this is in CNAB document, not necessarily.
How to validate the bar code, date of payment, among other things.

Sincerely,
rcd_tech@hotmail.com
Rank: Programador Pleno
Rank: Programador Pleno
Posts: 42
Joined: Thu, 08 Sep 2011 1:13 pm
Location: SP

Alex,

take a look at this link
http://www.macoratti.net/boleto.htm
is exactly what I want, only that this means confused to understand this documentation.

take a look, what I need is it there.

Att,
Ricardo Miranda
alexrsilva
Rank: Analista Sênior
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

What I told you about.
Stop generating the tickets, you will need the banks documents for the ticket generation.
In the case of the link that passed me, he speaks only to Banco do Brasil, you will have one of these for Bradesco, CEF, Santander, Itaú and all other banks.
even if CNAB 240, 400 or any other pattern, you will have peculiarities of the banks, because the bacen only validates if the document only has the right amount of characters and some positions that are standardized by the BACEN, the rest bank can put whatever you want.
I will send the banks documents that I have here for the handouts.

I hope to have explained,
rcd_tech@hotmail.com
Rank: Programador Pleno
Rank: Programador Pleno
Posts: 42
Joined: Thu, 08 Sep 2011 1:13 pm
Location: SP

Legal Alex,

Send kindly.

E-mail: rcd_tech@hotmail.com

Skype: Ricardo.Orio.quasar

Thanks.

Att,
Ricardo Miranda
rcd_tech@hotmail.com
Rank: Programador Pleno
Rank: Programador Pleno
Posts: 42
Joined: Thu, 08 Sep 2011 1:13 pm
Location: SP

Legal Alex,

Send kindly.

E-mail: rcd_tech@hotmail.com

Skype: Ricardo.Orio.quasar

Thanks.

Att,
Ricardo Miranda
User avatar
dr_gori
Moderador
Moderador
Posts: 5024
Joined: Mon, 03 May 2004 3:08 pm
Location: Portland, OR USA
Contact:
Thomas F. G

Você já respondeu a dúvida de alguém hoje?
https://glufke.net/oracle/search.php?search_id=unanswered

If you are sending attachments, send to handwriter glufke.net

Dai I will attach this topic! (So ??you do not have to send everyone individually)

We do not want this topic to be those "Send to me too !!"

: -O
rcd_tech@hotmail.com
Rank: Programador Pleno
Rank: Programador Pleno
Posts: 42
Joined: Thu, 08 Sep 2011 1:13 pm
Location: SP

Alex,

Have you put some documentation here on the site?

I'm waiting.

Thanks.

Att,
Ricardo Miranda
rcd_tech@hotmail.com
Rank: Programador Pleno
Rank: Programador Pleno
Posts: 42
Joined: Thu, 08 Sep 2011 1:13 pm
Location: SP

I'm lost here.

The documentation I found are very poorly made, I can not understand them.

If you have someone here in the forum that has already generated a ticket in the system itself please give me some tips that is difficult.

From what I researched the bank offers a manual for generating this ticket, but I can not find any place in which I get these manuals, if I call my bank manager it goes to know?

Since thank you for the collaboration of all.

Thanks.

Att,
Ricardo Miranda
rcd_tech@hotmail.com
Rank: Programador Pleno
Rank: Programador Pleno
Posts: 42
Joined: Thu, 08 Sep 2011 1:13 pm
Location: SP

Good afternoon gentlemen,

No one to help?

A hug.

Att,
Ricardo Miranda
User avatar
bessa_lucas
Rank: Programador Sênior
Rank: Programador Sênior
Posts: 55
Joined: Fri, 17 Oct 2014 3:02 pm
Lucas Bessa
Analista de Sistemas

lucas.bessa@obers.com.br
lucas.bessa.ti@gmail.com

Personnel

I have a problem from the forms I shoot to generate the PDF of the Itau ticket, which has the source code 2/5 interleaved.

When I generate the preview, or generate the PDF from a printer (CutePDF and PrimOpdf) of the right. The problem is that I need to automatically generate by Reports 6i. It gets to generate the file, but I tried to read with Adobe Reader and do not, I could only open with other readers and the whole barcode messy.

Ps.: I have the source installed on my computer.
User avatar
bessa_lucas
Rank: Programador Sênior
Rank: Programador Sênior
Posts: 55
Joined: Fri, 17 Oct 2014 3:02 pm
Lucas Bessa
Analista de Sistemas

lucas.bessa@obers.com.br
lucas.bessa.ti@gmail.com

Hello everyone,

I ended up finding a solution using Java on the bank. See this topic. http://en.glufke.net/oracle/viewtopic.p ... 882#p39882
Post Reply
  • Information
  • Who is online

    Users browsing this forum: No registered users and 10 guests