Join the OracleApps88 Telegram group @OracleApps88to get more information on Oracle EBS R12/Oracle Fusion applications.

If you are facing any issues while copying the Code/Script or any issues with Posts, Please send a mail to OracleApp88@Yahoo.com or message me at @apps88 or +91 905 957 4321 in telegram.

Tuesday, September 23, 2014

XMLP Tags

IMAGE RETRIEVE FROM DATABASE
PLACE THE FORM FIELD AND RIGHT THE CODE THERE
<fo:instream-foreign-object content type="image/gif">
<xsl:value-of select="IMAGE"/>
</fo:instream-foreign-object>

SET PASSWORD THAT OUTPUT IS NOT SEEN IN PDF FROMAT
1) Open the .rtf
2) Go to File - > Properties
     Create a new custom property
a)  Name   : xdo-pdf-open-password
     Type     : text
     Value    : Either Hard Code the vale / or get the value for xml data
 b) Name :  xdo-pdf-security
     Type   :  text
     Value  : true

Concatenation tag:
<?xdofx:rpad(FIRST_NAME||LAST_NAME),30,'x')?>
<?value-of:concat(Payee/Address/City,’, ‘,Payee/Address/State)?>

If tag:
<?IF:COMM=’’?>SRY<?END IF?><?IF:COMM!=’’?><?COMM?><?END IF?>
image
Else if:
<?xdofx:if COMM!='' then SAL+COMM else SAL end if?>

DECODE TAG:
<?xdofx:decode(COMM,’’,’sry’,COMM)?>
<?xdofx:decode(COMM,’’,ENAME,COMM||’, ’||ENAME)?>

CHR:
<?xdofx:chr(65)?>
<?xdofx: to_char(sysdate,'dd-mm-yyyy')?>

ROUND:
<?xdofx: round(9.6)?>

SORT:
<?for-each:G_EMPNO?><?sort:ENAME;’ascending’;data-type=’char’?>
<?ENAME?>                                     
<?end for-each?>

SUM:
SUM:<?2+3?>
<?xdoxslt:sum(SAL)+xdoxslt:sum(COMM)?>
<?sum(current-group()//SAL)?>  //when ever we use double group it shows total sal for current group.

PAGE BREAK
<?split-by-page-break:?>
(OR)
<?for-each-group@section:G_EMPNO;DEPTNO?>//AUTOMATICALLY IT SPLIT DEPT WISE


PAGE LAYOUT: IT DISPLAYS INFORMATION LIKE NOTE,TERMS ETC IN THE ODD OR EVEN PAGE. IN HEADERS AND FOOTERS REGION WE CAN DISPLAY GO TO FILE AND SELECT PAGE SETUP AND SELECT LAYOUT TAB THERE CHECK THE OPTIONS.
<?section:force-page-count;'end-on-odd-layout'?>
<?section:force-page-count;'end-on-even-layout'?>

VARIABLE DECLARATION:
<?xdoxslt:set_variable($_XDOCTX,’A’,20)?>        
<?xdoxslt:get_variable($_XDOCTX,’A’)?>
<?xdoxslt:get_variable($_XDOCTX,’A’)+1?>

TO_CHECK_NUMBER:
<?xdofx:to_check_number(12345.67,1)?>
<?xdofx:to_check_number(123,0)?>
<?xdofx:to_check_number(12345.67,’EUR’,’CASE_LOWER’,’DECIMAL_STYLE_WORDS’)?>
<?xdofx:to_check_number(12345.67,’JPY’,’CASE_UPPER’,’DECIMAL_STYLE_WORDS’)?>

ADD & SHOW PAGE TOTAL:
<?add-page-total:t;’SAL’?>
<?show-page-total:t?>

TEMPLATE HEADERS:
<?template:header?>
EMPLOYEE DETAILS
<?end template?>             //WRITE THESE IN HEADER FORM AND CALL IN THE WORKING
<?call-template:header?>  //WRITE THESE WHERE U NEED


CHOOSE
image
Ex: <?choose:?>
<?when: DEPTNO=1610?>
Abc
<?end when?>
<?when: DEPTNO=210?>
Kas
<?end when?>
<?otherwise:?>
Def
<?end otherwise?>
<?end choose?>

ARRAYS:
<?xdoxslt:set_array($_XDOCTX, ‘RAVI’, 2, ‘KANTH’)?>
<?xdoxslt:set_array($_XDOCTX,’RAVI’,1,’NERELLA’)?>
<?xdoxslt:get_array($_XDOCTX, ‘RAVI’, 1)?>
<?xdoxslt:get_array($_XDOCTX,’RAVI’,2)?>

INSERT IMAGES:
INSERT ANY IMAGE AS U WISH AND RIGHT CLICK ON IT SELECT FORMAT PICTURE IN THAT SELECT WEB TAB AND ENTER

HYPERLINKS:
Hi: it is hyperlink right click on hi and select hyperlink in that select browed pages enter web site at run time we can open it.

1 comment:

Anonymous said...

Excellent post. I will be going through a few of these issues
as well..

Post a Comment

If you are facing any issues while copying the Code/Script or any issues with Posts, Please send a mail to OracleApp88@Yahoo.com or message me at @apps88 or +91 905 957 4321 in telegram.
Best Blogger TipsGet Flower Effect