BI Publisher
Discussion List
-
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 181 views 2 comments 0 points Most recent by Prasanth Senthivel-Oracle Product Master Data Management -
CX - Is venn diagram possible in OTBI?Total value of opportunities and Total number of opportunities should be displayed in the diagram along with the status. Is following design possible in OTBI?Nalsoft Pvt Ltd 31 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales
-
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 92 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 22 views 1 comment 0 points Most recent by Erika B-Oracle Reporting and Analytics for HCM -
i want a query to fetch item onhand with the current layer cost with a combination of valuation unitSummary: Attaching the code i am trying to run which is having a performance issue and could'nt figure out a way to fetch the layer cost of an item at a particular subin…Rudraksha Vishnu 51 views 1 comment 0 points Most recent by SRGogula-Oracle Reporting and Analytics for SCM -
i want a query to fetch item onhand with the current layer cost with a combination of valuation unitSummary: Attaching the code i am trying to run which is having a performance issue and could'nt figure out a way to fetch the layer cost of an item at a particular subin…Rudraksha Vishnu 374 views 1 comment 0 points Most recent by SRGogula-Oracle Reporting and Analytics for SCM
-
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 11 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 11 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM
-
Invoice Print Template can be edit or not and how it is mapped with applicationHi All, We would like to know how the Invoice Print Template is mapped with the application Can we edit the Invoice Print Template ( Add or Remove the fields) Can we cre…
-
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 588 views 1 comment 0 points Most recent by Andra Maria Popescu-Oracle Reporting and Analytics for HCM
-
HCM Extract to compress multiple reports in a Single Zip FileSummary: I'm loading Job Requisition Template Description. For this I combined ClobFiles and JobRequisitionTempalte.dat into .zip file manually, i 'm able to load data ,…
-
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 2 views 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 21 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 32 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 11 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 1 view 1 comment 0 points Most recent by Gaurav Bharadwaj-Oracle Reporting and Analytics for HCM
-
BIP Excel output removing zeros from decimalSummary: BIP Excel output removing zeros from decimal Content (please ensure you mask any confidential information): I have a BIP Data Model and Report with Excel (.xls)…KDR 11 views 4 comments 0 points Most recent by Hassan El Bouihi-Oracle Reporting and Analytics for SCM
-
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 25 views 1 comment 0 points Most recent by Hassan El Bouihi-Oracle Reporting and Analytics for HCM -
how to attach a static pdf from webcenter as attachment into our emailWe want to send a Email with a static pdf file as attachment to employees. So we are using the RTF template as the Email body and. And we have to attach the PDF file as …Dara Nagasai 31 views 1 comment 0 points Most recent by Hassan El Bouihi-Oracle Reporting and Analytics for HCM
-
Reports return SQL error since applying security profileHi there, Since doing a restructuring of the business, we applied a person security profile to one of the HR roles so that they could only search for and work with peopl…Matt Corserv 12 views 1 comment 0 points Most recent by Hassan El Bouihi-Oracle Reporting and Analytics for HCM
-
Extract Layout Templates in ReportSummary: Hi, Is there a way to extract the details of Layout Templates in a Report? The client wants to extract all layout details of their reports as Excel for their re…Ralph Aldrich Magno 11 views 1 comment 0 points Most recent by Mary Ramirez-Oracle General Ledger & Intercompany
-
Is there a table or a view holding "Previous Comments" or "Approval History" related to unapprovedSummary: In order to check a detailed approval status of Goals before approval, I'd like to extract data such as "Previous Comments" or "Approval History" . I'd like to …S.Watanabe0110-Oracle 11 views 1 comment 0 points Most recent by Adriana Tudor-Oracle Reporting and Analytics for HCM
-
How to track the number of requested feedback via BI PublisherSummary: How to track the number of requested feedback via BI Publisher Content (please ensure you mask any confidential information): Hi, we would like to generate a re…Barile Alberto 31 views 1 comment 0 points Most recent by Adriana Tudor-Oracle Reporting and Analytics for HCM
-
Select data which are displayed on the All-In-One EvaluationSummary: As per customer's request, I'd like to make a BI report that selects the data displayed on the All-In-One Evaluation. Content (please ensure you mask any confid…S.Watanabe0110-Oracle 31 views 1 comment 0 points Most recent by Adriana Tudor-Oracle Reporting and Analytics for HCM
-
BI Publisher Handle No Data in RTF TemplateHello, I want to prepare a report that returns data that I call from the web service via OTBI. However, when I try to return this value in BI Publisher rtf template, the…Sinem Kara 83 views 1 comment 0 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for HCM