BI Publisher
Discussion List
-
Request for SQL/OTBI to Extract Scheduled Process Parameters (ESS)Details: We are looking for a way to extract Scheduled Process details (ESS), specifically the following information that is visible in the UI for processes such as Calc… -
Dyanmic Deep Link in OTBISummary Need to identify mechanis to have dynamic deep links in OTBIContent Hi There, We have developed around 15 reports in OTBI having a deep link embeded in each of t…Sahil_Makhiza 489 views 25 comments 0 points Most recent by NeenaS25 Reporting and Analytics for ERP -
BI Cloud Connector (BICC) New featuresHi Does anyone know of any changes coming to BI Cloud connector with Fusion Application 22A upgrade. And can anyone help provide the link to the the New Features documen… -
What table store approval rules configuration in FusionSummary: We are looking tables name for approval rule configuration. Navigation: Tools>Transaction Console>Approval Rules Content (please ensure you mask any confidentia…
-
How to add account flex field as parameter for custom BIP reportSummary How to add account flex field as parameter for custom BIP reportContent Hi All - I have requirement to create custom BIP report which has to developed around GL …user12232237 135 views 7 comments 0 points Most recent by User_WAU4B Reporting and Analytics for ERP
-
Oracle table for termination reason in bip reportSummary: Unable to find the following data in oracle tables. I'm able to capture in otbi report, but we need a BIP report with same data and unbale to find in action rel…
-
Unable to report on the SCORM Interactions for the assessment section of some SCORM 1.2 filesSummary: Unable to retrieve learner responses from assessment section of SCORM 1.2 files created using Nimble. Content (please ensure you mask any confidential informati…
-
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 12 views 0 comments 0 points Started 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 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 338 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
-
Table for ESS Job scheduleSummary What is the table name in Oracle Cloud which stores the Schedule of an ESS JobContent Is there a table name or query which I can use for fetching the frequency, …Shubhojit Purkait 1.8K views 11 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
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…