BI Publisher
Discussion List
-
How many reports are there in systemSummary: can we create a report with the followed fields Report Name, Folder or path where, creator, who has access/visibility to it Content (please ensure you mask any … -
Content Status - Correct common lookup typeSummary: Hi, Content Status - For fetching the exact content status names, we see there are two lookup types available. Neither of them have the complete set of data tha…
-
How to fetch all sites linked to a particular customer using querySummary: How to fetch all sites linked to a particular customer using query Content (please ensure you mask any confidential information): Version (include the version y…Neelesh Varma 12 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales
-
need query to get activities content type for all the courses along with offeringsHi we have requirement to get the Course names along with the offerings and their activites content type in the bi report. Can any one share me the sql for fetching all …Dara Nagasai 31 views 0 comments 0 points Most recent by Dara Nagasai Reporting and Analytics for HCM -
Time Between Promotion in Oracle Fusion HCMSummary: Time Between Promotion Content (please ensure you mask any confidential information): Hi Team, Please help to create query for Average number of months between …Hitha Harikumar 11 views 2 comments 0 points Most recent by Hitha Harikumar Reporting and Analytics for HCM -
Query to get Employee Bank Account Details not tagged to personal payment method in Oracle HCM CloudSummary: Query to get Employee Bank Account Details not tagged to personal payment method in Oracle HCM Cloud Content (required): Hi All, We got the requirement to extra…Venkatesan 2.3K views 3 comments 0 points Most recent by Navya Siddaling Reporting and Analytics for HCM
-
Query to get customer profile historySummary: Query to get customer profile history Content (please ensure you mask any confidential information): We have a requirement where we are enabling Credit Limit at…
-
Standard Hours From per_availability_details.get_availability_detailsTeam, We have a requirement to get the standard hours for particular period. We have two parameters. Period Start Date and Period End Date. Ex. We are passing 03-Dec-202…
-
Get Scheduled Hours From Assignment Work SchedulesWe have a requirement to get the scheduled hours from Assignment Work Schedules. We are trying with the below code but its not giving hours. SELECT * FROM ( TABLE(PER_AV…
-
Can seeded flow Run Element Results Register be run secured by Business Unit ?Summary: Can seeded flow Run Element Results Register be run secured by Business Unit ? We have requirement to generate the output Run Element Results Register based on …
-
can we add filters for checklists tasks also in hcm extractswe wan to create DOR if the termination/resigantion checlists tasks are completed. Can we add filters for those also in HCM extracts. which bussiness object we need sele…
-
Getting Additional Compensation details in HCM extractHello, I am building an HCM extract to capture Employee changes. I am currently using this UE to bring all required attributes: PER_EXT_PAY_EMPLOYEES_V2_UE_EMP_REC I req…
-
HCM Extract is getting into error after adding Data Loader Interface - Delivery TypeHCM Extract is getting into error after 24A update. After import of extract and added new delivery type as Data Loader Interface and give correct object entity details t…
-
Query showing the values on the current Tax Calculation CardsSummary: I need BI publisher reports that show the values on the current Tax Calculation Cards for all active employees including their hire date. The values of greatest…
-
Created a Changes Only extract– contains historical data on Assignment detailsSummary: Hi Teams, Need to get history data from assignment using HCM extract, Root UE: GLOBAL_PAYROLL_INTERFACE_TERMS_UE Childs 1: PER_EXT_SEC_HISTORY_ASSIGNMENTS_UE Ch…
-
Table or OTBI subject area to get extract run status and logSummary: Table or OTBI subject area to get extract run status and log Content (please ensure you mask any confidential information): We want to inform business if HCM ex…ROOPESH MADAN-Oracle 11 views 1 comment 0 points Most recent by Rambabu Laveti-Support-Oracle HCM Extract -
Sequence NumberSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Rick Jason 1 view 1 comment 0 points Most recent by Hassan El Bouihi-Oracle Reporting and Analytics for HCM -
How many ways do I restrict the BIP reports and OTBI reports?Summary: How many ways do I restrict the BIP reports and OTBI reports? Content (please ensure you mask any confidential information): Hi Experts, Please tell me how many…Malak 1 view 1 comment 0 points Most recent by Hassan El Bouihi-Oracle Reporting and Analytics for HCM
-
how to capture the selected LOV values.Hi, Need help in achieving to print multiple LOV values selected. Its throwing the missing parenthesis select (:LE) from dual.Shanmukhi 11 views 3 comments 0 points Most recent by Hassan El Bouihi-Oracle Reporting and Analytics for HCM
-
java.net.SocketTimeoutException: Read time out - runReport ServiceSummary: java.net.SocketTimeoutException: Read time out - runReport Service Content (please ensure you mask any confidential information): We have a report created to ge…Nipuna Thandi Ashok 125 views 1 comment 0 points Most recent by Prabha.R Oracle-Oracle Reporting & Analytics for Sales
-
Need Tables for Cost Transactions Depletion Layer DetailsSummary: I'm looking for tables for Cost Transactions Depletion Layer Details as in the screenshot below. Content (please ensure you mask any confidential information): …Kunal Verma 261 views 1 comment 0 points Most recent by SRGogula-Oracle Reporting and Analytics for SCM
-
![Arun Kumar Krishnan [AK]](https://us.v-cdn.net/6034893/uploads/userpics/L8BUJDYF94E7/nTLGWFBWW678P.jpg)
Inherited Role Audit detailsSummary: Hi Team, Need a Role report that gives you the details for scenario: Role A is inherited by Role B(Employee Role) and assigned to Person A. Need to know below: …Arun Kumar Krishnan [AK] 31 views 3 comments 0 points Most recent by bobby.hussey Reporting and Analytics for HCM -
Someone Deleted the Custom folder from my Username. Is there any way to find the IP address or HOSTSummary: Someone used my credentials to login into UAT POD and Deleted the whole custom Folder. Is there any way to find the IP or Host of the user so that I can find wh…VarunMittal01 13 views 1 comment 0 points Most recent by Hassan El Bouihi-Oracle Reporting and Analytics for HCM
-
Is it possible to report on which workers are scheduled to work on a particular date?Summary: Content (required): I'd like to be able to report on which employees are scheduled to work on a certain date, based on the work schedule held for them, and what…Leanne W 131 views 10 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Unable to make fields Mandatory in Customer Bank account pageUnable to make fields Mandatory in Customer Bank account page Navigation: Receivables--> Billing--> Manage Customers--> Account Number-->Payment Details-->Payment Instru…Pooja K-Oracle 41 views 3 comments 0 points Most recent by Renuka Gajavelli-Oracle Receivables & Collections
-
Which Table is the Mastery Score Stored that is visible on the ActivitiesSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…