BI Publisher
Discussion List
-
Example Feedback Report query for BI Publisher based on Feedback requests and Questionnaire tablesSummary: Our requirement is to generate a report based on feedback requests and questionnaire (eg. Annual Performance Feedback) tables. Manager will submit Feedback Requ…MadhuLekkala 95 views 2 comments 0 points Most recent by MadhuLekkala Reporting and Analytics for HCM -
How to get items list along with Inventory organization associationSummary: How to get items list along with Inventory organization association Content (please ensure you mask any confidential information): We need list of items along w…
-
Expense report Output show words garbledSummary: Expense report Output show words Garbled, Unable to read by users Content (please ensure you mask any confidential information): Expense report Output show word…
-
I need to retrieve a list of all data roles and job roles associated with a given privilege.When querying by privilege name, I want to capture all the corresponding data roles and job roles linked to it. I attempted using the tables ASE_PRIVILEGE_VL and ASE_PRI… -
How to concatonate two values into a single field on Positive Pay XML templateWe have a need to combine payee name and address line 2 into the same field for one of our Positive Pay XML templates. I have tried using the concatonation function disc…Daniel T Roy 11 views 4 comments 0 points Most recent by Daniel T Roy Payables, Payments & Cash Management
-
Certain fields from table HZ_PERSON_PROFILES are not visible in AR Customer MasterHi, Certain fields like Gender, Date of Birth, Date of Death, and Initials from HZ_PERSON_PROFILE are present in the backend HZ_PARTIES table but are currently unavailab…Rimoni Shah-Oracle 23 views 2 comments 0 points Most recent by Rimoni Shah-Oracle Receivables & Collections
-
Past Attempt Details of LearnersIssue: We would like to view the learner's past attempts for specific courses through BIP. Description: We encountered an issue where a learner completes a course or off…Mohammed Waseem Akram S 51 views 2 comments 0 points Most recent by Mohammed Waseem Akram S Learning
-
SQL Query for Journal entries details and APInvoice table joinSummary: Need help on SQL query for the Journal entry details and Invoice details Join together. In the below screen shot we need highlighted information. I have written…
-
Payment Approval History ReportHi Team, We are trying to develop a query for Payment Approval History Report. Business requested to pull the below details: Payment_number Submitted_By Submitted_Date P…Badripalli Archana-Oracle 191 views 4 comments 0 points Most recent by James McBride Payables, Payments & Cash Management
-
How can we get the Posted Revaluation amount calulation on Daily basis not period?Summary: Bank customer and daily running the revaluation and wants to see the posted revaluation amounts for each foreign currency and revaluation rate. Content (please …Eswarvoona-Oracle 11 views 1 comment 0 points Most recent by veerendranath pulivarthi-Oracle General Ledger & Intercompany
-
Some Employee missing of the Reports on certain dateSummary: I want to explain the issue we encountered. On December 10, the HR team uploaded a change affecting all employees in a specific department, effective December 1…Lucas B Maciel 21 views 4 comments 0 points Most recent by gclampitt Reporting and Analytics for HCM
-
Query Regarding Adding a Secured List Table to Oracle BI Data ModelSummary: Query Regarding Adding a Secured List Table to Oracle BI Data Model Content (please ensure you mask any confidential information): Hello, I am working on a BI d…
-
Is it possible to find deleted checklist details?Summary: Is it possible to find deleted checklist details? Content (required): Hi All, For one employee, one check list has been assigned and deleted by someone. I verif…
-
Actual Termination Key Date?Client is saying The ActualTerminationKeyedDate is a column in the "per_periods_of_service" table. We don’t see from our side the termination_key_date from "per_periods_…Ronel M 2 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Human Capital Management -
Subject Area for Personal Payment Method DetailsSummary Subject Area for Personal Payment Method DetailsContent Hi All, Can any one please help me to find OTBI Subject area for personal payment method details. I have …nitin Sharma 213 views 13 comments 1 point Most recent by GopiKAutomus Reporting and Analytics for HCM
-
BIP Query to get only base elementsSummary BIP Query to get only base elementsContent While creating elements, there will be shadow elements that will get created automatically. Is there anyway to get onl…Sowdha Murugan 569 views 4 comments 0 points Most recent by Rakesh Kanukanti Reporting and Analytics for HCM -
How do I add location and brand segments to a Cost Summary report for fixed assets in Oracle Fusion?Summary: I would like to customize a seeded report found in Oracle Fusion by adding brand and location segments by updating the data model. Content (required): Version (…
-
how long data can store fa_fusion_soainfra.wftask this tableSummary: Need information about this table how long data will be store Content (please ensure you mask any confidential information): Version (include the version you ar…Nagendra Chitra-Oracle 72 views 1 comment 0 points Most recent by Satyam Roy Reporting and Analytics for HCM
-
HCM Workflow ReportSummary All HCM transactions current status of the workflow and approval detailsContent Hi, I'm trying to create a report to display all HCM transactions Current status … -
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… -
Terms & Conditions in PO PDFSummary: Hi Fellow Developers, The requirement is to host Terms and Conditions file in Oracle cloud and it should be printed as hyper link in PO PDF. when ever a Supplie…Dhilip Kumar P. 21 views 1 comment 0 points Most recent by Sai Karthik Reporting and Analytics for SCM
-
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 24 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…
-
JournalEntryReserveLedgerSummary: I am trying to customize the report Journal Entry Reserve Ledger and when I am trying to save the data model (JournalEntryReserveLedgerDm), I am getting pop up …JATIN_SINGHAL-Oracle 11 views 1 comment 0 points Most recent by Louise Gareau - Support - Oracle-Oracle Assets