BI Publisher
Discussion List
-
Conditional Signature Printing in Disbursement Payment File Formats Based on Fusion InstanceSummary: In the Oracle Fusion ERP seeded report “Disbursement Payment File Formats”, I need to conditionally print a signature in the check template based on the Fusion …Basavaraj Navalagi 11 views 0 comments 0 points Started by Basavaraj Navalagi Payables, Payments & Cash Management -
Customization of seeded "Supplier Balance Aging Report"Summary:Hi, I am looking for customization of seeded Supplier Balance Aging Report in Oracle fusion application where I want to add currency as a parameter to run the re…Shraddhha Namde 205 views 12 comments 0 points Most recent by Smruthi M Reporting and Analytics for ERP -
Account Analysis Report - How to Pass Account Filter (P_FLEX_FIELD_RANGE_FILTER_ID)Summary: We are working with the Account Analysis Report in Oracle Fusion (ESS Job). When we apply an Account filter (Natural Account segment) in the report submission U…sailesh_cloudare 23 views 2 comments 0 points Most recent by User_5PFSB General Ledger & Intercompany -
Recommended OTBI and BI Publisher Reports for Financial ReconciliationI’m exploring OTBI and BI Publisher in Oracle ERP Cloud and would like to build useful reports for reconciliation between Payables, Receivables, and GL. Could someone re…
-
Report Date Parameters needed START: (First_Day of Last month) END: (Last_Day of Last_month)Summary: Hi Forum: I'm looking to use below to accomplish General tab for Scheduling a report START: Last_Day(ADD_MONTHS(SYSDATE,-2))+1 First_day END: Last_Day(ADD_MONTH… -
User_2025-02-05-14-11-28-072 5.2K views 33 comments 1 point Most recent by suellen Reporting and Analytics for HCM -
BIP Schedule Data Parameters for the Previous MonthSummary: BIP Schedule Data Parameters for the Previous Month Content (please ensure you mask any confidential information): I am looking to use date parameters on a BIP …
-
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 151 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 461 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 61 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.3K 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 95 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 133 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 183 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 22 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 82 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…