BI Publisher
Discussion List
-
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 91 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 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…
-
What is the efficient way to get balance value in BIP report?Summary: Currenly we are using below subqueries to get the balance values for any payroll_rel_action_id. But our report has many columns to get the balance value and it … -
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 31 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 271 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 241 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 54 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 12 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 92 views 1 comment 1 point Most recent by Dhaval Patel-Oracle Payables, Payments & Cash Management
-
Action link for learningSummary: Need guidance to create action link for course learning report. I have made a learning report where course related columns are present, e.g. learning item name,…
-
SUBJECT_ID context in HRQ_QSTNR_PARTICIPANTS in case of use for Feedback CenterSummary: Hello, I'm building BIP report which should show Feedbacks from Feedback center where customer uses the questionnaire. I have SQL which returns me all questions…Martin Smid-Oracle 61 views 1 comment 0 points Most recent by Martin Smid-Oracle Reporting and Analytics for HCM
-
Which table holds Learning Initiative DataSummary Which table holds Learning Initiative DataContent Hi All, We are missing link to identify the only Initiative enrolled for specialization. We had built the below…