BI Publisher
Discussion List
-
Can we use invalid custom 'From email address' for BI Report Notification?Hi Everyone, We are trying to personalize 'Email From Address' for BI Reporting Delivery. We have changed 'Email From Address' by navigating to /xmlpserver → Administrat…BinduTammineni 2 views 0 comments 0 points Started by BinduTammineni Reporting and Analytics for HCM -
Issues while displaying Calnedar View in OTBISummary: Unable to call https://www.gstatic.com/charts/loader.js using Narrative view in OTBI Content (please ensure you mask any confidential information): We have a re…
-
Burst to Documents of RecordSummary BI publisher report bursting to DoR possible?Content Hey, We would like to create a BIP report (containing the approved notice period and other relevant data) in…Ann Van Roosbroeck 362 views 4 comments 2 points Most recent by Tara Samari-237472 Reporting and Analytics for HCM -
How to create an ER diagram that illustrates the relationship between tables within Oracle Fusion?Summary: How to create an ER diagram that illustrates the relationship between the PER_LOCATION_EXTRA_INFO_F table and the LOCATION_ID and LOCATION_NAME columns in HR_LO…Dhilip Kumar P. 8 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for HCM
-
Which table stores the acknowledgement date of performance document and comments entered by employeeSummary: We are trying to customize one performance module seeded report. In the report, we are trying to fetch whether document is acknowledged by employee or not. If y…
-
Need inputs to get the DFF fields in Worker folder in OTBI analysisSummary: Need inputs to get the DFF fields in Worker folder in OTBI analysis Content (required): We have few DFF fields in Employement and Person UI/Screen. As of now we…
-
SQL to retrieve employee name,person number,department name and department DFF detailsSummary: SQL to retrieve employee name,person number,department name and department DFF details Content (required): Hi All, Please share SQL to retrieve employee name,pe…C.R.Balaji 14.7K views 6 comments 0 points Most recent by Penmetsa_Sushma Reporting and Analytics for HCM -
Payroll query that fetches results only if Archive and Generate Payslips is run post Payroll runSummary: We have a requirement to fetch the run result values only if the Archive Periodic Pay results and Generate Payslips processes have been run for the person post …Pinky Mukherjee 707 views 5 comments 0 points Most recent by Vibha Pandey - Oracle Reporting and Analytics for HCM -
Why IRC_HTTP_REQUESTS is having blank when there is a data in Recruiting Messaging ConfigurationSummary: Hi Team, The SMS communication information is stored in IRC_COMM_ACCOUNTS but We are not getting anything in these tables IRC_HTTP_REQUESTS, IRC_HTTP_BODY_TOKEN…Opkey PA 3 views 1 comment 0 points Most recent by Prabhu Mohan-Oracle Recruiting, Opportunity Marketplace
-
Need inputs to fetch the Absence "Plan Use" informationSummary: Need inputs to fetch the Absence "Plan Use" information Content (please ensure you mask any confidential information): In the absence records, we need to fetch …
-
Audit Report - On Folder Permissions ChangesSummary: Content (required): We have a requirement on Auditing folder Permissions Changes on any OTBI folders This report in theory needs to show us When and Who and Wha…CB Trett 256 views 12 comments 3 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
Aggregate (sum) balance amounts by group in an RTF template (such as a Payslip)I've been asked to update a BI Publisher RTF template to consolidate a list of Payroll Balances by Reporting Name and Hourly Rate. The data in the XML extract appears in…Eric Geddes 452 views 6 comments 0 points Most recent by Himanshu Chavan Reporting and Analytics for HCM -
COUNT function in e-Text Template in BI Publisher with HCM extractSummary COUNT function in e-Text Template in BI Publisher with HCM extractContent I used count function in e-text template ,the count function returns no data, any thing…G Madatala 417 views 8 comments 0 points Most recent by Anupam Rana-Oracle Reporting and Analytics for HCM
-
query to identify the processed and unprocessed payroll transactions for BI reportsVersion (include the version you are using, if applicable): for version "Oracle Fusion Cloud Applications24A (11.13.24.01.0)".Immanuel Aruldoss 39 views 2 comments 0 points Most recent by Eric Geddes Reporting and Analytics for HCM
-
I am not able to get an etext output without Special charactersSummary: I am getting special characters in my etext output. I tried using UTF-8 character set, that still didnt help. I used save as encoding UTF-8 on rtf template. Tha…RohithGundreddy 8 views 0 comments 0 points Started by RohithGundreddy Reporting and Analytics for HCM
-
How to report on "Job Description" from "Job Profile"Summary: I need to report on job description and effective start/end date within each job [model] profile, but i can't seem to find it from BI. I tried to query few tabl…Adil_R 261 views 14 comments 0 points Most recent by Srinivas_Godari Reporting and Analytics for HCM
-
how to calculate average percentage of Budget Utilization in workforce compensation module?Summary: My requirement is to find out the average percentage of Budget Utilization in workforce compensation module. How can I derive that? Content (please ensure you m…Pritha 8 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
What table(s) joins the converted work assignment to the pending work assignment?Summary: I am seeking information on what table(s) joins the converted work assignment to the pending work assignment? Use case is that information stored on job offer a… -
Link between OTL time Entries with Element Entries or Calculation cardsContent Hi All, We enter data in OTL and transfer batch. Then calculation cards and Element entries will be created. We need SQL Query/OTBI link between OTL time entries…
-
Changing Date format to 'DD/MON/YYYY' in SQL for BIP reportHi, Can you please suggest how to change the Date format to 'DD/MON/YYYY' in the SQL for BIP Reports. Thanks in advance. -
How to report the 'Attachment Count' of a DoRSummary: How to report the 'Attachment Count' of a DoR Content (please ensure you mask any confidential information): Hi, we created a Document Of Record. The employee h…Barile Alberto 15 views 3 comments 0 points Most recent by gclampitt Reporting and Analytics for HCM
-
Physical Signature Example Report for JourneysSummary: In release 24B, Journeys introduces the ability for Physical Signatures to be captured in the Native Electronic Signature task types. Additionally, Native eSign… -
SQL Query to get Absence Qualified Entitlements for an EmployeeSummary Need an SQL query to build a BIP report similar to what is available on the Absence Records UI which provides details of qualified entitlementsContent I'm not ge…
-
BI Table with ActivityAttemptId or the ActivityAttemptNumberSummary: Hi, I need to load LearningRecordActivityAttemptV3 object. To use LearningRecordActivityAttemptV3, I need to uniquely identify the rows to update using either t…Camilla Crescenzi 93 views 2 comments 0 points Most recent by DanWoodward Reporting and Analytics for HCM
-
Need SQL query to get the report category details based on the HCM Extract nameSummary: Need SQL query to get the report category details based on the Extract name Content (please ensure you mask any confidential information): We need SQL query to …
-
How to connect Cloud Database to VS Code via Oracle Developer Tools for VS CodeSummary: We want to know if we can use Oracle Developer Tools for Visual Studio Code (SQL and PLSQL) extension to connect to Oracle HCM Cloud database. We are exploring …MaeHCM 60 views 2 comments 0 points Most recent by kollipara Bindu Bhargav Reporting and Analytics for HCM -
Bold letters are showing in PDF Output?Summary: We are facing an issue while generating PDF outputs for BI Publisher (BIP) reports. When the PDF output is generated using the RTF template, all the letters are…
-
BI Report: Empty report is downloaded eventhough the data is present in the view data modelSummary: Able to see the data in view data model. But in report, the data are not getting displayed and while downloading the report, Empty report is getting downloaded …SARAVANA KUMAR T-Oracle 124 views 5 comments 0 points Most recent by Lohit Kad-Oracle Reporting and Analytics for HCM
-
Data is not showing in BI after creating any TransactionSummary: Custom report is not reflecting data immediately after transaction is made in system. Content (required): We have created custom report which is based on absenc…
-
Personal Payment Method Processing OrderSummary: Hi all So I've seen this asked before on another post but there wasn't a solution. The processing order for Personal Payment Methods doesn't appear to match up …SimonG 81 views 7 comments 0 points Most recent by Divya Jayaraman-Oracle Reporting and Analytics for HCM