BI Publisher
Discussion List
-
Fusion Ap Invoice Workflow TablesHello Support, We have a requirement to get and build a report of the data stored in WF_NOTIFICATIONS tables of Oracle EBS system to Oracle Fusion System. In EBS we have…Nalsoft Pvt Ltd 105 views 2 comments 0 points Most recent by Swapnil Kashid Payables, Payments & Cash Management -
Privilege required to see Home Phone and Home Email Address in BIP ReportSummary: Content (required): We have few BIP reports created to cater to the client requirement. We see that the report doesn't fetch the Home Email Addresses and Home N…Prajna Hegde 261 views 11 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Linking ce_statement_lines and ap_checks_allSummary: Hi all, I can't find a way to link the tables: ce_statement_lines and ap_checks_all. Is there any intermediate table to link these? Or any way to link bank stat…Sheik Shameem 61 views 4 comments 0 points Most recent by Sheik Shameem Payables, Payments & Cash Management -
SQL to retrieve all learner records with community and course taken detailsHi, How to generate a report with all learner learning records along with their course taken details and the associated Category Community and Topic Community? I am unab…
-
How to Fetch Data from SCORM Assessments in Oracle Fusion HCMHi, I am working on a report in Oracle Fusion HCM where I need to fetch data related to SCORM assessments. Specifically, I want to retrieve information such as patterns … -
Can we exclude Public Holidays when scheduling processesSummary: Our client has a requirement to exclude weekends and public holidays when scheduling, for some of the finance processes. We are able to see an option to exclude…Snehal H 41 views 5 comments 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management
-
Need to build report between Task and Call Report (created via Task Page)Summary: Created a Task > open Task Detail > Action > Create Call Report. So now we have Task and its linked call report. Now we want to create a BI Report which should …AMIT KUMAR YADAV 41 views 9 comments 0 points Most recent by Dimple-Nagesh-Support-Oracle Reporting & Analytics for Sales
-
Need query to get asset details as mentioned in the summarySummary: Hi, There is an asset which is placed in service in Jan-24.Suppose there is an amount adjustment done in Aug-24 to the asset and in oct-24 life in months adjust…Madhan NM 291 views 1 comment 0 points Most recent by Louise Gareau - Support - Oracle-Oracle Assets
-
BI report: how to differentiate between learning outcomes and prerequisitesHello, is it possible to differentiate between learning outcomes and prerequisites? which table can we use to retrieve learning outcomes and what table for prerequisites…Alessandra T. 1 view 1 comment 0 points Most recent by Elaine Berrick Reporting and Analytics for HCM -
What table that holds actual work schedule of employee ?I want a query that gets the actual work schedule of employee in this screen
-
What are the setups/steps needed to enable to print the checks in local language?We have a requirement from the Canada, that has to print the checks in their local language (Canadian French). Could you please provide the steps that need to enable in …Raju Thadakala_1234 41 views 3 comments 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management
-
How to develop a BIP / OTBI report to fetch details from VBCS pageSummary: Hi Team, We have a customized VBCS page for Inventory transactions. Our requirement is to develop a BIP / OTBI report to fetch details from the VBCS page. Is it…Dhilip Kumar P. 42 views 5 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for SCM
-
Need an SQL Query to get the questions in learning module evaluation section shown in image?Navigation in user login:- Me→ Learning→ select any completed course→in default section select evaluation and click on review attempt We can see the questions in above n…
-
Dynamic Payroll Relationship group not working as a parameterSummary: We have a requirement to add Payroll Relationship group as a parameter to a custom BI report. While running with this parameter, the report runs fine with stati…
-
Consolidated List of OTBI and BI Publisher Reports Posted (14 April 2015)Content The following is the list of published OTBI and BI Publisher reports between 10 December 2014 and 10 February 2015: * OTBI: Employee Salary and Performance Ratin…Julian Challenger-Oracle 298 views 3 comments 3 points Most recent by Ms_Oracle Reporting and Analytics for HCM -
Can any one share sql query to fetch employee contacts details(contact person_id,date of birth)Summary: I have a requirement to fetch employee conatct details(Children),contact person Id, date of birth and their marital status, can anyone help me? Content (please …Lakshmi Devi Bathala 1.1K views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
2717700.1Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Prasad Singamaneni-Oracle 11 views 1 comment 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
How to get the bank account assigned to a party siteSummary: We need to list all bank accounts being used by sa party site. Bank accounts that we can see when we navigate to Manage Suppliers page Content (required): We ar…
-
SQL query to retrieve the canceled invoices amount as per the date for AP aging report.((select sum(aia1.CANCELLED_AMOUNT) from ap_invoices_all aia1 where 1=1 and aia1.APPROVAL_STATUS = 'CANCELLED' and aia1.invoice_id = aia.invoice_id AND :as_of_date < aia…Vikas V. Kamat 497 views 4 comments 0 points Most recent by Vikas V. Kamat Payables, Payments & Cash Management
-
Query to get payment method field in Order Management in Oracle FusionContent Hi all, Can someone tell me from where I could pick the payment method field mentioned at the front end of the Order management page? I have checked for the tabl…Sushan Peiris 1.2K views 2 comments 4 points Most recent by Shishir Dhone Reporting and Analytics for SCM -
Digital Signature in RTF templatesSummary: Hi Team, Could you please advise on how to enable digital signatures in RTF templates that span multiple pages? According to the documentation, it seems we need… -
Process Payment Files > ISO 20022 SEPA > Credit Transfer Messages > Predefined BI Publisher TemplateSummary: Process Payment Files > ISO 20022 SEPA > Credit Transfer Messages > Predefined BI Publisher Templates Content (required): Hello All, Regarding the ISO 20022 SEP…Bernard T 11 views 2 comments 0 points Most recent by Glen Ryen Payables, Payments & Cash Management
-
How we can determine which report an employee has downloaded on PCSummary: Hello all , Can we get the information which report is been downloaded by employee on there PC Content (please ensure you mask any confidential information): Ve…
-
Required List of all custom and seeded BIP report having xls output formatSummary: Can Oracle provide list of all custom and seeded report having xls output format from fusion bi publisher? Content (please ensure you mask any confidential info…Punam Roy Karmokar 51 views 7 comments 0 points Most recent by Punam Roy Karmokar Reporting and Analytics for HCM -
Get the description of a value in a valueset using HCM ExtractSummary: Hi, I need to extract the field description from the value set for each value and I need to insert the description as an attribute in the HCM extract Content (p…
-
sql query to find link between Intercompany Accounting and GLI want to know the tables and link between intercompany accounting and general ledger. I want to pick intercompany data in query. -
Transaction Approvers Comments ReportSummary I am preparing a report to fetch Transaction details along with Approver comments which we can see in Transaction console.Content Hi Team, I am facing a problem … -
In standard - Disbursement Payment File Formats report need xml /data model.Summary: User wants to see approval History details in Standard Disbursement Payment File Formats report. There is no data model available . Kindly provide the xml / dat…Naggrajan 41 views 1 comment 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management
-
How do we encrypt the Payables Payment Connection Credentials in the ERP database?Summary: How do we encrypt the Payables Payment Connection Credentials in the ERP database? They are encrypted on the screen but not in the ERP database tables which pos…CarmenR. 21 views 1 comment 0 points Most recent by Daniela Petria-Oracle Payables, Payments & Cash Management