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, I have a WD Cloud Server on which I have placed all my music. I have turned on HomeSharing, but I do not seem to be able to access music that is not in my iCloud. Also, I cannot change or create any new playlists. Any ideas? ThanksI thought that [More]
Error code msvcr80 after last update now itunes will not open.  Reinstalled and still does not workClick here and follow the instructions. If they don't work, perform a complete reinstallation (Windows XP, Windows Vista and newer). (98968)Read other [More]
HI, Can anyone explain why when posting an Invoice with unplanned delivery costs using T-code MIRO, the purchase order info. does not show in the GL line item display T-code FS10N for any of the unplanned delivery cost line items. If anyone have a so [More]
I would like to ignore the first row in each file in the sender channel - how can i do it?Hi Check this, As he said give Document Offset = 1 http://help.sap.com/saphelp_nw04/helpdata/en/2c/181077dd7d6b4ea6a8029b20bf7e55/content.htm Also check this fo [More]
I have tried loading CPOStudios.com in Safari, Firefox, and Camino on my G5 and my iMac (sam house, same conenction.) On other households it loads in my area (same service provider). Out of state and out of country it loads. It stopped loading RANDOM [More]
hi can any body tell me how to handle amount field in bdc AMOUNT CONVERSION 1. FIELD NAME :-WRBTR 2. IN FLAT FILE DATA IS :- 9.5 HOW TO CONVERT IT. waiting for responce Edited by: tapan rath on Dec 21, 2007 8:03 AMthanks for your reply actually when [More]
I am having one problem related to express server database created using relational access administrator. I am using express objects to create some adhoc analysis reports. For that i have created express database using Relational Access Administrator [More]
Some older forum entries imply that it is possible to package your own seed data but I haven't found any documentation on this. Is it possible? Where can I find more info? What I'm looking to do is have my product installer run a silent install of XE [More]
Unfortunately when my new 5S was set up by the folks at the provider, they accidentally set it up as a new phone so none of my information that was stored in the cloud came over.  I have one by one added all my apps but for the life of me can't figur [More]
Hi experts, In normal Shipment we have SD_SHIPMENTS_SAVE. I would like to ask for your advice that is there any function module similar to SD_SHIPMENTS_SAVE but can process saving from external application for TD Shipments ? Kindly advise.Hi,     Che [More]