BI Publisher
Discussion List
-
Is there a way we can use embedded reports for custom error messagesWe have a requirement to have an error message to validate entries in a standard field in Learning module. As far as we have checked, there are no autocomplete rules ava… -
Passing the parameter at run time from the URLI am creating a BIP report and want to pass parameters from the URL. For example, I have a report with a parameter for Assignment ID. When I open the report, it should l… -
How can I create a JSON file using BI PublisherSummary: How can I create a JSON file using BI Publisher Content (required): I want to create a JSON file using BI Publisher. I am able to generate the JSON format in th…Viju George 1.6K views 8 comments 1 point Most recent by Swati epari Reporting and Analytics for HCM
-
In BI Publisher scheduled report how to disallow using Email Destination while retaining burstingSummary: Can BI Publisher scheduled reports be setup to disallow using Email Destination (either enterprise wise or certain user roles) while at the same time retaining …Jbgood 12 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM
-
Opportunity Marketplace Out of the Box ReportingSummary: Opportunity Marketplace Out of the Box Reporting Content (please ensure you mask any confidential information): Are there any out of the box reporting for Oppor…
-
BI report does not open in android devicesWe have a third party payroll integration and we have a report so that payroll outputs can be pulled from self service. When this report is opened from the mobile applic…Ömer Vardar 34 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
BI Report Time card details - Calculated details by earned dateSummary: Team we have a requirement to fetch all the details available in the timecard. (Calculated details by earned date) - Screenshot attached. I am using the below q…
-
Editing PersonHeader subtemplateHello. I'm trying to customize the PersonHeader subtemplate and is already in the Shared Folders/Custom/Human Capital Management/ Workflow Notifications. But when I chan…Maria Cristina L. San Jose 62 views 2 comments 0 points Most recent by Luis Villagomez - IMMI Reporting and Analytics for HCM
-
How to customize the sub template for Termination Report?Summary: How to customize the sub template for Termination Report? Content (required): Hi All, How to customize the sub template for Termination Report? Where I can find…Venkatesan 32 views 4 comments 0 points Most recent by Luis Villagomez - IMMI Reporting and Analytics for HCM
-
PER_PERSON_SECURED_LIST_V View Does not Retrirve all RecordsSummary: PER_PERSON_SECURED_LIST_V View Does not Retrieve all Records. It fetches the data of only the Current logged in user. Please advise Content (please ensure you m…MilanMohanty 163 views 4 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Does anyone know why running a BIP report from OIC produces different result vs. ESS?Summary: We created a BIP report to generate data in XML for a data integration, but some elements are getting dropped when it's run from OIC. Content (please ensure you…
-
Can we burst XPT templateSummary: We have an Report created with XPT template (Normal report creation). Can we use this template and burst the report in excel format? Content (please ensure you …
-
Query to get Scheduled BIP Jobs in Oracle Fusion HCMHi All, Is there a way to retrieve the schedule details of BIP reports like job name, report name, schedule start date, schedule end date, frequency etc. using a sql que…Dhanuka Chamal 1.1K views 2 comments 5 points Most recent by Vishnu Vardhan Raju Reporting and Analytics for HCM -
BI Publisher Report SQL Error : SQL or ORA exceptions caused due to invalide sql , database packageSummary: I've created a headcount report that combine all workforce informations based on per_all assignments, compensation data based on cmp_salary_v cmp_salary_v2... i…Ayoub AFRASS 914 views 5 comments 0 points Most recent by Juan Pablo Gonzales Reporting and Analytics for HCM -
BIP Query Job Roles and the roles assigned to themSummary: I'm trying to create a BIP query that shows me Job Roles and the roles assigned to them. I tried to create the report, but I can only get it to this point: sele…JaimeOrtega 119 views 4 comments 0 points Most recent by JaimeOrtega Reporting and Analytics for HCM
-
How to convert RTF template file from LF to CRLFSummary: Convert file from LF to CRLF Content (please ensure you mask any confidential information): I would like to ask on how to use the CRLF in RTF Template. Is it li…MayCab 12 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
Values being truncated at 240 characters in the non-Excel output formatsHow to address those values being truncated at 240 characters in the non-Excel output formats.Ronel M 1 view 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM -
Balance trending reportWe have developed a Balance trending report for current & previous check dates. When we are running for a particular employee we are able to see data within 2 seconds, W…JanardhanP 1 view 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
Building a BIP Report for User Access TrackingSummary: Dear Customer Connect Community, I hope this message finds you well. I am looking to create a BIP Report using standard SQL to track user access within specific…Matheus Roberto 32 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM -
User All Login Details within a specific periodHello Experts, Below query provides information on Last Login Date. For example, a user last logged in 1st Nov, this query will provide Last Login Details. However, is i…ImSt2509 96 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM -
Payroll - Element Entries Real Time SA not returning car allowance Elements in the reportSummary: I have created an OTBI report with car allowance element entries for two Business units by using "Payroll - Element Entries Real time" subject area, each BU hav…Hitachi ServiceDesk 12 views 0 comments 0 points Started by Hitachi ServiceDesk Reporting and Analytics for HCM
-
How to use outer join in OTBI AnalysisContent Hi All, I am using Worker Assignment Real Time Subject area and i have to pull only the person who has home phone number . The person who don't have home phone n…User_2025-02-04-18-22-33-673 1.5K views 5 comments 1 point Most recent by RajaPalli Reporting and Analytics for HCM -
Excel Output Formats is not generating any data and file size is showing only 7 KBSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…sayeed_ahmed 11 views 1 comment 0 points Most recent by sayeed_ahmed Reporting and Analytics for HCM -
Encryption format supported by OracleSummary: The public key algorithm for this private key is not supported error while connecting to a FTP server Content (please ensure you mask any confidential informati…
-
SQL Query to fetch value set details with respect to modulSummary: Hi All, I want to fetch the value set details with respect to module, can anyone help me with table name or query? Version (include the version you are using, i…ShawShankk 285 views 1 comment 0 points Most recent by Deepak Deenadayalan Reporting and Analytics for HCM
-
Seniority Dates V2 to V3 TransitionContent Hi all - my search skills are seriously lacking, or there is just no information out there ... what work is involved in transitioning from V2 to V3 for the new s… -
Timing issue for an SQL querySummary: Content (please ensure you mask any confidential information): Hello experts, we built a query to retrieve the organization manager assignment id for a specific… -
Query to fetch the individual Manager Rating and Employee rating corresponding to each Goal.Summary: I am creating a custom report to get the employee and manager ratings for each performance goal. I got the summary ratings from table 'HRA_EVAL_RATINGS'. But fo…Rahul K-Oracle 833 views 2 comments 0 points Most recent by Jean Vishal Reporting and Analytics for HCM
-
Report to get Original Date Earned of element entrySummary: Report to get Original Date Earned of element entry Content (please ensure you mask any confidential information): Hi Team, Greetings! Does anyone have the repo…Parag Hiremath 275 views 3 comments 1 point Most recent by Parag Hiremath Reporting and Analytics for HCM -
Need sample query to fetch list of document records for dependentsSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Mallikarjuna Reddy 2 views 1 comment 0 points Most recent by gclampitt Reporting and Analytics for HCM