BI Publisher
Discussion List
-
How to get full length sentence of a label in bar graph for charts function in RTF Template of BIPSummary: We do have feedback questions and ratings against each question. The goal is to display a bar graph in RTF Template with question vs ratings. How to get full le…Harini Sairam 11 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM -
How to SUM G_1, G_2 and G_3 in DATA_DS summary record for ETEXT template?Summary: we have 3 Records as G_1, G_2 and G_3 and need to show the total number of records in each of them have to be sum and display in DATA_DS in E-text fixed length …Vinay Prasad 31 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM -
BI Publisher is limited in Storage?Summary: Does anyone know, What is the maximum volume of gigabytes that can be stored in different file formats? Regards, Content (please ensure you mask any confidentia…Hernan Modlin-Oracle 1 view 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
Need to create a report on the bursting job history detailsHi, We have a job which triggers letter to employees. We need to create a report wo whom and all the letter is triggered from job history. Can you help me with the table…Shanmukhi 11 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
How to correctly write a BIP query in the OAC environmentSummary: Obtain the value list of launch parameters in a BIP report on the OAC environment Content (please ensure you mask any confidential information): Hi when I write…AM HRE 21 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
Is CRC32 function supported by Oracle fuion BISummary: Is CRC32 function supported by Oracle fuion BI Content (please ensure you mask any confidential information): Version (include the version you are using, if app…Ishtiaque AHmed 31 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
What can be the sql query to determine the person address subject to LDG address configuration?What can be the sql query to determine the person address which satisfies the condition of having all the mandatory address field by the person LDG address configuration…
-
Query to get Report run History in Fusion HCMSummary: Query to get Report run History in Fusion HCM Content (required): Hi All, Can we get the detail who all have run the BI report, is there any query available. He…Swati U 1.8K views 11 comments 0 points Most recent by Punam Roy Karmokar Reporting and Analytics for HCM
-
Document of record - config ignored + inconsistent behaviourSummary: Document of record is attaching even though configuration states that document name is required and relevant. HCM Extract has an output item that points to a BI… -
Can we download AP invoice attchement for BU / period of timeSummary: Can we download AP invoice attchement for BU / period of time Content (please ensure you mask any confidential information): Can we download AP invoice attcheme… -
Report on Career AmbassadorHi, is there any Oracle HCM table available to report employees who signed up for Career Ambassador?Francesco Cerioni 21 views 5 comments 0 points Most recent by Francesco Cerioni Reporting and Analytics for HCM -
Query to get all possible list of ess job statusesHi, Is there a standard or common lookup which holds all possible values of ESS Job statuses like Succeded, Error, Warning etc. ? There's one common lookup 'ORA_WLF_ESS_…Ankit_Bhadja 1.3K views 4 comments 1 point Most recent by User_65LA6 Reporting and Analytics for ERP -
SQL Query for Fixed Asset YTD DepreciationSummary: Hello, We have a customized Oracle BI Publisher Report for Fixed Asset's YTD Depreciation. Our business requirement is that : When an asset is fully depreciated…
-
Regarding "SEPA Credit Transfer Initiation" paymentHello gurus, Good day! 1. I would need the original copy of "ABBL XML FORMAT" the xsl template for the "SEPA Credit Transfer Initiation (with unstructured remittance det…viji_r 32 views 1 comment 0 points Most recent by Mohamed Sadik -Oracle Payables, Payments & Cash Management
-
How to fetch "Check Payment Status" and "Check Issued State" in HCM for US Payroll ?Summary Hi All, Kindly help me to fetch the details of the Check payment as in HCM. As I required a few below columns: Check Payment Status: What is the current status o…abhjkum-Oracle 32 views 1 comment 0 points Most recent by Stephen Westerfield-Oracle Payables, Payments & Cash Management
-
Global Talent Community Pool data not visible in OTBISummary: Hi Team, We are using OTBI to fetch data from the candidate data belonging to "Global Talent Community Pool". However, we are getting only one record having sta…
-
Certification: Retrive attachments information with OTBI or BI PublisherHello, our customer asks to retrive the information associated to the attachments section of certifications (URL and PDF), is it possible? if so, how? Any advice? Thank …Alessandra T. 1 view 0 comments 0 points Most recent by Alessandra T. Reporting and Analytics for HCM -
How to add ICS file in custom alert/notification?Summary: How to add an ICS file in a custom alert/notification? We have created a BI Publisher report for customized notifications in which we are using RTF templates. C…
-
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 Harish Vummidi 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. 32 views 5 comments 0 points Most recent by Jun Ye-Support-Oracle Applications Security