BI Publisher
Discussion List
-
Custom Report - It is possible to translate Layout name i an RTF type reportHello, We have a OTBI report created with a RTF template. In the report, we have by example an Layout name call Approval_RTF. When we attach this report to a dashbord an…Patrick Turcotte 32 views 2 comments 0 points Most recent by Patrick Turcotte Reporting and Analytics for HCM -
Locking the Receivable Invoice Form based on DFF ValueSummary: There is a requirement where I want to lock the receivable Invoice based on the DFF value. The scenario is, If the DFF value shows the In-process status of bein…
-
Expenses Module: Specific tables and fields where the employee banking information is stored?Summary: I've been asked the following 2 questions by one of our internal auditors, specific to the Expenses Module: List the specific tables and fields where the employ…
-
Query to get Change Orders details like changed/updated data like PO amount, Invoice Number and InvContent Hello all, Can someone tell from where I could pick the details for Change Orders details for a Purchase Order which is in "Open" status and if changes are made … -
query to fetch WorkDayDefId and WorkDayDefinitionCodeSummary: query to fetch WorkDayDefId and WorkDayDefinitionCode Content (please ensure you mask any confidential information): I am trying to fetch WorkDayDefId and WorkD…Aishwarya_15 11 views 3 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Is there a way to see the Oracle tables & selection criteria used to generate Payroll Activity Rpts?Summary: Several of our BI Publisher payroll reports, which have successfully reconciled to Oracle Payroll Activity Reports for the same timeframes for the past five yea…BeachDreamer 22 views 2 comments 0 points Most recent by BeachDreamer Reporting and Analytics for HCM -
BIP Report Assistance - Transaction Console with Approvers (Job Requisition)Summary: Looking for assistance with creating a BIP report to audit pending actions from the Transaction Console. I found most of the information needed in the following…
-
How does the Financial Tax Register(FTR) report works with the following parametersSummary: How does the Financial Tax Register(FTR) report works with the following parameters : Reporting Level : Ledger Reporting Context : Ireland USD Reporting Ledger …Yasasree Boosireddy-Oracle 204 views 1 comment 0 points Most recent by Rama Mohan - Support-Oracle Tax & Global
-
How can i get the results of a fast formula directly from a querySummary I have a complex fast formula and need to read the result of it through a query. Content (please ensure you mask any confidential information): Version (include …Farah Alajou 151 views 1 comment 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
How to get organization ID and name of bank statement data?Summary: We are trying to create custom BIP report that would output the bank statement import errors and successful data. Among the fields required by client was to add…Patricia Azucena 14 views 1 comment 0 points Most recent by Julien_Dubouis Payables, Payments & Cash Management
-
Globally Change User Timezone Preference in OTBISummary Is there a way to globally change users' timezone preference in OTBI?Content Hi! I am wondering if anyone knows if there is a way to globally change the OTBI tim…Lindsay Lamont 78 views 8 comments 0 points Most recent by Simon Tomey Reporting and Analytics for HCM -
REQUESTED_FOR_PERSON_ID Foreign key for BI ReportSummary: REQUESTED_FOR_PERSON_ID Foreign key for BI Report Content (please ensure you mask any confidential information): Hi, we would like to create a report which prov…Barile Alberto 12 views 1 comment 0 points Most recent by AnishaPatra-Oracle Reporting and Analytics for HCM
-
HR_GENERAL.DECODE_LOOKUP not returning valueSummary: HR_GENERAL.DECODE_LOOKUP function is used in the BIP report to fetch the meaning of the lookup code passed. Content (required): HR_GENERAL.DECODE_LOOKUP functio…Meenakshi K 1.3K views 4 comments 0 points Most recent by AnishaPatra-Oracle Reporting and Analytics for HCM
-
Run report REST API for Oracle BI PublisherSummary: I'm trying to run a BI report and get the output via this REST API: /services/rest/v1/reports/{reportPath}/run I tried running it but is getting 404 not found e…JEngalan 201 views 1 comment 0 points Most recent by Rasheed - Fusion Support Engineer-Oracle Receivables & Collections
-
How the translation tokens works ?Summary: Hello, I have two learning use cases regarding token translation that I'd like to share with you and understand. Both are kind of close, the only difference is … -
Missing a voided check in reportSummary: Missing a void check in pay_ce_transations Content (please ensure you mask any confidential information): Hi, One of our report to fetch a list of voided checks…
-
Test Changes to AP ChecksSummary: Is there an easy way to test the formatting of AP checks? Content (please ensure you mask any confidential information): We recently had to make a change to our…Raz Baboorian 31 views 4 comments 0 points Most recent by Raz Baboorian Payables, Payments & Cash Management
-
impact of scheduled HCM Extract and Reports during the maintenance or upgrade timeSummary: Customer has concern with scheduled BI, OTBI Reports and HCM Extract during the Maintenance window. What will happened with them. CRitika.ray-Oracle 14 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
How to get the self service url from course numberSummary: I have requirement to fetch "Self Service URL" which pops when we click Course Number in the Course Page. Sample URL : "https://fa-xxxx-dev3-saasfaprod1.fa.ocs.…Amrita_Pritam_Nayak 18 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Need assistance to get YTD balance using pay_balance_view_pkg.get_balance_valuesSummary: We are trying to get YTD balance using pay_balance_view_pkg.get_balance_values. I am using the attached query, but it is not returning any result, though employ…
-
Dashboard prompt is not workingSummary: Hi, I have created an analysis using logical sql and passed parameter i.e. presentation variable inside logical sql. But when I am using dashboard and dashboard…Shreya Datir 55 views 5 comments 0 points Most recent by Shreya Datir Reporting and Analytics for HCM
-
![Arun Kumar Krishnan [AK]](https://us.v-cdn.net/6034893/uploads/userpics/L8BUJDYF94E7/nTLGWFBWW678P.jpg)
User login details reportContent Hi Team, We have a requirement to see the list of users logged into the Fusion application on a specific day, in a format like the below sample: User Name | Logi…Arun Kumar Krishnan [AK] 676 views 3 comments 2 points Most recent by Naveen.yadav Reporting and Analytics for HCM -
We are taken the backup of BI report before cloning but now unable to edit the reportSummary: Hi Team, We are taken the backup of BI report before cloning but now unable to edit the report and I'm able to get below error ? PFA. Thanks, Ajay Content (plea…Maddipati Ajay Kumar 15 views 3 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Report to monitor SCORMs answersHello everyone If the contents are SCORM, it is possible to produce reports (e.g. a report that highlights, for each individual question, the answer provided by the user… -
DFF information in our learning request approval flowSummary: We would like to include DFF information in our learning request approval flow . Is it possible to achieve it ? If yes, please suggest the steps for the same. C…
-
Need to edit the NewHireReport data model to include the SecurityFinal tableSummary: In the AssignmentChangeReport datamodel (EmploymentUpdateProcess), there is a table called "SecruityFinal". This table provides the following data (see below) o…
-
In oracle fusion which table locations nameDear , Can anybody guide me in oracle fusion which table have location name. i tried to find but i cant. Kindly check the attached pic i need these column in table where…Mirza_Adeel 5.6K views 5 comments 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for SCM -
I want SQL query to fetch data from 9 Box Matrix dashboard in Talent Review MeetingsHi team I hope you are doing well. I want SQL query to fetch data from 9 Box Matrix dashboard in Talent Review Meetings (Box label, Rating, and manager name) Kind regard,Mohamed_Shafay 74 views 4 comments 0 points Most recent by AnishaPatra-Oracle Reporting and Analytics for HCM