nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle AI and Analytics

Child Item

Oracle BI Reports,in report output the dates are not coming as per the format set in user preference

User_VO7FP

We are working on Oracle BI Reports, in report output the dates are not coming as per the format set in user preferences,

Find more posts tagged with

BI Publisher

BI Publisher Report Templates

Accepted answers

MandeepGupta

https://community.oracle.com/products/oracleanalytics/discussion/comment/61861#Comment_61861

That's right.

Thanks.

All comments

MandeepGupta

https://community.oracle.com/products/oracleanalytics/discussion/24086/oracle-bi-reports-in-report-output-the-dates-are-not-coming-as-per-the-format-set-in-user-preference

The dates by default are shown in date timestamp format as stored in DB. If you need any particular format, you need to define that in your BI data model query.

Thanks.

SayanDutta

we also have same requirement,

MandeepGupta

Please check sample given on below support note to convert it as per User preferences:

How To Set Date As Per User Preference Time zone in Fusion Applications BI Publisher Report (Doc ID 2864734.1)

Thanks.

User_VO7FP

@MandeepGupta so if a user changes his/her preferences say (mm-dd-yy —> dd-mm-yy) then it will not reflect automatically in BI reports ?
I have to think of a generic date format for all reports we have for this client?

MandeepGupta

https://community.oracle.com/products/oracleanalytics/discussion/comment/61861#Comment_61861

That's right.

Thanks.

User_VO7FP

@MandeepGupta thanks for your quick reply

Top Leaders

Mallikarjuna Kuppauru-Oracle 35

Top Questions

Keeping track of the last scheduled run for a BIP Scheduled Report
Hi, We are scheduling a report to be sent out every week. We were wondering if it was possible to keep the latest date that the report ran as a parameter somewhere so that we could use that to only fetch the values in the report which have a latest update time of after the last run of the report? This way we'd only be…
Scheduled report in BI Publisher 12c returns garbled excel output
Hi everyone, I'm using Oracle BI Publisher version 12c and recently I notice a strange error: when I schedule some reports that use excel templates (.xls), their output can not be opened without the error message "The file format and extension of <report_name> don't match. The file could be corrupted or unsafe. Unless you…
OIC SOAP Connection — OAuth Authentication Fails Intermittently
Hi everyone, We configured a SOAP connection in Oracle Integration Cloud (OIC) using OAuth authentication. However, when we run our integrations, the SOAP invocation fails intermittently. Some integration iterations fail. Most iterations succeed. Sometimes, all iterations complete successfully without any issues. When we…
OTM/GTM - what is the size limitation for oracle BI Publisher rtf template?
OTM/GTM Product is currently using OAC for reporting. We wanted to know what is the limitation for oracle BI Publisher rtf template size. We already have verified the documentation : https://docs.oracle.com/en/cloud/paas/analytics-cloud/acpmr/top-faqs-design-publisher-reports.html But wanted to know if this generic figures…
BIP Report for Assignment Transactional History Detail Report
Hi, We are trying to retrieve the complete history Bip report of assignment updates where the same assignment record has been modified multiple times with an unchanged Effective Start Date. We are currently using PER_ALL_ASSIGNMENTS_M and PER_ALL_ASSIGNMENTS_M_; however, the data returned does not consistently reflect all…