BI Publisher
Discussion List
-
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… -
BI Publisher reports folder security in HCM FusionSummary: Hello, I need help in BI Publisher reports folder security in HCM Fusion. I need to know if we can achieve a functionality on BIP reports where a developer can …
-
eText Replacement Characters command not effectiveSummary: Content (please ensure you mask any confidential information): I am trying to remove problematic characters from the resulting file via eText command but it's …
-
Automate - PDF files upload from report to Document of RecordSummary: Automate PDF files upload from report to Document of Record based on Person Number Content (please ensure you mask any confidential information): We have a requ…
-
Person Images Table stores Garbage ValueSummary: Hi Team, We have a BIP Report that fetches certain person details along with their profile information. This report feeds the output to a third party SFTP serve…Durgadevi-Oracle 11 views 0 comments 0 points Started by Durgadevi-Oracle BI Publisher Learning Center -
HCM extract pulling changes several days after change was madeSummary: Content (please ensure you mask any confidential information): Hi, we have a series of HCM extracts that pull various data pieces in order to be fed to a 3rd pa… -
How to bulk download HCM Extract/Payslip data xml files from past 1 year runSummary: For a third party integration, we need to download payslip data xml files for past 1 -2 years. Data XML is not defined as extract delivery option. The only way …
-
what is the difference between SQL bind and Post SQL bind.Summary: Hi all, I have a requirement where I have to make a dependent parameter in HCM extract. I used refine extract and now need to decide what to use SQL bind or Pos… -
Can I use output from one BI report as input to another BI report?Summary: Content (please ensure you mask any confidential information): I know that I can create multiple templates for my output, but that would require me to run the d…
-
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…
-
Query to get event details for the deleted/Active checklist.Query to get event details for the deleted/Active checklist. Thanks
-
Fetch balance values from Fast FormulasI have a requirement to fetch balance values based on input balance names passed to Fast Formula. I am using Balance Specific DBI's to fetch their values. When I hardcod…
-
Beginning Balance of Accrual in Absence Plan WrongSummary: Hello, I have an extract that uses the UE ABS_EXT_PER_ACCRUAL_UE. We have people getting an adjustment of 22 in their absence plan every 16th of June. This is d… -
Parse JSON data in HRC_ATOMPUB_ENTRIES.ENTRY_XML fieldSummary: For reporting purposes we need to read and parse the JSON payload that is present in Atom Feed Table. The field ENTRY_XML contains an XML which tag //entry/cont…
-
Real Time Trigger to Third Party systemsSummary: Trigger real time termination transactions data using API/BIP/Extract to third party system on a real-time basis Content (required): Hi Team, when a termination… -
How can we upload Vendor file into Cloud w/out OIC?Summary: How can we upload Vendor file into Cloud w/out OIC? The file is a .txt format that later i would like to use Load Data From File and an HDL Transformation FF on… -
Why bursting from BI Publisher sends emails to 1 domain and not the other?Summary: Why bursting from BI Publisher sends emails to one domain and not the other? Content (required): I created a BI Publisher report having bursting object on it. I…Stefano_Mazzocca 32 views 1 comment 0 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for HCM -
Email blocking problems? SPF SetupSummary: Hi, Are any other UK customers experiencing problems with emails from HCM being blocked recently? We are starting to get emails (delivered as part of HCM Extrac… -
Username and PasswordHi, As this REST API returns /hcmRestApi/resources/11.13.18.05/userAccountsLOV all the usernames Is there any API to return the username and password of given user Thanks -
Inbound HCM Extract to compress multiple reports in a Single Zip FileSummary: Hi, We have a Inbound BI Report created. The Inbound Interface HCM Extract needs to run multiple reports and compress all those reports into single zip file and… -
To capture Personal Payment method changesSummary: To capture Personal Payment method changes Content (required): Planning to develop a extract to capture personal payment method changes . My question is , how t…
-
How to identify process id of data load triggerred using HCm extractSummary: Need to know logic to find process id of a HDL load carried out using "inbound integration" delivery type option within a HCM extract using a BIP query Content …
-
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…
-
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 …
-
Find and Replace PROD path reference in extractsSummary: Find and Replace PROD path reference in extracts Content (required): Hi Team, Greetings! We have multiple extracts with reference to Production path on SFTP or … -
Added new delivery options at Element Result Report but output is not available once we runSummary: Added new delivery options at Element Result Report but output is not available once we execute Run Element Result Register flow Content (required): Added new d…
-
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…