Its always better to filter out the data in the Data Model , it can be done in the tempalte as well, but suggestion is to not bring in unwanted data

for BI Publisher the date from the XML data source must be in canonical format. This format is:YYYY-MM-DDThh:mm:ss+HH:MM Below are couple good blog posts from Product Team https://blogs.oracle.com/xmlpublisher/date-functions https://blogs.oracle.com/xmlpublisher/how-to-keep-your-dates-from-going-wild Mark completed /…

https://docs.oracle.com/cd/E28280_01/bi.1111/e22258/create_data_sets.htm#BIPDM149

please upload the template and sample xml

Hello you can use a IF or CHOOSE to get that ... some like below <?xdofx:if GENDER =1 then 'MALE' else 'FEMALE' end if?>

yes .. below snippet from the user guide <?xdofx:if AMOUNT > 1000 then 'Higher' else if AMOUNT < 1000 then 'Lower' else 'Equal' end if?> Pl Mark Complete / Helpful

can you try below samples SELECT FROM_TZ(CAST(TO_DATE('1999-12-01 11:00:00', 'YYYY-MM-DD HH:MI:SS') AS TIMESTAMP), 'America/New_York') AT TIME ZONE 'America/Los_Angeles' "West Coast Time"FROM DUAL<span class="pun"><br/></span><code><span class="kwd">* SELECT</span><span class="pln"> resolved_time AT TIME ZONE </span><span…

Hello .. Pl check the table properties and make sure the Repeat as header row at the top of each page is checked.. Also going forward please use one thread per issue. so it would help other people as well when they are searching for solutions..

HI, I'm not sure if you can do it in Fusion. ..but alternatively you can put the image directely on the RTF (given if it's only a few) .. there is an article if the image is store in the DB Fusion Applications - OTBI - BI Publisher - How To Display The Employee Image Stored In The Database OR XML Pulled into The Report ?…

Christian, The purpose of the Drafts is it serves as a TEMP directory to store unsaved information .. .on further digging the same was mentioned in note "Fusion BI - Catalog Files in /My Folders/Temp and /My Folders/Cache Get Purged After 25 Hours (Doc ID 2372726.1)" "/My Folder/Temp or /My Folder/Drafts are used…

Please see below links for more info ServiceNow Reporting in OBIEE with the ServiceNow JDBC Driver https://www.cdata.com/kb/tech/servicenow-jdbc-obiee.rst Web Services https://docs.oracle.com/cd/E28280_01/bi.1111/e22259/webservices.htm#BIPDV002 Blog https://www.rittmanmead.com/blog/2011/11/web-services-in-bi-publisher-11g/

OK can you provide the error message / error code ??

Tam, Are you trying to group by just the ACCOUNT ? As your template indicates the same .. so you will get one record of the Account And there are multiple records for Company ex:1432 has all the records on the output.. its not clear what your requirement / issue is.. can you clarify .. or send the mock up of what you are…

Tam, I would suggest to post it in EBS group ... see below link if it may help https://erp-integrations.com/2017/01/23/query-to-check-gl-balances-with-je-lines-balances-compare-period_balance-with-li… --YG

Check the following How Do You Customize The Purchase Order PDF Report Name Within Fusion Applications snippet from the discussion " At the moment creating a report output file with a dynamic name such as this isn't possible when generated in this way from BIP. The only functionality which comes close to what you need at…

if you click OK what is happening ??

I assume the administrator should have an option to set this up .. check the documentation https://docs.oracle.com/en/cloud/saas/procurement/r13-update17d/oaprc/manage-purchase-orders.html#OAPRC227244

you can try with coma separated "," or semi-colon ";" separated .. you may have to try this out on your query first and then implement the same on BI Publisher (in the default value box )

There is an option where you can enter default values for parameters , there you can list what the default values can be.. but with this option you may loose the option of selecting 'ALL' Hope this helps --YG

when developing the layout either in Interactive Mode or RTF Template use Group Above first by Country and then by Department Interactive Mode: RTF Template Below is how your template will look like .. Hope this helps