BI Publisher
Discussion List
-
bip query is very slowSummary: I have written a BIP query which runs fast in SQL Connect using one bind variable. When placing the query into a BIP report there are no issues but the query so…JDCal 82 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM -
Issue on value set retrieving custom field in person profileSummary: Content (please ensure you mask any confidential information): Hello experts, we created a custom value set retrieving a custom attribute in person profile. At …Valerio Curzi 1 view 3 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Cannot retrieve Manager IDSummary: Content (please ensure you mask any confidential information): Hello experts, I've created the attached value sets retrieving the employee Manager ID. If I laun…Valerio Curzi 11 views 3 comments 0 points Most recent by Valerio Curzi Reporting and Analytics for HCM
-
Extracting the "Write to person profile on completion" of a course "Skills and Qualifications" pageSummary: Hi We are currently trying to determine te perimeter of the courses that do not have correctly set the flag option "Write to person profile on completion" due t…
-
Help on manager hierarchy fast formulaSummary: Content (please ensure you mask any confidential information): Hello experts, I need to replicate the line manager hierarchy in compensation plan. However, we s…Valerio Curzi 32 views 0 comments 0 points Most recent by Valerio Curzi Reporting and Analytics for HCM
-
Query retrieving manager job nameSummary: Content (please ensure you mask any confidential information): Hello experts, how can I retrieve the line manager job name? I've used the following query but th…Valerio Curzi 101 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Query to retrieve employee Job nameSummary: Content (please ensure you mask any confidential information): Hello experts, do you have a sample SQL query retrieving the employee Job name visible in the ass…Valerio Curzi 696 views 5 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
sql to use in custom BIP report to restrict data dynamically based on the users data security&accessWe are trying to build an custom BIP report/sql script to restrict data dynamically based on the users roles and their data access in fusion (for example, to query AP in…daniel4u2uk 614 views 11 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
Termination Approval Process ReportHi… does someone have a report, either an OTBI or BIP, that captures the full termination process with comments, who it is/was assigned to, and status. We are having iss… -
Report a Course - Comment Attribute within OTBISummary: When a learner goes into learn and reports a learning item, a report is generated in OTBI and sent out to the recipients. This report does not include the comme… -
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 275 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] 73 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 73 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 22 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 77 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 397 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 162 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 739 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 22 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 23 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 41 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 122 views 12 comments 0 points Most recent by Prabha.R Oracle-Oracle Reporting & Analytics for Sales