BI Publisher
Discussion List
-
BI Publisher - Roles to Cancel Scheduled Job ReportWe are trying to cancel/delete an active scheduled job report. What are the roles we need to have the privilege to cancel the report job? -
Is it possible to use CASE to replace 4712/12/31 with CURRENT_DATEContent (please ensure you mask any confidential information): I'm using the Compensation - Salary History Details Real Time to return the "Salary Details"."To Date" fie…Joe Dorrian 101 views 3 comments 0 points Most recent by Joe Dorrian Reporting and Analytics for HCM -
How to join GL_JE_BATCHES and FA_FUSION_SOAINFRA.WFCOMMENTS tables in Oracle FusionSummary: What is the key column to join GL_JE_BATCHES and FA_FUSION_SOAINFRA.WFCOMMENTS tables in Oracle Fusion Content (please ensure you mask any confidential informat…
-
How to restrict Data Source in BI > Data Model > Data SourceSummary: Can we restrict the List Of Values from BI > Data Model > Data Source Content (please ensure you mask any confidential information): Customer is soon going to b…Dhananjaya Bhatta 151 views 3 comments 0 points Most recent by Dhananjaya Bhatta Reporting and Analytics for HCM -
Termination Dates and Payroll Data Query or ReportHi So looking for a query/DM or report that I can edit/update to show termination details and payroll data combined? Basically, I have been asked to create a report to b… -
All Scheduled Absences Report Not Pulling an EmployeeSummary: There is a custom BI publisher report that our HR department runs every pay period to view absences for that pay period. For some reason, in the last pay period…
-
Is it possible to customize data model for check print reportIs it possible to customize data model for check print report to add additional fields.vikram khengare 1 view 1 comment 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management
-
To Hide the "Edit Distributions" task by using SandboxHello, Team. In the Manage Transactions Screen, the user wants to hide the 'Edit Distributions' option under Actions Item. Navigation to this screen-->Receivables-->Bill…Venkateswari 21 views 1 comment 0 points Most recent by Veronica Stefan-Oracle Receivables & Collections
-
All AR transactions excluding vat and remaining balanceSummary: We need a report showing all AR transactions excluding vat and remaining balance including vat as at a date. If there is no remaining balance no need to be in t…
-
SCM reportingSummary Custom reports builtContent Our customer is using SCM and is not very pleased with the seeded reports in Oracle. Reports they are looking for are for example the…User_2025-01-28-02-43-26-951 157 views 6 comments 5 points Most recent by Mirza Muhammad Mohsin Baig Reporting and Analytics for SCM -
How to write SQL query to fetch the Tax value present in TransactionSummary: Needed to write SQL query to get total tax amount for a particular transaction shown in UI(please check below screenshot ) Version (include the version you are …Anoop Pillai 71 views 1 comment 0 points Most recent by Sairam Surampalli-Support-Oracle Receivables & Collections
-
Where can I find the create customer statements RTF to change to Logo?Summary: Good day, I am in the process of activating the create customer statements report because the Finance Team hasn't used it; However, I realize that the logo is n…
-
How to rectify No Access to BI Consumer RoleSummary: Hello Experts, In an attempt to remove catalogue access for Managers I have accidentally marked the custom folder in OTBI with BI Consumer Role 'No Access'. Is …Dan_Hinsley 101 views 2 comments 0 points Most recent by Dan_Hinsley Reporting and Analytics for HCM -
AP Aging The report will present the invoices payed and unpaid status as of the date selected?Parameter As Of date = Due date The report will present the invoices payed and unpaid status as of the date selected But we are facing an issue with the invoices that ha…Mohammad Hussein 23 views 3 comments 0 points Most recent by Mohammad Hussein Payables, Payments & Cash Management
-
OTBI Custom Dashboard look and feelHi Team, My customer has shared a requirement to customize a OTBI dashboard and wanted to view like attached image. Is there any option to make such graphical view? Plea…Mohan Murali P-Oracle 22 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Is there an audit/ query that we can use to pull the list of reports that uses a particular columnSummary: Hello SMEs, We are trying to get a list of reports that are currently pointing or exporting a specific column. Content (please ensure you mask any confidential …AprilleLyn 124 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
GL Journal Lines reporting for Mexico's Electronic Invoice UUIDSummary: I have a requirement to store Mexico's electronic invoice number (aka UUID) at the GL Journal Lines level. The UUID is being passed from Oracle Cloud Payables t…NancyR_Bravo 113 views 2 comments 0 points Most recent by NancyR_Bravo General Ledger & Intercompany -
Help me to get the documentation for the standard extracts available in fusionSummary: We are getting the standard extracts which are all available in the fusion. But unable to get the extract details. like any documentation. Please help us to get…RANJITH KUMAR S 21 views 3 comments 0 points Most recent by RANJITH KUMAR S Payables, Payments & Cash Management
-
A report that contain report name and the dm connect to itSummary: Content (please ensure you mask any confidential information): Hi all, My client wants to build a report that shows the report name and the DM connect to it. I …
-
OTBI Dashboard Prompt: Year, Quarter,MonthSummary: Need help on OTBI Dashboard Prompt: Year, Quarter, Month with Variable Content (please ensure you mask any confidential information): We are working on a custom…Mohan Murali P-Oracle 61 views 1 comment 0 points Most recent by Mohan Murali P-Oracle Reporting and Analytics for HCM
-
24B: BIP - What is the OTBI subject area or tables to get transaction approvers from Learning?Summary: What is the OTBI subject area or tables to get transaction approvers from Learning? Content (please ensure you mask any confidential information): Please share …Nipon 21 views 3 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM
-
We developed BI reports in English but user wants based on local Language how to show data ?Summary: HI We developed BI reports in English Language but user wants based on local Language need to show data ? if user from arbic from need to show arbic and if user…AjayKumar Maddipati 1 view 1 comment 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM -
Upload and Validate Corporate Card Transaction File what exactly doing this jobSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Customize Bank Transfer Approval email notification to show recipient's nameVersion: Oracle Fusion Cloud Applications24A (11.13.24.01.0) Within Cash Management / Cash Balances / Transfer Funds Details: When a transfer is created, it needs to be …NZ-user999 41 views 3 comments 0 points Most recent by Ramesh Thati-Oracle Payables, Payments & Cash Management
-
Need a report for Global transfer records with location old and new locationHello, I have requirement for report to show global transfer records with old and new location and also active inactive all employees with their salary if anyone have pl…Mirza_Adeel 21 views 6 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
"Activity Attempt Number" in Oracle BI PublisherSummary: Hello, We need to know in which table and column of Oracle BI Publisher the information "Activity Attempt Number" is located. Can you help us locate it? Thank y… -
Location of Highlighted Information in Oracle BI Publisher (Learning)Summary: Hello, We need to know in which table and column of Oracle BI Publisher the information highlighted in red is located. "Number of mandatory activities in each s…