OTBI
Discussion List
-
Join between PER_USERS and POZ_SUPPLIERSHi, we need help in creating a custom query and we need to join POZ_SUPPLIERS to the PER_USERS table. Can you please help assist? Thank you. -
Open a PDF in a new App or Quick actionIt is necessary to create an APP or Quick action that redirects to a PDF that the client provided us. I'm using the sandbox structure tool. But there is no option to upl…Brandon Martin-Oracle 11 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
How to restrict an OTBI analysis by data access added to a user?Summary: There is a an analysis created which has supplier information based on Business units. A user with access to only one business unit is able to see suppliers fro…
-
Restrict BI Author Role to only create OTBI Reports, they should not have ability to edit BI ReportsHow to restrict the user having BI Author Role to only create & access OTBI ORC Subject areas reports only. Not having access & edit BI Reports for other work area like …Twinkle Dudani 53 views 6 comments 0 points Most recent by Regie Mercado Reporting and Analytics for HCM
-
Access to Project Budget vs Actual and Project Capital Costs reportIs there a specific privilege or data policy to access Project Budget vs Actual and Project Capital Costs report? Project Accountant gives us access however it has too m…
-
How to transpose Rows to Column in OTBI Compensation Detail ReportSummary: you can use a pivot table and have salary basis as column and value in the metric section, you should apply aggregation rule like min/max on the metric values. …Jasmine 251 views 20 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
We need OTBI column name in Absence as per below image to get leave applied dateSummary: We need OTBI column name in Absence as per below image Type is Adjustment. Content (please ensure you mask any confidential information): Version (include the v…AjayKumar Maddipati 21 views 2 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
Custom Notification based on field updateIs it possible to trigger a notification when a field on Negotiation header is updated to a specific value?
-
Report not pulling correct salary infoSummary: We have a requirement from our HR department to build an AAP report that includes salary information for employees. We've tried building this report using a few…Henry Imgrund 33 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Can't find DFF's Fixed values TableManager Layout > Choose the defined layout > Details (Tab) > Add Field > choose attribute > finish > select the field and click edit > check the fixed list value > add t…Ahmed Matar 11 views 2 comments 0 points Most recent by Nilesh Kumar Mal-Oracle Transportation Management
-
Convert the column in the report to a numeric datatype from VARCHAR.Summary: I have a requirement: the output of the report, including columns like net_amount_due, should have a data type in number format after extraction in excel. Conte…DataWhiz 51 views 8 comments 0 points Most recent by Nilesh Kumar Mal-Oracle Transportation Management
-
SQL to get Org Pay Method of PersonSummary: SQL to get Person Org Payment Method Content (please ensure you mask any confidential information): pay_org_pay_methods_f record holds the BASE_ORG_PAY_METHOD_N…Vijay Solanki 51 views 2 comments 0 points Most recent by Vijay Solanki Reporting and Analytics for HCM
-
Version controlSummary Version control for OTBIContent Is there any preferred version control software for OTBI and BI Publisher code? ThanksUser_2025-02-05-23-02-10-916 50 views 3 comments 0 points Most recent by Jayapal Reporting and Analytics for HCM -
How to use Import Maps for Sales Order uploadSummary: We have a requirement to use import maps for sales order import/upload facility Content (please ensure you mask any confidential information): We would like to …
-
What is PVO for 'FUN_USER_ROLE_DATA_ASGNMNTS' table to extract data from BICC to oacsSummary: What is PVO for 'FUN_USER_ROLE_DATA_ASGNMNTS' table to pull data from BICC to OACS Content (please ensure you mask any confidential information): Version (inclu…Navadeep.Chowdavarapu 63 views 2 comments 0 points Most recent by AnujGupta_Tom BI Publisher Learning Center
-
Is it possible to use FBDI for adding some sites to an exiting customer?We created a customer but we need to add many sites to him, so we are thinking about using FBDI, but is it possibile for an existing customer to use FBDI just for create…
-
we wants to fetch changed attribute detail in OTBI as per below screenSummary: Hi Team, we wants to fetch changed attribute detail in OTBI as per below screen so which subject area need to use ?. Thanks, Ajay Content (please ensure you mas…AjayKumar Maddipati 11 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Customize AP Check Print in FinancialsContent Hello all, I customised the template of the default AP Check Print and also attached my data model to it, yet it stills shows the seeded template when I print th… -
Dynamic PO PDF bodySummary: one of my customer wants the PO PDF Body message that goes to the supplier to be customized dynamically and it needs to be editable for each email that is sent …
-
Invoice Lines with yellow exclamation markHi All, The Invoice lines have a yellow exclamation mark, with type Item and red box against Amount column. We are unable to find the error message it shows needs revali…Swapnil Kashid 11 views 2 comments 0 points Most recent by Swapnil Kashid Payables, Payments & Cash Management -
Allow tax withholding, Use Withholding Tax Flag, Withholding Tax Report Group, Federal ReportableSummary: Need help finding the table/s that holds the tax information below for Suppliers: 'Allow tax withholding', 'Use Withholding Tax Flag', 'Withholding Tax Report G…
-
Data Not Visible in OTBI Dashboard for the userSummary: We have created one custom OTBI dashboard. When we give access to the user, he can access the dashboard but data is blank. What roles are requried? Content (ple…Santosh Vaidya 52 views 3 comments 0 points Most recent by Santosh Vaidya General Ledger & Intercompany -
logo in OTBISummary: I am trying to load a logo image on an OTBI Report, I am getting this error. "The file uploaded may contain a virus or otherwise failed to be scanned for viruse…mmjohnson0522 51 views 7 comments 0 points Most recent by mmjohnson0522 Reporting and Analytics for ERP
-
how can we add two subject areas worker assignment and ORC subject area for candidate numberSummary: Hi Team, we need candidate number from ORC subject area source real time and worker assignment real time . Thanks, Ajay Content (please ensure you mask any conf…AjayKumar Maddipati 1 view 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
SQL to find Material Transaction for Dropship Sales OrderSummary: SQL to find Material Transaction for Dropship Sales Order Content (please ensure you mask any confidential information): we are looking to get a SQL to find Mat…