OTBI
Discussion List
-
How to Write REGEXP_LIKE FUNCTION in ORACLE BI EE DatabaseSummary: How to Write REGEXP_LIKE FUNCTION in ORACLE BI EE Database. The Below part is having an issue. Please help me how to write regular expression in Oracle BI EE ON…Niranjan_DTCC 113 views 3 comments 0 points Most recent by Niranjan_DTCC Reporting and Analytics for HCM -
Oracle Fusion to customize format payment data modelSummary: Hello everyone. For implementation on a client, a new custom check format needs to be created. It is necessary to add some fields that are not shown in the xml.…Juan López 341 views 2 comments 0 points Most recent by MariusS-Oracle Payables, Payments & Cash Management -
BI Consumer role is not giving access to create data model in my folderWe are trying to give read only access to BI reports in OTM. We provided BI Consumer role to user by using which we able to access the reports and able to run. But we ar…vikram khengare 51 views 4 comments 0 points Most recent by Nilesh Kumar Mal-Oracle Transportation Management
-
Link between XLA, FA and supplier detailsSummary: Link between XLA, FA and supplier details Content (please ensure you mask any confidential information): We have a requirement to fetch the XLA accounted DR, CR…
-
Default communication Method as E-Mail in Purchase OrderSummary: Is there any way to default the Communication method as E-Mail when I create a Purchase Order without using Communication Method in Supplier Site Content (pleas…
-
The PO E-Mail notification cannot be delivered to the recipientsSummary: When all buyers create PO's all suppliers can't receive PO email notification and send an email to the buyers as shown in the image below Hope to get a solution…
-
Subledger DFF enabled not shown in OTBI subject areasSummary: BIenabled subedger line level DFF cannot be found in OTBI subledger accounting subject areas Content (please ensure you mask any confidential information): A li…Dian Minshan 1 view 2 comments 0 points Most recent by Viviane Vasconcelos Subledger Accounting & Accounting Hub -
'Payables Invoices - Holds Real Time' subject area has been obsoleted from 19bSummary Payables Invoices Holds Information Reorganized in the Oracle Transactional Business Intelligence Subject AreasContent Hi All--> Payables Invoices Holds Informat…
-
How to enable report job historySummary: I need to enable the "Report Job History" option in the Home tab of OTBI, without leveraging BIAuthor or BIAministrator, as we have a requirement to view and no…
-
Extracting Performance Goals that have attachments using OTBISummary: I am trying to report on performance goals that have attachments, in OTBI, and have searched all of the relevant subject areas, with no success. Is anyone able …Paul Morrissey 31 views 1 comment 0 points Most recent by Sivakumaran Muthusamy-Oracle Reporting and Analytics for HCM
-
Is there a way to find out if the users really using the current assigned role that they have?Summary: In the Fussion application, we can pull list of users who has a certain data role. But we wanted to know who among those users in the list that are actually usi…Lorejean Gelacio 31 views 2 comments 0 points Most recent by MilanMohanty Reporting and Analytics for HCM
-
Audit log related to sales unit price and purchase unit priceSummary: For the audit report found under tools, which products have audit log related to sales unit price and purchase unit price? Content (please ensure you mask any c…
-
Report to fetch all position Name changes but the job remains sameSummary: I want to fetch a report for the position name updates when we have same job code Content (please ensure you mask any confidential information): we need to find…Rajesh Suvala85 31 views 8 comments 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM
-
Blanket Purchase AgreementHello, dear friends Please help me, I need to know which is the Oracle fusion table that brings the information of the supplier items in the Blanket Purchase Agreement m…
-
Purchase Order PDF report customizationSummary: I have customized the purchase order print PDF and when adjustments are made directly to the .rtf layout I have to generate a change order to the purchase order… -
Line Manager and HR getting different values for years of service formulaSummary: I am working on a report that lists employees that have upcoming birthdays and upcoming anniversaries in the next month. If they have a birthday, that birthday …joshvanlaan 11 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Using Dashboard Prompts When Using OTBI AgentGood day Experts, Is there a way to use the available dashboard prompts in a dashboard when creating an OTBI Agent? For example I have a dashboard where the default peri…JMLMIII 41 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
OTBI Export Using Formatted > Excel Row LimitationGood Day, I have a set of data consisting of 90,000+ rows. Exporting via Data > Excel, all rows are retrieving when exported. But exporting using Formatted > Excel, it o…
-
Which subject area can we locate the consumption advice details?Summary: I'm trying to create an analysis which will me if the consumption advice line is open for invoicing or already invoiced. ex. Consumption Advice Number - PO Numb…
-
How to view Logical Ship and Receive transaction for Dropship ordersSummary: How to view Logical Ship and Receive transaction for Dropship orders Content (please ensure you mask any confidential information): We have a requirement to rec…
-
Error when scheduling Logical SQL ReportContent Hi all, I've scheduled quite a few logical SQL reports, but the two newest ones I've created (Change Value Reports) receive the attached error. Any ideas on what…User_2025-01-31-00-25-12-234 29 views 5 comments 1 point Most recent by Neysan Mohajer Reporting and Analytics for HCM -
Need dashboard prompt based on field with complex formulaSummary: I have a report on a dashboard that has a field that gives me the highest level of education obtained by first ranking the degrees on the employee's records and…
-
Vacation hours disbursedSummary Vacation hours disbursedContent Hello Community, Are you aware of any report in oracle that will tell us vacation hours disbursed? We are specifically looking fo…User_2025-02-05-16-57-43-236 6 views 6 comments 0 points Most recent by Andrew_Schmitz Reporting and Analytics for HCM
-
Fusion Open Purchase Order as on Certain Past DateSummary: Is there a report or a way to build report which will show Open Purchase Order as on Certain Past Date. Content (please ensure you mask any confidential informa…
-
Customer wanted automate the T4 slips that should deliver to terminated emps personal email addressSummary: Hi Experts, Need suggestions on how to automate the T4 slips that should deliver to terminated emps personal email address, if anyone implemented this functiona…Rama123-Oracle 11 views 1 comment 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM
-
PPM Control Budget Balance Report RequirementHi, We have multiple requirements from users asking for drilldown of balance shown in Award Overview Page under Control Budget Balances view. So we are trying to develop…
-
HCM Auditing/ Audit reportSummary: Hi ALL, We'd like to understand what auditing is available and how detailed auditing would be enabled. It may just be an OTBI report, it may require some settin…RamkumarKadhiravan 42 views 1 comment 0 points Most recent by Satyam Roy Reporting and Analytics for HCM -
Does SOC1 report also covers OTBI and BI PublisherDoes SOC1 report also covers Oracle Transaction Business Intelligence (OTBI) and Oracle Business Intelligence Publisher (BI Publisher)?Temi A. 41 views 3 comments 0 points Most recent by Temi A. Reporting & Analytics for Fusion Service
-
Payroll Audit ReportSummary: Hi All, Do we have any option for audit report on Payroll details. Who has accessed a specific salary/payroll screen in the past 7 days? Thanks, Ram Content (pl…RamkumarKadhiravan 21 views 2 comments 0 points Most recent by RamkumarKadhiravan Reporting and Analytics for HCM