BI Publisher
Discussion List
-
Are there User Entity for Individual Compensation Plan In HCM ExtractSummary: Are there User Entity for Individual Compensation Plan In HCM Extract Content (please ensure you mask any confidential information): Version (include the versio…Ketan-Oracle 12 views 0 comments 0 points Most recent by Ketan-Oracle Reporting and Analytics for HCM -
Separate Remittance Advice based on custom data modelSummary: Is there a way of customising the disbursement extract associated with the Separate Remittance Advice for cloud customers. Our requirement is to add details to …Tim2021 581 views 5 comments 0 points Most recent by Sai Revanth Payables, Payments & Cash Management -
Customizing Separate Remittance Advice Subject with dynamic valueSummary: Customizing Separate Remittance Advice Subject Content (please ensure you mask any confidential information): Hi Team we should customize the subject with PAYEE…Luca Nobili PWC 263 views 6 comments 1 point Most recent by Luca Nobili PWC Payables, Payments & Cash Management
-
why is there no EVENT_ID in FA_DEPRN_DETAIL for certain assets for depreciations?Summary: For certain assets, which have depreciation reserve balance and the account as shown in view accounting in Asset Inquiry screen. The Same asset, does not have E…
-
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 74 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…MudshaikhMub 2 views 0 comments 0 points Most recent by MudshaikhMub Reporting and Analytics for HCM
-
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 15 views 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 38 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.6K 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 2 views 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 12 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. Version (include the vers…
-
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 98 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 208 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 399 views 5 comments 0 points Most recent by Habiba KAYAAKAY Reporting and Analytics for HCM
-
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 65 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 38 views 2 comments 0 points Most recent by Umesh Chauhan Reporting and Analytics for ERP
-
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…
-
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 472 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 4 views 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 1 view 2 comments 0 points Most recent by Vishal Purohit Reporting and Analytics for HCM