BI Publisher
Discussion List
-
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 54 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 11 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 32 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 join ra_customer_trx_all (AR Header Table) with projects tables to get the project NumberSummary: We are Trying to get the 'Project number' field in the 'Manage Transactions' Header Screen inside 'Billable' in Receivables. We are unable to find direct join t…PrerakKhandelwal 321 views 2 comments 0 points Most recent by Jesús Vega-Oracle Receivables & Collections
-
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 11 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 21 views 0 comments 0 points Started 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 212 views 1 comment 0 points Most recent by Srikanth Mandapati Panduranga-Support-Oracle Workforce Management
-
Direct Link to Travel and Expenses Work AreaSummary: Take user directly to their work area via embedded link Content (required): Via BIP, we burst out an email reminding our users that they have aged corporate ite…
-
Oracle HCM Cheque Report any issues in customizing a template for itSummary: Have been asked to create a customized template for the seeded report and check printing into a tri-fold check printout. I have not dealt with this report befor…
-
Inbound HCM Extract to compress multiple reports in a Single Zip FileSummary: Hi, We have a Inbound BI Report created. The Inbound Interface HCM Extract needs to run multiple reports and compress all those reports into single zip file and… -
I need to get a link to see a dashboard without settings pannel.Summary I need to get a link to see a dashboard without settings pannel.Content Hi, I have a dashboard that I have to link in the employees profile. Our customer needs t…Pablo Martinez de Villa De las Heras 121 views 16 comments 0 points Most recent by Tomasz 'TJ' Jublewski Reporting and Analytics for HCM -
which table having the United States Job Information under the Manage Job setupSummary: Hi Team, We could not find the right table for "United States Job Information under" the "Manage Job setup" We have gone through multiple table but we are unabl…Opkey PA 11 views 1 comment 0 points Most recent by Martina Iovino-Oracle Reporting and Analytics for HCM
-
SQL Query to fetch Configure Negotiation Award Outbound Service in oracle fusionSummary: Content (please ensure you mask any confidential information): We required table to get the columns in the screenshot Version (include the version you are using…Chintan_KRishna973102 32 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
Which SQL table stores the Transfer Order Receipt Distribution Journal EntriesSummary: I am aiming to write a report that joins the 'journal entry account' - pictured below, all the way to the INV_TRANSFER_ORDER_LINES table using source document n…MichaelV823 12 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
Seeking guidance on SQL querySummary: Hello, can someone please advise how to transform this query in order to return only records where a combination of (esib.item_number, hp.party_name, and pltl.l…MichaelV823 11 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
Audit Cancelled Reqs that were tied to an open Purchase Order at time of cancellationSummary: Is there a way we can write a query/check an audit file that contains history of all requisitions that were cancelled that were already tied to an open Purchase…MichaelV823 1 view 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM