Posts

Showing posts with the label xml publisher

How to get xml file out from Concurrent PGM

People normally remove the attached template and change the output format of Concurrent Pgm back to XML , then run the Pgm and get the XML out. But it is not required. How to get the XML from a BIP based concurrent request/report: a. View->Requests b. Click on Diagnostics button c. View XML If you are interested in the physical file in Server. Actually XML file is stored in UNIX box @ $APPLCSF/$APPLOUT/o{REQUEST_ID}.out What about the output file format naming convention. Naming convention of the output would be as follows and it resides in the following path The output is $APPLCSF/$APPLOUT/{REPORT_NAME}_{REQUEST_ID}_{COUNT}.[PDF|RTF|EXCEL|HTML] Unfortunately, there is no option , right now atleast in BIP CC Pgm integration to customize the output names, reason , to trace back , they need to follow some standard this way. Tables involved in the CC integration & output ==> FND_CONC_REQ_OUTPUTS In future there might something , which facilitate to change this. Suggestion ,how i...

Limit rows per page

Image
Solution to have fixed number of rows in each page. This solution is not a perfect solution considering the line size increases due to text in each line. But this solution gives you how to fix no of rows per page. In the forum Heated discussion Users are arguing for having a placeholder in same fixed place on all pages, irrespective of no of lines , increased line size due to word-wrap. Here i am not going to discuss anything related to that. But a simple logic of , how to fix number of rows. Step 1: Loop through the records and display them Step 2: Have a condition for MOD of position(), then insert a page-break on the result of Zero Step 3. Blank row has to be filled, a condition has to be added, to find how many blank rows ROWLIMIT - (count of row mod ROWLIMIT) will gives us the rows to be filled. Step 4: use foreach_number function to simulate the iteration. Refer the images below

Loopin in ?

ha ha h ah ahha hah Tim has taken my entry from forum thead and updated in his blog for an entry. Thanks to Tim for this. As i mentioned in the forum thread, there are many ways to do this. the another way is :). You can do this in this way too. create a table with two rows and two column, in the first row give the heading for the each column as TEXT and ID In the second row, first column, type this ""?for-each:LINE_ATTACHMENTS/TEXT? ?.?"" in the second row, second column, type this ""?following-sibling::.[1]? ?end for-each?"" Longtime back I had a colleague named "James" who had a similar requirement, i helped him little bit. But i did not follow-up with him, hope he got the solution what he wanted.