BI Publisher
Discussion List
-
BIP: For Year Parameter, Set Default Value as Current Year and attach LOV (SQL Query LOV) to the YeaSummary BIP: For Year Parameter, Set Default Value as Current Year and attach LOV (SQL Query LOV) to the Year ParameterContent Hi, This is related to earlier post: https…User_MC37Q 1.1K views 5 comments 1 point Most recent by NIRMAL KUMAR L Reporting and Analytics for HCM -
Query Supplier Account Bank Information TableSummary: I Want to export all information about supplier account bank via BI Report Content (please ensure you mask any confidential information): Supplier on Procuremen…Muhammad Fahmi 132 views 3 comments 0 points Most recent by User_U58AH Payables, Payments & Cash Management -
Report or SQL Query to Identify Unused Departments in Department TreeHi Team, We’re looking to generate a report that identifies unused departments within our department tree. Specifically, we’d like to find departments that: Have no asso…Mahendra Y 2 views 1 comment 0 points Most recent by Carl Bequilla-Oracle Reporting and Analytics for HCM
-
Access to customize reports in Publisher greyed outHi all, Hoping someone could assist with an issue regarding access to customize reports in Publisher. The user has BI Author and BI Admin. The folder permissions for the…G. Class-Peters 21 views 0 comments 0 points Started by G. Class-Peters Reporting and Analytics for HCM -
NETWORKDAYS Logic In BI ReportHi , As a Business requirement we want to get the Working days between 2 days. I tried to get this using below query. But getting 0 as output. (select count(*) from tabl…GaneshSKulkarni 1 view 0 comments 0 points Started by GaneshSKulkarni Reporting and Analytics for HCM
-
Burst to multiple email addresses stored in a parameterSummary: Burst to multiple email addresses stored in a parameter Content (please ensure you mask any confidential information): I would like to have Bursting to multiple…
-
Reporting/Managing on Goal Plan EligibilitySummary Can goal plan eligibility be managed like Performance documents can?Content I've been searching the forums but haven't found a clear answer. I have a lot of ques… -
Unable to proceed to create Dataset using webservice in Oracle BIP ReportSummary: Unable to create dataset with Webservice while creating custom BIP report Content (please ensure you mask any confidential information): below are the steps to …SireeshaJaladi 121 views 6 comments 1 point Most recent by Sri Prasanth Reporting and Analytics for ERP
-
Not able to view seeded template at the seeded path after customising the reportI have customized the seeded template for the US Payslip report and it is present at the custom path:/shared/Custom/Human Capital Management/Payroll/Payment Distribution…Aditya Jadhav 32 views 4 comments 0 points Most recent by Aditya Jadhav Reporting and Analytics for HCM
-
Missing Columns in BICC PVO but columns available in the underlying Oracle database tablesSummary: While analyzing the BICC Object Views for sending the data to Traget System—similar to the BIP extracts—for the following three Oracle tables, I noticed that so…Anshul Bansal 53 views 1 comment 0 points Most recent by Sai Revanth Reporting and Analytics for ERP
-
How To Edit Payroll flow report as it is seeded Gross to Net ReportThe data model and report are both seeded for Gross to Net Report. Can you please let us know if the Payroll Flow can be altered to call custom reports as we would like …Srujanya Dodda 41 views 3 comments 0 points Most recent by Ketan-Oracle Reporting and Analytics for HCM
-
Request to Exclude Zero-Amount Records from Standard Customer Statement ReportHi Team, We have requirement in the standard customer statement report output and require a solution or workaround to exclude zero-amount records from the report. For re…Raman_Balasubramaniam 41 views 3 comments 0 points Most recent by User_VQFGM Receivables & Collections
-
OTBI/BIP catalog/folder last update date differenceHI Team, After a refresh/upgrade/patch getting applied does the folder last modified date change for each folder. We could see some folders have different last modified … -
How to add page break in etext template (Fixed position based) in BIP reportHow to add page break in etext template (Fixed position based) in BIP report? Need to add page break after every 50 rows.Harshitha S Motagi 31 views 3 comments 0 points Most recent by Lee Eslick-Huff Reporting and Analytics for ERP
-
Hi All can anyone help me to print these columns item and description in my transaction report.Summary: Please help me to print these columns in my transaction detail report please provide sql or tables where i can find these columns data. These are present under …
-
Any OTBI Report/table to get Multiperiod Accounting Transactions AHCSDo we have any tables or oracle Reports BI or OTBI to get the list of Multiperiod transactions posted and future transactions other than table XLA_MPA_DISTRIBUTIONS.Chetan007 1 view 1 comment 0 points Most recent by Anca A-Oracle Subledger Accounting & Accounting Hub
-
Need to get the OTBI Schedule Agent Information Report Jobs.Summary: Content (please ensure you mask any confidential information): We need to the details of OTBI agent schedule report jobs when the report was run details, who ra…VishnuVardhan Raju 31 views 3 comments 0 points Most recent by Nathan CCC Reporting and Analytics for HCM
-
The extract chunking task does not generate the default XML(at least parameter data) file.Hi Team, We observed that when there is no data to chunk, the extract chunking task completes successfully after 25C; however, it does not generate the default XML file …
-
BI Publisher Run report Rest API Call Unsuccessful.Summary Trying to access the Run Report Rest API for BI Publisher but without success.Content Hi there, I'm trying to run a POST request against the RunReport task withi…User_2025-02-05-10-38-08-223 178 views 6 comments 0 points Most recent by Babu Chalamalasetti Reporting and Analytics for ERP -
Trying to add new custom font in BIP getting errorSummary: I am Trying to add new custom font in BIP getting below error. Path : Admisnstartion→Runtime Configuration→Font Mapping When i click on Font mapping then gettin…Basavaraj Navalagi 71 views 6 comments 1 point Most recent by Bhaskar Konar Reporting and Analytics for ERP -
Looking for a way to limit/disable the use of the refresh button on the BIPublisher rep executionMy client has a report that runs based on a date range. However, after running the report, when they immediately click the Refresh button, it triggers the data extractio…Oscar Chahestian-Oracle 1 view 4 comments 0 points Most recent by Oscar Chahestian-Oracle Reporting & Analytics for Sales
-
We need show Invoice Distribution COA Account segment values on AP CheckSummary: We need to show Invoice Distribution COA Account segment values on AP Check in Fusion Cloud Accounts Payable. These fields are not available in XML. I cannot ad…Ibrahim Konak 21 views 1 comment 0 points Most recent by AnamariaRoman-Oracle Payables, Payments & Cash Management
-
How to viiew Package - gl_flexfields_pkg.get_description_sqlHi, I was able to fetch the description based on the package /* select gl_flexfields_pkg.get_description_sql(23,23,7) from dual*/. However; I would like to see the entir…
-
segregation of dutiesIs there a report for segregation of duties for Finance?
-
How to fetch the physical address of Geo coordinates that we have in Time records?Summary: On the OTL page, we can view the latitude and longitude of the geo-location from which an employee submits their timesheet. Additionally, there is a button that…ManikandanRajagopalan 31 views 4 comments 0 points Most recent by ManikandanRajagopalan Reporting and Analytics for HCM
-
How to Add Custom Email Body Text for Separate Remittance Advice Email (with PDF) in OracleHi All, In Oracle Fusion Payables, I need to send a Separate Remittance Advice by email with a PDF attachment and have a specific message appear in the email body. The m…Mukesh Sirigiri 185 views 3 comments 0 points Most recent by Mukesh Sirigiri Payables, Payments & Cash Management
-
unable to query the rejected transaction details from the approval related tablesSummary: We have a requirement to report on the approval transactions (approved/rejected) and we have built the query based on hrc_txn_fnd_bpm_task_vl and hcm_fusion_soa…
-
Is there any base table for privilege master along with table to map privilege table with roles?Summary: Hello experts, We are trying to create a BIP query to map the user to role and role to privilege. Previously we were using the "ASE" tables for this purpose, bu…
-
How to link ANC_ABS_USAGE_RULES_F and ANC_ABSENCE_TYPES_F tableHow to link ANC_ABS_USAGE_RULES_F and ANC_ABSENCE_TYPES_F table select * from ANC_ABS_USAGE_RULES_F usage_rules where ABS_USAGE_RULE_ID =300000134481566 -- ABSENCE_TYPE_…Rama Krishna_Annam 11 views 1 comment 0 points Most recent by Carl Bequilla-Oracle Reporting and Analytics for HCM