BI Publisher
Discussion List
-
What all roles has BI Consumer Privilege?Summary: We have created a copy of the Employee role and removed the analytics permissions from it. However, we would now like to grant analytics access to only a few se…Anusha716 106 views 2 comments 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales -
Asset RegisterSummary: Looking for SQL query or OTBI report to get Project Segment (CoA) wise Asset Register Report. Balancing Segment, Cost Centre and Natural accounts are visible in…
-
BIP Joining GL with PJF_PROJECTS_ALL_BI'm trying to join PJF_PROJECTS_ALL_B with this query so that I can add segment1 from the table to this GL report. Does anyone have any insight for easiest way to achiev…
-
Query for State Tax Withholding details for all statesSummary: Hello! I am looking for the BI query for State Tax Withholding. Thank you in advance! Content (please ensure you mask any confidential information): Version (in…
-
Which field holds data for 'Expense Auditor Completed Approval Date ' in Expense ModuleSummary: Which field holds data for 'Expense Auditor Completed Approval Date ' in Expense Module. We have also created an SR 4-0000627381. Content (please ensure you mas… -
Is it possible to have candidate signature on Course Completion Certificate?Summary: Possibility of having candidate signature on the course completion certificate Version (include the version you are using, if applicable): 25A
-
Required a field name and Table name for Manage Payment MethodsSummary: Hi Team, We need backend tables and a column for the field "Automatically assign payment method to all payees" under Usage rule → Manage Payment Methods. I coul…Opkey PA 33 views 1 comment 0 points Most recent by Krishna Pulicherla-Oracle Payables, Payments & Cash Management
-
How can we output the "Entered Period" for Expensed Asset in customized BIP?In the Document below, it shows that the Entered Priod in Fixed Assets can be output from XLA_AE_HEADERS.PERIOD_NAME or XLA_AE_HEADERS.EVENT_DATE. However, when it comes…Nao-Oracle 21 views 1 comment 0 points Most recent by Louise Gareau - Support - Oracle-Oracle Assets -
What tables/views are related to REST API /itemUnitOfMeasureConversionsSummary: I need to confirm the data is being retrieved without exception, so I would like to create a report of the same data that the API should be fetching. Content (p…
-
Automating AGIS Invoices creation processHi Team We are trying to automate AGIS Invoices creation.OIC triggers the Transfer Intercompany Transactions to receivables.And after its trigerred we have created the B…
-
Need inputs to fetch balance "Reference" field value against balance dimensionSummary: Need inputs to fetch balance "Reference" field value against balance dimension Content (required): In the Employee Payroll balance results we are able to see Ba…
-
Table to get the field of Condiion under Manage Chart of Accounts MappingsSummary: We need a table and column where the Condition field information stored for the setup "Manage Chart of Accounts Mappings". Attached the screenshot with highlite…
-
How to access Data Model via API?Summary: How to access Data Model via API? Content (please ensure you mask any confidential information): Hi, our customer have external dashboards, using PowerBI, and t… -
Does anyone have a Leadership Hierarchy prompt or guidance on how to create one?Hello Does anyone have a leadership hierarchy prompt? If so can you share some guidance on how it was created? I want to be able to add a leadership hierarchy onto our d… -
Table or Query for Condition column for Separate Remittance Advice in Manage Payment Process ProfileSummary: Hi Team, We need a table or query to get Condition fied under the Separate Remittance Advice in the setup Manage Payment Process Profile. We gone through these …Opkey PA 21 views 1 comment 0 points Most recent by Stephen Westerfield-Oracle Payables, Payments & Cash Management
-
How to fetch custom attribute of Legal Entity in BIP?Summary: How to fetch custom attribute of Legal Entity in BIP? Content (please ensure you mask any confidential information): I have this custom field: I cannot see it i…Stefano_Mazzocca 1 view 1 comment 0 points Most recent by Stefano_Mazzocca Reporting and Analytics for HCM -
How to print data from different levels in the same line in Etext templateHi All, I am using EText template for HCM Extract which results in Employee having Multiple Balances. The Requriement is to display the employee record along with all th…
-
BI Publisher - RTF Template - Numbered List in Offer LetterSummary: Hello everyone, I am new to build the BI Publisher, I would like to check a feasibility for my client requirement. My client offer letter has a numbered list e.…
-
How to display a BIP Report in multiple excel sheetsSummary: How to display a BIP Report in multiple excel sheets Content (please ensure you mask any confidential information): Hi, we would like to display the output of a…Barile Alberto 71 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for HCM
-
Table FND_SESSIONS, columns FIRST_CONNECT and LAST_CONNECT, what do they mean?Summary: Content (please ensure you mask any confidential information): Can someone explain what FIRST_CONNECT and LAST_CONNECT columns in table FND_SESSIONS represent? …Stefano_Mazzocca 21 views 2 comments 0 points Most recent by Nathan CCC Reporting and Analytics for HCM
-
Query to fetch legal reporting unit mapped to a legal entitySummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Can we create custom views in Oracle fusion?Summary: Can we create custom views in Oracle fusion? We need to create the view to use it in a value set.
-
Seeking guidance on LISTAGG() functionSummary: Hello, could someone please guide on why listagg() is not working in the following query: Content (please ensure you mask any confidential information): Hello, …
-
Can we add expense report print to email notrification attachment?Hi All, As we know, we can print expense as below: Can we set this printout as an attacthment in expense approval notification email? Thanks in advance! Weitao -
Which BIP table stores the attachments under Talent Profile?Summary: Which table stores the attachments under Talent Profile? Content (please ensure you mask any confidential information): I'm trying to fetch this attachment unde…Stefano_Mazzocca 11 views 1 comment 0 points Most recent by Stefano_Mazzocca Reporting and Analytics for HCM
-
Display date in a pivot table (both for OTBI and BI Publisher)Summary: Display a date in a pivot table (OTBI and BI Publisher) Content (please ensure you mask any confidential information): Hi, I wish to create a pivot table like s…
-
SQL query to create value set for Manage Organization Tree Node namesSummary: We need to establish a value set to define the node names under Manage Organisation Tree. Do we have any SQL query to get to get the Node Name? If not please te…
-
How to set a display order for the columns of a BIP Report (csv output)Summary: How to set a display order for the columns of a BIP Report (csv output) Content (please ensure you mask any confidential information): Hi, we created a BIP repo…Barile Alberto 142 views 3 comments 0 points Most recent by Satyam Roy Reporting and Analytics for HCM