Sitemap

Amicuk Programming Answers

Reg: Problem  in XML PUBLISHER Report

2015-10-11   Views:0

Advertisement

Hi all, I am working building report using xml publisher. Problem i facing was , *1. I created the template in RTF and attached to data definition* for eg: my rtf is sno item quantity price ( I created this field in table structure and mapped to xml

Hi all,
I am working building report using xml publisher. Problem i facing was ,
*1. I created the template in RTF and attached to data definition*
for eg: my rtf is
sno item quantity price ( I created this field in table structure and mapped to xml data)
Total Price ( this also i am getting from data definition)
The below is sample constant sentence for my client and typed just below Total Price ( field i mentioned above)
Inspected  By                                          Approved By     
*1)*
________________________________     1)________________________________     Store Incharge : ______________________
*2)*
________________________________       2)  ________________________________     Received           : _______________________
*3)*
________________________________     3   ________________________________     Prepared  By    :             _______________________
NOTE : ABOVE MENTIONED LINES ARE CONSTANT ONE.
2. When i ran the report, if my data definition return 5 lines means , i am getting PDF output Correctly in single page (1st page)
3) If my data definition returns lines more than 8 lines means, I am getting PDF output with Table structure values with item, in 1 st page and Constant sentence in 2nd page of PDF
4) If my data definition returns lines between 5 and 8 means, I am getting PDf output with table structure values with item and some of Constant sentence of my client in 1 st page and few of the constanst sentence in 2nd page.
Actually my need
Even if the data definitions exceeds more than 5 lines the constant sentence should be placed either in the first page or in the next page based on the no. of lines in the data definition.
How to resolve this... any approach most welcome. Wat changes i have to make.

The replay answer
Advertisement
Krishna
Modified your code a little bit.Use this
    public int submitCPRequest(String shipmentId) {
    System.out.println("into submitCPRequest");
        OAPageContext pageContext;
        OAWebBean webBean;
    try {
OAApplicationModule am =pageContext.getApplicationModule(webBean);
    OADBTransaction tx = (OADBTransaction)am.getOADBTransaction();
    java.sql.Connection pConncection = tx.getJdbcConnection();
    ConcurrentRequest cr = new ConcurrentRequest(pConncection);
    String applnName = new String("XXAPL"); //Application that contains the concurrent program
    System.out.println("ApplName"+ applnName);
    String cpName = new String("XXAPLPOSMPRD"); //Concurrent program name
    System.out.println("Concc Name"+ cpName);
    String cpDesc = new String(" APL PO Shipping Material Pickup Request"); // concurrent Program description
    // Pass the Arguments using vector
    // Here i have added my parameter headerId to the vector and passed the
    //vector to the concurrent program
    Vector cpArgs = new Vector();
    cpArgs.addElement(shipmentId);
    System.out.println("Args"+ cpArgs);
    // Calling the Concurrent Program
    int requestId = cr.submitRequest(applnName, cpName,cpDesc, null, false, cpArgs);
    cr.addLayout("XXAPL", "XXAPLPOSMPRT", "ENG", "US" , "RTF");
    System.out.println("Req Id"+ requestId);
    tx.commit();
    return requestId;
        catch (RequestSubmissionException e) {
        System.out.println("Into Exception");
        OAException oe = new OAException(e.getMessage());
        oe.setApplicationModule(this);
        throw oe;
        catch(Exception exception)
        throw OAException.wrapperException(exception);
    }Thanks
AJ

Go to See the other 15 answers

Reg: Problem  in XML PUBLISHER Report

Category:DefaultRelease time:2015-10-11Views:130

Hi all, I am working building report using xml publisher. Problem i facing was , *1. I created the template in RTF and attached to data definition* for eg: my rtf is sno item quantity price ( I created this field in table structure and mapped to xml[More]

Sorting Problem in XML Publisher Report

Category:DefaultRelease time:2015-10-11Views:130

Dear Members, I am facing problems with sorting data in my XML Publisher Report. We are using Oracle E-Business Suite 12.1 Version and i developed a rtf Template and executable is an RDF which generates XML Data. I want the whole report to group by e[More]

Excel Output problem with XML Publisher Report

Category:DefaultRelease time:2015-10-11Views:130

Hi Experts, I am working on XML Publisher report with EBS 11i and database 9i. My XML Report output type is EXCEL, i have below issue with the output. I have column 'quantity' with xml tag <?QUANTITY?>. In the XML file it's showing the value '028' f[More]

Problem in XML Publisher Report submission from OAF Pages

Category:DefaultRelease time:2015-10-11Views:130

Hi, I am trying to submit Concurrent Program from OAF Page which is an XML Publisher Report. The request is Submitting and Completing successfully but when we open to view the out put we are able to view the HTML tags. We checked the same Concurrent[More]

Problem with XML Publisher report when there are no detail records.

Category:DefaultRelease time:2015-10-11Views:130

I am working on an Oracle XML Publisher procurement report (Oracle E-Business Suite R12) that starts with a budget amount that is imported from our financial system, then lists all requisitions and orders that are in process (not approved). The amoun[More]

Dynamic Image Problem in xml publisher report

Category:DefaultRelease time:2015-10-11Views:130

Hey guys, I hope you doing well. I am facing a problem in rtf template for offer letter. I have requirement that applicant signature will be print on Offer letter. For that insert dummy image and change his Alternative text to url:{concat('${OA_MEDIA[More]

Xml publisher report problem

Category:DefaultRelease time:2015-10-11Views:130

I have a xml publisher report which list job names. After submitting concurrent program, I am getting below error A semi colon character was expected. Error processing resource some of the Jobs have special character '&'. below is code CREATE OR REPL[More]

XML PUBLISHER report in Excel out put problem

Category:DefaultRelease time:2015-10-11Views:130

Hi Experts, I have developed one XML report which output type is EXCEL in Oracle Application. I am getting some -ve value in the report so I need to do the trailing sign Menace for example I got a value -8645 I need to display the value like (8645).[More]

Problem with data size in XML Publisher report

Category:DefaultRelease time:2015-10-11Views:130

Hi Experts, I am working on EBS11i and database 9i. I working on XML Publisher reports, i have one XML Publisher report with generating output in EXCEL format. If i submit the report, if the data is huge (like 2.3 million records), it's ending up wit[More]

XML Publisher Report with PL/SQL

Category:DefaultRelease time:2015-10-11Views:130

Hi Like to know how to develop the XML Publisher Report with PL/SQL, i did the following 1. created a pkg like as below CREATE OR REPLACE PACKAGE BODY APPS.TEST_XMLTAG_PKG AS PROCEDURE main (errbuf OUT VARCHAR2, retcode OUT NUMBER ) IS BEGIN DECLARE[More]

Xml publisher report giving warning

Category:DefaultRelease time:2015-10-11Views:130

Hi friends, I have a issue with xml publisher report. All existing xml publisher reports are working fine. Only the problem is newly created one. Application version 11.5.10.2 dDtabase 9i BIdesktop version is 10.1.3.4.1 MS office  2010 i checked the[More]

Hot
Hi Gurus, I have configured Rejection message handler to send the rejected file into a location of an FTP server. The action part of my fault policy looks like this <Actions> <Action id="writeToFile"> <fileAction> <location& [More]
I swear, if gwha had a neck I'd choke it. I'm so frustrated that I can't get this service to function. I'm pretty sure everything's configured correctly, but if I stop an agent it never gets restarted by gwha. Server: OES2, fully patched. GroupWise 7 [More]
... does not work at all. (imac duo, sys 10.4.4)Tom, A rather cryptic request, I assume that you are having trouble with Help, if I am correct, Troubleshooting Help Viewer by Dr. Smoke may be "Helpful." Let us know, especially since you have an [More]
Hi All, I have a requirement to create a custom payroll function that returns some data from IT0006 and IT0032. I have written the code in PCBURZDE0, as the payroll is for Germany, it does read the data needed. My question is, how I can access the va [More]
I flashed my Supermicro X9SAE motherboard to v2.0a (form v1.0), now my system hangs displaying "SunOS Release 5.11 Version 11.1 64-bit Screen. Copyright,,,,," The grub menu appears ok before this, from which I have tried playing around with kmds [More]
Hello All, I have a standard report which displays the data in ALV Grid. This data can also be exported to Excel sheet. I have got an FBI assignment where I have to add some new fields besides the existing ones. Could you please provide me with some [More]
Hi all, There is an existing query in our system and now the requirement is to add and insert few fields to the existing fields of output of that query. Please let me know step by step procedure to achieve this. Thanks in advance-It depends upon the [More]
My poster (imported from file) appears as expected in the window for the movie, when the page is selected; BUT when the movie has stopped, the poster doesn't reappear – the window just stays black until the page is turned and reopened. This happens b [More]
How do I get to the Software Setup screen to insert a serial number to convert from trial version of PSE 11 now I've purchased it?Hi Ceejaywolf21, When you launch the trial version it will automatically prompt to enter the serial number to activate. [More]
Well after a very successful last posting - here goes again .... I'm trying to get the dragged images to appear in the box. But for some reason they're not appearing. As you can tell - I is still a newbie! Thanks <?xml version="1.0" encoding= [More]