Data Models
Discussion List
-
Issue with .xlsx formatWhen scheduling a report and then the report is sent to the manager, manager cannot receive it because report cannot be sent. Could it be that .xlsx option is not suppor… -
HCM Production data needs to be masked conditionallyRather than the non-production environment (we know that sensitive data can be masked in non-prod during P2T), we need to conditionally mask production data such as sala… -
sql query to retrieve HCM Annual Salary as of max date of (1/1, date of hire, or Effective date)Summary: Hi Folks, Do you have query to retrieve HCM Annual Salary as of max date of (1/1, date of hire, or Effective date when Standard Hrs is >=20) Thanks -
Users Transaction DetailsHi Team, Greetings!! We are looking to get Users Transactional Data (When the user account got inactive or locked, Error message if user trying to login), time the appli…Anand-ST-Oracle 41 views 2 comments 1 point Most recent by Kishore Padala-Support-Oracle Applications Security
-
How to Display current TIME STAMP in HCM extract that Uses an eText Template to generate the fileSummary How to Display current TIME STAMP in HCM extract that Uses an eText Template to generate the fileContent Hi Experts, Can anyone please help me as to how to displ… -
List of Values SQL query with multiple columnsHello - I want to know if it is possible to use a List of Values object (with a Parameter) and select 2 columns in the LOV query, and then display one column for the End…
-
AR Aging Report Issues in BI PublisherHi everyone, I'm hoping to get some help with an AR Aging Report built in BI Publisher. I inherited this report from someone else, and I'm facing two issues: Missing Cus…
-
query to get the due date in payment under invoices to payHi, Could you please advise in which SQL table can I find the Due Date in Payables → Payments → Create Payment under Invoices to Pay. Thank you.Elyse Meouchi 1.4K views 2 comments 0 points Most recent by Stephen Westerfield-Oracle BI Publisher Learning Center
-
How to retrieve bank account details on report with correct party ID?Hello, We have run the attached SQL query. However, we have noticed that for one employee, we were not able to retrieve the bank details as shown below: Currently on the…VDoolhur 824 views 5 comments 0 points Most recent by Stephen Westerfield-Oracle Human Capital Management
-
how to Retrieve the GUID of a row (global unique identifier ) using SQL ,not RESTsome apis require the GUID to update a record , not the id or rowid We can retrieve that value using REST api (/fscmRestApi/resources/11.13.18.05/invoices/1/child/invoic…
-
HDL for historical dataHi Team, Could you pls help me with HDL template for loading historical data? Thanks in advance!!
-
Issue with Table pay_dir_comp_details_f, pay_dir_card_components_f 'Responsive UI' calculation cardFor "US Federal Tax Card Details" and " US State Tax Card Details " Records for "calculation card details" are not appearing in the table "pay_dir_comp_details_f" when t…Siddharth D Chaware 531 views 9 comments 0 points Most recent by Vibha Pandey - Oracle Payroll and Global Payroll Interface (GPI)
-
Field URL is blank in view fnd_documents_vlSummary: Field URL is blank in view fnd_documents_vl Content (required): We are trying to report on the documents people have, we are trying to use the "URL" field of th…Samantha Aguilar C 111 views 7 comments 0 points Most recent by John T-Oracle Human Capital Management -
How can we add an LOV to an additional address attribute fieldSummary: Hello, we are struggling to evaluate if we can add an LOV to an additional address attribute field. As of right now, those fields always show up as text fields:… -
Are document records stored in a server?Summary: Hi Community, Our client is transitioning from PeopleSoft to HCM Cloud. Currently the documents they upload are stored in a File Server in PeopleSoft. Are Docum… -
How is data capture in HCM Events TableSummary: We want to understand how is data captured in HCM Events Table & How does it differ from Audit Table ( which is table with_ at the end)? Can anyone share any in…
-
N/APost created by mistakeHumberto Martín-Oracle 11 views 0 comments 0 points Most recent by Humberto Martín-Oracle Human Capital Management
-
how to change date format un bipSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Query to get the tax name and rate from a draft invoice under contractI need to retrieve the tax name and tax rate applied on the draft invoice (without calculating it manually) under contract management. In the tables pjb_inv_line_dists a…Elyse Meouchi 41 views 0 comments 0 points Most recent by Elyse Meouchi BI Publisher Learning Center
-
How to get the value from the UDT for the Custom field DFF?Hello Experts, We're adding a Custom Grade Ladder through a Descriptive Flexfield (DFF), where the values originate from the UDT. The expected outcome is that selecting …
-
Is there a column in Per_all_assignments_f which can tell us the source for the assignment record?We can do internal movements via core hr and OCR. How do we which assignment is updated via OCR or Core HR? As part of recruitment the assignment type is created as 'O'.…DevasishG 21 views 3 comments 0 points Most recent by Rambabu Laveti-Support-Oracle Human Capital Management
-
Fetch Salary LogsSummary: Hello, We have a requirement where we need to understand if we have standard dashboard or report where we can get the logs of all the users who are accessing sa… -
Can a worker historical conversion be done AFTER loading top of stack?Summary: We have been trying to extract and convert historical worker information for several months, but continue to have problems with extracting the data in such a wa…
-
Report related detailsHello, We want to know details for the one of the BI report, how we can find below details, do we have any Query to check all details for the BI report. Report Name, Fol…
-
Extensible Flexfields not auto populating on basis of SQl QueryHi There, I am trying to auto populate Extensible Flexfields through sql. This sql contains recent action code transaction and shows its Effective Start date. In order t…Aviral Tripathi 101 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Human Capital Management
-
we want to mask all NID Details how to do this anyone have any idea on thisSummary: we want to mask all NID Details how to do this anyone have any idea on this Content (please ensure you mask any confidential information): Version (include the …
-
How to retrieve asset category base rate for previous month & current month using sqlRetrieve asset category base rate for previous month & current month using sqlSravan Kumar Meka 1 view 0 comments 0 points Most recent by Sravan Kumar Meka BI Publisher Learning Center
-
Create a Department Hierarchy - Organizational Tree or Department Tree?Summary Create a Department Hierarchy in Oracle HCMContent Hello everyone, Currently we are using the Organizational Tree area of Oracle HCM to drive security, meaning t… -
Mapping of Seniority dates after V3 Seniorty Dates migrationSummary: We are using PER_PERIODS_OF_SERVICE table's - ORIGINAL_DATE_OF_HIRE( as Enterprise Seniority Date) & ADJUSTED_SVC_DATE (as Legal Entity Seniority Date). After V…User_2025-07-18-06-45-42-477 151 views 3 comments 0 points Most recent by Nidhi515 Human Capital Management
-
BI Publisher Report- Learning Initiatives including Course number and Title-LearningHello All, I have the SQL code that fetches the learning initiative number, name, Course Number, and Title, but I have found duplicate rows because the Course titles do …Thulasi Ram 131 views 8 comments 0 points Most recent by Soare Oldrich Alexandru-Oracle BI Publisher Learning Center