BI Publisher
Discussion List
-
Job Profile AuditsHi , I have a requirement to pull the changes made to Job profiles/Job details. Is there any way if it can be retrieved from Audit report, If yes, how can i achieve it. …Praveen_Chouhan 1 view 3 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
How can I make sure that when the Dashboard is first opened, no data comes in without selecting a paHi, I designed a dashboard for users. It has a detailed dashboard with assignment information of individuals and multiple parameters. What I want is for the parameter sc…Sinem Kara 51 views 9 comments 0 points Most recent by Jahnavi-Oracle Reporting and Analytics for HCM -
Is it possible to get the list of all the Data Models using a specific keyword in Dataset SQL?Summary: Is it possible to get the list of all the Data Models using a specific keyword in Dataset SQL? Content (required): Looking for a query that can be used to check… -
API to manage BIP Catalog ObjectsSummary: Content (required): We have a CatalogService WSDL to download and upload catalog objects, however, that API asks for passing the username and password in the Bo…Vinay Gharge 33 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for ERP -
REST API to schedule and run report in Oracle Fusion BIP reportsSummary: REST API to schedule and run report in Oracle Fusion BIP reports Content (required): Version (include the version you are using, if applicable): 22D Code Snippe… -
Need help in understanding the BIP SQL query (new to SQL and BIP)Summary: Hi Experts I'm new to SQL and BIP reporting. I'm working on one BIP report and I have added parameter to an existing BIP query to filter based on item number, a…Sharmava 52 views 2 comments 0 points Most recent by Umamaheswara Reddy Karri Reporting and Analytics for ERP -
Where to find Risk Code Description in DBSummary: Need to find the Risk Code (or Workers Compensation Code) description in the database. Content (required): I am creating a report pulling data out of hcm cloud … -
WRS best practice for Financial reports or Oracle BI publisher is more stable?Summary WRS vs BI Publisher for reportingContent WRS vs BI PublisherWhere is it recommended to develop a complicated financial report with compairsons Oracle BI Publsihe…Umer.Farooq 34 views 2 comments 1 point Most recent by CA Nirmal Choudhary General Ledger & Intercompany -
Is anybody created OTBI/BI/HCM extract to fetch the Learning detail history.Summary: Is anybody created OTBI/BI/HCM extract to fetch the Learning detail history Content (required): Version (include the version you are using, if applicable): Code… -
Invoice History Report for a given supplierHi All Is there any standard report which allows to drill down open closed invoices per supplier and also drilldown to the individual invoices via deeplinks ? Thanks Mur…Murthy Kodavati 11 views 2 comments 0 points Most recent by Murthy Kodavati Reporting and Analytics for ERP -
BIP - Non-catalog item reportSummary: Hello, Have anyone tried creating a Non-catalog item report in Learning? Do you know where I can get these details below? (Column name, tables in BIP) Your help…Hazel De Castro 101 views 6 comments 0 points Most recent by Hazel De Castro Reporting and Analytics for HCM -
Create a Report for Candidate Job Application with the Prompts as Prescreening QuestionsSummary: Hello Experts, We have a requirement where we need to build a report with the Filters as the Prescreening Questions. There are 15 Prescreenshing questions but w…HarishVummidi 104 views 2 comments 0 points Most recent by HarishVummidi Reporting and Analytics for HCM -
Scheduling the report(Email Notification) if the data is present in itSummary Scheduling the report(Email Notification) if the data is present in itContent Hi All, Greetings !! Our customer's requirement is to receive the report/Email noti…User_2025-01-29-01-27-20-754 213 views 17 comments 0 points Most recent by Adam_Cantwell Reporting and Analytics for HCM -
Customizing Print Receivable Transactions: Invoices ReportSummary: We have this seeded report "Print Invoice Template" (Defaultinvoice.xdo) which has a corresponding ESS job "Print Receivable Transactions: Invoices" which is a …Ashu Raj-Oracle 606 views 8 comments 0 points Most recent by Sahil_Makhiza Reporting and Analytics for ERP -
How to read primary national identifier?Summary: How to read primary national identifier? Content (required): How to read primary national identifier? I use per_national_identifiers table but no reference to t…Nicola Petri 91 views 2 comments 1 point Most recent by Seema Kalantri Reporting and Analytics for HCM -
Do Business Unit names in BI report criteria gets changed to BU ID value during archive/ unarchive?Summary: Hi All BI/ reporting experts - The question is regarding migrating BI reports from one pod to the other. Oracle recommends using archive/ unarchive feature. We … -
Schedule BI Report > Schedule tab > UTC Time ZoneSummary: Schedule BI Report > Schedule tab > UTC Time Zone Content (required): Hello All, When we schedule a BI Report from the Schedule tab: it seems the Time Zone of t…Bernard T 21 views 1 comment 0 points Most recent by Andreea Brem-Oracle Reporting and Analytics for ERP -
Fixed Assets category listing from Oracle CloudSummary: We want extract the complete category setups including the accounting from Oracle Cloud Content (required): We have over 51 asset books and 300 asset category, … -
How can I get double quotes around fields in the output generated by an etext template?Summary: After adding a new field to a current etext RFT template and uploading it, the output no longer contains double quotes around the fields that contain spaces or …BeachDreamer 1.3K views 3 comments 0 points Most recent by BeachDreamer Reporting and Analytics for HCM -
How to find the list of scheduled jobs and their individual runs?Summary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):kishore madhavan-Oracle 51 views 3 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for HCM -
Need a query to get negotiation approver list in oracle fusionSummary: Content (required): Hello everyone, I need a query to get negotiation approver list in oracle fusion.Please advise! BR, Sushan Peiris Version (include the versi…Sushan Peiris 314 views 1 comment 0 points Most recent by Sushan Peiris Reporting and Analytics for ERP -
What are the available web services for Fusion BIP?Summary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):kishore madhavan-Oracle 21 views 1 comment 0 points Most recent by Skolli-Oracle Reporting and Analytics for HCM -
How to SUM 1st, 2nd, 3rd and 4th occurrence of values in trailer summary record for ETEXT template?Summary: I have a requirement to build a trailer record that includes 4 separate SUM totals based on the occurrence of these totals in the employees record. I can't chan… -
Getting warning while creating Content Data setSummary: Getting warning while creating Content Data set Content (required): Hi All, Got a requirement to show attachments in the PO PDF report. So we try to customize t… -
Where is WF_ROUTING_RULES located? Vacation Rules table?Content Hi, I'm trying to do reports for vacation rules and I have read I can use WF_ROUTING_RULES but or the life of me I can't find where these reside Any clues? Do I …King Jack 292 views 9 comments 2 points Most recent by Divya Mangtani Reporting and Analytics for ERP -
Period name taken as a parameter tag display in a wrong format in excel outputSummary: Content (required): Hello Everyone, I recently created a BIP report using excel with the "xls" format and using the xml exported, I ,created the report in an ex…Sushan Peiris 151 views 3 comments 0 points Most recent by Sushan Peiris Reporting and Analytics for ERP