BI Publisher
Discussion List
-
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 296 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 57 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 299 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.2K 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 515 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 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. -
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 47 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 691 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 71 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 528 views 5 comments 0 points Most recent by Kevin M-Oracle Reporting and Analytics for HCM
-
How to rename the Remote File Name, in order to display hour and minuteSummary: How to rename the Remote File Name, in order to display hour and minute Content (please ensure you mask any confidential information): Hi, we scheduled a BIP re…Barile Alberto 41 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
How to Schedule a BI Publisher Report with Dynamic time range in parameter ValuesIssue Description: We need to view the BIP Reports -'Execution History by User' and 'BIP Reports Execution Summary'. To accommodate this, we are utilizing one of Oracle'…Rajesh Kumar Gunda 142 views 5 comments 6 points Most recent by Rajesh Kumar Gunda Reporting and Analytics for ERP
-
BIP Bursting - Linked OTBI Reports HelpHi all, I'm wondering if anyone has a solution to a challenge I've encountered recently. I have two OTBI reports, a feed and a report where the report links to the feed.…MikeW 11 views 4 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How to run the Talent Profile seeded report?Summary: I need to export an XML file, but I won't be able to view all the fields and content sections. See below parameters used: Version (include the version you are u…