BI Publisher
Discussion List
-
Table and Field Name for Offering TypeSummary: Table and Field Name for Offering Type Content (required): Hi, we would like to know what is the name of the Table in Oracle HCM which includes the information … -
Filter based on custom values in promptSummary: How to filter analysis based on custom values in prompt? Content (required): I have a variable prompt which has custom values like ALL, Female, Ethnicity etc. i…Raghavendra M 43 views 4 comments 0 points Most recent by Raghavendra M Reporting and Analytics for HCM -
Error While opening OTBI ReportSummary: Error While opening OTBI Report Content (required): Hi Everyone, While opening the OTBI report, it throws me following error. As per the document Doc ID 2083725… -
Report on Salary Change Action and ReasonSummary I'm looking to report on Action and Reason within Manage SalaryContent Using the Compensation - Salary Details Real Time subject area I'm able to pull Action and…User_2025-01-25-00-37-41-739 211 views 6 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
What are the tables that store the Manage Associated Business Entities data?Summary: What are the tables that store the Manage Associated Business Entities data? Content (required): Version (include the version you are using, if applicable): 22.…User_2025-02-11-06-12-35-024 130 views 2 comments 0 points Most recent by User_2025-02-11-06-12-35-024 Reporting and Analytics for ERP -
Calculation Cards TRUSummary: I would need to get the value of TRU in Calculation Card. I am unable to find the table name. If anyone could help on this, would be really great. Screenshot At… -
OTBI Hospital Custom TableSummary: Dear All, Where can i find this table is maintained in Oracle system? Thank you Izliana Content (required): Version (include the version you are using, if appli…Izliana 31 views 1 comment 0 points Most recent by Maria Croitoru-Oracle Reporting and Analytics for HCM -
Results to be displayed horizontally instead of vertically in reportsSummary: We have a requirement where the results displayed in reports are vertical but we need to display that column horizontally. Suppose say for example this the resu…Prajwal kumar 81 views 5 comments 0 points Most recent by Prajwal kumar Reporting and Analytics for HCM -
Digitally Sign BIP report sent to SFTP server using BurstingSummary: Hi Team, Once we set up the SFTP server in fusion as a delivery option, there is a checkbox to sign output. So does it digitally sign the file and it will use w… -
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 31 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 51 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 101 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 592 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 83 views 2 comments 1 point Most recent by Seema Kalantri Reporting and Analytics for HCM