BI Publisher
Discussion List
-
Need inputs to use :{PARAMETER.P_TIMEZONE} in the Value set from clause.Summary: Need inputs to use :{PARAMETER.P_TIMEZONE} in the Value set from clause. Content (please ensure you mask any confidential information): In the custom HCM Extrac…
-
Fusion Application BI Publisher - SSH Public Key authenticationSummary: How to setup FTP connection to a vendor, using SSH public key authentication? Content (please ensure you mask any confidential information): The FTP server setu…
-
change assignment numberSummary: Hi,is it possible to change assignment number via HDL? Content (please ensure you mask any confidential information): Version (include the version you are using…
-
HCM Extracts PGP Encryption converts file to ANSI FormatHi Experts, We have built an HCM extract with e-text template which generates CSV file. Without encryption turned on, the file format is UTF-8, but after PGP encryption …
-
HCM Extract BIP report delivery handling of special XML CharactersHello All, We have a requirement from a client to pull all of the Talent Profile items from the HRT_PROFILE_ITEMS table. when creating the extract we noticed that in the…
-
Need SQL query to display HCM Extract results and output file namesSummary: Need SQL query to display HCM Extract results and output file names Content (required): We developed custom HCM Extract and it is having multiple delivery optio…
-
Extract gives an error in work relationship for terminated employeesSummary: We are using this extract from a couple of months ago. It works for all other employees. Now the client requirement to add terminated employees is in the extrac…
-
CANCELED_HIRE system person type not populated after cancellation of employee work relationshipSummary: CANCELED_HIRE system person type not populated after cancellation of employee work relationship Content (please ensure you mask any confidential information): W…
-
Dynamic Payroll Relationship group not working as a parameterSummary: We have a requirement to add Payroll Relationship group as a parameter to a custom BI report. While running with this parameter, the report runs fine with stati…
-
Get the description of a value in a valueset using HCM ExtractSummary: Hi, I need to extract the field description from the value set for each value and I need to insert the description as an attribute in the HCM extract Content (p…
-
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…
-
How to zip multiple output files from HCM Extract and FTP to third partySummary: How to zip multiple output files from HCM Extract and FTP to third party Content (please ensure you mask any confidential information): We have a requirement to…
-
Oracle HCM Extract, function XDO_SKIPROW not working in excel template with multisheetsI need to hide/skip some rows in each sheets with different conditions for each sheet. Instead i am using : XDO_GROUP_?XDOG2? but it is limited to 1 condition. What is…
-
If condition to update Payslip subtemplate to display 4 decimals for Houlry employees onlySummary: We have a requirement to display 4 decimals for Hourly employees for Base Salary field and all other amounts/salaried employees display 2 decimals (default). I …PraveenkK 1 view 1 comment 0 points Most recent by Divya Jayaraman-Oracle Payroll and Global Payroll Interface (GPI)
-
Is it possible to retrieve deleted technical talent profile competencies in HCM extracts?Hi if we are deleted technical competencies for particular person in talent profile, Is it possible to retrieve deleted technical talent profile competencies in HCM extr…
-
Loop back integration using HCM Extract Inbound InterfaceSummary: Loop back integration using HCM Extract Inbound Interface with HCM Data Loader - If the extract not return any rows on a particular run , it won't have any HDL …
-
How to bind effective date parameter of HCM Extract to BIP Report's parameter and load HDL ?Summary: How to bind effective date parameter of HCM Extract to BIP Report's parameter and load the HDL file generated by BIP Report ? Content (please ensure you mask an…
-
HCM Extract for assignment changes only generating previous sequenced rowSummary: I've created a HCM Extract that pulls assignment details for employees, including past, present, and future assignments. The only filtering criterion I use is t…
-
Primary City/County while loading address - Vertex CodeSummary: Need a way to identify primary city/primary county for given Zip code Content (please ensure you mask any confidential information): We receive City and Zip cod…
-
OIC Integration call from HCM CloudSummary: Call OIC Integration form Oracle HCM Cloud Content (please ensure you mask any confidential information): We have created one lookback integration using OIC. In…
-
HCM Extract Encryption for specific fieldsSummary: We have a requirement to create HCM extract and send the data to SFTP. Our customer wants to encrypt specific fields instead of whole file. Please let us know i…Thulasipriya K-Oracle 26 views 3 comments 0 points Most recent by Juan Carlo Culibra-Oracle HCM Extract
-
Does any one works DOR functionality to custom HCM Extracts to store Output form to Person DOR ?Hi All, We have a requirement to Store the Generated output form in Person Document Records for Terminated Employees using custom HCM Extract. we want to upload automati…
-
How to Add Representative information into ExtarctSummary: Hi Expert, I'm new in Oracle Extract, and I need your assistance regarding adding representative information to the worker extract file. I tried to search the u…
-
PER_EXT_SEC_PERSON_UE is picking Addrline1 from Primary addr and remaining addr picking wrong datSummary: In One of the ADP extract, We have observed that PER_EXT_SEC_PERSON_UE picking primary address only in Addressline1 and rest of the address fields(Addrline2,Sta…
-
Can a Position DFF field value be used as criteria for a workflow transaction approval rule?Summary: Is it possible to create an approval rule for a Position DFF field as criteria for transaction approval rule? We have a business need to route a Manager's posit…Becky J. 35 views 1 comment 0 points Most recent by Jose Antonio Gil del Prestamo Human Capital Management
-
Filter PER_EXT_PAY_EMPLOYEES_V2_UE to get the assignments of employees with payroll results onlySummary: Our custom HCM Extract contains the following UEs (per hierarchy): 1. PAYROLL ACTIONS RANGE UE (Root Data Group) 2. PAYROLL REL ACTIONS RANGE UE (Connected to #…
-
Inbound interface issue 24CHI Experts, After 24C patch upgrade in our instances we tested inbound interfaces what we saw is after all the steps completed (2/2) the generated HDL is failed to load …
-
HCM Extract reference root data group attribute in child nodeSummary: I have a custom extract to pull payroll balance for employees. It has 2 data groups. The first data group has balance values and child data group has employee d…
-
How to Get UCM File Details By Bi ReportInfo in Soap Web ServicesI Ran Bi Report in Oracle Fusion The delivery channel is UCM later i want to get that report file from ucm by passing inputs as Bi Rpeort Details Like Report Name, Path …