Data Models
Discussion List
-
Report to show View Count on Knowledge ArticlesSummary: Report to show View Count on Knowledge Articles Content (required): We are looking for a report which shows the number of views on published Knowledge Articles/… -
BPM Worklist Transaction Status LOVHi, We are building a report to pull the list of transaction from BPM Worklist. We want to use Transaction Status as one of the parameters for this report. We need help …
-
Per_user_roles or ase_user_role_mbr to be used for Reporting ?Hi , We are trying to develop a BI report to extract all User assigned roles and privileges along with the effective date information . Which table is considered best to…
-
List of Standard Duty and Data Roles for Oracle Fusion HCMSummary: List of Standard Duty and Data Roles for Oracle Fusion HCM Content (please ensure you mask any confidential information): Dear Community, Similar to the post (h…
-
How to trace donated hoursGood day! is there a way in SQL to connect/trace donated hours of the employees involved? I'm only able to see who donated but cannot connect to who received those donat…notautomni9 11 views 1 comment 0 points Most recent by Claudiu Postolache-Support-Oracle Human Capital Management -
what is the difference in oracle cloud hcm core from legalentityID to legalentityorganizacionid?Summary: Content (please ensure you mask any confidential information): what is the difference in oracle cloud hcm core from legalentityID to legalentityorganizacionid? … -
Which table contains the information from Manage Legal Reporting Unit HCM Information ?Summary: Content (please ensure you mask any confidential information): Which table contains the information from Manage Legal Reporting Unit HCM Information? Version (i…
-
Error while loading the French names to Document typesSummary: Hello Everyone, Greetings of the day!! We have a document type with the name T2200 in the system. Now we are trying to load the french name(Transalated name) of…
-
I need a query for the last updated dates made to audit approval rulesSummary: Data extraction for audit purpose - last updates made to our approval rules Content (please ensure you mask any confidential information): I need a query for th…Global Support Desk 11 views 1 comment 0 points Most recent by Deaconu Constantin Valentin-Oracle Human Capital Management
-
Need help in getting the query to fetch Candidate Extra Info from ORCSummary: I have been trying to look for tables that stores the Extra Info section details on the Candidate profile in ORC. If anybody has worked on it, can you share the…Rini_Varghese-Oracle 11 views 1 comment 0 points Most recent by Rini_Varghese-Oracle Human Capital Management -
How do you write a query for standard working hours in BIP?I need to get the standard working hours for employees into my query. I can see the standard working hours work is worked out in the following order : 'Standard Working …
-
Need help with Loopback Integrationshttps://us.v-cdn.net/6034893/uploads/Y2EH05POYKRM/loopback-integrationsref-15.docx We are exploring the option of "Loopback Integration" previously known as "Inbound Int…
-
Link between the gl/xla tables and tax tablesHello, I need to display the tax information (tax code, tax rate) for Journals having source 'Tax' (Note that these are journals created using the 'Create Taxable Transa…Varun Dhondea 254 views 2 comments 0 points Most recent by Varun Dhondea BI Publisher Learning Center -
Get employee information that has been modified since a specific date using SQL queriesSummary: Get employee information that have been modified since a date by using SQL queries and not API nor ATOM fields. Content (please ensure you mask any confidential…
-
How to have CR LF in ETEXT OutputI would like to ask on how to create a CR LF with ETEXT Output that is using an RTF Template.MayCab 1 view 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Human Capital Management
-
Backend column name to fetch special purpose attribute in element input valueSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
BIP Report not retrieving data for single value in parameter, But same is working fine in DataModelSummary: BIP Report not retrieving any data when single value is selected in parameter, But the same is working fine in Data Model. Please help. Content (please ensure y…Mallikharjun Purilla-Oracle 31 views 2 comments 1 point Most recent by Hello123 Reporting and Analytics for HCM
-
How to get the last degree if the worker have 2 records in a Analysis and ReportSummary: How do we get the last degree if the worker has 2 or more records in an Analysis and Report? We need to get the last degree considering their last start date. C… -
Bursting Email not getting sentHI While I am using Parameter3 of query as my company's domain mail. It is not getting sent . Please suggest client does not want email sender to be shown as Oracle. How…Aditi Agrawal2650 64 views 1 comment 0 points Most recent by Dimple-Nagesh-Support-Oracle BI Publisher Learning Center
-
Need an Correct SQL Query to get updated start time and stop time from OTL Submitted time entriesBelow is the reference query which is pulling duplicates becuase of confusion between range and measures types. SELECT papf.person_number, htc.start_time, htc.stop_time …
-
Job Profile - Work RequirementsSummary What are all the work requirement fields associated with a job profile?Content Hi Everyone, I am looking to understand what are all the work requirement fields t…User_2025-02-06-09-32-26-556 59 views 4 comments 1 point Most recent by Merwin Human Capital Management -
How to send bursting email using personal email address?How to send bursting email using personal email address?Do we need to configure something or mail address can be used directly in bursting query?Aditi Agrawal2650 11 views 0 comments 0 points Started by Aditi Agrawal2650 BI Publisher Learning Center
-
SQL query to fetch Division, BU and Department namesSummary: Hi Team, We have created a SQL query to fetch Inactive employees AOR. We would like to fetch division name, Department name and Business unit name also in the s…Ooha Pranathi Akkala 4.3K views 12 comments 0 points Most recent by RyanPasca1 Reporting and Analytics for HCM
-
In transaction Console, all old transactions are not visibleSummary: In transaction Console, all old transactions are not visible only few are visible. How to check the old transactions. Need to create a report to fetch old data.…
-
Query on changes only Extract data retention periodSummary: Hello, I have been using a report to extract the xml data for our changes only extract for a long time now. i was able to pull data from flows that were near 30…
-
Query to get assignment category in Positions pageSummary: I am building a BIP report for the active positions in Fusion. I need to fetch the actual Assignment Category found in Positions page: In hr_all_positions_f tab…Patricia Azucena 673 views 2 comments 0 points Most recent by Patricia Azucena Human Capital Management
-
Which table have nationality information in Oracle HCMSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Add role restriction of table access while developing the sql query and not while viewing the reportSummary: For OTBI and BIP we want restriction to be added on table access while coding the reports for specific modules. The client wants to code reports in the system u…Tarushee Agarwal 1 view 1 comment 0 points Most recent by Rambabu Laveti-Support-Oracle Human Capital Management