BI Publisher
Discussion List
-
OTBI Filter Criteriaanalysis result in error when no prompts are selected Errore Errore di visualizzazione della vista Errore durante l'elaborazione della query (SQLExecDirectW). Dettagli e…Rosita Santosuosso 11 views 0 comments 0 points Most recent by Rosita Santosuosso Reporting and Analytics for HCM -
options to pause GL posting during incremental GL balances extractsSummary: Oracle GL Cloud provides any built-in functionality to temporarily pause General Ledger (GL) posting, looking for a feature to temporarily pause or queue GL and…sateesh Polkampally 11 views 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle General Ledger & Intercompany
-
Set different hyperlinks for different languages with Page ComposerContent Hi all, we have the following problem: We have customized the "Request noncatalog item"-page. Therefor, among other things, we have insterted a hyperlink that re… -
How to show custom dashboards under Dashboard Header Menu in Oracle Fusion Report & AnalyticsI have created custom dashboard and I want show that dashboard under Dashboard Header Menu as attached Help me how to achieve it. How to add custom dashboard to Existing…
-
Unable to modify JobOfferLetterDM as it is giving the error ORA-01719.Summary: I would like to add the candidate's preferred language column in the OfferRecipient data set Cand.CAND_PREF_LANGUAGE_CODE but when saving the data model, it thr…
-
balances gl and slaSummary: balances gl and sla Content (please ensure you mask any confidential information): We need to create a report with the Accounting Hub balances for a supporting …Francesca1 1 view 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle General Ledger & Intercompany
-
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 22 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 434 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 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 151 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…