Results 1 to 7 of 7

Thread: Not able view RD output from submitted job details

  1. #1
    New Member
    Join Date
    Jul 2011
    Posts
    16

    Not able view RD output from submitted job details

    Hi ,

    We are not able to view the output generated by one of the JD Edwards Bi Publisher reports. This report runs on scheduler daily once.

    XML is generated and the data in it looks good. But when i click to view the output it is taking me to the screen "Report Definition Output Repository" as shown in the attached document.

    This issue is happening with two BI Publisher reports only ( these two reports are reading data from the table F47047). Other BI Publisher reports are working fine.

    This issue is happening only for the last couple of days..before that it working fine.

    I tried to republish the RD. Some times it worked and some times it didn't work ( It is throwing an error as shown in the attached doc)

    Appreciate your help in resolving this issue.

    Thanks,
    Attached Files Attached Files

  2. #2
    The best way to find out if there is a problem is :

    1. Download the template and save it off
    2. Save the XML as well
    3. Open the saved template and try to preview using the saved xml via the word plug in.
    --- if it does not show up on the preview ; then the template is not correct ; You will need to upload the correct template
    --- if it shows up correctly on the preview ; then you may want to research further with the log turned on.
    Thanks,
    Sheeba.

    - E1 9.0 ,TR 8.98.4.2 , SQL 2008 R2 , IE 11
    - have worked on B7322, XE Release B7333, B7334 (as400/sql 2005 Win 2003); E1 8.12(Oracle 10g OAS 10.0.1.2)

  3. #3
    New Member
    Join Date
    Jul 2011
    Posts
    16
    HI Sheeba,

    Thanks for your reply.

    It works well in the lower environments.

    Also i tried the steps that you suggested and it shows up correctly on the preview.

    Thanks,
    Satya.

  4. #4
    Dear Sheeba,

    We are experiencing the same problem but for all the submitted jobs.
    I have managed to save the XML but don't know how to go about downloading the template in point #1 above. Also if i need to turn on the logs, how will i go about it?

    I appreciate your help.

  5. #5
    Oracle document 651589.1 details how to obtain debug logs - https://support.oracle.com/epmos/fac...ay?id=651589.1

  6. #6
    New Member Arjun Damodar's Avatar
    Join Date
    May 2010
    Location
    Toronto, Canada
    Posts
    39
    Make sure the RD is available in the production environment and is not version specific to a different version.
    Arjun Damodar

  7. #7
    As others have suggested , try downloading the XML source from the job output using row exit -> View source and get the xml . For TR template , P95600 , you can download and upload templates from there . The using BI publisher desktop plugins in word , load xml schema and view pdf , I understand it comes correct , right ?

    Have you tested this on any other server like say DVB or PYB or any non prod server , does it work all the time when a user fires it and produces output when there is data ?

    In production , have you tried to run manually yourself using your user id and see what it does for same data selection and same version same setting , does it produce or fail too ?

    If it works on non prod server but not on prod server , then try repromotion , include all objects like TR , RD , report , versions tables views DSTR etc and promote again and build and deploy , check with deploy logs and see if all is fine . If still an issue , try uploading TR manually in production using P95600 and check .

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
The legal restrictions and terms of use applicable to this site are available here.
Use of this site signifies your agreement to the terms of use.
JDELIST is NOT affiliated with JD Edwards® & Company, Oracle or Peoplesoft. Contents of this site are neither endorsed nor approved by JD Edwards® & Company and, or Oracle.