BI Publisher
Discussion List
-
Help Finding Training "Start Date" Field or Table in Oracle DBWe’re trying to report learner states as Not Started, In Progress, Completed, and Past Due. Currently, we can only show Not Completed, Completed and Past Due reliably. T… -
Joining GL with subledger, description repeatingI have the below SQL query and it runs and amounts are as expected. My issue is that when looking at a project journal the line description is repeating and it's not dis…Sean-B-01 11 views 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle General Ledger & Intercompany
-
Some of the PDF attachments not appearing on printed AR Invoice in Print Receivables TransactionsHi Team, We are facing an issue where attachments in receivables transactions are not consistently getting attached or sometimes dropped during the printing of the invoi…
-
Supplier Spend Analysis report fails with error ORA-06503: PL/SQL: Function returned without valueWe are trying to run standard report Supplier Spend Analysis report, but as soon as we open the report, it tries to load and fails before we submit the report with error…Shailender Ahuja-Oracle 25 views 2 comments 0 points Most recent by Shailender Ahuja-Oracle Payables, Payments & Cash Management
-
sql query to fetch Number of Learning Outcomes achieved in last 1 yearSummary: sql query to fetch Number of Learning Outcomes achieved in last 1 year Content (please ensure you mask any confidential information): Version (include the versi…
-
sql query to fetch Total number of Learning Compliance in last 1 yearSummary: sql query to fetch Total number of Learning Compliance in last 1 year Content (please ensure you mask any confidential information): Version (include the versio…
-
sql query to fetch Total number of Learning Item Enrollments in last 1 yearSummary: sql query to fetch Total number of Learning Item Enrollments in last 1 year Content (please ensure you mask any confidential information): Version (include the …
-
sql query to fetch Total number of Learning initiatives created in last 1 yearSummary: sql query to fetch Total number of Learning initiatives created in last 1 year Content (please ensure you mask any confidential information): Version (include t…
-
Sql query to fetch Total number of No shows trainings in last 1 yearSummary: Sql query to fetch Total number of No shows trainings in last 1 year Content (please ensure you mask any confidential information): Version (include the version…
-
sql query to fetch Total number of ILT - Trainings Created in Last 12 MonthsSummary: sql query to fetch Total number of ILT - Trainings Created in Last 12 Months Content (please ensure you mask any confidential information): Version (include the…
-
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 412 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 Most recent 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 …
-
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 42 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 157 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 1K 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…
-
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 31 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…