BI Publisher
Discussion List
-
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 79 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 161 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 729 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 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 121 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 532 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
-
Report to fetch void payment dateSummary: We are looking for a report with output similar to Payment Register Report but with an additional column to display the actual Void date. Content (please ensure…
-
BI Publisher Sending a report to FTP Server with SSHSummary: How do I schedule a report to be delivered to a destination configured with SSH authentication? Content (please ensure you mask any confidential information): H…
-
How to get the assignment name for an OTBI analysis?Summary: I need to know which subject area and fields I need to use, to get the employee assignment name for an OTBI analysis. Content (required): Assignment name Versio…Ayesha Iroshani 81 views 7 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Table used to store children custom objects!!Hi, We created Custom object "Proposal" and created child custom object from the parent object with name "Payment Plan" The parent custom object "Proposal" store its rec…Wesam Ibrahim 71 views 3 comments 0 points Most recent by Prabha.R Oracle-Oracle Reporting & Analytics for Sales