BI Publisher
Discussion List
-
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 62 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 47 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 293 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. 4 views 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 61 views 3 comments 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management
-
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.3K 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 555 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.3K 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 53 views 7 comments 0 points Most recent by Punam Roy Karmokar Reporting and Analytics for HCM -
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. -
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
-
Extract Completion Type of Learning Evaluation activity in an offeringSummary: We're trying to report on the COMPLETION_TYPE (Required or Optional) of all activities in an offering. We've made use of WLF_LI_ACTIVITIES_F table to query the …
-
Issue with Report Changes Not Reflecting After Clicking SaveWe encountered an unexpected behavior with one of our reports. We made some updates to the bursting, clicked the save button, but when we checked the bursting again, the…Michael Angelo Lucena 133 views 4 comments 0 points Most recent by Thri Gaadi Reporting and Analytics for HCM
-
sql query to get the Legislative Info and Associated Profiles associated with job in oracle fusionI need to fetch job code, job name ,Overtime Status under Legislative Info and details of Associated Profiles associated with job in BIP reportAnjali_Kumari4121 726 views 1 comment 0 points Most recent by GowriTatikonda Reporting and Analytics for HCM
-
can we generate report to view how many users clicks on the custom page in oracle fusionSummary: can we generate a report in bi publisher to view how many users views or clicks on the custom page or any page in oracle fusion ui. Content (please ensure you m…Someshvar Bansal 72 views 2 comments 0 points Most recent by jiweiss-Oracle Reporting & Analytics for Sales
-
BIP report RTF template excel output type date formatting issueSummary: Hi, Trying to show BIP report output data in excel using RTF template, but when we click on the output data column in the excel data file , the date value showi…Phani S-Oracle 541 views 5 comments 0 points Most recent by Kevin M-Oracle Reporting and Analytics for HCM