BI Publisher
Discussion List
-
Need to display employee records transferred from Payroll to GLContent Hi All, We transferred the data from Payroll to GL. Now we need to display those records either in OTBI/BIP. Can you suggest do we have any subject area/BIP tabl… -
Query to fetch Transaction console entries along with multiple Approver detailsSummary: Need a Query to fetch Transaction console entries along with multiple Approver details Content (please ensure you mask any confidential information): Version (i…NagasaiM135 28 views 6 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for ERP
-
Need a query to get latest activation Date for Supplier Site so we need to restrict a custom reportHi Team, We built a custom report for Supplier and supplier site info and we got a requirement that we need to restrict the supplier sites which got recently activated i…Sarath Lakshman 17 views 7 comments 0 points Most recent by Shyam Patel Reporting and Analytics for SCM
-
Does BIP reports support docuSign?Summary: Content (please ensure you mask any confidential information): In this discussion it seems docuSign is not supported for BIP reports. Can someone from Oracle co…Stefano_Mazzocca 2 views 0 comments 0 points Most recent by Stefano_Mazzocca Reporting and Analytics for HCM -
Auto Refresh InfotilesSummary: Client would like an invoice “dashboard” experience in Oracle Fusion Cloud that updates in near real time (or auto-refreshes on a set interval) without users ma…
-
Auto Refresh InfotilesSummary: Client would like an invoice “dashboard” experience in Oracle Fusion Cloud that updates in near real time (or auto-refreshes on a set interval) without users ma…
-
How to search for future approvers in an approval process in Oracle HCM Cloud by query?Good morning! How are you? I have a question, exists any VIEW objects or table (Im creating a bi publisher) that I can use to get the information of all the approvers of…
-
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 669 views 5 comments 0 points Most recent by Sai Revanth 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 3 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 17 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 55 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 4 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…
-
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 217 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 435 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 117 views 5 comments 1 point 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 37 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 61 views 2 comments 0 points Most recent by Umesh Chauhan Reporting and Analytics for ERP