BI Publisher
Discussion List
-
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 72 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 21 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 21 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 121 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 112 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 65 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… -
How to view and modify code in header RTF template without breaking the outputSummary: Hello, good day! Is there a way to view and edit the whole code in header of the RTF template? We have this bunch of code in the header of the RTF template and …Ralph Aldrich Magno 31 views 4 comments 0 points Most recent by Rickell Muir Receivables & Collections -
"Asset Cost and Reserve Report" csv extract size limit exceedingHi Team, I had scheduled "Asset Cost and Reserve Report" once for a single country and for a single period. The delivery channel is email. I'm getting the below error: D…Prakhara 244 views 5 comments 0 points Most recent by Louise Gareau - Support - Oracle-Oracle Assets -
Sandbox- AP invoice,If any GL code otherthan “****” is used under multiperiod, user receive popupSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Stephen Sushanth Alexander 11 views 1 comment 0 points Most recent by Elena Vlad-Oracle Payables, Payments & Cash Management -
We need backend tables where the information stored for "Manage Collections Preferences"Summary: Hi Team, We need a backend tables where the Global preference information stored under the task "Manage Collections Preferences". Attached screenshot for your r…Opkey PA 21 views 4 comments 0 points Most recent by Kalpesh Salunke-Oracle Receivables & Collections