BI Publisher
Discussion List
-
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 …
-
Payroll Message ReportSummary: We have a requirement to customize the standard extract "Payroll Message Report" to add additional fields Business Unit Name & Department Name. But I am unable …
-
XML tag in RTF TemplateSummary: Team, We have developed one extract. The data is getting appeared in XML. But in the output file, its not getting appeared. Any idea, how can we get Business Un…
-
Lookback through HDL after getting dat file as result of hcm extractSummary: We are creating probation automation in that we are linking bip report to hcm extract and output of that hcm extract will be hdl file and we want to trigger hdl…
-
How to convert calculated fields into measures OTBISummary: We're using data from the Recruiting - Recruiting Real Time subject area. We need to create a performance tile to display Total Openings Left to Fill however th…Mark kristan De los Reyes 15 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle HCM Integrations
-
OTBI>Analysis>Edit Formula the same as the "Listagg" function in HCM SQLSummary: is there a similar function in OTBI>Analysis>Edit Formula the same as the "Listagg" function in HCM SQL? Content (required): Version (include the version you ar…Mark kristan De los Reyes 12 views 2 comments 0 points Most recent by Raghavendra Raghunath-Oracle HCM Integrations
-
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…
-
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…
-
sFTP connection is failing with 503 error after whitelisting Oracle given IPsSummary: sFTP connection is failing with 503 error after whitelisting Oracle given IPs Content (required): Our system was upgraded with 23A over the weekend and after th…
-
How to schedule 'Load data from File' payroll flow as it asks for content ID to be uploadedSummary: How to schedule 'Load data from File' payroll flow as it asks for content ID to be uploaded Content (required): How to schedule 'Load data from File' payroll fl…
-
Need to know how much volume of data we are receiving and extracting from Fusion applicationSummary: Need to know how much volume of data we are receiving and extracting from Fusion application Content (required): Need to know how much volume of data we are rec…
-
Report Output is blank after passing the flowInstanceName/payrollActionId of the Extract RunSummary: Hello All, Can anybody please give inputs for this issue. Report Output is blank after passing the flowInstanceName/payrollActionId of the Extract Run. The Extr…
-
BI Report SOAP ServiceSummary: Is it possible to have a documentation to run a BI Report through SOAP? Content (required): Is it possible to have a documentation to run a BI Report through SO…
-
I need help to correct a Data Extract - eText - Timezone IssueSummary: I have a data extract and the output uses an eText file for the data layout. That attached document shows a snippet of the eText where FORMAT_DATE(SYSDATE,'MM/D…
-
SQL Query to get the Balance dimensions and corresponding context valuesSummary: SQL Query to get the Balance dimensions and corresponding context values Content (required): We are looking to get the balance dimension names and context value…
-
Report generation from base64 pdf returned from webserviceWe require to call a base64 webservice directly from an OTBI report placed on the Fusion apps springboard, and open the base64 pdf file. Business case is: we have a 3rd …
-
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…Claudio Marini-Oracle 22 views 0 comments 0 points Started by Claudio Marini-Oracle HCM Integrations
-
Job History of BIP Reports/Flow History of HCM ExtractsSummary: Hi, We have a few questions on the Job History of BIP Reports/Flow History of HCM Extracts; as I could not find any document for this information: 1.) How many …
-
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…
-
HCM Extract xsl template to generate formatted XML Output that almost replicate original xml outputSummary: HCM Extract xsl template to generate formatted XML Output that almost replicate original xml output. We just need to get rid of the duplicate output that is usu…
-
is pivot functionality works good in all environments?Summary: Hi, I am trying to convert data rows into columns using pivot function in BIP Reports. i tried to use in test environment the pivot functionality working good. …
-
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 #…
-
Can an extract generate the 4 different templates based on different conditionsSummary: Hi all, I am working on a requirement where I have to generate 4 different templates based on the different condition. I have built the extract which is fetchin…
-
Error - An assertion failure was detected at location ProcReportPayAct.childRequestSSummary: Extract error at BIP stage - An error occurred. An assertion failure was detected at location ProcReportPayAct.childRequestS. Contact your help desk Content (re…
-
Rest API for Legal Entity in Oracle HCMSummary: We have this project where a requirement is to find a legal entity identifier in Oracle HCM and integrate it to a SaaS Environment. I'm trying to find a Rest AP…
-
REST API to create Non Catalog Learning Items for employeeSummary: REST API to create Non Catalog Learning Items for employee Content (required): Hi Experts, Could you please provide me the REST API to create Non Catalog Learni…
-
Structural Change in the HCM Extract XML OutputSummary: Hi Team, Does UE (User Entity) change in an already existing HCM extract changes the structure of the XML output? We have change the UE for the child data group…
-
Need to display AOR related information in the HCM ExtractSummary: Need to display AOR related information in the HCM Extract Content (required): We have a requirement to display Person information along with AOR related inform…
-
Change Only HCM extract for Recruiting/Job RequisitionSummary: Hi Team, We have a requirement to send the Job Requisitions changes using the HCM extract to the third Party system. Kindly share the code pack if anyone had co…