BI Publisher
Discussion List
-
Is the default MICR MT in MS Word a licensed monotype font?I'm trying to figure out if our check templates will need updated for the 24A release and am getting the run-around. Does anyone know if the default MICR MT font that is…KatieW_IUH 171 views 3 comments 1 point Most recent by Gerardo Carrillo Payables, Payments & Cash Management -
sample query to check Invoice/Credit Memo has been posted to GLHi Team, Need sample sql to check Invoice/Credit Memo has been posted to GL or not
-
Need inputs to use :{PARAMETER.P_TIMEZONE} in the Value set from clause.Summary: Need inputs to use :{PARAMETER.P_TIMEZONE} in the Value set from clause. Content (please ensure you mask any confidential information): In the custom HCM Extrac…
-
HSDL Updates to Requisition are not captured in IRC_LC_HISTORY TableSummary: When a requisition is updated using HSDL and if EXT_PUBLISH_JOB_STATUS , EXT_PUBLISH_JOB_END_DATE columns are being updated without any change to phase or state…vinay karumanchi 12 views 1 comment 0 points Most recent by Madalina Danis-Support-Oracle HCM Spreadsheet Data Loader (HSDL)
-
HCM Embedded BIP ReportsSummary: How to show BIP report with parameter in Comp landing page Content (please ensure you mask any confidential information): I'd like to show Embedded BIP Reports …CHANZAWA-Oracle 21 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
How to create a custom report in BIP with calendar .ics as attachmentSummary: If we need to create a BIP report which has calendar invite .ics as attachment along with other content in email, how can we do that? The requirement is the ema…Hemali Khatri 11 views 2 comments 0 points Most recent by Satyam Roy Reporting and Analytics for HCM -
Database table to get the min and max quantity for Replenishment plan type item in oracle fusionSummary: Hi all, please let us know Database table which stores min and max quantity for Replenishment plan type item in oracle fusion Content (please ensure you mask an…User_WCAA0 62 views 3 comments 0 points Most recent by Paul H - Terillium Reporting and Analytics for SCM
-
custom report in Thrive that relates to competency assessments within an individual’s profileHi, I am looking to build a custom report in Thrive that relates to competency assessments within an individual’s profile. There doesn’t seem to be a suitable native rep…Chintan Shyara 1 view 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
How to pull data in Power BI from Oracle Fusion/ATP TablesSummary: How to pull data in Power BI from Oracle Fusion Content (please ensure you mask any confidential information): We are looking to pull data in Power BI from Orac…Abhishek Sinha 111 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales
-
Changing Oracle out-of-the-box data model of invoice print templateSummary: We have a requirement in the invoice print template to group and print the Bundle Name for lines with a bundle and just the product name for lines that are not …
-
How to enable Report Job History to BI Consumer in Home page of BI Catalog?Summary: Please refer to the BI Catalog Home page of BI Author and BI Consumer. How to enable also Report Job History link in Home page of BI catalog to BI Consumer? Wha…CS Yuen-Oracle 122 views 2 comments 0 points Most recent by CS Yuen-Oracle Reporting and Analytics for HCM
-
BIP Query to Retrieve Learning Course and Associated Learning Outcomes DetailsBIP Query to retrieve learning Course and Associated Learning Outcomes details: Course Name, Course Number, Mapped section name and skills
-
Error Installing BI Publisher - Set Word2007 flg failedSummary: Receiving an error when trying to install BI Publisher Content (please ensure you mask any confidential information): I am currently trying to install BI Publis…Becky Mixon 461 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
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 541 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 42 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 71 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 102 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 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…