BI Publisher
Discussion List
-
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 128 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 13 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 175 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… -
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 93 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 24 views 0 comments 1 point Most recent 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…
-
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… -
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…
-
specific field in the database tables that indicates Copy functionality.Summary: Hi everyone, I’m working with Oracle Learning and I’d like to know if there’s a specific field in the database tables that indicates whether a learning item (fo…
-
Print Talent ProfileContent I am creating a custom print of talent profile RTF Template and there are some sections that are only available to line managers but when an employee prints it s…Misbahul Khair 51 views 3 comments 2 points Most recent by Rishitha sravanya Reporting and Analytics for HCM -
REST API to get sales Order line tax amountI am looking for Sales order tax amount for each line. In front end i am able to see tax amount for each line. but when I check it through API, I am getting only total t…
-
whats argument2 in Load Interface File for ImportSummary: whats argument2 in Load Interface File for Import Content (please ensure you mask any confidential information): Im trying to submit Load Interface File for Imp…Jaeyshree Kumaran Kalpana 37 views 2 comments 0 points Most recent by Mahindra reddy-Oracle General Ledger & Intercompany
-
Business Intelligence Publisher Bursting to Email upper ThresholdContent Business Intelligence Publisher Bursting to Email upper Threshold Requirement: 50000 Bursting records get selected and they need to be sent as Email Attachment i…Shivakumar Ayyanagowdar-Oracle 280 views 13 comments 1 point Most recent by Prudvi_Batlanki Reporting & Analytics for Sales -
Customize Printable Expense ReportSummary & Content: Need details for the other VOs and the attribute list similar to what was provided for PrintableReportVO and PrintableExpenseVO in the Oracle Ddocumen…Upendra Nayak 250 views 7 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP -
How to call ESS job by API erpintegrationsHi Experts, I 'm trying to execute ESS job "General Ledger Trial Balances Report" by API erpintegrations in postman. POST https://xx.fa.us2.oraclecloud.com:443/fscmRestA…Marcos Allonso-53979 67 views 3 comments 0 points Most recent by Lakshmi Alagappan-Oracle General Ledger & Intercompany -
Custom Folder is unavailable to all the UsersSummary: Our users are not able to see the Custom Folder under Shared Folders All our reports are in the Custom folder. Possibly -mistakenly the permission of the folder…
-
Finding corresponding entity§ion of an intercompany transaction that hits an entity & sectionHow to find the originating entity and section number of a transation that ends up in another entity and section in the General Ledger. Currently our ERP COA has Entity,…
-
Human Capital Management - Transaction Administration Real Time subject area not workingSummary: We have a report reuqirement to fetch all workflow transactions whether completed or failed, and for failed transactions we need to populate th eissue title, is…Velidi Supraja 11 views 0 comments 0 points Most recent by Velidi Supraja Reporting and Analytics for HCM
-
1099 Future Support for IRS A2A (Application-to-Application) XML File FunctionalityDescription: We are seeking information on whether Oracle plans to support IRS A2A (Application-to-Application) XML file functionality within the product in future relea…Senthil Murugan J 101 views 1 comment 1 point Most recent by Dhaval Patel-Oracle Payables, Payments & Cash Management