BI Publisher
Discussion List
-
Gigs progress history is not available in IRC_LC_HISTORY tableSummary: Gigs progress history is not available in IRC_LC_HISTORY table such as Gig Filled date, Gig completed date, unpublished date, etc. We are unable to extract data…Shalini.bh 32 views 1 comment 0 points Most recent by BrianLawrence.G-Oracle Reporting and Analytics for HCM -
How to Prevent Spacing between unmet conditions?Summary: I am currently in the process of consolidating multiple offer letters into a single document. Within this composite offer letter, I've included several sequenti…Emily Cox 1 view 1 comment 0 points Most recent by Patricia-S-Oracle Reporting and Analytics for HCM
-
Information about Report and its linked data modelSummary: looking for any table or Subject area where we can get information about Report and its linked Data model. to ensure that every report linked with report after …Amit_Ekbote 1 view 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM
-
Consolidate multiple extract in single extractSummary: I need to develop three separate HCM extracts. However, I would like to consolidate the data from all three extracts into a single XML file. Is there a method a…
-
How to query rehire contingent workers in BI reportSummary: I need to query for rehires To look for rehires the person has to have an active Contingent Worker assignment from the past and either a pending worker or conti…Vishnupriya 455 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Report on Leave of AbsenceSummary: In our company, we use an Action in the Employment page to track if the employee is going on Leave of Absence (e.g. Maternity leave). Then, we use another actio…
-
Need to provide SFTP URL as a hyperlink in RTF template.Hi, We have a requirement to send email notification to user after extract run, in email we have to provide SFTP location as a hyperlink so that when user clicks on it, …
-
I am looking for Oracle fusion HCM exit interview questionare tables to develop a BI reportSummary: with the columns mentions below Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code …Shyam Kumar Ganti 44 views 1 comment 0 points Most recent by Mihnea Savu-Oracle Reporting and Analytics for HCM
-
Remove column from Excel BI Publisher reportI have a report containing many columns that I prepared using Excel Publisher and I want to remove a column, but when I upload it back to the system by clicking delete t…Cansel Karasoy 500 views 2 comments 0 points Most recent by Alexandru Burcea-Oracle Reporting and Analytics for HCM -
OTBI report how to display parameter list of values only with the report result in the list ?Hello , In OTBI report, we would like to have a list of values on parameter “location “ based on the values of the report result . Only the values that are extracted fro…Revital Mefano 404 views 4 comments 0 points Most recent by Revital Mefano Reporting and Analytics for HCM -
Displaying different sections in mobile app and web app on dashboardHello, in the dashboard I have prepared, I want some sections to appear only in the web application. I want some of them to appear only in the mobile application. Is thi…Sinem Kara 21 views 1 comment 0 points Most recent by Florin Loghin-Oracle Reporting and Analytics for HCM
-
BI Report Logo not displaying when exporting report to MS WordSummary: BI Report Logo not displaying when exporting report to MS Word. Content (please ensure you mask any confidential information): I have created a BI report. I use…IanDeKoker 51 views 1 comment 0 points Most recent by Andra Maria Popescu-Oracle Reporting and Analytics for HCM -
How can I join General ledger and ExpensesHow can I join General ledger and Expenses I am precisely looking to join below tables gl_je_lines gl_ledgers exm_expense_types Much appreciate your help on this
-
I am having trouble adding Job Code, Job Title, and Department to this Address Change ReportSummary: Hello, I need to add Job Code, Job Title, Department and HR Status to this report and I am having trouble doing so. My current code is attached. Any suggestions…
-
Is there a multi-level exploded BOM table or table view in Oracle Fusion databaseSummary: Is there a multi-level exploded BOM table or table view in Oracle Fusion database. Content (please ensure you mask any confidential information): I need to writ…Mike.Myers.CDIPRODUCTS.COM 169 views 2 comments 0 points Most recent by Prasanth Senthivel-Oracle Product Master Data Management
-
CMP_SALARY_SECURED_LIST_V emptySummary: Using CMP_SALARY_SECURED_LIST_V to secure a BIP report, but the table is empty for target user. Content (please ensure you mask any confidential information): H…Claudia Schiff 64 views 2 comments 0 points Most recent by Claudia Schiff Reporting and Analytics for HCM -
We are not getting GL Cost Center information when we are trying to pull data across learning recordSummary: We have a requirement to pull cost center details in learning history report across learner assignment details. In our project cost center is linked to departme…Pankti Shukla 24 views 1 comment 0 points Most recent by Erika B-Oracle Reporting and Analytics for HCM -
How to print only tags restricting corresponding values in xslt template version 1?Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Pritha 13 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM
-
Bi Publisher. How do you show parameter values used for the reportSummary: We would like to show on the BI Publisher report output the parameter values used to create the report. Can anyone help with this please. Thank you. Content (pl…Kevin Robertson 12 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM
-
How to enable file data source in BI publisherSummary: Add new data source feature has been disabled for FILE connection. How to enable this option. Content (please ensure you mask any confidential information): Add…Anoop K N 538 views 1 comment 0 points Most recent by Andra Maria Popescu-Oracle Reporting and Analytics for HCM
-
How to find the BIP report name which is using a specific SFTP connectionI know the SFTP name that is being used to transfer a file to vendor. But I do not know which BIP report is using that SFTP connection. I have looked at the report jobs …
-
How to fetch Reason value from ORC in BI reportSummary: Hello Experts, Need your help in pulling a field called reason found in ORC module. PFA the screenshot of the field i want pulled. I am aware this field is pres…Jithin Mathews 1 view 1 comment 0 points Most recent by Jithin Mathews Reporting and Analytics for HCM
-
Data model with excel as source not workingSummary: Data model with excel as source not working Content (required): Hi Team, Greetings! We have the data model with 2 groups - one with excel as the source and othe…Parag Hiremath 21 views 1 comment 0 points Most recent by Skolli-Oracle Reporting and Analytics for HCM -
How to add BI publisher report to Briefing bookSummary: We have a requirement to Add a BI Publisher to a Briefing Book. I tried creating it by following the steps mentioned in below link but not able to see the outpu…Santhosh Gangishetty 22 views 1 comment 0 points Most recent by Skolli-Oracle Reporting and Analytics for HCM
-
How we can pull old assignments and old payroll name?I need logic for old assignments and payroll name, it will be appreciable if you will provide me any sample query. This is the Requirement Global Transfers processed in …Narmada Yadav 34 views 1 comment 0 points Most recent by Anca Andronic-Oracle Reporting and Analytics for HCM -
i want to join (PAY_PAYMENT_TYPES) tables with person details.wanted to fetch payment type and payment source highlighted in the below snapshot.Chetana Pawar 12 views 1 comment 0 points Most recent by Anca Andronic-Oracle Payroll and Global Payroll Interface (GPI)
-
opening of Outlook and send mail for rejection of performance assessmentsHi code is written so that mail is sent for rejection of assessments. when we click it will redirect to outlook. mailto:fusion_notifications@XXXX.com?subject=%20Reject%2…Shanmukhi 11 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM
-
BIP report to scan BIP custom catalog for a key word in custom SQLSummary: Any Table which stores BIP Custom SQL. So That I can query that table to find a Particular "Table" used in all custom SQL. Content (please ensure you mask any c…SaiPavan Kumar Gadepalli 11 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM
-
Report related detailsSummary: Hello, We want to know details for the one of the BI report, how we can find below details, do we have any Query to check all details for the BI report. Report …Namrata_20 2 views 1 comment 0 points Most recent by Gaurav Bharadwaj-Oracle Reporting and Analytics for HCM
-
BI Report job success but email not deliveredHi, We have come across an issue with one of our bursting reports wherein the Report job is showing as Success, but the email is not being delivered. Can someone help wi…Praneeth K 13 views 1 comment 0 points Most recent by Hassan El Bouihi-Oracle Reporting and Analytics for HCM