You can use TO_CHAR option as well: sql TO_CHAR("Table"."Number Column")

Please try the below: Edit the analysis Click on Advanced Tab In the Prefix input box, add the following and click Apply and Save the analysis: SET VARIABLE DISABLE_CACHE_HIT=1,DISABLE_PLAN_CACHE_HIT=1;

Please try the below and see if this helps: Fusion Applications OTBI: How To Configure And Use Audit For Usage and Performance In OTBI For Fusion SaaS Cloud Customers (Doc ID 2731495.1)

OTBI does allow selective null value inclusion rather than applying a global setting across all columns. You can enable null values for just one column using View Properties in the Results tab. Go to the Results Tab Modify View Properties (Click on the table or pivot view where you want to display null values. Select View…

Ensure TEMPLATE_FORMAT is Set Correctly TEMPLATE_FORMAT = 'HTML' instead of 'eText' that prevents attachments from being included. 2. Modify the Delivery Channel Instead of 'EMAIL', try using 'NONE' or another delivery method that doesn’t generate attachments.

The limit of 15 MB is set at the SMTP server configuration across all the Fusion Application Fleet and cannot be changed. Please review the below KM note: Oracle Fusion BI Publisher: Report outputs larger than 15 MB do not get delivered via Email (Doc ID 2114473.1) You can try UCM (Universal Content Manager) for Report…

Try Below query: SELECT NEXT_DAY(TRUNC(SYSDATE, 'MM') - 1, 'SUNDAY') AS First_Sunday, NEXT_DAY(TRUNC(SYSDATE, 'MM') - 1, 'SUNDAY') + 7 AS Next_Sunday FROM dual; OR SELECT NEXT_DAY(TRUNC(SYSDATE, 'MM') - 1, 'SUNDAY') AS First_Sunday FROM dual;

Please provide more details about the issue. Any specific time it gets error out, Is the issue with any specific user. Please check the below possible cause and try below options: Data Model Issues If the table relies on a complex query, check whether the dataset is returning inconsistent results. Try running the query…

Character Limits for Bursting Email Parameters Email Subject (parameter4): Typically supports up to 256 characters. Email Body (parameter5): Can handle up to 4,000 characters, but this may depend on the database's handling of CLOB data types. https://docs.oracle.com/cd/E21764_01/bi.1111/e18862/T527073T555155.htm

Check PDF Compatibility Settings Some scheduled reports generate PDFs in a format that Adobe Acrobat may not fully support. Try opening the PDF in Adobe Acrobat Reader and go to File > Properties to check the PDF version. If it's an older or unsupported format, try converting it to a newer version using Adobe Acrobat Pro.…

Try the below: Remove Explicit Aliases from SQL Formula Since OTBI applies its own aliases, avoid using "Worker"."Person Number" AS "Person_Number"—instead, just use: sql "Worker"."Person Number" Then, rely on post-processing in your application to rename the columns. 2. Use BI Publisher Data Model Instead a) If you need…

Ensure Aggregation Is Set to MAX In the Column Properties, confirm that the aggregation is set to MAX for both Manager and Employee Comments. If OTBI isn't grouping them correctly, try SUM instead. 2. Verify Grouping Fields in OTBI In the Results tab, ensure that Employee ID or Document ID is included to force grouping of…

I just expanded on your approach a bit by providing additional details and formatting for clarity. Your method—either using a Pivot Table or CASE statements—is the right way to go for structuring Manager and Employee comments in a single row. Try the below steps: Navigate to Your Analysis in OTBI Open Oracle OTBI and go to…

Pivot Table Method:If OTBI allows pivoting, you can structure the data using comments as a measure and set aggregation to MAX: a)Drag the Comments field to the Measures section b)Set aggregation to MAX c)Use the Role Definition field as the pivot column d)Ensure each participant's role is properly mapped This will allow…

Steps to Set Column Aliases: Navigate to the Criteria Tab Open your OTBI Analysis and go to the Criteria section. Modify the Column Formula Click on the fx (Formula) button for the column you want to rename. Use the AS keyword to define an alias. Example: sql "Person"."Person Number" AS "Person_Number" Save and Run the…

You can try the below options: Reduce Ring Thickness Modify the graphType attribute to RING_SINGLE instead of RING_MULTI to control thickness. Adjust the series size using the PieSliceDepth attribute. 2. Increase Font Size for Center Value (100) Modify the <GraphFont> size inside the <Title> tag. Example: xml <Title…

You can try the below options: Use <?split-by-page-break:?> Tag Ensure that you're using the <?split-by-page-break:?> tag correctly in your RTF template. https://community.oracle.com/mosc/discussion/3502364/not-working-in-rtf-for-page-break 2. Adjust Table Properties If your data is inside a table, try modifying the table…

Possible Workarounds you can try: Use Separate Repeating Groups Instead of nesting, try structuring your data so that each repeatable block is independent. You may need to flatten the data structure before passing it into the template. 2. Use RTF Templates Instead If nesting is essential, consider switching to RTF…

Few approaches you can explore from OTBI perspective: Check Available Subject Areas – Ensure that you're using a subject area that includes resource-level data. Some reports rely on Project Costing or Grants Management subject areas for resource tracking. Join Resource Tables – If your current report is task-based, you may…

Please try the below: 1.Using BI Publisher Catalog Reports Oracle BI Publisher allows you to manage and report on catalog objects, including folders, reports, data models, and templates. You can navigate to the BI Publisher Catalog and export details about the objects stored within it. Custom SQL Query in Oracle Analytics…