BI Publisher
Discussion List
-
Function "per_bipntf_flex.getEFFAttributesFromCompare" is not retriving the data properly.Summary: We are using TABLE(per_bipntf_flex.getEFFAttributesFromCompare(htd.TRANSACTION_ID, 'Responsive', 'j_CategoryPerAsgEitResponsiveEmplFlowsVORow','FALSE')) functio…Maran Aswin 164 views 0 comments 0 points Most recent by Maran Aswin Reporting and Analytics for HCM -
23D:AUDIT MASS DOWNLOAD OF DOCUMENT RECORDS-hr_dor_mass_requestsHello All I am trying to query the hr_dor_mass_requests and its populating the values. It populates the numeric values for status and object version number as 3,4,7. wha…
-
Audit Report for Talent for changes in skills and qualification pageSummary: Audit Report for Talent for changes in skills and qualification page Content (please ensure you mask any confidential information): Hi Team, Greetings! Is there…Parag Hiremath 3 views 0 comments 3 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
Performance Document - Current ApproverSummary Need report for who is the current approver of a perfomance documentContent I have the report which shows the Next Performance task status. Which is great, but i…
-
Is there a way to auto-increment date parameter while running "Multiperiod accounting"process/reportSummary: We need "Create Accounting" and "Multiperiod Accounting" jobs to run daily. While the "Create Accounting" job’s date parameter is Incrementing automatically eve…Srikanth Dodla 184 views 1 comment 0 points Most recent by Priyaranjan Shetty-Oracle Payables, Payments & Cash Management
-
help to get SQL query to get the data from tax conditions to Value set valuesSummary: One of our tax determination factors is line account (one of the segments in CoA). We are looking for a report to get CoA values with tax rule name and tax rate…
-
Custom report is changed using page integration. But the link is showing the previous reportThe report is added to the home page as a page entry using page integration. Later the report path is changed and report is modified using page integration. However, the…Reshma Eldho 1 view 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Need to fetch the grade, grade step and grade rate at the employment level using BI reportSummary: Hi all I need to fetch the grade, grade step, and grade rate whichever assign to the person, but in my query, I am getting multiple grade steps assigned to the …Deepak Bhatt 3K views 11 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
ORA-01719: outer join operator (+) not allowed in operand of OR or IN with payroll reportHi, The environment was recently upgraded to version 24D. Following this upgrade, the payroll report started encountering the attached error during execution (ORA-01719:…Saurav R-Oracle 122 views 1 comment 0 points Most recent by Matthew Hancock Reporting and Analytics for HCM
-
How to return values within a subquery by referencing tables from outer query?Summary: Content (please ensure you mask any confidential information): How can I return the name of the task owner from Oracle HCM Journeys using the Task Owner Person …Giuseppe Cannova 32 views 2 comments 0 points Most recent by Ramchander Pothanolla Reporting and Analytics for HCM -
General LedgerI' like to output the SEGMENT values (SEGMENT1~12) registered in GL that have an enabled flag of 'N', column by column. To achieve this with BIP, which table should I re…
-
Query to find schedule details of a BIP reportSummary: Content (required): Hi Team, Is there a way to identify the schedule details of a BIP report like schedule start date, schedule end date, frequency etc? Version…MandeepGupta 1.3K views 8 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
how to customize employee promotion letter notificationSummary: how to customize employee promotion letter notification Content (please ensure you mask any confidential information): Hi Team, We got a requirement to add new …
-
sql query to get all the team members approved/rejected expenses reports data by passing manageridSummary: is there any sql query available for manager to get that will return all of his employees expense reports data Content (please ensure you mask any confidential …
-
Need an SQL to list out all the Corporate card Transactions with Respective MCC codeSummary: Need an SQL to list out all the corporate card Transactions with Respective MCC codes & Expense Types -
Last modified date of Payables Unaccounted and Sweep Report does not match with 24C/24D upgrade dateHi, 24C patch was applied to our systems in August-24 and 24D in November-24, but the last modified date of Payables Unaccounted and Sweep Report is 10/3/24. The auditor…Pranita 51 views 4 comments 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management
-
I am not able to fetch the pay value for Social Security DeductionsI am not able to fetch the Pay Value of Social Security Deductions For Oman Salary Payment Report in Oracle Fusion Cloud HCM . Can someone help me out with the query or …Tuhinaa Nanda 2 views 1 comment 0 points Most recent by Tuhinaa Nanda Reporting and Analytics for HCM
-
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 181 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 11 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 22 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 12 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 72 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
-
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 153 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 517 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM