6 Replies Latest reply: Mar 21, 2012 7:49 AM by 924340 RSS

    How concurrent program generates XML

    924340
      Hi
      I want to know how concurrent program generates XML output file when we set the output file type as XML.
      I want the file which concurrent program uses to generate XML output.
      Any help Appreciated.....
        • 1. Re: How concurrent program generates XML
          AlexAnd
          for apps use E-Business Suite

          btw

          >
          I want to know how concurrent program generates XML output file when we set the output file type as XML.
          I want the file which concurrent program uses to generate XML output.
          >
          do you see a concrete example?
          or in general?
          • 2. Re: How concurrent program generates XML
            924340
            Yes for EBS.

            I want to know how oracle apps generate XML output.
            i.e which are the files used by oracle apps and what is their execution sequence.
            • 3. Re: How concurrent program generates XML
              AlexAnd
              >
              i.e which are the files used by oracle apps and what is their execution sequence.
              >
              depends on the method of creating a concurrent program

              you can create concurrent which generate xml in package or by xml data template
              • 4. Re: How concurrent program generates XML
                924340
                Hi AlexAnd ,

                I have created a concurrent program with Output type as XML and executable as PL/SQL.
                Now my question is to generate XML output must be using some template.
                Where this template is store and how it helps concurrent program to generate xml output.
                • 5. Re: How concurrent program generates XML
                  AlexAnd
                  >
                  I have created a concurrent program with Output type as XML and executable as PL/SQL.
                  >

                  you have plsql package as executable for concurrent program
                  so
                  you can generate your xml in package by
                  fnd_file.put_line(fnd_file.output, <your xml element>);
                  for example
                  fnd_file.put_line(fnd_file.output, '<CUSTPAR>' || p_paramm_value ||'</CUSTPAR>');
                  Now my question is to generate XML output must be using some template.
                  >
                  for generate xml by xml data template
                  you must set for concurrent program
                  XDODTEXE as executable
                  then create xml template - about see in http://docs.oracle.com/cd/E12844_01/doc/bip.1013/e12187/T421739T434255.htm

                  in this case concurrent will be generate xml by xml template

                  >
                  Where this template is store and how it helps concurrent program to generate xml output.
                  >
                  for publisher exists template(layout of report in rft, pdf ...) and xml template (which generate data for template)
                  which are stored in several tables, for example, XDO_TEMPLATES_B, , XDO_DS_DEFINITIONS_B, XDO_LOBS (this contain template layout as lob)
                  • 6. Re: How concurrent program generates XML
                    924340
                    Thank you.