BI Publisher
Discussion List
-
Database column that stores the Average Actual Effort per Attempt and Virtual Classroom typeThere are 2 fields in the application related to Learning. The field names are Average Actual Effort per Attempt (Self Paced Learning) and Virtual Classroom Type (Offeri… -
how to get read only access to reports and analyticsSummary how to get read only access to reports and analyticsContent Hi Team - I need to grant only read access to Reports and Analytics page...With this grant,the user s… -
How to get the details like employee user name, person number and employee statusHi Team, We have requirement to see employee user name, person number and employee status in a report. Can anyone help me on this. Regards, RaviRavi-Palacharla-Oracle 352 views 4 comments 0 points Most recent by AMIT KUMAR YADAV Reporting and Analytics for HCM -
How to hide Page Options while accessing by managers Fusion Cloud HCMHi Team, Could you please to hide below Page Options (Edit dashboard, other options in it) while accessing by managers in Fusion Cloud HCM BIP.Chanikya Neelam-Oracle 1 view 0 comments 0 points Started by Chanikya Neelam-Oracle Reporting and Analytics for HCM
-
write a sql query to fetch Total number of Learning Assignments Completed in last 1 yearSummary: write a sql query to fetch Total number of Learning Assignments Completed in last 1 year Content (please ensure you mask any confidential information): Version …
-
Assets - The following segment labels have misspelled BI Object Name setSummary: Hi What are correct spelled BI Object Name set for Assets. I have hit the following error: Regards, Bo Content (please ensure you mask any confidential informat…
-
please suggest database tables/how to calculate Available to reserve and Available to transact QtySummary: We want to fetch Available to reserve and Available to transact Qty based on lot details from the database tables. Can you please suggest the database tables/ho…KOTTHURI ASHOKBABU 41 views 2 comments 0 points Most recent by BalaKadapa Reporting and Analytics for SCM
-
View PDF Option is not working for some Cancelled PO in fusion.Hi Experts! Recently we are facing an issue with view pdf option in fusion. Case: It is working for PO s which are not cancelled. Its working for some Cancelled POs. But…Mainur-Oracle 141 views 11 comments 0 points Most recent by Malleswara_Rao_P Reporting and Analytics for ERP
-
While Downloading the General Ledger Details Report in CSV format getting Date format IssueWe are experiencing major flaws in one of the mostly widely used out-of-box report "General Ledger Accounts Details Report" in Fusion (Standard Report). — Accounting Dat…Sai Kumar Bhanumukkula -Oracle 11 views 1 comment 6 points Most recent by CA Nirmal Choudhary General Ledger & Intercompany
-
Query/BI Report - Pay Elements Paid Past Term DateHi I am looking for a query/BI report that will show me pay elements that have been processed and paid past the employee's termination date. I tried searching the commun… -
Query to extract all the updates made on employees assignmentsSummary: Content (required): Hello experts, when accessing the employee assignment page, it is possible to see users making last updates. Is there a query to extract all…Valerio Curzi 973 views 6 comments 0 points Most recent by VivekKumarAgarwal_CZTR1 Reporting and Analytics for HCM -
BIのサブジェクトエリアSales CRM LeadResourceでリードのチームメンバーを取得したいサブジェクトエリアSales CRM LeadResourceでリードのチームメンバー全員を取得したいです。 方法を教えてください。M.AZUMA 1 view 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales -
Write a sql query to fetch average number of learning days per employeeSummary: Write a sql query to fetch average number of learning days per employee (includes all formal learning). Content (please ensure you mask any confidential informa…
-
In the BIP report we need Virtual Classroom Type from Learn ModuleWe need to fetch Virtual Classroom Type from learn module. Which table field is to be mapped to get the below required details.
-
Ability to store Email ID on Order and then use it for sending invoices to customerSummary: Content (please ensure you mask any confidential information): Need an ability to capture ordering email id for credit card customers and use that to send an em…
-
OTBI - Issue while submitting Custom report - Asset Cost DetailSummary Error while selecting parameters for Custom OTBI report which was copied from Asset Cost Detail reportContent Error while selecting parameters for Custom OTBI re…User_2025-02-04-10-47-46-258 42 views 1 comment 0 points Most recent by Priya_Ananda Reporting and Analytics for ERP -
Change database timezone?Hello Gurus, I understand that data in Oracle Fusion tables are being stored in UTC timezone. Can that be updated to timezone per Organization's choice? If yes what can …Sheetal VBCS 34 views 2 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP
-
write a sql query to fetch Total number of Learning Request Approved in last 1 yearSummary: write a sql query to fetch Total number of Learning Request Approved in last 1 year Content (please ensure you mask any confidential information): Version (incl…
-
Report BI - double column headerHi, is there an alternative to RTF for making a report with two headers on the columns? Example I have these columns: Organization Tot Male Female Tot Male Female Org1 4…
-
How to make the email confidential through bursting in BIPSummary: We have a requirement to make the email confidential in BIP , we are sending the email to recipients through bursting . Content (please ensure you mask any conf…
-
How to hide embedded dashboard setting and help link and create custom dashboard styleContent Hi All, I have embedded a dashboard adding dashboard link to webpage content on the Oracle cloud hcm homepage. 1) I have added "PortalPages" to the link, however…Punam Roy Karmokar 85 views 8 comments 0 points Most recent by Punam Roy Karmokar Reporting and Analytics for HCM -
Query to get the failure reason of a transactionSummary: Please share any sample query to get the issue description of a failed transaction Content (please ensure you mask any confidential information): From the scree…
-
ESS Job Report Output File NameSummary: After running the ESS job in Oracle Fusion 'Default Document', we can see the output name. Can we set this output name to reflect the order number or invoice nu…User_39SVE 70 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP
-
what table stores payment date of quick prepayments?Summary: hi All , i need to get the below payment date for BIP but i am not able to get the table which stores this. Please help. i tried PAY_REL_PAYMENTS_VL PAY_PAYROLL…Divya Vaish 21 views 6 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Whether increasing the maximum length of existing value set used for GL DFF cause any impact ?In Oracle Fusion Financials, can we increase the maximum length of existing value set used for GL DFF. Will there be any negative impact for this?raveenasingla 11 views 1 comment 0 points Most recent by CA Nirmal Choudhary General Ledger & Intercompany
-
How to know who delete some reports in OTBIA folder containing reports has disappeared from my environment, and we want to know if it was accidentally deleted by a user or where the folder is located.Roy1823 33 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP
-
Any SOAP or REST calls available to see status of scheduled BIP reports?Hello Gurus, I am looking for SOAP/REST calls that can tell me whether the scheduled BIP report failed or succeeded. The navigation is Reports and Analytics → Home → Rep…Sheetal VBCS 32 views 2 comments 0 points Most recent by Shankar-Oracle Reporting and Analytics for ERP
-
SQL Table where Webclock events information will be storedSummary: Hi All, We are looking for a report to capture details of Webclock Events. Its use is to check which all entries have Clock in And Clock out correctly, and the …Abhishek Bhaskar 51 views 2 comments 0 points Most recent by Siddhesh_Nisal Reporting and Analytics for HCM