BI Publisher
Discussion List
-
Employee time card punch in, punch out details SQL query in OTL fusion HCMSummary: Hi Team, We have a requirement to send notification to employees who has missed their time card punch in, punch out. Can anyone please help me with the sql quer…Prasad Singamaneni-Oracle 270 views 1 comment 0 points Most recent by Srikanth Mandapati Panduranga-Support-Oracle Workforce Management -
Direct Link to Travel and Expenses Work AreaSummary: Take user directly to their work area via embedded link Content (required): Via BIP, we burst out an email reminding our users that they have aged corporate ite…
-
Oracle HCM Cheque Report any issues in customizing a template for itSummary: Have been asked to create a customized template for the seeded report and check printing into a tri-fold check printout. I have not dealt with this report befor…
-
Inbound HCM Extract to compress multiple reports in a Single Zip FileSummary: Hi, We have a Inbound BI Report created. The Inbound Interface HCM Extract needs to run multiple reports and compress all those reports into single zip file and… -
I need to get a link to see a dashboard without settings pannel.Summary I need to get a link to see a dashboard without settings pannel.Content Hi, I have a dashboard that I have to link in the employees profile. Our customer needs t…Pablo Martinez de Villa De las Heras 122 views 16 comments 0 points Most recent by Tomasz 'TJ' Jublewski Reporting and Analytics for HCM -
which table having the United States Job Information under the Manage Job setupSummary: Hi Team, We could not find the right table for "United States Job Information under" the "Manage Job setup" We have gone through multiple table but we are unabl…Opkey PA 14 views 1 comment 0 points Most recent by Martina Iovino-Oracle Reporting and Analytics for HCM
-
SQL Query to fetch Configure Negotiation Award Outbound Service in oracle fusionSummary: Content (please ensure you mask any confidential information): We required table to get the columns in the screenshot Version (include the version you are using…Chintan_KRishna973102 31 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
Which SQL table stores the Transfer Order Receipt Distribution Journal EntriesSummary: I am aiming to write a report that joins the 'journal entry account' - pictured below, all the way to the INV_TRANSFER_ORDER_LINES table using source document n…MichaelV823 11 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
Seeking guidance on SQL querySummary: Hello, can someone please advise how to transform this query in order to return only records where a combination of (esib.item_number, hp.party_name, and pltl.l…MichaelV823 12 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
Audit Cancelled Reqs that were tied to an open Purchase Order at time of cancellationSummary: Is there a way we can write a query/check an audit file that contains history of all requisitions that were cancelled that were already tied to an open Purchase…MichaelV823 1 view 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
assignments rows are not end dating properly in bi publisherI am attempting to create a report on assignment data that will show all promotions for all employees. I have a functioning query that is pulling the correct data but us…
-
Query to get Sales order line with Kit item like 1.1..2Summary: Please help me determine if a Sales order line is a Kit item and the line number should display as 1.1.2, 1.1.3, etc. Content (please ensure you mask any confid…
-
How to Find Specialization Assignment of a Course Assignment in BIPHow can I find a learners associated specialization assignment from the course assignment? I've tried to use wlf_ar_relations_f because I was able to use that to find th…
-
Can Not Copy And Rename An Seeded HCM Extract such as "Payments"Summary: Hi All, When we are trying to copy the existing HCM Extract getting below error on the same instance. JBO-26041: Failed to post data to database during "Insert"…
-
In which table having the Workday informationSummary: Hi, We need a table to get workday information. For the setup: Manage Department have the workday information and we could not find the right table. Attached sc…
-
Check Print Page countHi Team, We have a requirement of developing a report which gives the count of pages that was used for a particular check in Oracle Fusion. Questions: 1. Are there any b…Sandipan Pal 1 view 1 comment 0 points Most recent by Nani Prasanth Doredla-Oracle Payables, Payments & Cash Management
-
Learn Module | SQL query to get specialization details , module name, offering name, enrolled learneContent Hi All, I am working on a report where I need to fetch specialization details and its' corresponding module name, offering name, enrolled learners, current statu… -
How to show Attachment Link in the ReportSummary Is there a way to show actual attachments link in a report whether in analysis or BIPContent Is there a way to report on actual attachment which was attached as …Prateek Parasar - GTUK, ACE Pro 1.5K views 25 comments 3 points Most recent by Neha_Naik004 Reporting and Analytics for HCM -
Steps to customize standard BI Report and Add ParametersContent Hello All, We have a requirement to customize standard BI Report to add parameters and modify the data model. Do we have any oracle document about this process ?…Sridhar Gupta 116 views 8 comments 0 points Most recent by Yugesh Keluskar Reporting and Analytics for ERP
-
Convert UTC timestamp data to Mountain Time using "Format Mask Feature" in Oracle Cloud BI ReportI am using below code in data model to convert UTC to MT in report output. But column looses formatting when exported in excel and used in Pivots. How to achieve the sam…DeepankarGera 12 views 1 comment 0 points Most recent by Sridhar Gupta Yerram-Oracle Reporting and Analytics for ERP
-
Table name or column name for expense accountHi Team, We have a requirement to fetch the account value and cost center information on custom expense report. Please let us know where can we fetch the GL Account info…
-
How to Find Table with Approver Details for General Ledger Lines.Summary I am trying to create a audit report for GL entries however i need to retrieve the journal approver details. Please advise which table would have this informatio…Dave Sherrard 589 views 9 comments 1 point Most recent by Deepak Kumar Dev-Oracle General Ledger & Intercompany
-
SQL Query service to extract the Payment Methods for all employeesSummary: I am trying to retrieve all current (i.e. 100%) bank accounts for all employees Content (please ensure you mask any confidential information): Would someone be … -
Trying to get BIP report to burst and consolidate on emailSummary: I am having trouble getting my BIP report to burst and consolidate delivery by email, even though the Enable Consolidate Output box is checked. I have been doin…
-
How to build query like audit report?Summary: Content (please ensure you mask any confidential information): I can run this Audit Report: Is it possible to query the database to obtain the same info? Versio…Stefano_Mazzocca 24 views 1 comment 0 points Most recent by Martina Iovino-Oracle Reporting and Analytics for HCM -
filter out html imputs in columnSummary: Im making a reporting for talent and need to filter out de html inputs in the Description field of the table HRT_CAREER_STATEMENT_ITEMS_V. is there a better way…Lucas B Maciel 11 views 0 comments 0 points Most recent by Lucas B Maciel Reporting and Analytics for HCM -
BI Tables storing legal employer addressSummary: Content (please ensure you mask any confidential information): Hello experts, do you know in which Oracle HCM table the legal employer address is stored? Thanks…Valerio Curzi 21 views 2 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Ability to run trial balance report ESS jobSummary: Oracle fusion user should be able to run only trial balance report seeded ESS job through his login. Help me with all the required privileges I need to add to m…Aditi Agrawal2650 393 views 2 comments 0 points Most recent by Kumar 57 General Ledger & Intercompany
-
In which table has the information of Manage Legal AuthoritiesSummary: SQL query or Table has the information of Manage Legal Authorities Content (please ensure you mask any confidential information): Version (include the version y…
-
Cannot get specific element entry values from XML data cache column for pending transactionSummary: We are not able to get the accurate element entry value from XML data cache element entry rows data , we are only fetching values if they have in element entrie…Kaustubh Deshmukh 12 views 1 comment 0 points Most recent by Soumya Suravita Reporting and Analytics for HCM