NF-e (Electronic Invoice)

Este forum é destinado a perguntas relacionadas a Oracle, mas que não se enquadram nos forums acima. Aqui serão tratadas também sobre outras tecnologias da oracle, como o Workflow, BPEL, Spatial, OCS, etc.
Post Reply
User avatar
alef
Rank: Analista Pleno
Rank: Analista Pleno
Posts: 119
Joined: Tue, 06 Nov 2007 2:45 pm
Location: Patos de Minas - MG
Alexandre Matos
Patos de Minas - MG
Do interior de Minas para o resto do Mundo

Personally, I'vê been planning a little about NF-E and I wanted to know if anyone has already deployed in some company.

And how was this done? What are the steps to follow.

I am planning on the Federal Revenue website http://www.nfe.fazenda.gov.br



wanted to make a multirão to see if learning fast, and also a way to archive this here in the forum.


.
: -O
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

Good idea.
Who has already implemented, please share with us on the subject! : -The http://en.glufke.net/oracle/viewtopic.php?t=3064
Last edited by dr_gori on Thu, 22 May 2008 11:43 am, edited 1 time in total.
edson.amorim
Rank: Analista Sênior
Rank: Analista Sênior
Posts: 135
Joined: Thu, 04 Oct 2007 3:36 pm
Location: Belo Horizonte - MG

Dear colleague,

to you here from the forum. I hope to continue counting on and you and who can be able to collaborate as well.

a large embrace,

Edson
vsf
Rank: Estagiário Júnior
Rank: Estagiário Júnior
Posts: 2
Joined: Wed, 21 May 2008 8:27 pm
Location: Salvador
Contact:

Refer to the article by my own published in http://www.activedelphi.com.br/lista_to ... &topico=17 EU contains information on generation, signature, transmission and DANFE electronic invoice (NF-e)

there you find generation examples, Signature and transmission that simplify the process for just the call of 1 function!
_________________
_________________
Sincerely,

Victory Fernandes
Engineer
Engineering, Research and Development
] E-mail: hereim@ig.com.br

TKS Software
Tech-Knowledge Solutions
Dedicated automation and software solutions
Site: www.igara.com.br
User avatar
alef
Rank: Analista Pleno
Rank: Analista Pleno
Posts: 119
Joined: Tue, 06 Nov 2007 2:45 pm
Location: Patos de Minas - MG
Alexandre Matos
Patos de Minas - MG
Do interior de Minas para o resto do Mundo

There you find examples of generation, signature and transmission that simplify the process for just the call of 1 function!

From what I saw you have already developed a valid tool? is not it?

and for Forms? Did you do anything? Someone here from the forum has already developed ???


vlw by tips will already help a lot.
Trevisolli
Moderador
Moderador
Posts: 2016
Joined: Wed, 12 Jan 2005 3:25 pm
Location: Araraquara - SP
Abraço,

Trevisolli
OCA Oracle PL/SQL Developer Certified Associate
OCP Oracle Forms Developer Certified Professional
Araraquara-SP

Alef, beleza my old man?.

We are having some problems around here, with XML, XDS's and, if you can get something, I'm posting here for everyone, beleza?
User avatar
alef
Rank: Analista Pleno
Rank: Analista Pleno
Posts: 119
Joined: Tue, 06 Nov 2007 2:45 pm
Location: Patos de Minas - MG
Alexandre Matos
Patos de Minas - MG
Do interior de Minas para o resto do Mundo

Good Trevis ...



I will study the VSF articles more deeply, I believe that here in Minas Jaja so forcing the use of NF-E, and there begins rush ... hehehhehe
User avatar
fabdepaula
Rank: Estagiário Pleno
Rank: Estagiário Pleno
Posts: 4
Joined: Thu, 15 May 2008 8:53 pm
Location: Araraquara -SP

Our cool find this topic about electronic invoice. Here in the company we work we are developing a module to work with NF-E, everything was going very well until we come across the inviving XML and XSD. Creating the XML files is no problem, the problem is at the time of submitting this XML creates validation through the XSD that the government offers, we are trying to find the best solution to do this. First we try the following solution, record the XML we create on the bench, until there beauty, we created a table with XmlType field and recorded the XML. The problem is in loading the xsd in the bank, we are trying to do this using the dbms_xmlschema package where we put the xsd purchases in a bank directory and with the command dbms_xmlschema.registererschema we register these xsd to the bank, that's where we are with problems, if we create a simple sample XSD we managed to register normal on the bank and then we managed to submit the XML already saved in the bank the validation of XSD, but when we try to load the XSD from the government we can not, the government xsd are more complex From an XSD it is called another XSD, ours we are picking up from them !!!

If someone has passed this problem using this solution or another please help us and tell us how they are doing to validate XML using government XSDs

Thanks !!!!
figueiredocassio
Rank: Estagiário Júnior
Rank: Estagiário Júnior
Posts: 1
Joined: Fri, 15 Aug 2008 2:54 pm
Location: SP
Cassio Figueiredo

Hi everyone, how are you?

in relation to the subject NF-E, there is a lot of material released on the Federal Revenue Site in relation to SPED, within the SPED subject this included Sped Fiscal, Sped Account and NF-E, were E-Lalur, and knowledge of transportation and other projects that the government is leading.

in relation to NF-E implantation, I have already participated in deployments, including the next week I will be starting another NF-E X EBS (Oracle) project.

Remembering that Oracle is preparing to meet requirements for NF-E, but companies depend on Oracle partners who already have their own communication systems with Sefaz, which automatically generates the Danfe and generate XML, for the sephaz of origin.

If you want more information, I am at your disposal.
SjraarGubbels
Rank: Estagiário Pleno
Rank: Estagiário Pleno
Posts: 4
Joined: Tue, 16 Sep 2008 6:21 pm
Location: Patos de Minas MG

We have already developed a solution for Forms / Reports 6i (forward) end that Forms does not have much option for webservices / Java, so we use Java Stored Procedures and some packages for Java client from ORACLE and XML DB.

It was not easy but we got it.

For those who need (still) I can perhaps offer a partnership.

Sjraar Gubbels
Obers Ltda
alves.felipe
Rank: Estagiário Júnior
Rank: Estagiário Júnior
Posts: 1
Joined: Mon, 10 Aug 2009 3:39 pm
Location: PR

Fabdepaula

managed to register the NFE XSD ??
mbs
Rank: Estagiário Júnior
Rank: Estagiário Júnior
Posts: 1
Joined: Thu, 18 Feb 2010 8:51 am
Location: MG

Access the site www.mbsinformatica.com.br - The
bertosro
Rank: Analista Júnior
Rank: Analista Júnior
Posts: 88
Joined: Fri, 18 Aug 2006 11:13 am
Location: São Paulo - SP
Bertosro
MSN / TALK - roberto.fernandes@gmail.com

Dear colleagues Good morning.
I am creating the XML 2.0 generation routine for NF-e and I have a technical question regarding the XmlForest command.

When an XmlForest does not have nehum element with data it returns the closed tag, so: </ f2> I would like to know if someone knows how not to return this closed tag when there is no content inside it.

See the paratic example:

Select which generates the XML

Select all

 
   SELECT xmlElement("infNFe",xmlAttributes('2.0' as "versao"), 
              xmlForest --F1 
              (   
                'F1' as "numero"         
              ) as "F1" ,  
              xmlForest --F2 
              (   
                NULL as "numero"         
              ) as "F2" ,  
              xmlForest --f3 
              (   
                'F3' as "numero"         
              ) as "F3"                              
          ) as "infNFe" 
     FROM DUAL 
What returned

Select all

 
<infNFe versao="2.0"> 
  <F1> 
    <numero>F1</numero> 
  </F1> 
  <F2/> 
  <F3> 
    <numero>F3</numero> 
  </F3> 
</infNFe> 
expected return

Select all

 
<infNFe versao="2.0"> 
  <F1> 
    <numero>F1</numero> 
  </F1> 
  <F3> 
    <numero>F3</numero> 
  </F3> 
</infNFe> 
daniella
Rank: Estagiário Sênior
Rank: Estagiário Sênior
Posts: 10
Joined: Fri, 19 Nov 2010 1:23 am
Location: RJ

My XML has tags on the same line. I'm using xmlelement, xmlattributes.
How to do to skip line and identify the tags?
Post Reply
  • Information
  • Who is online

    Users browsing this forum: No registered users and 12 guests