BI Publisher
Discussion List
-
What is the table storing Account Type?Summary: What is the table storing Account Type? Content (please ensure you mask any confidential information): Hi Experts, May I ask what is the table storing accountin… -
HCM secured views - listHi, Can you please suggest where can I get all the list of secured views for HCM? Thanks in advance. Version (include the version you are using, if applicable): 24C -
CertificationSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Vijay Kumar Reddy 1 view 1 comment 0 points Most recent by HarishVummidi Reporting and Analytics for HCM
-
Report to extract all Dynamic Group/Analysis Criteria and the filters applied to it.Summary: We have Dynamic Group/Analysis Criteria created in Oracle Learning. Is there a report we can use to extract all Dynamic Group/Analysis Criteria and the filters …
-
Is there a way in BIP PL SQL to retrieve where the transaction has been done?Hello Experts, for example, the transaction was done in Me Tab, then PL SQL will tell that this is Me tab page, or in a My Team page. I am currently creating a transacti…Joliver Caangay 1 view 1 comment 0 points Most recent by Joliver Caangay Reporting and Analytics for HCM
-
Is it possible for Oracle Tables for all HCM transactions including archived transactionsSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Check Printing IssueSummary: Overflow in Check Printing Content (please ensure you mask any confidential information): We have to customize the out of the Box Check Printing report. Above t…KetanDoshi 11 views 1 comment 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management
-
IP address when an employee completes a courseSummary: Please let us know if there is a way to capture the IP address when an employee completes a course or any where in table the IP address is captured when employe…
-
Can anyone please share the best practice to create BIP Report template having more than 50 columnsSummary: Can anyone please share the best practice to create BIP Report having more than 50 columns I have a requirement to develop a BIP report having 54 columns and he…Kundan Kumar17 21 views 0 comments 0 points Most recent by Kundan Kumar17 Reporting and Analytics for HCM
-
Is there a way to delete data from FND_SESSION_ATTRIBUTES, FND_SESSIONS tablesSummary: Hi Fellow Developers, The requirement is to delete all data from FND_SESSION_ATTRIBUTES, FND_SESSIONS tables for security reasons. Content (please ensure you ma…Dhilip Kumar P. 31 views 5 comments 0 points Most recent by Jun Ye-Support-Oracle Applications Security
-
Is it possible to report on Alert History?Summary: Need to see alert history in easy to read format Content (required): We have quite a few alerts running and would like visibility to what is sent and when to he…Janine Brown 426 views 10 comments 4 points Most recent by Murali Togaru Reporting and Analytics for HCM -
which table and column the 'Stage' field is fetched from in the 'Manage Payment Process Requests' ?From which table and column the 'Stage' field is fetched from in the 'Manage Payment Process Requests' screen in Oracle Fusion Payables as attached?Nirosha Yelicherla 61 views 4 comments 0 points Most recent by lkarthik-Oracle Payables, Payments & Cash Management
-
Payables Trial Balance Report ESS Job Template changeSummary: Hi, User requested to create a template change for Payables Trial Balance Report, the ESS job. As this is an oracle developed report you cant make a template ch…aireyevan 51 views 3 comments 0 points Most recent by Shouryadeep12-Oracle Payables, Payments & Cash Management
-
Project info for an expenseHello all, I've a requirement to pull the project details like expenditure organization, task number,project numer for an expense itemizations created for an expense lin…
-
Set default value for LOV to NULLI have a BIP report with multiple LOV parameters. When data-model/report is opened all LOV parameters are set to ALL by default, I need these parameters to be set to NUL…
-
Receivables Aging by General Ledger Account Report - seeded Datamodel not workingSummary: I have been able to customize the Receivables Aging by General Ledger Account Report to be more usefull, by using the seeded datamodel and creating a new report…Anders W. Langholm 21 views 7 comments 0 points Most recent by Tyrion Lannister Receivables & Collections -
Need an help for SQL querySummary: Content (please ensure you mask any confidential information): I want to extract report for Manage Legal Reporting Unit Registrations, however I have a SQL whic…Shilpa Dam 83 views 3 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Information: Query to get last P2T/T2T Refresh DateSummary: In order to get last refresh date from backend, below SQL can be used: select * from ask_deployed_provision_configs last_update_date column in this table gives …MandeepGupta 321 views 3 comments 11 points Most recent by Shyam Patel Reporting and Analytics for HCM -
Report for active State Withholding ID for W2Summary: Report for active State Withholding ID for W2 Content (please ensure you mask any confidential information): Hi All, Greetings! We need to get the list of the a…Parag Hiremath 1 view 0 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
How can I see all chart types in Fusion Data Intelligence (FDI)?Summary: How can I see all chart types in Fusion Data Intelligence (FDI)? Content (please ensure you mask any confidential information): I need to know what kind of char…Stefano_Mazzocca 31 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM -
sql to get learner pass fail status along with course completionHello, Does any one know which table stores the Learner course completion status (complete/not complete) along with pass/fail status? @Sricharan Monigari @MandeepGupta @… -
Extracting the absence durationSummary: Hi, I need to extract the absence duration of employees for a report need. I thought I could use the GET_PAY_AVAILABILITY function for this, but it didn't work.…Barış Ergün 82 views 2 comments 0 points Most recent by Omnia-Oracle Reporting and Analytics for HCM -
Can we get ZPL output for Zebra Printer from Oracle BI PublisherSummary: We need to get ZPL output for Zebra Printer from Oracle BI Publisher. Is it possible to get that. Please advise. Content (please ensure you mask any confidentia…Sandipan_Chakraborti07 11 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
Support Incremental is not enabling for BICC extractSummary: Hi Team, we are using application composer custom objects and looks like supports incremental is not getting enabled to this like it happen for seeded ones. Can…PrasadN 54 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
Inquiry Regarding Dynamic User Inclusion in Report Emails via BurstingSummary: Hi Oracle Experts, We have received a request from our users to include the username of the individual executing a report in the email body after the "Thanks" s…Sai Sreeram Gundepudi 21 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
How to use if statement for comparing dates in BIP templateSummary: How to use if statement for comparing dates in BIP template Content (please ensure you mask any confidential information): I have customised the Customer Statem…Chez 1 view 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
Will Oracle provide NAUPA Reporting format for unclaimed property filings to State?Summary: State of Illinois requires electronic reporting for the unclaimed escheatment property. Will Oracle Fusion create a reporting format in later releases to accomo…LE 21 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
Date parameter is defined as date but I still get errorSummary: I have created p_date as a date parameter in my data model. p_date is defined as date data type and parameter type date. I am looking to get the days between p_…Consultant Ian 31 views 7 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM