BI Publisher
Discussion List
-
Sql query to get cost code effective start date and effective end dateSummary: Sql query to get cost code effective start date and effective end date Content (please ensure you mask any confidential information): Version (include the versi…Anup Karmankar 71 views 18 comments 0 points Most recent by Anup Karmankar Reporting and Analytics for HCM -
GL Audit Trail Report not availableHi All, I am just trying to run the GL Audit Trail Report by below path, but report is not available. Steps to Search in BI Catalog: Go to Reports and Analytics > Browse…
-
adding different manager types to analysis reportsHello there, I have prepared a report from the analysis and in this report I would like to see the types of managers that people are affiliated with, such as head and ex…Sinem Kara 21 views 4 comments 0 points Most recent by Girish Kushibi Reporting and Analytics for HCM
-
Query to retrieve Payroll Relationship information at the employee levelSummary: Content (please ensure you mask any confidential information): Hello experts, please could you share a sample query to retrieve the attached data visible in the…Valerio Curzi 1.5K views 2 comments 0 points Most recent by Ramchander Pothanolla Reporting and Analytics for HCM -
Selection Methods in Learning InitiativesSummary: Need SQL Query to extract Selection Methods in Learning Initiatives When you edit an initiative, there's an option Selection Methods in the step 2
-
learning initiatives querySummary: When you edit an initiative, there's an option to use an Analysis in the step 2 Select Learners. Is there a way to pull all the courses, initiatives and the cor…
-
Need to generate a sequence number in outbound file at BIP. How to achieve thatSummary: Need to generate a sequence number in outbound file at BIP. How to achieve that Content (please ensure you mask any confidential information): Need to generate …Ishtiaque AHmed 22 views 4 comments 0 points Most recent by gclampitt Reporting and Analytics for HCM
-
Please Help with Audit approval QuerySummary: The auditor has requested the dates of the last updates made to our Audit approval rules for the following areas: Job Offer Job Requisition Approval Termination…Global Support Desk 12 views 3 comments 0 points Most recent by gclampitt Reporting and Analytics for HCM
-
Expenses - Expense Transactions Real Time "The specified criteria didn't result in any data.I am facing same issue not able pull expense details from Expenses - Expense Transactions Real Time " Subject area. Only details from Employee folder are populating. if … -
Payables Invoice and Supplier Balance Aging reports complete in ErrorSummary: Content (required): Hi, We have created a custom role to run AP related reports. It includes the below privileges and duty roles; Privileges Submit Payables Inv…Sheneli98 312 views 8 comments 0 points Most recent by Udhaya Kumar S Payables, Payments & Cash Management
-
Is there a SQL query that will show when last a BI Report has been run by a user?Summary Is there a SQL query that will show when last a BI Report has been run by a user?Content Hello Is there a SQL query that will show when last a BI Report has been…IanDeKoker 546 views 13 comments 0 points Most recent by Sharmila Ravi Reporting and Analytics for HCM -
To report performance document status related information and rating detailsSummary To report performance document status related information and rating detailsContent Hi , Planning to build a report to show performance document status of a pers…Phani S-Oracle 182 views 7 comments 1 point Most recent by Pavan Kumar Thummalapalli Reporting and Analytics for HCM
-
Query to extract Journey ID, Journey Name and task IDSummary: Content (please ensure you mask any confidential information): Hello experts, do you have a query retrieving all Journey details loaded at the employee level? T…Valerio Curzi 1.3K views 3 comments 0 points Most recent by Ramchander Pothanolla Reporting and Analytics for HCM
-
How can we disable Scheduled Process module under tools from user's account?Summary: We need to disable Scheduled Process module under tools from user's account, so that they can't run jobs manually. Content (please ensure you mask any confident…
-
How to see Rest api results? Which privilege I need?I have a custom page that shows customers data, but I think I need a privilege to access on Rest api service, because with standard AR roles I can't see nothing. someone…
-
Absence DFFSummary: Dear All, I have created global DFF in the absence page and I want to show them in the analysis report for, I already use ( Workforce Management - Absence Real … -
Transaction Awaiting Consolidation ReportSummary: We had this report is EBS R12 and it will shows all the AR transactions including Credit Memo, Debit Memo and Chargeback. Shall we have the same kind of report …
-
Interface tables used in the Fusion Accounting Hub Import process (Import Accounting Transactions)Summary: Can someone provide details about the interface tables used in the Fusion Accounting Hub Import process (Import Accounting Transactions)? Specifically, I am loo…Singhi, Govind 193 views 4 comments 0 points Most recent by Singhi, Govind Subledger Accounting & Accounting Hub
-
How to Output a Table Entered in HTML Format in a Document Using BIPSummary: I am creating a document using BIP. I want to output table data entered in HTML format. I would like to confirm the following two points: What kind of SQL state…
-
Need a report which can provide details if any scheduled job runs and BI report run got missed.Hi Team, We have a requirement in place that if any report schedule and job schedule got skipped due to any reason then we need a BI or OTBI report by which we can track…Sanchit_Jauhari_2211 31 views 3 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
How to customize seeded Payment Register ReportSummary: How to customize seeded Payment Register Report Content (please ensure you mask any confidential information): Hi All, We got a requirement to add new columns i…Venkatesan 136 views 6 comments 0 points Most recent by Ramchander Pothanolla Reporting and Analytics for HCM
-
Query to get Statement of Earnings (Payroll -> Person Results -> Calculate Payroll)Team, It would be helpful if you can guide me on how to fetch Earnings Value. (Highlighted one).Manoharan 308 views 4 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
How to join a Timesheet Row to an Absence Row (HWM_TM_RPT_ENTRY_V to ANC_PER_ABS_ENTRIES)Summary: If we have a person with 2 timesheet rows on the same day, each representing half day of absence, and we have 2 absence rows each of a different absence type - …
-
Query to find details of Scheduled Processes ESS jobs?Summary: Hi Team, we have requirement to fetch all ESS jobs from Scheduled Processes UI. while i am checking the backend tables unable to fetch the name of scheduled pro…Vishnu_Jai 4.1K views 4 comments 0 points Most recent by Stephen Westerfield-Oracle Payables, Payments & Cash Management
-
what are the PVO's available for Legal Entity which can be used in Finance Module ESS JobHi, Could you please provide a list of PVO which can be used for Legal Entity in Finance Module ESS Job. Thanks, LakshmiLakshmiSahithi 1 view 1 comment 0 points Most recent by Mahesh Adivishnu-Oracle Receivables & Collections
-
Oracle Learning Cloud Bulk Processingwe need to have details about the ESS Oracle Learning Cloud Bulk Processing, which has been running in production. Is it possible to get these details via query? Do you …