BI Publisher
Discussion List
-
How to Fix Height of table In An RTF TemplateSummary: Hi Team ,Can anyone tell me how to Fix Height of table In An RTF Template. Example: If table has 1 or 10 invoice the height of table should be same. I have chec…Nidhi Chhajed 282 views 3 comments 0 points Most recent by Leeni Samuel Reporting and Analytics for ERP -
How to display OTBI report in Journey task "report"Summary: Hi Team, I have a OTBI report and I want to display in journeys where employee can see the data and esign. I am using advanced task and but report is not coming…AvinashP 221 views 15 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Account Analysis Report - The report columns are shuffled in CSV format outputIn Standard Account Analysis Report - The report columns are not in a proper order in CSV format output. for every different parameter the some columns are shuffled. Ple…Thanigainathan R 11 views 1 comment 0 points Most recent by CA Nirmal Choudhary General Ledger & Intercompany
-
How to add Hyperlink to BI Excel template fieldSummary: We have a requirement to show Oracle AR Invoice Page and when click on Invoice Number in BI Excel template. Excel template has list of Invoice Numbers and its d…SireeshaJaladi 402 views 5 comments 0 points Most recent by SatheeshSamy-Oracle Reporting and Analytics for ERP
-
Which table stores Payroll Association dates?Summary: We are able to report on Payroll Relationship Final Close date and specific Payroll Assignment dates, but cannot find the data for Payroll Association Final Clo…TraciH-NorthBayHealth 1K views 6 comments 0 points Most recent by awheel09 Reporting and Analytics for HCM -
Scheduling "report" based on column with user emailSummary: I developed an SQL report on OTBI and an EXCEL output should be delivered to corresponding users. There is a column containing email address of the user and use…Rojhat Sinan Balka 1 view 1 comment 0 points Most recent by James McBride Reporting and Analytics for ERP
-
Query/tables to find payment approved by final approver approved PPRSummary: Query/tables to find payment approved by final approver approved PPR Content (please ensure you mask any confidential information): Hi All, We got a requirement…
-
Request Read Receipt while scheduling BI ReportsContent I have scheduled a BI report and enabled Request Delivery Status Notification and Request Read Receipt Option. But I havent received any email or notification af…Sabarish Reddy Ganda 128 views 1 comment 1 point Most recent by Usman Ali2025 Reporting and Analytics for ERP
-
Duplicate of Print Receivables Transactions Report fails to reach parameter selectionSummary: I have created a duplicate of the Print Receivables Transactions Report to be able to add an additional parameter to the report. Upon duplication the process sh…
-
Tables to get Multiperiod Accounting Invoices With Amortization ScheduleSummary: Tables to get Multiperiod Accounting Invoices With Amortization Schedule Content (please ensure you mask any confidential information): Hi All, Is there any tab…Venkatesan 71 views 1 comment 0 points Most recent by Daniela Petria-Oracle Subledger Accounting & Accounting Hub
-
Seeded Deferred Compensation Overlimit Balance Exception report has incorrect formula valueSummary: Balance Exception Report for Deferred Compensation Overlimit with exception name 401k Over the Limit has incorrect formula value Content (please ensure you mask…Karen Settembrino 11 views 0 comments 0 points Started by Karen Settembrino Reporting and Analytics for HCM -
SQL query or Table for Actions under Transaction Design studio in oracle fusion HCM my client groupSummary: Hi Team, We need a table name or SQL query where the information of Actions under Transaction Design studio in oracle fusion HCM my client group. Content (pleas…
-
ELIGIBLE WORKERS FOR COMPENSATIONSummary: How can I extract the list of workers that concur to determine the number of eligible in the fields ELIG_COUNT_DIRECT of CMP_CWB_SUMMARY table?Gian Luca Triglia 11 views 1 comment 0 points Most recent by Gian Luca Triglia Reporting and Analytics for HCM
-
Facing issue to fetch proposed value of Pending TransactionsWe are trying to fetch proposed valued of pending transactions. Transaction is on Assignment change, I have written the following code but getting ORA19011: "Character s…SWAGATA1991 31 views 2 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
How to customize ISO20022CGI2019.xslSummary:How can I customize ISO20022CGI2019.xsl? Which fields from which records can I use? Content (please ensure you mask any confidential information): Version (inclu…User_VJR36 21 views 2 comments 0 points Most recent by MariusS-Oracle Payables, Payments & Cash Management
-
HCM EPBCS Metadata Extract Not Pulling All EmployeesHello, We are using the OOTB HCM Extract to EPBCS. We are having an issue where active employees are not coming through our Metadata extract, but do come through our Ass… -
BI Report to get the previous and present records of job, salary amount, department and grade.Hi Team, I need a working sql query to get the previous and present records of job, salary amount, department and grade in BI Reports. Parameters: - Action Code, from da…Support 22 views 2 comments 0 points Most recent by Carl Bequilla-Oracle Reporting and Analytics for HCM
-
How to create Parameterized HCM Extracts which is linked with BIP Report?Summary: Hello, We have a requirement to load a data using HDL by getting a data from HCM Extracts which is also linked to BIP report. We have achieved this without any …
-
Create BI with CustomSubject area crossed out.The subject area is crossed out to create a BI. One has the activity as the primary subject and the second has theOpportunity as the primary subject. When I add a “Resou… -
Profile BIP_CLIENT_REFRESH_TIME_HCM is not working as ExpectedStep1 Manage Administrator Profile Values Search for Profile :BIP_CLIENT_REFRESH_TIME_HCM Profile Value is 1440 Step2 we updated the profile value to 15 at Site level Sa…Rama Krishna Annam 1.5K views 2 comments 1 point Most recent by NERU Reporting and Analytics for HCM
-
Last login of service accountSummary: I would like to find when a particular service account last logged in either through UI or through Webservice or both in Oracle ERP Fusion. Is there any SQL que…
-
Reading offering, functional area and setup task using querySummary: For an integration, looking for a way to map Offerings/Functional Areas and available Setup tasks. Using OTBI, is it possible to write a report/query to get the…
-
Need query/table to get accounting status of external transactionsSummary: Need query/table to get know the accounting status of an External Transaction Content (please ensure you mask any confidential information): Version (include th…Dipak Das 21 views 1 comment 0 points Most recent by Shouryadeep12-Oracle Payables, Payments & Cash Management
-
Job Offer Letter - RTF template If Condition for hire dateSummary: Hi Everyone, Does anyone has experience to write the condition rule under the RTF Template for Job Offer Letter (BI Pulisher), I would like to get some advise o…Kristy Fung 18 views 1 comment 0 points Most recent by Lohit Kad-Oracle Reporting and Analytics for HCM
-
Creating a Headerless CSV File Using eText TemplateSummary: We are planning to develop a report in BI Publisher that generates a CSV file without column headers. Our understanding is that in order to exclude the header, …Jimin Park 145 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
How to use number format of process options of ess job in the BI publisher concerned ?Hi, how to format amounts of my custom BI Publisher depending on Number Format of my custom ESS job (defined for this custom report), submitted to Scheduled Processes ?LaurentDup 1 view 1 comment 1 point Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP -
error using data mode property: Optimize Query ExecutionSummary: Hello everyone, a few days ago I experienced a new situation. I have a report that extracts a large amount of data (over 100,000). I tried to optimize the execu…Ayala01 11 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP -
Query to Find Privillages under Role and its Inherited RolesSummary: Need query to get privileges assigned under Role and its inherited Roles. Content (please ensure you mask any confidential information): Tried Below query but l…Nishanth B Jain 528 views 2 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP -
I want to restrict last line of any receipt line to be printed in EDI Etext template for the clientWe have 2 new BIP report enhancement requirement To restrict every receipt's last line to be restricted in the query, please see screenshot below for your reference the …Shahid Qureshi 11 views 2 comments 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP