BI Publisher
Discussion List
-
How to monitor who and when ran a BI report that was not scheduled?We need to see who and when people run the BI Reports without scheduling.Kristel Janssens 23 views 1 comment 1 point Most recent by Raghavan p-Oracle Reporting and Analytics for ERP -
BIP | SFTP filenames with .XLS or .XLSX extensions are not readable in SFTPSummary: Hi Experts, My requirement is to place the SFTP file in .XLSX format. SFTP filename with .XLS or .XLSX extensions are not readable in SFTP, but filenames with .…Arti_Priya 11 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM -
Load and Import Bank Statement Warning messageSummary: Hi Team, We are loading the bank statement using SOAP Services to run the "Load and Import Bank Statement" process. We are using a BI report to fetch the error …Rajeev Nayan 21 views 3 comments 0 points Most recent by Neha Garg-Oracle Payables, Payments & Cash Management -
Is there a way to manage assets in multiple currencies?Summary: Is there a way to manage assets in multiple currencies? If the reporting currency is USD and the local currency is IDR, assets are registered in USD, but there … -
Can I download bi publisher to mac?Summary: Hi team, I want to switch to mac , I saw that is problem to download BI publisher, someone tried? and there any other problem with mac?Guy_Ora 11 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM -
Rolling Average Wage ReportHi Does anyone have a sql query or a report that provides the average weekly wage over a 52-week period based on a specific date? We are trying to provide our Workers Co… -
What table stores the extended lookup code name for Visas and Permits?Summary: I am trying to build a DM for Visa and Permit notifications. What table stores the extended lookup code name for visas and permits? I would assume there is a ta…Luke.Findex 33 views 5 comments 0 points Most recent by Ketan-Oracle Reporting and Analytics for HCM -
I want more than 2 prompt input lines in OTBI.Summary: I want more than 2 prompt input lines in OTBI. Content (please ensure you mask any confidential information): When a graph is created in OTBI, the value list is…User_53LLL 1 view 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM -
Is there a way to find all data-models that use Bursting?Summary: We are planning a change in Sender Address in our ERP Instance and one of the requirements is to also amend it for all the Bursting reports configured in the sy…Prateek Mohan 11 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM -
Get list of all BI Publisher reports that use a specific data modelSummary: Is there a way in BI Publisher to get a list of all BI reports that are using xyz data model as the DM, in order to understand the impact of making changes to a…Shant_Sarkissian_WJG 685 views 7 comments 0 points Most recent by ManavM Reporting and Analytics for HCM -
How to remove special characters in the output of a e-text templatesSummary: We want to send all the open POs to a third party system in .txt format. The item description have a lot of special characters, how to remove it in the output w…SuniChacko 596 views 5 comments 1 point Most recent by suamanch-Oracle Reporting and Analytics for ERP -
Unable to track the changes made in BPM rules through audit reports when migrated from SOA composerSummary: We are trying to track the changes made in BPM rules. We are able to get the details in audit report when we are updating the rules manually but when the change…Surendra Rodge 11 views 1 comment 0 points Most recent by Cosmin Nadolu-Oracle Payables, Payments & Cash Management -
Trying to add a telephone number hyperlink like "tel:###" to an RTF template for BI email burstingSummary: I'm trying to add a clickable telephone number hyperlink like "tel:###" to an RTF template used for BI-Publisher email bursting. According to this, it should be… -
release statement to workerSummary: We would like to report on the field " release statement to worker" to check how many Line Managers have enabled this for their direct reports once comp cycle i…Manoj B. Cheruvathoor 2 views 3 comments 0 points Most recent by Saliha MAACHA Reporting and Analytics for HCM -
How to encrypt and decrypt images in Oracle fusionSummary: How to encrypt and decrypt images in Oracle fusion Content (please ensure you mask any confidential information): Hi All, We got a requirement to encrypt and de… -
Send automatic birthday wishes to employees via mail from organization.Summary: Send automatic birthday wishes to employees via mail from organization. Content (required): Hello All, I have a requirement, need to send automatic birthday wis… -
BIP Pivot Table Row Label Header PropertySummary: Hello, I'm trying to have a header label for my rows in a pivot table in BI Publisher. I'm using the Row Label Header property but does not show anything. Can y…Guillaume SAVALL 142 views 6 comments 0 points Most recent by Austin Rodola Reporting and Analytics for HCM -
Busting with OTBI as DataSource in a DatamodelSummary Error on Busting with OTBI as DataSource in a DatamodelContent Hi All, I am trying to use a OTBI Analysis/OBIEE sql as a source in a BI Datamodel. The Bursting i…User_2025-01-22-19-45-49-284 53 views 2 comments 0 points Most recent by Asif_T Reporting and Analytics for HCM -
Back-end table for Vacation Rule delegation and Task delegationHi Cloud Community, We have an audit requirement to get details on the Vacation Rules set by the user and based on the certain criterion it will be marked as compliant /…Tushar_Singhania 55 views 2 comments 0 points Most recent by Swapnil Kashid Payables, Payments & Cash Management -
How to fetch Cost Center Details which are mapped at Department LevelContent Hi Team, In our organisation we mapped Cost Center at Department level. How to fetch those cost center details. If anyone have SQL query please help me. I tried …User_2025-02-05-04-17-04-394 8.2K views 13 comments 0 points Most recent by Boying Reporting and Analytics for HCM -
Are there any fusion tables that store the Daily Amount and Days on ExpensesAs in "Expenses - Expense Transactions Real Time" Subject Area Daily Amount and Days these fields are not present so is there any fusion table where we can get these det… -
Emails with analysis tables are putting in extra spacingSummary: We have analysis that displays jobs that were posted in the past week. We send this report to users via email and have the data displayed in the body. The data … -
Alert Composer: Message text stored in which tableSummary: I want to get the message text of an alert composer. where it will be stored, Only message body was able to found-. which is in HTML format. most of the alerts …Merwin 36 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM -
Feasibility to update the path of the customized report in HCMSummary: Hi, Actually, there is a functional configuration done in HCM where we have option to select the templates basically report templates to generate the report. In… -
BI Publisher Pivot Table Limit/Configuration of able to add only 5 columnsSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…S Javir 25 views 3 comments 0 points Most recent by Thulasipriya K-Oracle Reporting and Analytics for ERP -
Does SFTP setting done in Production is copied over to non-production environment during P2T?Dear Experts, Can someone let me know if SFTP setting done in Production is copied over to non-production environment during P2T? Please share oracle documentation for r…B S Rafatullah-Oracle 11 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
Roles and Privileges ReportHi, Can you please help me to develop a report that lists all the privileges for all roles (including both predefined & custom roles) in Fusion? Something like this: Rol…