BI Publisher
Discussion List
-
SQL query to retrieve employee country (work relationship level)Summary: Content (please ensure you mask any confidential information): Hello experts, is there a way to retrieve Country field at the employee level by SQL query? If so…Valerio Curzi 579 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM -
"Test Notification Email Address" TableHi, Is it possible to query the BPM Worklist "Test Notification Email Address" from a table? Thanks, Derrin -
The XML which we have pulled for the Job History doesn't hold the Job statusThe XML which we have pulled for the Job History doesn't hold the Job status if it is success or failed the against individual employee if the job is success of failure …Shanmukhi 1 view 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
how to convert blob type to actual text in oracleSummary: the underlying tables store the xml data of employees in blob format, the customer wanted to see the exact content of this File_data column in output results.. …Rama123-Oracle 41 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
ar invoice dff freezed after invoice completionSummary: Hi Team, we have a requirement to update the Invoice line DFF after the receipt is created for that invoice and status needs to be updated based on the Json fil…Aru Chauhan 21 views 1 comment 0 points Most recent by Mallik Durgumpudi-Oracle Receivables & Collections
-
Time Change Request reportSummary: Hi All, Has anyone Developed a BI/OTBI Report on Capturing Details of Time Change Requests? We have a requirement and working on this. Appreciate if anyone can …Abhishek Bhaskar 76 views 3 comments 1 point Most recent by Peeyush Chandel Reporting and Analytics for HCM -
BIP Query to Retrieve Learning Course and Associated Prerequisites DetailsBIP Query to retrieve learning Course and Associated Prerequisites details: Course Name, Course Number, Prerequisites
-
Getting an Error in BIP Report: ORA-01427: single-row subquery returns more than one rowSummary: Currently, we are using the attached data model to generate a BIP report for Employee leave Details which is working perfectly. We got a requirement to get the …sayeed_ahmed 106 views 4 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
How to get one time data in audit tables after enabling auditing for HCM processes.Summary: How to get one time data in audit tables after enabling auditing for HCM processes. Content (please ensure you mask any confidential information): We have enabl… -
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 3.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 81 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.6K 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 11 views 3 comments 0 points Most recent by gclampitt Reporting and Analytics for HCM