Reports
Discussion List
-
BI multivalue filter with bad performanceHello, We are tuning a query and see that the performance issue was in the multivalue filters. We are filtering invoices with the Code combinations table and filtering d… -
What is Public View Objects (PVO) and where can we use it?Summary: What is Public View Objects (PVO) and where can we use it? Can it be used in Data model for BI Publisher report? Also, can we see the SQL or logic behind this P…Karun Jain-Oracle 5.5K views 6 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
How to find out columns with empty value in Oracle fusion table through query ?Summary: Hello... I want to make a query to get all blank column names from a Oracle fusion table…Kindly help me in writing the query. Thanks. Content (please ensure you…I am a learner 21 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
Oracle Fusion BIP SQL using BIPUBLISHER_V to pull data from Audit Tables via BIP for custom reportsHi Guys https://us.v-cdn.net/6034893/uploads/XBAKK1LFAVL0/wp-fusionbipaudit-5459609.pdf I saw a very old post relating to using BIPUBLISHER_V, quoting the PDF attached, …
-
How to get manager comments from absence approval notification in BI reportsHi Team, How to get manager comments from absence approval notification in BI reports We are searching for table name and field name that stores manager's approval comme…Anup Karmankar 31 views 1 comment 0 points Most recent by Florin Dumitru-Oracle Workforce Management
-
How to change 'TO' email address in workflow approval email notifications BIP TemplatesSummary: We have a requirement to change the "TO" email address when approving /rejecting workflow emails. We need to replace it with organization email address. Then it…Aditya Jena 31 views 2 comments 0 points Most recent by Venk Kudire- Support-Oracle Fusion Applications Administration -
Query to find instance refresh /clone date in FusionContent Hi All, Like we used to have below query in EBS to get instance clone date , what table is used in fusion. SELECT resetlogs_time FROM v$database; Any help is rea…Nidhi Chhajed 3.2K views 8 comments 0 points Most recent by Bhanuchander Manthri Reporting and Analytics for ERP
-
Need Join Condition column for tablesSummary: Hi team, I have two tables to join hrc_dl_message_lines hdml and HR_ALL_POSITIONS, where i need position code from HR_ALL_POSITIONS table by joining with below …
-
How to group by formatted date column AnalysisSummary: Hi, we create analysis to count PO created yearly, so create Analysis include bill-to-location, creation date columns ,we want to group by bill-to-location, cre…
-
table name to fetch 'Write to person profile on completion' In learningSummary: Which table stores information about the Field 'Write to person profile on completion' In learning Navigation :- Course ->Skills and qualification -> manage -> …Shubham Wadekar-Oracle 1 view 0 comments 0 points Started by Shubham Wadekar-Oracle Reporting and Analytics for HCM
-
PCMCS SystemSummary: Found the Issue when execute the system report and did not find any context or target for any dimension data Content (please ensure you mask any confidential in…AKKHAPON KUMSARANEE 31 views 1 comment 0 points Most recent by Raama Rao-Oracle Profitability and Cost Management
-
how to get the Annualized salary of terminated employeesSummary: I just need basic details like thePerson number, Name etc of terminated employees with their annual salary. How do I get this in the OTBI report ? Content (plea…Trupti Khodke 43 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Recruiting Offer > Message Notification OTBI FieldGood Day Experts, Is the 'Message Text' field in recruiting module in fusion available in OTBI Recruiting Real Time subject area? Navigation from fusion is Offer > Actio…
-
Embed BI Publisher report without Fusion HeaderSummary: Hi - I am trying to embed a BI Publisher report into a page for our Learning admin to use but when I embed the report using the link provided within the catalog…
-
How to Merge column headings after grouping columnsSo I have created a sample report from sample data model to explain the issue here. I have grouped columns on years. Please find the report layout below (Image 1) and it…
-
ESS Jobs DashboardSummary: ESS Jobs Dashboard Content (please ensure you mask any confidential information): Hi Team, Greetings! As you know -we submit/schedule multiple ESS jobs. Is ther…Parag Hiremath 373 views 5 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP -
Delay in updating the Substitution Variable Value to Narrative ReportingContent We have several MR reports in Narrative Reporting with a substitution variable (EPBCS) as default value in prompts, every time we change the sub var value in EPB… -
Need SQL query to display HCM Extract results and output file namesSummary: Need SQL query to display HCM Extract results and output file names Content (required): We developed custom HCM Extract and it is having multiple delivery optio…
-
Who printed this report?Summary How do I find out who printed a report?Content A "General Ledger Account Details Report" printed on our check-printing printer, but no-one in the office admits t…User_2025-01-31-00-03-48-847 59 views 9 comments 0 points Most recent by RanaMK-Oracle Reporting and Analytics for ERP -
How to show 0 value instead of null value in a calculated formula column in OTBI report?Summary: How to show zero value instead of null value in a calculated formula column in OTBI report Content (required): I have a column 'Variance' which has value that i…Abhishek Shukla 1.2K views 6 comments 0 points Most recent by Pooja_hb-Oracle Reporting and Analytics for ERP -
How to translate Amount in Words from English to Arabic language in rtf templateSummary: we have a requirement to print Payment amount in Words (English) to Arabic language in check template. The expectation is that, translate below given English te…SireeshaJaladi 566 views 9 comments 0 points Most recent by ArjunReddy88 Reporting and Analytics for ERP
-
We are trying to send a static (fix)pdf attachment to all newly created candidatesSummary: We are trying to send a static (fix)pdf attachment to all newly created candidates, for that we tried below query . Have uploaded a pdf doc to content server as…Awadhendra Tripathi 31 views 3 comments 0 points Most recent by Manikanta Reddy S Reporting and Analytics for HCM
-
SQL Link between AP and Projects ?Summary: Report which shows project transaction that have flown through to AP Content (required): Hi Does anyone know the links/joins between AP and Projects, we are try…
-
Performance OTBI to extract Task Status, Section Names, Rating LevelsDears, we have a requirement to build an Analysis to extract performance document task status and ratings given to each document section. To do so we are crossing "Workf…Domenico P. 194 views 1 comment 0 points Most recent by Sivakumaran Muthusamy-Oracle Reporting and Analytics for HCM
-
Privilege required to see Home Phone and Home Email Address in BIP ReportSummary: Content (required): We have few BIP reports created to cater to the client requirement. We see that the report doesn't fetch the Home Email Addresses and Home N…Prajna Hegde 261 views 11 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
How to get deep link in Excel Template on a particular field in BI ReportWe are trying to get a deep link as a hyper link on a particular column in Excel Template in oracle fusionLakshmiVanarasi 172 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for ERP
-
BIP Report not retrieving data for single value in parameter, But same is working fine in DataModelSummary: BIP Report not retrieving any data when single value is selected in parameter, But the same is working fine in Data Model. Please help. Content (please ensure y…Mallikharjun Purilla-Oracle 31 views 2 comments 1 point Most recent by Hello123 Reporting and Analytics for HCM
-
Active department not found in reportHi, We are using the department level to differentiate between departments (divisions, sections, units). We have created a new tree version based on the new requirements…Catherine Abi Samra 11 views 2 comments 0 points Most recent by Catherine Abi Samra Reporting and Analytics for HCM -
Error when generating report, unsupported output format XLSXWe've received an error on one of our reports. Error message is the following: "Output failed. [INSTANCE_ID=bip.bi_serverHA] [OUTPUT_ID=158261] oracle.xdo.servlet.data.D…Francisco Carrillo-Robles 211 views 3 comments 0 points Most recent by Ajay Sharma Reporting and Analytics for ERP