BI Publisher
Discussion List
-
Sending of analysis to managers via agentsSummary Sending of analysis to managers via agentsContent Hi - We have set up a number of Analysis which are currently being sent to different business units / locations…Roy Paolo Paunlagui 75 views 10 comments 0 points Most recent by Vivek Balchandani Reporting and Analytics for HCM -
BIP report to get the approval status with history and attachments for Leave encashment, salary trasSummary: Hi Experts Could you please help me with the BIP report sql query on how to get the approval status for DOR requests like Leave encashment, salary transfer lett…
-
How to get Branding Image URL for Course created in Oracle Fusion HCMHello Everyone, We are developing a custom report to list courses, and one of the requirements is to display or extract the URL of the uploaded branding image for each c…Sammeta Srividya 1 view 3 comments 0 points Most recent by ShahzaibShaukat Reporting and Analytics for ERP
-
Query to fetch "Issue Description" and "Resolution" for failed transactions.We had a requirement to display issue description and resolution for failed transaction. When we use table hrc_console_fault_details_vl hcfdv(for description and resolut…Nalsoft Pvt Ltd 21 views 2 comments 0 points Most recent by Nalsoft Pvt Ltd Reporting and Analytics for HCM
-
Query for Transaction Console transactionsSummary: Query for Transaction Console transactions Content (required): I am looking to write a query that contains the below information from the Transaction Console, r…
-
Query to extract attachment URL (i.e. Document of Records; Skill and Qualifications)Summary: Content (required): Hello experts, do you have a query to retrieve the attachment URL? In other words, I need to retrieve the URL for some Document of Records a…Valerio Curzi 1.5K views 11 comments 0 points Most recent by ValentinaG-Oracle Reporting and Analytics for HCM -
Page Customization: Pop up message on clicking Create ItemSummary: Customer have requirement to customize Clicking the Create Item “+” button in the Oracle Expenses module it should display a pop-up with cancel and OK options w…Manjusha ERP Tech09-Oracle 1 view 3 comments 0 points Most recent by Manjusha ERP Tech09-Oracle Expenses
-
Regarding - Alerts Failure during Bulk LoadSummary: We have implemented multiple custom BI Publisher–based alerts that are triggered on specific business scenarios and scoped to particular Business Units. During …Abdul Raqueeb 1 view 0 comments 0 points Most recent by Abdul Raqueeb Reporting and Analytics for HCM
-
Can we add parameters to the Standard ESS Job "Print Commercial Invoice Report"Summary: Hi Team, Business needs a parameter on the report which allow them to change the Title of the Proforma Invoice based on user selection like parameter Document T…
-
how to translate the AR Invoice Line Description to French in BIP Reports in BIP ReportsSummary: The customer has a business requirement to translate the AR Invoice Line Description into French for their reports. Language should be picked dynamically based …ramesh.daniyala.mcd 11 views 0 comments 0 points Most recent by ramesh.daniyala.mcd Receivables & Collections
-
ORA-01427: single-row subquery returns more than one row ERRORSummary: Have a Payroll Config workbook and returning error. We can't seem to identify the issue. it exists in one of the 3 attached data sets. https://us.v-cdn.net/6034…
-
Bursting to get xml as an attachment from xsl templateSummary: Hello Experts, I have a report where I am using xsl template as layout. Our requirement is to send the report output in xml format to the destination email, but…Jaswant Prajapati 91 views 2 comments 0 points Most recent by User_DXHDL Reporting and Analytics for HCM
-
Enterable Calculation Values on Calculation Cards - Query/ReportSummary: Enterable Calculation Values on Calculation Cards - Query/Report Content (required): Hi Team, Greetings! Does anyone have the report or query to extract the dat…Parag Hiremath 201 views 8 comments 1 point Most recent by Parag Hiremath Reporting and Analytics for HCM -
What tables to use to pull Learning Class Training Supplier?Summary: Need to find which database tables to use to pull 'Training Supplier' found in Oracle HCM Learning Classes Content (please ensure you mask any confidential info…marcfromhawaii 385 views 5 comments 0 points Most recent by Habiba KAYAAKAY Reporting and Analytics for HCM
-
Can we add parameters to the Standard ESS Job "Print Commercial Invoice Report"Summary: Hi Team, Business needs a parameter on the report which allow them to change the Title of the Proforma Invoice based on user selection like parameter Document T…
-
Need BIP report SQL query to get GL Balances by Posting Date in oracle FusionSummary: Customer is looking for following columns in the report -Ledger -Period -Posting Date -Account -beginning balance -period activity -ending balance tried to join…Kalyani-Oracle 24 views 5 comments 0 points Most recent by Kalyani-Oracle General Ledger & Intercompany
-
How to Sort the data in Resource AlertSummary: We've developed an alert which will notify line managers and listing the employee's (reporting to the line manager) who are all overdue in completing their lear… -
How to create positive pay file for outside checks recorded using Manual paymentSummary: Need to create positive pay file for payments recorded using Payment type = Manual while using the "create payment" functionality Content (please ensure you mas…Umakanth Saripalli 33 views 4 comments 0 points Most recent by Kish_Hariharan Payables, Payments & Cash Management
-
Impact of Redwood Changes on backend Tables (OTBI/BIP/FRS Reports)Summary: Any changes to database/table structure for Fusion Financials? Any guide/pointers on what's needed to be checked before/after migrating to Redwood for our exist…
-
Is it possible to track how many employees clicked on a particular tile in the HCM Open Page - Eg: PSummary Is it possible to track how many employees clicked on a particular tile in the HCM Open Page - Eg: Person ManagementContent Hi Team, Is it possible to track how … -
Create Rules XML File for BI Extender Automation under a custom roleSummary: How to allow ESS Job 'Create Rules XML File for BI Extender Automation' under a custom role (no privilege since a Java type program) Content (please ensure you …Umesh Chauhan 21 views 2 comments 0 points Most recent by Umesh Chauhan Reporting and Analytics for ERP
-
Is there any way to track Tile clicks by Users in HCM ?Hello Experts, Has anyone implemented or come across a supported method in Oracle Fusion HCM to track how often Home page tiles (e.g. Team Activity center) are accessed …
-
Scheduling in HCM ExtractWe have the following requirement for the extract and would like to seek inputs on feasibility and the recommended solution approach. Requirement: The extract XX needs t…
-
How to find the difference between two date attributes in eText templateSummary: We need to find out the difference between two dates and add 1 to the result in eText template. Content (required): We need to find out the difference between t…Meenakshi K 1.2K views 7 comments 0 points Most recent by Ruma Bhatnagar-Oracle Reporting and Analytics for HCM
-
Oracle HCM BI Table to retrieve employees Eligible for eligibility profileHi team, the client ask for creating a report to track Eligibility Profiles and Employees eligible for them. Is it possible to create a report like this "dynamically", s… -
OTBI analysis opens directly without showing prompt when opened from the reports and analytics pageHi team, Facing an issue where an OTBI analysis opens without showing any prompt from the reports and analytics page ( it's added to favourites ) but when opened by navi…Raghavendar 457 views 2 comments 0 points Most recent by CA Nirmal Choudhary Reporting and Analytics for ERP
-
How to Include Invoice Legal Entity in Custom Oracle Payment File for Third-Party IntegrationSummary: We are working on integrating Oracle ERP Cloud with a third-party platform to process Accounts Payable (AP) payments. The process involves submitting a Payment …Khushbu Mahindru 1 view 3 comments 0 points Most recent by Willson Mach Payables, Payments & Cash Management
-
Bursting Report for Line Managers - Future Hire Notifications (No Data Returned)Summary: Hi Community, I'm developing a bursting report in BI Publisher that will notify line managers about employees starting on their hire date. The report should run…Vishal Purohit 3 views 2 comments 0 points Most recent by Vishal Purohit Reporting and Analytics for HCM -
Historical FTE values in BICCHi, The customer would like to extract assignment history data, including FTE, using BICC. I found that we can retrieve historical assignment data through HcmTopModelAna…