BI Publisher
Discussion List
-
How to link GL journals to external cash transactionHi Team, I would like to create a custom BIP report to link GL journals to external cash transaction. How can I trace back from GL journal to external cash transaction? … -
Excel template - with CSV Output -- Do we have an option to hide parameters ?Hi team, Excel template - with CSV Output -- Do we have an option to hide parameters ? -SridharSridhar Gupta Yerram-Oracle 21 views 3 comments 0 points Most recent by Shankar-Oracle Reporting and Analytics for ERP
-
Excel template- Why the column header is not copied into other sheet- for rec# > 65KHi team, When the output has more than 65K records - Excel output is getting generated with multiple sheets, but only the first sheet has column name, remaining sheets d…Sridhar Gupta Yerram-Oracle 1 view 2 comments 0 points Most recent by Shankar-Oracle Reporting and Analytics for ERP
-
Not able to get any Data from the table INV_MIN_MAX_GTSummary: Not able to get any Data from the table INV_MIN_MAX_GT. Do we need any specific roles or data access for that Content (please ensure you mask any confidential i…Chaitra Kayi-Oracle 52 views 5 comments 0 points Most recent by Maalavica Reporting and Analytics for SCM
-
query to get asset number under transaction information at subledger levelThanks in Advance !
-
Inventory Transaction Detail BIP Report-30 Columns-Item with Serial Control Enabled-65K LimitationSummary: Hi Everyone, We have a requirement from business to build BIP report for the Inventory transactions which they track manually at present. There are around 30 co…
-
Using Dynamic Hyperlink in Layout Editor (.xpt template)Summary: I have a report using .xpt template / Web layout editor, there is a text Goal Center that I need to convert to a hyperlink so users can go directly to My Team >…Carlo Reyes-59977 93 views 0 comments 0 points Most recent by Carlo Reyes-59977 Reporting and Analytics for HCM
-
Fusion BI Report Time zone issues in report output related queriesOur users are in PST Timezone and has raised concerns about report outputs being in UTC Timezone. We are trying to update report code and wanted to clarify few queries b…Abhilash K - Deloitte USI 561 views 8 comments 1 point Most recent by Abhilash K - Deloitte USI Reporting and Analytics for ERP -
How to create data control name while registering ESS jobHi, We have requirement to modify default parameters of the seeded ESS Job. Parameters controls by the "Data Control Name" . Is there any feasibility to create a new "da…
-
What is the link between batch name and ESS job Import Journals ?Hello, We need to query the details of a journal batch (Batch name) with the schedule process (ESS Job 'Import Journals') that created that journal batch. We obtain the …
-
Cannot generate "Open Purchase Order Analysis Report"When I tried to run the standard "Open Purchase Order Analysis Report," I noticed that it doesn’t have a layout and the data model appears to be empty. I’d like to under…
-
SQL for ENABLED code combinations that have a disabled segment included.Summary: SQL for ENABLED code combinations that have a disabled segment included. Content (please ensure you mask any confidential information): SQL for ENABLED code com…
-
Output File Names | BI Reports and Payroll FlowsContent Hi, We've had a requirement where the users wanted to generate the file output via Payroll Flows rather than accessing it via a link / BI catalog path. We've man…
-
RTF Template: Achieve Distinct Values in RTF TemplateSummary: RTF Template: Achieve Distinct Values in RTF Template Content (please ensure you mask any confidential information): Hi Team, I have an extract where location a…UrvashiJ 564 views 1 comment 0 points Most recent by Basavaraj Navalagi Reporting and Analytics for HCM
-
In the BIP report I require Virtual Classroom Type from Learn ModuleSummary: Content (required): I need to fetch " Virtual Classroom Type " and respective Virtual Classroom/Classrooms.Which table field is to be mapped to get the below re…
-
How to fetch Audit reports under tools or how to schedule the audit report and get data on a dailySummary: Hi Team, I need to fetch audit data, I am able to export the data from the audit report under the tools, how to schedule this report on a daily basis or help me…nanda.patil 226 views 3 comments 1 point Most recent by Ashwin Sinha Reporting and Analytics for HCM
-
Print Receivables Transactions – Historical Delivery Details Retrieval (Older than 1 Year)Hi All, Need to check if there’s any way to retrieve delivery details (email, timestamp, etc.) for invoices sent via the Print Receivables Transactions job, specifically…
-
BIP Report - Security - Role/Privilege required to access data in XLA tablesSummary BIP Report - Security - Role/Privilege required to access data in XLA tablesContent Hello, We developed a custom BI publisher report having XLA tables in the Dat… -
Table / Columns name to report the Evaluation and typeNeed the table / column information to report the below highlighted fields in custom BIP to review the feedback basis the evaluation attached to the offering against the… -
I am not able to see few terminated PPRs in iby_pay_service_requests tableSummary: Some of the terminated PPRs in the iby_pay_service_requests table are not visible to me. Does this table lack any security or data access? Despite the fact that…Lakshmi Bandlamudi 1 view 2 comments 2 points Most recent by Mohanasindhu Dhiraviyam Reporting and Analytics for ERP
-
Difference between Date_created column and creation_date column in GL_INTERFACE TableSummary: Difference between Date_created column and creation_date column in GL_INTERFACE Table. Name Datatype Comments CREATION_DATE TIMESTAMP Who column: date and time …
-
Week Number calculation for OTL Overtime report if week starts from saturday and end on fridaySummary: Hi Team, We need to calculate the weeknumber for a overtime card report. Week will start from saturday and end on friday We need to pass "from week" and "to wee…
-
which table has the information of Legislative Categories for Manage legala AuthoritiesSummary: Hi Team, We need a table where the information of Legislative Categories stored for Manage legala Authorities. We have the table HZ_PARTIES to get Legal authori…Opkey PA 11 views 1 comment 0 points Most recent by Chai-Oracle Payroll and Global Payroll Interface (GPI)
-
Question about Infolet on ERPHi Team, Our client is currently undergoing a process to revalidate user privileges. During this process, we observed that simply accessing the pages and viewing the Inf…Oscar Chahestian-Oracle 21 views 4 comments 0 points Most recent by Oscar Chahestian-Oracle Reporting and Analytics for ERP
-
Which table is used to extract the offer price data?Hi all, does anyone know which table is used to extract the offer price? We need to retrieve this information for a report. I'm also attaching a screenshot of the data. …
-
Base table - Email Notifications Workflow approvalsContent Hi, I am looking for a table that holds emails sent out of the workflow mailer. I am specifically looking for details such as Transaction/Task id along with an e…Sriharsha Devraj 800 views 2 comments 0 points Most recent by User_AOTJG Reporting and Analytics for HCM -
Permission Error When Trying to Migration BIP Reports between DEV and SAT environmentsSummary: We've setup a pipeline in VBS and are using a job to migrate data models and bip reports from one region to another and running into a permissions error on our …User_2025-03-07-05-28-28-079 61 views 10 comments 0 points Most recent by Choudhary Punit Reporting and Analytics for ERP
-
with clause subquery and function together and usage of bind variableSummary: Hi Team, I am facing an error as "ORA-17003: Invalid column index". I am using functions(with clause) and I have to get the value from the BIP report parameter.…Sunil Pradhan 32 views 0 comments 0 points Most recent by Sunil Pradhan Reporting and Analytics for ERP