BI Publisher
Discussion List
-
Need help in getting the query to fetch Candidate Extra Info from ORCSummary: I have been trying to look for tables that stores the Extra Info section details on the Candidate profile in ORC. If anybody has worked on it, can you share the…Rini_Varghese-Oracle 11 views 2 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Steps to get BI Server LogsSummary: Steps to get BI Server Logs Content (please ensure you mask any confidential information): Hi Team, Greetings! For troubleshooting a report failure related issu…Parag Hiremath 11 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM -
Query to get REQUISTION NUMBER, REQUISITION NAME, CANDIDATE SELECTION PROCESS, REQUISITION STATUSSummary: Can anyone please help me in writing a Oracle SQL Query for BI Report to fetch columns like REQUISTION NUMBER, REQUISITION NAME, CANDIDATE SELECTION PROCESS, RE…a.w.anand 3K views 9 comments 0 points Most recent by Gongati Nandish Kumar-Oracle Reporting and Analytics for HCM -
401K Annual Census ReportSummary: We are new to Oracle Cloud and looking for a 401(k) or 403(b) Annual Census file. It would include Name, SSN, DOB, Hire Date, Term Date, Status, Gross Earnings,…
-
BI query returning learner activity score returns blank after Redwood implementationSummary: We have implemented Redwood 24D release this month. A query that was initially returning scores of employees is now returning blank data Content (please ensure …
-
Fast Formula with FF type "Extract Criteria" is not working when we are trying to add it in extract.Summary: Hi Team, We have designed extract to pull the employee assignment details but it was picking the multiple records for an employee. We used fast formula in "Filt…
-
Is it possible to add a Field Tag inside the Textbox in RTF TemplateSummary: We have a requirement to add name field inside a text box and add a photo inside a circle shape. I tired, but not able to add those fields. I even tired to add …Sujeeth Chinta 83 views 9 comments 0 points Most recent by User_OCKZO Reporting and Analytics for HCM -
Impact of overriding OBSOLETE with ERROR status in WLF_LEARNING_EVENTSummary: Impact of overriding OBSOLETE with ERROR status in WLF_LEARNING_EVENT Content (please ensure you mask any confidential information): Hi Team, Greetings! We have…
-
Trying to Retrieve the Specific Ethnicity Record Associated with each Period of ServiceSummary:It appears that there is a separate row in table per_ethnicities for each of an employee's period of service. Looking for a query Content (please ensure you mask…ChicagoConsultant 1 view 1 comment 0 points Most recent by ChicagoConsultant Reporting and Analytics for HCM
-
Is there a link between Contact and Bank account?Summary: We want to develop a report which list all the active bank account with their specific contacts. Content (required): I have been able to link the 2 using BI pub…Remi Grégoire-Jacques 31 views 3 comments 0 points Most recent by S.heha.n Payables, Payments & Cash Management
-
How do I access BI Publisher Logs in the HCM OTBI / BIP application.Summary I have a dashboard with prompts for a BIP report and all of the prompts work except two. How can I access the log files for the BI Report so I can see the variab…
-
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.4K 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 21 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 13 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 301 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 543 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.2K 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 …