BI Publisher
Discussion List
-
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 …
-
PER_EXT_PAY_EMPLOYEES_V2_UE won't retrieve INACTIVE person information regarding salary informationSummary: Hello, Customer Connect! I had developed an HCM Extract that fetch employee data such as some person/assignment information(person_name, assignment number, lega… -
REST API to execute Oracle BIP Report With ParametersSummary: Can anybody Please share a working example of REST API to execute Oracle BIP Report with Parameters Content (please ensure you mask any confidential information…MilanMohanty 24 views 1 comment 0 points Most recent by Madalina Danis-Support-Oracle HCM Integrations -
Can we run a BIP report with REST API datasource in Payroll Flow pattern?Summary: Dear Folks, I'm trying to call REST API method from BIP report to trigger a method in OIC. So, I created a BIP report with REST API endpoint URL as data source.…
-
Can I SFTP the documents stored in documents of record through BI Publisher BurstingSummary: Can I SFTP the documents stored in documents of record through BI Publisher Bursting FTP? This is PDF attachments. Kindly assist. Content (please ensure you mas…
-
Can we control the delivery option runtime in HCM Extract?Summary: Can we control the delivery option runtime? Like send the Email Report based on a Parameter set during submission of extract? when we submit an extract, if i su…
-
Where can I find Oracle IPs used for exporting files?Summary: I need to find Oracle IPs Content (please ensure you mask any confidential information): My integration sends a file from Oracle HCM Cloud to an external SFTP s… -
How to create and automatically import HDL?Summary: How to create and automatically import HDL? Content (please ensure you mask any confidential information): I need an updated guide to automate the import of an …
-
I am trying to apply filter in SOAP API using v6:filterExpressions but it failsSummary: I am trying to apply filter in SOAP API using PersonID=10004234442 but it is giving error. Can someone let me know what is the right way to apply filter. I want…
-
Documentation for SFTP protocolSummary: Documentation for SFTP protocol Content (please ensure you mask any confidential information): I'm looking for a document that explains how to export a file in …
-
Is there a known limitation for HCM Extract Output generated in .txt format?Currently, we have an extract that makes use of the user entity, PER_EXT_SEC_ASSIGNMENT_BASIC_UE, and runs on system date; and the data model, globalReportsDataModel, to…
-
HCM Extracts vs BICCWhat tool is recommended to do bulk extract of Oracle fusion data (HCM, ERP and CX)? Couple of advantages I see with BICC is it supports Blob/Clob data with low or no cu…
-
using HCM extract in need to upload the profile image into document recordsusing HCM extract in need to upload the profile image into document records post approval. Once the image is approved it will be enabled. Same image can we upload in DOR…
-
Query for Third Party payments along with involuntary deduction component referencesSummary: Delivered Third Party Payment Register Report is not fetching unpaid payments in the report along with the status. We need a query to retrieve the unpaid paymen… -
I'm New to Extracts how can I Learn any reference .Summary: Hi Team, Hope all are doing well ! I'm new to Extracts but I want learn extracts , so any one help me how can i go to ? Thanks, Ajay Content (please ensure you … -
How to create SSH key pair for SFTP server authentication from Oracle Fusion.Hi Team, We have a requirement to configure a third party SFTP server with private key authentication. Vendor is requesting us for the SSH key pair. We need to Share pub… -
Failed - IO errorSummary: Failed - IO error Content (please ensure you mask any confidential information): When we tried to click on "customize" option, getting this error. Even if we tr…
-
Where is the old value and New value fields getting stored in the Oracle HCM database schema?Summary: I want to fetch the old value and new value field in the BIP and want to know where they are stored in the backend schema? Content (please ensure you mask any c…
-
how to use preprocess XSLT File in xdo_metadata in excel using bi publisher?Hi - I am new to hcm extract and would like to use the preprocess XSLT file on excel xdo_metadata bi publisher. I am looking for documentation because it is not currentl…
-
In HCM Extract, can we add custom email for success/failure notification?The HCM Extract is triggering the custom BIP report and delivering the file to the specified SFTP folder. Now the user wants to get notified via email after the process …Kunwar Prashan Srivastava 62 views 4 comments 0 points Most recent by Jonalyn Cabrera Salonga HCM Extract -
Need to do a Conditional Replacement on HCM Extract with EText TemplateSummary: Hello! I have 5 Value Set/Fast Formula for attributes in HCM Extract. 4 of them have some conditions to change a information showed on the 5th(The 5fth one is a…
-
Extract output file name concat with the extract parametersSummary: Hi All, I am working on a HCM extract where requirement is to generate the output file name which contains the interface name concats with the parameter as ment… -
sql to get the HCM extract failure list for specific datesSummary: Need to create report which gives extract failure details. Code Snippet (add any code snippets that support your topic, if applicable): Im trying below sql to g…
-
How to set {$SYSDATE()$} into Effective Date on Scheduled Extract ?Summary: How to set {$SYSDATE()$} into Effective Date on Scheduled Extract ? Content (please ensure you mask any confidential information): How to set {$SYSDATE()$} into… -
TYPE field on HR_ALL_ORGANIZATION_UNITS_FSummary: There is a field called "TYPE" in the HR_ALL_ORGANIZATION_UNITS_F table. As per the table reference documentation… "This is a user defined type for differentiat…Kammasavala Ramadevi 62 views 1 comment 0 points Most recent by Keerthi Masireddy-Support-Oracle Human Capital Management
-
How to consolidate multiple extracts in a single extractSummary: Hi, I need to develop three separate HCM extracts. However, I would like to consolidate the data from all three extracts into a single XML file. Is there a meth…
-
Query to get event details for the deleted/Active checklist.Query to get event details for the deleted/Active checklist. Thanks
-
Direct URLs needs to be placed in a third party application for direct navigation in the systemSummary: Third party application will require the direct URLs from the Fusion HCM to be embedded in their system, which will help the employees to navigate directly to t…
-
HCM Extract to compress multiple reports in a Single Zip FileSummary: I'm loading Job Requisition Template Description. For this I combined ClobFiles and JobRequisitionTempalte.dat into .zip file manually, i 'm able to load data ,…