This discussion is archived
1 2 Previous Next 15 Replies Latest reply: Dec 15, 2012 11:45 PM by M_KH_1981 RSS

EBS 12.1 integrate with XML Publisher

M_KH_1981 Newbie
Currently Being Moderated
Hi all
I'm new in Xml Publisher yet and I used Oracle Discoverer before
but now i want to use Xml Publisher for reporting.
I see usefull post BI Publisher on EBS R12
also Note: 552735.1 - Integrating Oracle Business Intelligence Applications with Oracle E-Business Suite
but I have some problem yet.
in some article has been said that we should http://<hostname>: <port >/xmlpserver for Logging in to Oracle BI Publisher

1. I think this is not for EBS (is only for when we installed Oracle BI Publisher), is it true?

2. as default xml publisher is active in ebs and we can use this for our report, is it true?

3. i think xml publisher in EBS give us only xml file and we should use Xml Publisher Desktop to see our reports (With xml file source), is it true?

can anybody help me please ....

Thanks
  • 1. Re: EBS 12.1 integrate with XML Publisher
    Srini Chavali-Oracle Oracle ACE Director
    Currently Being Moderated
    M.Khayatan wrote:
    Hi all
    I'm new in Xml Publisher yet and I used Oracle Discoverer before
    but now i want to use Xml Publisher for reporting.
    I see usefull post BI Publisher on EBS R12
    also Note: 552735.1 - Integrating Oracle Business Intelligence Applications with Oracle E-Business Suite
    but I have some problem yet.
    in some article has been said that we should http://<hostname>: <port >/xmlpserver for Logging in to Oracle BI Publisher

    1. I think this is not for EBS (is only for when we installed Oracle BI Publisher), is it true?
    Correct - this is for a standalone install of BI Publisher and not applicable to EBS.
    2. as default xml publisher is active in ebs and we can use this for our report, is it true?
    Yes - you can use BI Publisher to create reports out of EBS base tables. If you are wanting to create reports out of any custom tables or remote custom databases, pl contact your Oracle salesperson for licensing issues.
    3. i think xml publisher in EBS give us only xml file and we should use Xml Publisher Desktop to see our reports (With xml file source), is it true?
    BI Publisher Desktop is a development tool to design the layout of the reports. EBS includes seeded xml templates as well as design templates. When XML reports are run, these two templates are automatically used to produce the desired output.

    Pl see these links for further info

    http://www.oracle.com/webfolder/technetwork/tutorials/obe/fmw/bi/xmlp_ebiz/index.html
    http://www.docstoc.com/docs/23964434/XML-Publisher-For-Dummies-%E2%80%93-A-Step-By-Step

    can anybody help me please ....

    Thanks
    HTH
    Srini
  • 2. Re: EBS 12.1 integrate with XML Publisher
    Hussein Sawwan-Oracle Employee ACE
    Currently Being Moderated
    1. I think this is not for EBS (is only for when we installed Oracle BI Publisher), is it true?
    Yes, but this doc is for integrating BI Publisher with EBS.
    2. as default xml publisher is active in ebs and we can use this for our report, is it true?
    Correct.
    3. i think xml publisher in EBS give us only xml file and we should use Xml Publisher Desktop to see our reports (With xml file source), is it true?
    Correct.

    Thanks,
    Hussein
  • 3. Re: EBS 12.1 integrate with XML Publisher
    M_KH_1981 Newbie
    Currently Being Moderated
    Hi Srini
    thanks for your complete reply.
    now i have some knowlege about XML PUBLISHER
    your document XML-Publisher-For-Dummies is very useful for me.

    but when i have done steps you said i encounter a new problem Concurrent Program Request is not able to find an XML template for your program. etc...
    I guest it is a generic problem for new xml publisher users
    but my Data Definition Name is same with Application Shortname & Executable name
    also when i click on download template in Template Tab, I can download template file
    also again I have selected my Template file in System Administration Responsibility and OnSite tab.
    so I can't understand where is my problem

    can you help me what should i do?
    and what can I create another data definition with the same code with previous data definition?

    please note that my report is Standard report: Users of responsibility

    thanks for help
  • 4. Re: EBS 12.1 integrate with XML Publisher
    Srini Chavali-Oracle Oracle ACE Director
    Currently Being Moderated
    If you have performed all of the setups correctly, then when you submit the concurrent, the template field in the SRS form should get automatically populated. Can you confirm this is the case ?

    HTH
    Srini
  • 5. Re: EBS 12.1 integrate with XML Publisher
    M_KH_1981 Newbie
    Currently Being Moderated
    Hi Sirini
    I found out this error is not serious.
    because when we encounter this error, we can click on Option button and choose our template manualy.
    ofcourse I couldn't understand why this occure for me when I think I do all steps correctly and I'm trying to solve this now

    but when I choosen my template manualy again my request ended with warning and I couldn't see my report and always shown me XML code
    again I found out that i should use Xml Publisher Desktop 10..... instead of 11.1.5....
    by using that version this problem solved too.

    now my problem is:
    When I choose pdf for outpout report, my report make in server and I can copy generated pdf to local computer with for example Winscp
    but when I click on view output button I encounter this message:

    Authentication failed.

    do you know why???

    thanks for your help
    Meysam
  • 6. Re: EBS 12.1 integrate with XML Publisher
    Srini Chavali-Oracle Oracle ACE Director
    Currently Being Moderated
    M.Khayatan wrote:
    Hi Sirini
    I found out this error is not serious.
    because when we encounter this error, we can click on Option button and choose our template manualy.
    ofcourse I couldn't understand why this occure for me when I think I do all steps correctly and I'm trying to solve this now
    If you have performed all of the steps correctly, then the template should auto-populate - you should not have to manually select it. Pl check your setups.
    but when I choosen my template manualy again my request ended with warning and I couldn't see my report and always shown me XML code
    again I found out that i should use Xml Publisher Desktop 10..... instead of 11.1.5....
    by using that version this problem solved too.
    You have to use the correct version of Publisher Desktop tool - pl see this MOS Doc

    Overview of Available Patches for Oracle XML Publisher embedded in the Oracle E-Business Suite [ID 1138602.1]
    now my problem is:
    When I choose pdf for outpout report, my report make in server and I can copy generated pdf to local computer with for example Winscp
    but when I click on view output button I encounter this message:

    Authentication failed.

    do you know why???
    Is this the complete error message ? If not, pl post the complete error message - do you see this message in your browser ?
    thanks for your help
    Meysam
    HTH
    Srini
  • 7. Re: EBS 12.1 integrate with XML Publisher
    Hussein Sawwan-Oracle Employee ACE
    Currently Being Moderated
    but when I choosen my template manualy again my request ended with warning and I couldn't see my report and always shown me XML code
    again I found out that i should use Xml Publisher Desktop 10..... instead of 11.1.5....
    by using that version this problem solved too.
    Please see (How to Determine the Version of Oracle XML Publisher for Oracle E-Business Suite 11i and Release 12 [ID 362496.1] -- 4. Additional patches for XML Publisher) for the version you need to use.
    now my problem is:
    When I choose pdf for outpout report, my report make in server and I can copy generated pdf to local computer with for example Winscp
    but when I click on view output button I encounter this message:

    Authentication failed.

    do you know why???
    This is a generic error, please check (Apache/Application) log files for details about the error.

    Please also see if ("Cannot instantiate permission class "oracle.as.scheduler.security.MetadataPermission", target "oracle.bip.ess.JobDefinition.EssBipJob" Error After Submitting Reports in Clustered BI Publisher Environment [ID 1455977.1]) is applicable.

    Thanks,
    Hussein
  • 8. Re: EBS 12.1 integrate with XML Publisher
    M_KH_1981 Newbie
    Currently Being Moderated
    Hi Srini
    Srini Chavali wrote:
    If you have performed all of the steps correctly, then the template should auto-populate - you should not have to manually select it. Pl check your setups.
    I think I found out what's the problem.
    whenever I create a template with a language excluding English like Arabic , I encounter this problem.
    and when I create a new Template with English language and add to Template the problem solve and the template populate automatically.
    I checked it with 2 or 3 report, I hope it is be correct.
    now my problem is:
    When I choose pdf for outpout report, my report make in server and I can copy generated pdf to local computer with for example Winscp
    but when I click on view output button I encounter this message:

    Authentication failed.

    do you know why???
    Is this the complete error message ? If not, pl post the complete error message - do you see this message in your browser ?
    Yes, this is complete message in my browser , I see this message in browser.
    as i said my pdf report make in server and i can see it when I copy it from server
    but when i click on Preview button a new popup page open in my browser and show this message:
    Authentication failed.
    ofcourse when my report output is RTF instead of PDF there is no problem and i can open report with this button.

    please tell me is there any configuration in wherever that I missed it???

    Thanks
    Meysam
  • 9. Re: EBS 12.1 integrate with XML Publisher
    M_KH_1981 Newbie
    Currently Being Moderated
    Hi Hussein
    Hussein Sawwan wrote:
    now my problem is:
    When I choose pdf for outpout report, my report make in server and I can copy generated pdf to local computer with for example Winscp
    but when I click on view output button I encounter this message:

    Authentication failed.

    do you know why???
    This is a generic error, please check (Apache/Application) log files for details about the error.

    Please also see if ("Cannot instantiate permission class "oracle.as.scheduler.security.MetadataPermission", target "oracle.bip.ess.JobDefinition.EssBipJob" Error After Submitting Reports in Clustered BI Publisher Environment [ID 1455977.1]) is applicable.
    Yes, this is generic error.
    where is Apache log??
    if you mean *error_log* and *access_log* so i can't find any clue or error of this error.
    but about application log: $APPL_TOP/admin/CONTEXT_NAME/log is application log?
    in this address there isn't any relative log file that changes with this error.
    the latest log file that changes are adadmin.log & and adpatch and adwork logs

    can you help me alittle more??

    Thanks
    Meysam
  • 10. Re: EBS 12.1 integrate with XML Publisher
    Srini Chavali-Oracle Oracle ACE Director
    Currently Being Moderated
    M.Khayatan wrote:
    Hi Srini
    now my problem is:
    When I choose pdf for outpout report, my report make in server and I can copy generated pdf to local computer with for example Winscp
    but when I click on view output button I encounter this message:

    Authentication failed.

    do you know why???
    Is this the complete error message ? If not, pl post the complete error message - do you see this message in your browser ?
    Yes, this is complete message in my browser , I see this message in browser.
    as i said my pdf report make in server and i can see it when I copy it from server
    Pl elaborate what and how you "see" - can you open the PDF file ?
    but when i click on Preview button a new popup page open in my browser and show this message:
    Authentication failed.
    Where is the preview button ? Pl identify what browser version you are using.
    ofcourse when my report output is RTF instead of PDF there is no problem and i can open report with this button.

    please tell me is there any configuration in wherever that I missed it???

    Thanks
    Meysam
    HTH
    Srini
  • 11. Re: EBS 12.1 integrate with XML Publisher
    M_KH_1981 Newbie
    Currently Being Moderated
    Hi Srini
    Srini Chavali wrote:

    Pl elaborate what and how you "see" - can you open the PDF file ?
    Ok,
    When my concurrent program finished depends on choosen output format,it creates a file in address $APPLCSF/$APPLTOP like others concurrent program output files.
    but if I want to see output pdf then I need some tools like Winscp or using Os File Sharing to copy output pdf to my hard drive.
    I use these methods so I can open created pdf on my hard drive localy not by using EBS Forms.

    but if I want to use Requests Form in ebs to see concurrent program status and output and log, when I click on View Output, it can't download or open pdf file and only open on my browser a new page or popup page and show me Authentication failed. message.
    i know this is generic message, but i want to know where can i fount log or ... for solving this error.

    So I can only see and open pdf output files without EBS and by using another tool.
    Where is the preview button ? Pl identify what browser version you are using.
    I'm sorry
    it's my fault, Preview Button means View Output Button on requests Form in EBS.

    Thanks
    Meysam
  • 12. Re: EBS 12.1 integrate with XML Publisher
    Srini Chavali-Oracle Oracle ACE Director
    Currently Being Moderated
    Pl post details of OS, database and EBS versions.

    Pl check the application listener log for any errors - this can by typically found in the $TNS_ADMIN directory (or subdirectories) when logging in as the owner of the application binaries (typically APPLMGR) and sourcing the environment variable file.

    Are you able to view the output from other concurrent programs without any errors ?

    HTH
    Srini
  • 13. Re: EBS 12.1 integrate with XML Publisher
    Hussein Sawwan-Oracle Employee ACE
    Currently Being Moderated
    Yes, this is generic error.
    where is Apache log??
    if you mean error_log and access_log so i can't find any clue or error of this error.
    but about application log: $APPL_TOP/admin/CONTEXT_NAME/log is application log?
    in this address there isn't any relative log file that changes with this error.
    the latest log file that changes are adadmin.log & and adpatch and adwork logs

    can you help me alittle more??
    Please see (Oracle Application Server Diagnostic Tools and Log Files in Applications Release 12 [ID 454178.1]).

    Thanks,
    Hussein
  • 14. Re: EBS 12.1 integrate with XML Publisher
    Hussein Sawwan-Oracle Employee ACE
    Currently Being Moderated
    but if I want to use Requests Form in ebs to see concurrent program status and output and log, when I click on View Output, it can't download or open pdf file and only open on my browser a new page or popup page and show me Authentication failed. message.
    i know this is generic message, but i want to know where can i fount log or ... for solving this error.
    Please see the doc in my previous reply for the logs you need to check (file names and location).
    I'm sorry
    it's my fault, Preview Button means View Output Button on requests Form in EBS.
    It is not your fault and I got it from your first reply :)

    Thanks,
    Hussein
1 2 Previous Next

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points