BI Publisher
Discussion List
-
Submit button is disabled for Trial Balance Report ESS JobSummary: When user is running the Trial Balance Report ESS Job, Submit button is disabled.Prince Choudhary 161 views 12 comments 0 points Most recent by Nimesha Yatigammana Reporting and Analytics for ERP -
Defining a Common Font Placeholder for Approval NotificationsHi Community, We’re currently working on streamlining the design of approval notifications and were wondering—is there a way to define a common placeholder for the font … -
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 6 views 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 51 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 96 views 0 comments 0 points Started 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 513 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 551 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…
-
Required table for "Direct Apply" section under the task "Recruiting Category Enablement"Summary: Hi Team, We are unable to find the table for the field "Direct Apply" under the setup task Recruiting Category Enablement. The main table are IRC_TP_PARTNERS, I…
-
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 221 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 18 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. …