BI Publisher
Discussion List
-
Extract Specialisation, Spec Section, Course, Offering, Offering Section, Activity in 1 row?Summary: Is there a way to extract the Specialisation, Specialisation Section, Course, Offering, Offering Section and Activity in one row? Content (required): Is there a… -
SQL for Current approver of AP InvoiceSummary: We have requirement to find the current approver of AP Invoice if the invoice is under approval . We are using below query to find the current approver select A…Oracletechnofunctional 1.6K views 1 comment 0 points Most recent by SankarBalu Payables, Payments & Cash Management -
Using SUM function in Table Type Value set using FFSummary: Unable to get the sum function in table value set and how we need to get these values in query? Content (required): Here i am facing multiple rows for each diff…Janardhan ACS-Oracle 813 views 2 comments 0 points Most recent by Peeyush Chandel Reporting and Analytics for HCM
-
How to call an OIC integration from BIP reportSummary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):
-
Need report that shows all approval assignees who have NOT approved invoiceSummary We are trying to build a report that provides only “open/incomplete” invoice approvals (i.e. only those approval assignees who have NOT approved yet)Content We a…User_2025-01-28-19-14-07-225 577 views 16 comments 2 points Most recent by DahliaG Reporting and Analytics for ERP -
How to show parameter in exacel template in fusion bi reportSummary How to show parameter in exacel template in fusion bi reportContent In BI report datamodel, I have taken parameters and build report also. Now in bi excel templa…Soumya Goswami-Oracle 64 views 6 comments 0 points Most recent by ShitalRamteke Reporting and Analytics for HCM -
Can BI Publisher be used to send XMLs in UBL 2.0 format? If yes, please elaborateSummary: At my client all financial transactions in Receivables are subject to archiving at a 3rd party. The client wants to be able to leverage the Generate Bill flag o…
-
UBL 2.0 format trhough BI PublisherSummary: We need to send file to 3rd party vendor in UBL 2.0 format of all invoices (also not printed ones). Can this be achieved through BI Publisher? Content (required…SirilG 81 views 3 comments 0 points Most recent by Andreea Laura Panait-Oracle Receivables & Collections
-
How to create Budget vs Actual and variance report?Summary: Hi, We have loaded our budget on budgetary control. We are now trying to build a report with budget vs actual amounts and variance between the two. However, ora…
-
Extracting data using BIP Publisher Report for REST API Load (Creating Timecard)Team, We have a requirement to create bulk time entries for employees (Copying previous timecard and creating the same timecard for current week - Dates differs) and we …
-
How do you increase the performance on a seeded report without losing functionality?Summary: The client complains of a seeded report running for 3 to 4 hours, e.g. Fixed Asset Register report and I would like to know suggestions on performance tuning or…
-
How do you add segments to seeded report in BI Publisher?Summary: I would like to customize a cost summary report in fixed assets by adding two segments (company and location). Content (required): Version (include the version …
-
Access DBCS tables in SaaS BI Publisher ReportsSummary Is it possible to access DBCS tables while creating BI publisher reports in SaaSContent Hello We have a requirement to build some BIP reports out of the tables t…Deepika Jain DJ 98 views 3 comments 1 point Most recent by Nathan CCC Reporting and Analytics for ERP
-
Is there any way to fetch all the scheduled (Reports, Extracts and OTBI) as a report.Is there any way to fetch all the scheduled (Reports, Extracts and OTBI) as a report.Mallikarjuna 11 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Need table and field names in ORC Requisition Page->Progress SectionSummary: Need table and field names in ORC Requisition Page->Progress Section. Kindly help, below is the screen shot of the page and highlighted the fields. Progress Sec…GajavalliKoteswararao 51 views 2 comments 0 points Most recent by Ronal Khara-Oracle Reporting and Analytics for HCM
-
Fast Formula making difference between date fieldsSummary: Content (required): Hello experts, do you have an example of fast formula making the difference between dates? For example we need to create a fast formula maki… -
New Hired employee details with Requisition Details (Req Number, Hiring Manager, Recruiter Name etc)Summary: Sql Query to get New Hired employee details with Requisition Details (Req Number, Hiring Manager, Recruiter Name etc) Content (required): Version (include the v…Awadhendra Tripathi 3.1K views 4 comments 0 points Most recent by Gamidi Venkat Rambabu Reporting and Analytics for HCM
-
Folder permission in OTBI "Resetting?" - "Enterprise Scheduler Job Application Identity for HCM"Summary: Good Day, We have a number of Custom Folders within Shared Folders - Custom where for some reason the "Accounts" "Permission" on specific user on each folder ke…Clifford Trett 511 views 0 comments 0 points Started by Clifford Trett Reporting and Analytics for HCM -
Calculating Past Experience of employees in HCM BISummary Calculating Past Experience of employees in HCM BIContent Hi; I was trying to calculate the total past experience of the employee in BI with the below formula bu…User_2025-01-22-18-29-47-758 126 views 3 comments 0 points Most recent by Vishnupriya Reporting and Analytics for HCM
-
BIP - Organization HierarchySummary: Hello, Does anyone tried creating report in BIP with organization hierarchy details? For example: Enterprise Division Business Unit Department Level 1 Departmen…
-
Query to get time card approver name and approved dateSummary: I need query to get time card approver name. Content (required): I need query to get time card approver name. Version (include the version you are using, if app…Swati U 2.1K views 4 comments 0 points Most recent by Durgadevi-Oracle Reporting and Analytics for HCM
-
Can we restrict learning course details from backend for reporting ?Summary: We would like to give restricted access to the technical person to on the basis of specific course or offering details in oracle learning cloud . We would like …
-
New hires are not showing in SQL reportSummary: New hires are not showing in SQL report. We created report by using Data model. When we export the report, there are not some new hires in it. Content (required…
-
Are the BPM configuration tables exposed to OTBI?Summary Looking to query BPM configuration tables directly to support external audit change management populationContent Are the BPM configuration tables exposed to OTBI…Jeff Hare CPA CISA CIA 83 views 6 comments 0 points Most recent by Bianca Lei Villareal Reporting and Analytics for ERP -
The scheduled BIP report is not received to gmail accountsSummary: Content (required): We've scheduled the report to be received by the users with specific roles. It is successfully delivered for some of the accounts but we hav…Evgeniya Repnina 31 views 2 comments 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM -
Reporting on rejection commentsSummary What is the name of the BI database table that stores the tracking of rejection comments for transactions?Content I was easily able to find / report on the comme…User_2025-01-28-21-53-32-678 151 views 8 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
Learning item access group -BIP table to fetch Person Number List details for Learning access groupSummary: I am working on one BIP report where I am fetching one column to learning access group members using Person Number List options. In which table the person numbe…Kamini Kaushik-Oracle 41 views 1 comment 0 points Most recent by Erika B-Oracle Reporting and Analytics for HCM
-
Transactions Print Data Model ParametersSummary: Content (required): I am trying to run the Transactions Print Data Model directly not via the ESS, however regardless what parameters I enter it does not return…
-
Change of Owner in Catalog FoldersSummary: What are all the actions that trigger the change of ownership for folder, sub folder and reports under it? Please explain in what all cases "System Account" is …
-
I want to use hth.xml_data_cache.getClobVal() to get the Promotion details like new Position, etcSummary: I want to use the hth.xml_data_cache.getClobVal() function to display the Promotion details like new Position, new Manager, new Salary in separate columns. How …Consultant Ian 21 views 0 comments 0 points Started by Consultant Ian Reporting and Analytics for HCM