OTBI
Discussion List
-
Selecting multiple default values in prompts in BI reports and OTBI AnalysisContent I have a requirement where I need to select multiple values in the prompts in the BI reports and OTBI analysis. For example: Consider the column 'Assignment Stat… -
How do we add Tasks, Reports and Analytics Panel to the Order Management PageSummary: How do we add Tasks, Reports and Analytics Panel to the Order Management Page Content (required): Business requirement is to add tasks, reports and analytics pa…kalyan gade 116 views 1 comment 0 points Most recent by SRGogula-Oracle Reporting and Analytics for SCM -
Person Seniority Real Time not showing resultsSummary: The "Person Seniority Real Time" subject area is not returning any results, even though we're currently using the Seniority Dates V3. Does anyone have a solutio…Martijn van den Berg 32 views 2 comments 0 points Most recent by Martijn van den Berg Reporting and Analytics for HCM -
Payment History Transaction amount getting doubled OTBISummary: We are selecting columns (Supplier Number, PPR Name, Payment method, Payment number Payment status, Payment History Transaction amount, Payment History Transact…Panduleni Kadhepa 31 views 1 comment 0 points Most recent by AnamariaRoman-Oracle Payables, Payments & Cash Management
-
Need to Print Salary Amount in Spanish and Portugese in Employee letter ( BI Report)Summary Need to Print Salary Amount in Spanish and Portugese in Employee letter ( BI Report)Content Hi AllWe have a requirement to build Employment letter, letter is in …Naveen Jayaraman-48236 28 views 8 comments 0 points Most recent by Bhardwaj Yash Reporting and Analytics for HCM -
Select highest value only for duplicate rowsContent I have a table of data in OTBI but some employees have duplicate rows. This is because they have 2 different values in a certain column. For these employees, how…
-
Deeplink for labor distribution scheduleIs there a deep link available for the labor distribution schedule? I am developing a custom dashboard to assist the team in monitoring labor distribution activities and… -
Deeplink to Inquire on Detail BalancesSummary: We want to link from a BI Publisher and OTBI Report directly on the Inquire on Detail Balances Page with filled out parameters. It should be the same like it is…Yves Chassein 104 views 1 comment 0 points Most recent by Julien_Dubouis General Ledger & Intercompany -
Report to get list of all ESS jobs scheduled in FusionSummary Looking for a resuable report or query which can fetch details of all scheduled ESS jobsContent Looking for a resuable report or query which can fetch details of…MandeepKGupta 3.3K views 16 comments 1 point Most recent by Peeyush Chandel Reporting and Analytics for HCM
-
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 solutio…
-
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 15 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…
-
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 272 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…Maddipati Ajay Kumar 25 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 32 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 13 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 52 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 72 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 54 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 71 views 2 comments 0 points Most recent by AnujGupta_Tom BI Publisher Learning Center