BI Publisher
Discussion List
-
Unable to find table name that stores comments from 'Request more Info' section of BPM approvalsSummary: Hi All, Unable to find where the comments are stored from 'Request more Info' section of BPM approvals. It's not in table FND_BPM_TASK_COMMENT or HRC_TXN_COMMEN…Nirmal Ignatius 21 views 3 comments 0 points Most recent by Satyam Roy Reporting and Analytics for HCM -
Sample query to retrieve employee DivisionSummary: Content (please ensure you mask any confidential information): Hello experts, we need to retrieve the employee division name. Do you have a sample query to do i…Valerio Curzi 535 views 6 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
BI Report on candidate interaction date as per applicationNeed BI Report on candidate interaction date as per application. Code Snippet (add any code snippets that support your topic, if applicable):Aishwarya Somvanshi 11 views 3 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
FTE and Headcount no longer in per_all_assignments_m tableSummary: Is there a reason why FTE and Headcount no longer in per_all_assignments_m table? Content (please ensure you mask any confidential information): Version (includ…Consultant Ian 21 views 2 comments 0 points Most recent by Consultant Ian Reporting and Analytics for HCM -
Which table store user password and Password expiration DateSummary: Hi , Please let us know Which table stores the user password and Password expiration Date under User definition. Navigation : Tools-> Security Console-> User At…
-
Query to join BEN_PRTT_ENRT_RSLT to Payroll Tables (PAY_RUN_BALANCES)Summary: Hi experts, Just wondering if there's a way to connect the benefits table BEN_PRTT_ENRT_RSLT to payroll table (ex. PAY_RUN_BALANCES). We have a BIP report requi…
-
Change format date for Completion Course Certificate templateSummary: Hello all, We're modifying the data template for the Completion Certificate Course using BI Publisher. We need to change "COMPLATION DATE" data format. Analyzin… -
FA to GL Reconciliation Report at Asset Category (Capital Asset Rollforward Report)Hi Team We are building a custom report to reconcile FA cost and Accumulated depreciation balances between FA and GL, at the Asset Category level.. We are facing few cha… -
In oracle fusion Expenses in which table we will get itemization dateEmployee expenses Itemization date in which table we will get .For itemization few expenses I am getting wrong date in EXM_EPENSES table START_DATE column I considered a…
-
Report of edited termination datesSummary: To assist with researching retroactive payroll scenarios, we would like to report on employees who have edited/corrected termination dates. We would like to sho…awheel09 31 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Report to fetch void payment dateSummary: We are looking for a report with output similar to Payment Register Report but with an additional column to display the actual Void date. Content (please ensure…
-
BI Publisher Sending a report to FTP Server with SSHSummary: How do I schedule a report to be delivered to a destination configured with SSH authentication? Content (please ensure you mask any confidential information): H…
-
How to get the assignment name for an OTBI analysis?Summary: I need to know which subject area and fields I need to use, to get the employee assignment name for an OTBI analysis. Content (required): Assignment name Versio…Ayesha Iroshani 81 views 7 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Table used to store children custom objects!!Hi, We created Custom object "Proposal" and created child custom object from the parent object with name "Payment Plan" The parent custom object "Proposal" store its rec…Wesam Ibrahim 71 views 3 comments 0 points Most recent by Prabha.R Oracle-Oracle Reporting & Analytics for Sales
-
What table holds the future incumbents details?I am trying to pull the person number of a future incumbents but i'm not sure what table holds that info. Does anyone know? TIA. 😊Michael Angelo Lucena 21 views 6 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Are there agreed standards used by the community when reporting dates?We have adopted the US format for all reporting with users then setting preferences at an account level. Are there any standards which are adopted by customers as best p…Clare Murtagh 1 view 2 comments 1 point Most recent by Clare Murtagh Reporting and Analytics for HCM -
Unable to find Ending balance column in GL balance TableI am looking for a Ending balance for a particular account in gl_balances table. Is any other table contains this value ?
-
Report on Benefits GroupSummary BEN_BENFTS_GRPContent Hello. I am trying to link the table BEN_BENFTS_GRP (name field) back to the employees (person_id or person_number). I have tried linking i…
-
Birthday alert with Background imageSummary: i have a birthday alert requirement and whenever i try to put the image as background using watermark option, rtf file size is getting increased and getting bel…AshokPothula1 21 views 0 comments 0 points Most recent by AshokPothula1 Reporting and Analytics for HCM
-
How to show amount of times a report has been run?Summary: The 'OTBI usage real time' subject area can't show usage of reports - how to report on this? Content (please ensure you mask any confidential information): We h… -
CCC IMPL BICC Not Showing all FieldsSummary: Hi Team, We have application composer object created and it included number fields like ( Account Number, Site Number) looks like only id's are showing up in th…
-
How Do I get access to the WebCenter Content serverSummary: I have SQL provided by Oracle that give me the Content Server URL. When I click it, I get directed to the Content Server, but I do not have access to the file. …Al Darabaris 102 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Table for Global access group CriteriaSummary Table for Global access group Criteria and selection methodContent Table for Learning initiatives CriteriaHi Everyone can anyone help me in the table name that c…
-
How can we pass date parameters into the List of values to fetch the data based on the date rangeHow can we pass date parameters into the List of values to fetch the data based on the date range? Based on the dates the recoded should get refreshed in the parameter n…Shanmukhi 161 views 2 comments 0 points Most recent by Vaishnavi Katiyar Reporting and Analytics for HCM
-
EEO-4 Category table nameSummary: Hi, everyone. would like know where I can found this columns. Regulatory Response Ethnicity - TEXT → I can't found the string data data type. EEO-4 Category → E…
-
How to fetch Reason value from ORC in BI reportSummary: Hello Experts, Need your help in pulling a field called reason found in ORC module. PFA the screenshot of the field i want pulled. I am aware this field is pres…Jithin Mathews 51 views 4 comments 0 points Most recent by Nimisha Nirmal QC Reporting and Analytics for HCM