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
Dear All, I have enhanced 2LIS_11_VASCL datasource, to pull value from condition record, called Surchage. I have set reversal indicator for this field in my datasource. I have written code in CMOD to get this value from KONV table of that sales order [More]
Can anyone tell me? I have an old (about 6 year old) Mac. I made the mistake of upgrading it to leopard. Then realized I need it to be able to run some old 0s 9 software. Can I reinstall the Panther CD without formating the disk?There is always a ris [More]
Does anybody knows if this update solves the printproblem in photoshop 9.0.1 ibook   Mac OS X (10.4.6)  You should re-read the article, since it was updated on the 28th: "Apple have just released Mac OSX 10.4.7 update, which includes a fix for the pr [More]
Hi, Our Production server is in High Availability on Unix ( DB node active & CI Node active). When I am executing the initialize tape or triggering the backup from DB13 in our production we are getting the below error. SXPG_COMMAND_EXECUTE failed for [More]
At my office computer we have an iTunes account that is to be used at our office as well as a couple places around the world. We have entered in all of our credit card and billing information and yet, after we sign out and sign back in, when we try t [More]
I just figured out how to view slideshows on the TV, however, after syncing the ipod, the photos are not in the same order as they were in the folder. (really annoying) Is there a trick to the sync or folder set up?I also tried to number (rename) all [More]
Im trying to make a movie that is that size can i do it with imovie?Not in iMovie. iMovie will do 16:9 and 4:3. The tool that will do what you need is QuickTime Pro Version 7, available for about $30 from Apple. You first need QuickTime Player Versio [More]
I have an early 2011 Macbook pro, and i have been advised to re install OS Lion but i do not know exactly how to re install Lion, i have been advised to hold down "alt" while booting up to get into the restore ??? is this true?  Any advice on ho [More]
I have had my Zen Touch since October and I have never had a problem with it, but suddenly yesterday I stopped for no obvious reason, it just froze. I have since tried to reset it a number of times, and everytime it goes into something called "recove [More]
Dear Friends, I have copied the standard MEDRUCK program to ZMEDRUCK and has changed its driver program accordingly to Z program. Now when I print the PO, it is displaying the FREIGHT break-up alongwith the total FREIGHT. I want to display only the t [More]