Category 81
Discussion List
-
Query to extract the last update author for document record fieldsSummary: Hello experts, please, could you share the query to execute in order to find the author of the last update on document record fields? Thanks in advance for your…Valerio Curzi 11 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Create BIP Report to Fetch the ESS Job Name, ID, And the SubmitterHi, We would like to create a report to fetch the ESS job name, id, and the submitter. ThanksAhmed Maher Kadeh 51 views 5 comments 0 points Most recent by Abhijit Sahu-Oracle BI Publisher Learning Center -
As an HR how do we administer and check the transcript/course for a particular employee.Summary: As an HR how we want to administer and review the transcript/course for the questions to see whether the employee is answering correctly or not, and also need t… -
Need to fetching displayvalue of payroll time type from time entry layout component.Summary: Hi, We want to fetch the display value of the payroll time type from the time entry layout component. I am not able to find it in any OTL subject area. Has anyo…Piyush Pokharkar-Oracle 41 views 2 comments 0 points Most recent by Piyush Pokharkar-Oracle Reporting and Analytics for HCM -
Skills OTBI reportSummary: Dear Experts, Please could anyone help how to extract the OTBI report to find how many employees updated the Skills in the Oracle? Kindly help with the subject …Rajeshkumar_Sekar06 31 views 7 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
How to show only the MAX response attempt for a questionniare response in OTBI analysisSummary: We have an OTBI Analysis that returns information based on a checklist questionnaire. Employee can be asked to review and revise this content. We then want to p…Amy Wilson 31 views 3 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
Customisation of Expense Approval Workflow Notification using BIPSummary Issues persist even while following expense config document step by stepContent Hi,We are trying to implement customized expense approval workflow notifications …
-
Need OBTI Course Record Count ReportSummary: I do not know what I'm doing wrong. I need a report where I can get the Overall count and % or completions and not completed, but I keep getting errors. Does an…
-
Costing of Positions subject area in OTBI?Summary: We get requests from all of our customers in Academics and Healthcare for reports/ analysis that show position costing but we have to use BI Publisher since we …Darren Nelson 303 views 9 comments 0 points Most recent by Venkateswara Rao Vadlamani Reporting and Analytics for HCM -
How to create a Cross-Tab reporting using BIP Excel TemplateSummary: How to create a Cross-Tab reporting using BIP Excel Template Content (required): Hi, We have a complex report layout and we have to develop it using BIP Excel T…
-
How to write filter for custom logic?Summary: I have a parameter Diverse, it has values ALL and Diverse. if user selects Diverse it should display the counts of diverse employee, if ALL selected all employe…Raghavendra M 91 views 14 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Migrate reportsSummary: Report not being updated when migrated to different environment. Content (required): Hi all, We have encountered an issue in the following situation: Goal is to…
-
Report tabs on Learning admin dashboardSummary Report tabs on Learning admin dashboardContent Hi All I've noticed in a few Oracle videos, the Learning admin dashboard has a number of different tabs (see attac… -
DFF at Supplier Address not visible in OTBI report Subject AreasSummary: Content (required): Hi, I have created an OTBI report for Supplier Master details. I have defined few DFFs at supplier profile level, site level and at address … -
How to restrict custom folder created in dashboardSummary: How to restrict custom folder created in dashboard Content (required): Hi Experts, We have created one custom folder and included all the custom reports in the …
-
REST API for Common Features > Get a lookup codeSummary: REST API for Common Features > Get a lookup code Content (required): Hello All, I am using the REST API below to fetch the Common Lookups whose Lookup Type (=XX…
-
I am working on one of the change only extract but I am not getting OLD values for few recordsSummary: I am working on one of the change only extract but I am not getting OLD values for few records Content (required): I am working on one of the change only with p…
-
In need of a report that returns associates who had a change in their direct managerSummary: Have a need for a report that returns associates who have changed their direct manager Content (required): We have a need for a report (BIP or OTBI) that will i… -
Link external data inside BIP reportSummary: Hi! I have an external data that is in excel file, is there a way to import this data into BIP and access it inside the data model? If yes, kindly share a docum…RenzelkeithCoquia 91 views 6 comments 0 points Most recent by makarandamondikar Reporting and Analytics for HCM
-
Calendar year is not populated in 1099 ReportSummary: Calendar year is not populated in 1099 report output Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code …Surya01 122 views 4 comments 1 point Most recent by Jeff Rich-Terillium Payables, Payments & Cash Management -
Management Report Export in ExcelSummary: Content (required): Hello, We have a requirement that client want to export the report in the different tabs of the excel for cost centre dimension. We have mor…
-
Number of invoices processed per FTE that performs the process “Process accounts payable (AP)”Summary: Number of invoices processed per FTE that performs the process “Process accounts payable (AP)” Content (required): We are making an attempt to calculate the per…SaurabhSinghal26 92 views 1 comment 0 points Most recent by SaurabhSinghal26 Payables, Payments & Cash Management
-
SQL query statement to get all unaccounted transaction in AR with full GL StringSummary: Require query to extract all unaccounted transaction in AR with full GL String to review all incomplete Invoices (transactions), credit memos, and on-account cr…Rajesh_BR 2.7K views 1 comment 1 point Most recent by Veronica Stefan-Oracle Receivables & Collections
-
PO Change order History TableSummary SQL/Table to fetch Purchase order change historyContent Hi, Can anyone please help me with the back end table/SQL to get the purchase order change history. I was…Sahil_Makhiza 1.5K views 7 comments 0 points Most recent by Anjana Das-Oracle Reporting and Analytics for SCM
-
PRC - Unable to create Purchase Requisition with Destination Type as InventorySummary: Content (required): Hi, I am trying to create requisition with destination type as Inventory. But when I add item and click on cart system throws below error: "…
-
Inquiring logic used in one field of OTBI reportSummary: Need to know the logic used to calculate the field 'Years of service' Subject Area: Workforce Management - Work Relationship Real TIme Measurement Name: Years o…Jithin Mathews 41 views 2 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Report on Assessment in LearningSummary: Hi Reporting Experts, Is it possible to build a report on assessment for OLC in which we can determine who has changed assessment questions and date and time of…Saurabh Pratap Singh 51 views 2 comments 0 points Most recent by Saurabh Pratap Singh Reporting and Analytics for HCM -
How to run REST API to update invoice payment method ?Summary: How to run REST API to update invoice payment method ? Content (required): Hello There are more than 3,000 invoices with a wrong payment method hence I was wond…Cesar Saveedra 617 views 7 comments 0 points Most recent by Swapnil Kashid Payables, Payments & Cash Management
-
Can we have any job process to run HDL(.dat) file which output of BI reportSummary: Can we have any job process to run HDL(.dat) file which is output of BI report Content (required): Can we have any job process to run HDL(.dat) file which is ou…