BI Publisher
Discussion List
-
bursting is not workingSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t… -
Unable to view the Export option while accessing the OTBI report via Performance TileSummary: Hi. I think I have a similar issue to https://community.oracle.com/customerconnect/discussion/561120/unable-to-view-the-export-option-while-accessing-the-otbi-r… -
I embedded a BIP report in front end. But refresh button is causing problem.I embedded a BIP report in front end. But refresh button is causing problem. First I have to click apply and then refresh button (green higlighted) then only report is a…
-
What are the Scheduled Process Tables that could connect to the business unitI'm trying to get the connection of the tables uses to store the scheduled process and join it to the table of business unitShe_1080 31 views 1 comment 0 points Most recent by Sridhar Gupta Yerram-Oracle Reporting and Analytics for ERP
-
How to generate the BIP report with the user time zone rather than the server time zone?Summary: Our reports are generated in UTC time zone, especially when it comes to Exit reports the LWD & the submitted dates are not matching because of time zone differe…Elavarasan S 183 views 2 comments 0 points Most recent by Elavarasan S Reporting and Analytics for HCM -
Custom report Layout/Template not showing for a user for Accrual Reconciliation ReportSummary: Custom report Layout/Template not showing for a user for Accrual Reconciliation Report Content (please ensure you mask any confidential information): We previou…
-
Is it possible to report on default validity rules of courses?Summary: Is it possible, using BI Publisher or OTBI, to report on courses Default Assignment Rules (specifically the fields: Validity Period Starts/Validity Period Optio…
-
How to fetch current incumbent name for a Position_code/position idSummary: Please Help! Please share your insights ASAP! I need help in fetching current incumbent name tagged to a position code. I wrote the query like this : SELECT DIS…
-
Bursting Issue in Balance Forward Billing ReportSummary: We are encountering an issue with bursting in the customized Balance Forward Billing seeded report. Content (please ensure you mask any confidential information…
-
Reporting employee access to dataHello Experts, It was rise as a demand the possibility to have a report on what employee has access of country data, i was trying to use per_person_secured_list_v and pe…Lucas B Maciel 21 views 3 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
how can i fetch in bip report parent position name and parent position code for a position codePlease Help Me! Need to write a sql query for all the position details, in which i need to fetch parent position name and parent position code, how can i fetch that in b…ANNU10 21 views 4 comments 0 points Most recent by Carl Bequilla-Oracle Reporting and Analytics for HCM
-
Need SQL query to get Set General PreferencesSummary: We need a query for the setup Set General Preferences as shown in the UI. We are unable to get Date format, Time format and Time zone as shown in UI page. For e…Opkey PA 64 views 3 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
Dependents not displaying on reportSummary: I had a detailed Benefits Enrollment report that had the employee's information and dependent information displaying on the same report. I started with Benefits…
-
Table name or column name to fetch the accounting date for Expense Report (Payables Invoice)Summary: Hi Team, We have a requirement to fetch the accounting date for Expense Report after transferring them to the payables. Please let us the table name or column n…
-
Enquiry on usage of FA extract tables for developing BIP reportsWe have a requirement to develop BIP reports. We already have the FA extract process run post every period close. Wanted to check the feasibility of using FA extract tab…
-
We need some assistance to create a report from the budgeting systemSummary: There is a requirement to create a report from the budgeting system with the fields 1.Budget year 2.IT Budget allocated by Business Unit 3.IT Budget - Actual vs…
-
Query to get the Job Requisition Approver details in BIP ReportSummary: we are trying to get the details of Job Requisition approval flow. precisely we wanted to get the details:::: with whom the Requisition is pending with? Content…User_2025-03-07-05-34-02-150 1.6K views 9 comments 0 points Most recent by User_YG5HR Reporting and Analytics for HCM
-
Do we have any WebService to display the list of reports in Oracle Fusion ?Summary: Hi Team , Do we have any WebService to display the list of reports in Oracle Fusion ? ** i have used the table : GL_FRC_REPORTS_B , but its of not much use - as…Sridhar Gupta Yerram-Oracle 1 view 1 comment 0 points Most recent by Ayala01 Reporting and Analytics for ERP
-
Query/tables to find payment approved by final approver approved PPRSummary: Query/tables to find payment approved by final approver approved PPR Content (please ensure you mask any confidential information): Hi All, We got a requirement…Venkatesan 13 views 1 comment 0 points Most recent by Alexandra Tam -Oracle Payables, Payments & Cash Management
-
Tax Audit Trail Report export to excel doesn't have transaction num but html and pdf does have it.Summary: Export to excel different than html and pdf export. Anyone else have that issue? Content (please ensure you mask any confidential information): Version (include…
-
Trace the processing details of scheduled BIP ReportSummary: Trace the processing details of scheduled BIP Report Content (please ensure you mask any confidential information): Hi Team, Greetings! What are the best option…Parag Hiremath 31 views 2 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
Learning Sql to fetch Analysis Report CriteriaIs it possible to fetch Analysis Report Criteria name associated to course. I have found the table(WLF_BI_ANALYSIS_DESTINATIONS) which stores the Analysis Report Criteri…
-
How to refresh data in GL_FRC_REPORTS_BWe have requirement to fetch all the report details from given instance. Table Name : GL_FRC_REPORTS_B ( this table doesn't contain the updated data) What are the steps …
-
What is the Subject Area to retrieve Invoice DetailsSummary: We are currently retrieving invoice details using a DM (Data Model) report with the SQL query provided below. Now, we want to create an Analytics Report using a…Anusha716 14 views 1 comment 0 points Most recent by Prabha.R Oracle-Oracle Reporting & Analytics for Sales
-
Why cant I find AI Apps Administrator under Tool (quick link)Summary: We planned to use newly (23B) rolled Intelligent Account Default AI feature in Fusion Payables. The first step is to add role 'Application Implementation Consul…Bikash Khilar 391 views 21 comments 0 points Most recent by Beat Nuolf-Oracle Payables, Payments & Cash Management
-
How to add security on custom BIP folderSummary: We want to implement security to a custom BIP folder to give restrict access of some users to it. How can we do that? Is there something we can do in permission…
-
Segregating the success and error report to different email id through SOAP UI Request PayloadSummary: I did a POC , using the SOAP UI Payload request i'm able to get the email notification to multiple emails. but the expectation was like for success report we wi…Ankita Mohanty 22 views 0 comments 0 points Most recent by Ankita Mohanty Reporting and Analytics for HCM
-
How to fetch amount delivered on PO through SQL QueryWe have a custom Purchase History BI report that gives entire PO history. This report also has columns named quantity_delivered and amount_delivered which are being fetc…Pranita S 1.2K views 7 comments 0 points Most recent by Rakesh Sreenivasa Reporting and Analytics for ERP -
Employee time card punch in, punch out details SQL query in OTL fusion HCMSummary: Hi Team, We have a requirement to send notification to employees who has missed their time card punch in, punch out. Can anyone please help me with the sql quer…Prasad Singamaneni-Oracle 270 views 1 comment 0 points Most recent by Srikanth Mandapati Panduranga-Support-Oracle Workforce Management