BI Publisher
Discussion List
-
SQL query to retrieve a common lookup description at the employee levelSummary: Content (please ensure you mask any confidential information): Hello experts, we created a custom common lookup. We need to extract at the employee level the lo…Valerio Curzi 273 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Multiple Assignment ReportSummary: Does anyone have an XML or data model that captures employees with two (or multiple) active work assignments; showing job, department and manager details. Conte… -
![Arun Kumar Krishnan [AK]](https://us.v-cdn.net/6034893/uploads/userpics/L8BUJDYF94E7/nTLGWFBWW678P.jpg)
Participant Feedback - Questionnaire Responses duplicationSummary: Dear Team, We have a Performance template which has the Participant feedback included and would like to capture the responses provided by the Participants in th…Arun Kumar Krishnan [AK] 71 views 4 comments 0 points Most recent by Martin Smid-Oracle Reporting and Analytics for HCM -
Extract a list of custom reports in HCM from OTBI and BI PublisherSummary: Is it possible to extract a list of custom reports created in OTBI and BI Publisher, including: The subject areas and folders used, and the fields in them and o…Paul Morrissey 71 views 2 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for SCM -
SQL query of Fast Formula retrieving manager+1 and manager+2Summary: Content (please ensure you mask any confidential information): Hello experts, do you have an SQL query or fast formula to retrieve the employee manager+1 and ma…
-
Move Dashboard Page to a subpageSummary: Hi, I have created a dashboard with multiple Subpages under one Dashboard page. When i rename the Subpage names (In Dashboard Properties), somehow its convertin…Sudheer YN 201 views 8 comments 0 points Most recent by Dianne Barnhouse Reporting and Analytics for SCM
-
Extract run Failing after adding new FastFormulaSummary: Extract is failing after adding new rule to get the correct parking tier based upon employee salary Content (please ensure you mask any confidential information…GauravGupta39 21 views 4 comments 0 points Most recent by GauravGupta39 Reporting and Analytics for HCM
-
HCM Reporting/Extracts usage recommendationsSummary Out of plane vanilla sustainable reporting ideas for HCMContent Disclaimer: following post expresses personal opinion of author based on many years and many rele…Valeriy Gorbunov-80491 78 views 8 comments 2 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Where can I find release notes regarding OTBI and BI Publisher for HCM?Hello, I am looking for Release Notes or What's New regarding OTBI and BI Publisher for HCM Cloud. Could you please help me find where they are? Kind regards AliceAlice Gouzy 21 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Fast Formula or query retrieving the number of working daysSummary: Content (please ensure you mask any confidential information): Hello experts, it is possible to build an SQL query or Fast Formula retrieving the number of work…Valerio Curzi 361 views 3 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Table to see RA_INTERFACE_LINES attributesI popoluted the DFF in RA_INTERFACE_LINES, and I need to view them in a query, in join with ra_customer_trx_all. Which tables stored information about interface_line_att…ACNROMA2023 11 views 1 comment 0 points Most recent by Sairam Surampalli-Support-Oracle Receivables & Collections
-
Roles and Privilege required for ExternalReportWSSService creation using SOAP WebservicesWe created a call for a report using Soap Webservice, but we need to add the role or privilegies to our User. Someone knows them? Thank you so muchACNROMA2023 151 views 2 comments 0 points Most recent by Humberto Martín-Oracle Reporting and Analytics for ERP
-
ORACLE FUSION HCM QUERY TO GET USER ACCOUNT LOCKEDSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Daniel Paul-183648 664 views 6 comments 0 points Most recent by Satyam Roy Reporting and Analytics for HCM
-
what are the tables where i can find project and its accouting detailsSummary: Hello , I want query or table names from which i can pick projects inofrmation of accounting like GL_date ,Account number,Account description. I am attaching th… -
Page breaks do not work for bursting (RTF template -> Excel output)Report has RTF template and it is exported to XLSX format only. Resulted Excel has 2 separated sheets (from functional logic one Excel file contains 2 reports are spaced…Sourabh Patial 21 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
BIP encryption with UTF-8 encoded csv fileHi Team, Can you please help me know how to generate a UTF-8 encoded csv file with encrypted pgp extension file. I am using etext template. Thanks.SM_EP 21 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
BIP internal bank account table?Hi Guys When I search online I get told to use view CE_INTERNAL_BANK_ACCOUNTS_V to lookup field INTERNAL_BANK_ACCOUNT_ID out of table iby_pay_service_requests. However w…
-
Show the postal 4 zip code on AP checkWe need to show the postal 4 zip code (postal code extension) in our AP check template, but the xml is not showing the field (Select document From iby_trxn_documents ord…Alvaro Artavia 42 views 3 comments 2 points Most recent by MiaM-Oracle Payables, Payments & Cash Management
-
Error when trying to add an analysis inside a datamodelI am trying to add an analysis inside a datamodel created through subject area, but when I click on view to see the information the application takes a long time and at …SERGIO BARRETO 126 views 12 comments 0 points Most recent by Prabha.R Oracle-Oracle Reporting & Analytics for Sales -
Unable to find table name that stores comments from 'Request more Info' section of BPM approvalsSummary: Hi All, Unable to find where the comments are stored from 'Request more Info' section of BPM approvals. It's not in table FND_BPM_TASK_COMMENT or HRC_TXN_COMMEN…Nirmal Ignatius 21 views 3 comments 0 points Most recent by Satyam Roy Reporting and Analytics for HCM -
Sample query to retrieve employee DivisionSummary: Content (please ensure you mask any confidential information): Hello experts, we need to retrieve the employee division name. Do you have a sample query to do i…Valerio Curzi 522 views 6 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
BI Report on candidate interaction date as per applicationNeed BI Report on candidate interaction date as per application. Code Snippet (add any code snippets that support your topic, if applicable):Aishwarya Somvanshi 11 views 3 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
FTE and Headcount no longer in per_all_assignments_m tableSummary: Is there a reason why FTE and Headcount no longer in per_all_assignments_m table? Content (please ensure you mask any confidential information): Version (includ…Consultant Ian 21 views 2 comments 0 points Most recent by Consultant Ian Reporting and Analytics for HCM -
Which table store user password and Password expiration DateSummary: Hi , Please let us know Which table stores the user password and Password expiration Date under User definition. Navigation : Tools-> Security Console-> User At…
-
Query to join BEN_PRTT_ENRT_RSLT to Payroll Tables (PAY_RUN_BALANCES)Summary: Hi experts, Just wondering if there's a way to connect the benefits table BEN_PRTT_ENRT_RSLT to payroll table (ex. PAY_RUN_BALANCES). We have a BIP report requi…
-
Change format date for Completion Course Certificate templateSummary: Hello all, We're modifying the data template for the Completion Certificate Course using BI Publisher. We need to change "COMPLATION DATE" data format. Analyzin… -
FA to GL Reconciliation Report at Asset Category (Capital Asset Rollforward Report)Hi Team We are building a custom report to reconcile FA cost and Accumulated depreciation balances between FA and GL, at the Asset Category level.. We are facing few cha… -
In oracle fusion Expenses in which table we will get itemization dateEmployee expenses Itemization date in which table we will get .For itemization few expenses I am getting wrong date in EXM_EPENSES table START_DATE column I considered a…
-
Report of edited termination datesSummary: To assist with researching retroactive payroll scenarios, we would like to report on employees who have edited/corrected termination dates. We would like to sho…awheel09 31 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM