Oracle Blogs

RTF function for QR code in report  ( works only with Oracle Fusion ) syntax : <?qrcode: fieldname; size; UTF-8?> Example : <?qrcode: PHOTOB64; 100; UTF-8?> ---------------------------------------------------------------------------------------------------------------------- For document for QR code in EBS click following link http://rehmansql.blogspot.com/2024/06/qr-code-generate-from-oracle-plsql.html

Use This XDOFX function in Loyout template to solve the Issue <?xdofx:replace(replace(field_name, CHR(13), ' '), CHR(10), ' ')?> example : <?xdofx:replace(replace(po_description , CHR(13), ' '), CHR(10), ' ')?>

Below is a XSL example used to style or format a xml. <?xml version="1.0" encoding="UTF-8"?> <xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="1.0">      <xsl:output method="xml" indent="yes"/>   <!--select="DATA_DS/INVOICE_NO" <== these are invoice field paths change them accordingly -->      <xsl:template match="/">     <Invoice>       <InvoiceNumber><xsl:value-of select="DATA_DS/INVOICE_NO"/></InvoiceNumber>              <InvoiceDetails>         <xsl:for-each select="DATA_DS/G_1">           <Detail>             <ProfileID><xsl:value-of select="PROFILEID"/></ProfileID>             <UBLVersionID><xsl:value-of select="UBLVERSIONID"/></UBLVersionID>   ...

Q1 for ar customer transaction lines  SELECT  distinct hca.account_number client_number, hp.party_name client_name, rctt.name TRX_TYPE1, rct.trx_number trx_number, rct.PURCHASE_ORDER, TO_CHAR(rct.creation_date,'DD-MON-YY') TRX_DATE, TO_CHAR(rctg.gl_date,'DD-MON-YY') GL_DATE, apsa.TAX_REMAINING VAT_AMOUNT, ROUND(NVL(XAL.ACCOUNTED_DR,0),2) DEBIT, ROUND(NVL(ACCOUNTED_CR,0),2)   CREDIT , ROUND((NVL(XAL.ACCOUNTED_DR,0)),2) - ROUND((NVL(ACCOUNTED_CR,0)),2) balance, xal.CURRENCY_CODE CURRENCY, rtt.name payment_term, TO_CHAR(apsa.due_date,'DD-MON-YY') DUE_DATE, xal.description DESCRIPTION FROM  XLA.XLA_AE_LINES  XAL, XLA.XLA_AE_HEADERS XAH, XLA.XLA_TRANSACTION_ENTITIES XTE, ra_customer_trx_all rct, ra_customer_trx_lines_all rcl, RA_CUST_TRX_LINE_GL_DIST_ALL rctg, ra_cust_trx_types_all rctt, ra_terms_tl rtt, ar_payment_schedules_all apsa, hz_cust_accounts hca, hz_parties hp WHERE 1=1 and rct.customer_trx_id = rcl.customer_trx_id and rct.CUST_TRX_TYPE_ID = rctt.CUST_...

  query to get DD&DT Tables in r12  ------------------------------- select * from XDO_TEMPLATES_B where template_code = 'SITCO_PORD_RPT_V'; select * from XDO_TEMPLATES_TL where template_code = 'SITCO_PORD_RPT_V'; select * from XDO_LOBS where lob_code = 'SITCO_PORD_RPT_V'; select * from XDO_DS_DEFINITIONS_B where data_source_code = 'SITCO_PORD_RPT_V'; select * from XDO_DS_DEFINITIONS_TL where data_source_code = 'SITCO_PORD_RPT_V'; -------------------------------------------------------------------------------- script to delete DD&DT ---------------------- BEGIN DELETE FROM XDO_TEMPLATES_B WHERE template_code = 'SITCO_PORD_RPT'; DELETE FROM XDO_TEMPLATES_TL WHERE template_code = 'SITCO_PORD_RPT'; DELETE FROM XDO_LOBS WHERE lob_code = 'SITCO_PORD_RPT'; DELETE FROM XDO_DS_DEFINITIONS_B WHERE data_source_code = 'SITCO_PORD_RPT'; DELETE FROM XDO_DS_DEFINITIONS_TL WHERE data_source_code = 'SITCO_PORD_RPT';...

Rdf Report Creation Process in oracle apps Report Builder is one of the Oracle GUI Tool   Graphical user Interface There are two ways we can develop the report ü  Wizard base ü  Manual While developing Report we have two stages. ü  Data Model ü  Layout model Data Model will be used to select the data from Database, SELECT Statemen and Formulas,Summary functions and so on……. Layout model will used to displays the datamodel fields in the desired format. Layout Model Objects: 1)Text : Will be used to display the standard text information          like titles,prompts,headings,Address…………… 2)Frame : Will be used to display the layout objects only one time            like totals,titles,Headings and so on 3)Repeating Frame: Will be used to display the objects multiple times            like databa...

  How to create a simple XML Publisher Report 1. Navigate to System Administrator->Concurrent->Program->Define and create a new concurrent program as below with Executable as “ XDODTEXE ” and output as “ XML “. Then click on parameters button and enter the parameter as below 2. Navigate to System Administrator->Security->Responsibility->Request,query request group as “ System Administrator Reports ” & application as “ Application Object Library “(Its the request group attached to System Administrator responsibility).Then add the newly created concurrent program to it. 3. Below is the Data Definition template XML which is created and its explanation. 4. Navigate to XML Publisher Administrator->Home->Data Definitions, click on “Create Data Definition” button and create Data Definition as below.Data Definition Code should be same as the Concurrent Program Short name which we created.Then click on Apply button. Attach the Dat...