BI Publisher
Discussion List
-
SQL to list all customized OTBI and BI Publisher reportsSummary How to list all OTBI and BI Publisher reports in Shared Folders?Content Hi Team, Does anyone have the SQL that we can run to list all OTBI and BI Publisher repor… -
How to gather data of update interest tab from all employees?Summary: We need to create a report which shows all the data user has entered in Update interest page. Basically we want to gather employee interest so that recruiter ca…Vaidehi Desai 21 views 2 comments 0 points Most recent by Vaidehi Desai Reporting and Analytics for HCM -
Etext Templates do not process an XML tag prefixed with underscoreSummary: XML Fields with underscore prefix are ignored in EText template e.g GB Statutory Deductions /PAYE/ Pay as you earn/ _TAX_CODE, _TAX_DISPLAY, _ISSUE_DATE etc Con… -
Oracle AI Apps: Intelligent Account Combination DefaultingSummary: Hi Oracle Team, https://us.v-cdn.net/6034893/uploads/2NO1N9TY10A9/iacd-supplemental-setup-guide.pdf When i going to enable this feature 'Oracle AI Apps: Intelli…Mina Sabry 155 views 13 comments 0 points Most recent by Sudip Dutta Payables, Payments & Cash Management
-
Working report stopped and throwing an error ORA-01722: invalid numberSummary: I was able to use a custom BI Report a week ago. But it stopped working and throwing an error "ORA-01722: invalid number" when running. I am not sure what is ca…
-
how to call BIP report using REST webserviceSummary: I want to get the BIP report output using REST webservice REST API for Oracle BI Publisher - Run report I have followed oracle doc and this Run Oracle BI Publis…KetanChavan 468 views 10 comments 0 points Most recent by Catherine Alequin Reporting and Analytics for HCM -
Error when running report using REST apiSummary: Error when running/calling the report using REST api. Content (please ensure you mask any confidential information): Hello Experts, Is there a way to call or ru…Shiva Kumar Bandaru 63 views 6 comments 0 points Most recent by Catherine Alequin Reporting and Analytics for SCM
-
Sql to reconcile Receivable Invoices' balances with their applied receiptsSo, I have constructed a sql query to look at Receivables balances using ra_customer_trx_all and ar_payment_schedules_all. I have another query which I tried to summaris…Robert of STAU 1.4K views 5 comments 0 points Most recent by gkulkarni Reporting and Analytics for ERP
-
How to get the last period of previous fiscal year in FRSThere is a requirement in balance sheet report where we need to get the details for Previous Year Ending(PYE) balances in one of the column in FRS report. For Ex: Curren…SRIKANTH DEVARASHETTY 104 views 4 comments 0 points Most recent by Rich Merkel Reporting and Analytics for ERP
-
Cannot drilldown to Invoice UI from Payment approval notificationThere is no hyperlink to drilldown to Payables invoice from PPR notification for the approver. Is there a way to enable this? Or is there a report that can be run that h…SarahL 11 views 1 comment 0 points Most recent by HD - Fusion ERP-Oracle Payables, Payments & Cash Management -
ORA-64203: Destination buffer too small to hold CLOB data after character set conversion.Summary: How to solve ORA-64203: Destination buffer too small to hold CLOB data after character set conversion. Content (please ensure you mask any confidential informat…Stefano_Mazzocca 132 views 3 comments 0 points Most recent by User_FR8AH Reporting and Analytics for HCM -
Purchase Order Reports not showing line quantityWe have an OTBI (BIP) report for Purchase Order details using Procurement - Purchasing real time. The Quantity field for Quantity based POs is not populating, are any fe… -
Delivery of balance forward bills stops in Retry In Progress statusSummary: Delivery of balance forward bills stops in Retry In Progress status Content (please ensure you mask any confidential information): You're about to run create a …Yuma Suzuki-Oracle 185 views 8 comments 0 points Most recent by Samyak Tomar Receivables & Collections
-
SQL query to Backend table for Filtered List under Learning ManagementSummary: Hi Team, We need a backend table or SQL query to get Filtered Lists in Learning Management module. Navigation: My Client Groups → Show More → click Filtered Lis…
-
Error handling in Dunning Letters?Summary: Error handling in Dunning Letters. Example: when there is no email address or dunning recipient specified for a customer then the 'Send dunning letters' job pro…Harsha Valasani 21 views 1 comment 0 points Most recent by Jesús Vega-Oracle Receivables & Collections
-
Each line must have a unique combination of INTERFACE_LINE_CONTEXT and INTERFACE_LINE_ATTRIBUTE valuSummary: Hi team, I was trying to test one edge case, where I wanted to process already imported invoices. but few errored out with Duplicate invoice number which is exp…
-
Please help to find Expense Digest email notification template. Need to edit.Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Time card details based on payroll flow - Load Time Card BatchesHi Expects, Requirement : Need to fetch time card details based on payroll flow - Load Time Card Batches. basically OTL report , based on payroll flow parameter. when we…Rajdeep Chavda 81 views 6 comments 0 points Most recent by Om Shukla-Oracle Reporting and Analytics for HCM
-
extract element type id from xml cacheSummary: How to extract element type id from xml cache: When I try to extract the value , it is always throwing error : extractValue(value(ElementEntry), '//ElementTypeI…
-
What table stores the learning item expected effort for self paced learning items?Summary: We are trying to produce BI publisher reporting for learning and cannot identify where the duration from the self-paced learning items is stored. We have checke… -
PPR Completion dateHi Team, Please suggest from where we can get the completion date of PPRs (as shown in the attached screenshots). We have already checked the following tables IBY_PAY_IN…Jayani Avutu 21 views 0 comments 1 point Started by Jayani Avutu Payables, Payments & Cash Management
-
Comment Column is splitting into multiple rows in Excel outputComment Column is splitting into multiple rows in Excel output for online BI template.
-
For the data conversion process, we need Course related data reports in Learning Module.Summary: We are trying to fetch details for the below objects from Course.dat EvaluationActivityV3 OfferingActivitySectionV3 InstructorLedActivityV3 AdhocResourceV3 Clas…
-
how DOCUMENT_CLOB gets populated in IBY_TRXN_DOCUMENTS table?We have requirements to create custom payment documents. We are reusing ISO20022CGI.xsl file from Disbursement Payment File Formats. The data model has SELECT DOCUMENT_C… -
Query to get interview details for a job requisition using BI ReportSummary: Hello Team, I am trying to get interviewer details (Interviewer person number and email address) using below query but I am not getting the right results. Can a…
-
Custom BIP reports - Security access to view scheduled job outputsSummary: Hi All, We have 5 custom BIP reports, which are shared via scheduling to 5 different groups of people in our organization. We are not sending the output via ema… -
How can we pull last day of current month in eText templateSummary: How can we pull last day of current month in eText template Content (please ensure you mask any confidential information): Hi Team, Our bank wants last day of m…
-
Lease Accounting - Generate Full Amortization Schedule on DemandHi ERP Reporting Gurus! I'm trying to build a report that effectively recreates the full lease detail report that is generated when you create the lease or make an amend…Patrick Northcraft 1 view 1 comment 0 points Most recent by Patrick Northcraft Reporting and Analytics for ERP -
Where the BI Template is defined for Invoice Print TemplateSummary: Where the BI Template is defined for Invoice Print Template Content (please ensure you mask any confidential information): We have made a minor change to our BI…