BI Publisher
Discussion List
-
Subledger DFF enabled not shown in OTBI subject areasSummary: BIenabled subedger line level DFF cannot be found in OTBI subledger accounting subject areas Content (please ensure you mask any confidential information): A li…Dian Minshan 1 view 2 comments 0 points Most recent by Viviane Vasconcelos Subledger Accounting & Accounting Hub -
find value in one loop and traverse back to another loop in xml etext templateSummary: I have an XML of ACH file where in there is a value in this path PAYMENT_RECORD/PAYMENT_DETAILS/PAYER_METHOD/EFT_USER_REF. When Make EFT Process is ran the outp… -
How to enable report job historySummary: I need to enable the "Report Job History" option in the Home tab of OTBI, without leveraging BIAuthor or BIAministrator, as we have a requirement to view and no…
-
Report to fetch all position Name changes but the job remains sameSummary: I want to fetch a report for the position name updates when we have same job code Content (please ensure you mask any confidential information): we need to find…Rajesh Suvala85 31 views 8 comments 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM -
Need a SQL Query Help To Fetch Non-PO Matched Invoice Lines (Account Payables)Summary: Our requirement is to fetch the Non-PO matched invoices, the query should even exclude Invoice lines which are associated with PO. Only Invoices without PO (at …Jayaram AnuPriya-Oracle 31 views 2 comments 0 points Most recent by Jayaram AnuPriya-Oracle Payables, Payments & Cash Management -
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 … -
Sql Query to get payroll deduction detailsSummary: I am looking for a query which provides terminated employees last earnings and deduction details from payroll. Content (please ensure you mask any confidential …Rahul K-Oracle 513 views 1 comment 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Customer wanted automate the T4 slips that should deliver to terminated emps personal email addressSummary: Hi Experts, Need suggestions on how to automate the T4 slips that should deliver to terminated emps personal email address, if anyone implemented this functiona…Rama123-Oracle 11 views 1 comment 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM
-
Missing workflow detail in the WFTASK for a spend authorizationWe have developed a custom BIP report, and report fetch the workflow details for spend authorization for all workflow approval scenarios. Its observed, there are for few…
-
SSN not removed from headingContent I want to modify alert notification template, where when employee update their contact relation, their SSN number should not be visible to approver. However when…Aanila Nanda-Oracle 11 views 1 comment 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM -
Need changes in Print Receivable Job to print invoice without customer bill to email contactSummary: currently Print receivable invoices job is not picking the invoice where bill to customer email contact is not present. we are getting below error. PRINT_INVOIC…Raj Jain-Oracle 46 views 1 comment 0 points Most recent by Sairam Surampalli-Support-Oracle Receivables & Collections
-
Payroll Audit ReportSummary: Hi All, Do we have any option for audit report on Payroll details. Who has accessed a specific salary/payroll screen in the past 7 days? Thanks, Ram Content (pl…RamkumarKadhiravan 21 views 2 comments 0 points Most recent by RamkumarKadhiravan Reporting and Analytics for HCM -
HR Audit reportSummary: Hi All, I have a question regarding the HR Audit report feasibility. If HR were to identify sensitive data, is it possible to enable auditing on a handful of sp…RamkumarKadhiravan 1 view 0 comments 0 points Most recent by RamkumarKadhiravan Reporting and Analytics for HCM
-
Last Date WorkedHow to pull "Last Date Worked" from Termination Info? Is there a table in BIP where we can pull this column?Ronel M 1 view 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Troubleshoot Incorrect Work Pattern SQL QuerySummary: Hello, I am a beginner with SQL and am trying to resolve an issue with an incorrect Work Pattern Report built for us by an Oracle Consultant. I am trying to get… -
Sql Query to find the approver name for AP invoicesSummary: I am looking to get approver name for AP invoices Content (please ensure you mask any confidential information): Version (include the version you are using, if …Rahul K-Oracle 251 views 1 comment 0 points Most recent by Saurav Sunny Payables, Payments & Cash Management
-
Best Approach to Restrict Seeded Folders AccessSummary: We have users from 3 areas such as HCM, Finance and SCM. We have dedicated Custom reports folders for each set of users such as HRs can access 'Custom HCM Repor… -
BI Publisher - pulling Candidate Source Medium and SourceSummary: We have a BI publisher report that we want to use to report on Candidates who are specifcally coming from these two Source Mediums: Referral and "Candidate adde…Evelina Hobson 31 views 3 comments 0 points Most recent by MilanMohanty Reporting and Analytics for HCM
-
Need to change default from email address"bipublisher-report@oracle.com" to customer email addressesSummary: Hi Experts, We are trying to burst the BI outputs and needed to change the default from email address "bipublisher-report@oracle.com" to other. Let's say for le…Rama123-Oracle 518 views 1 comment 0 points Most recent by MilanMohanty Reporting and Analytics for HCM
-
Need query to get the list of all roles for a given roleSummary: Navigation: Tools > SecurityConsole > Roles If I query a role name, I want display all the roles associated with it. I want to build a query for the same. Pleas…Niranjan_DTCC 41 views 4 comments 0 points Most recent by Dhilip Kumar P. Reporting and Analytics for HCM
-
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 create consolidated AR invoices based on Order Types or Invoice rules in oracle fusionSummary: Do we have details available on what are the options available to consolidate Oracle AR Invoice in Fusion ? Business doesn't want use Bills Forward billing feat…
-
SQL query for absence disbursementSummary: Hi Experts, I need to fetch the absence disbursement value for a plan (screenshot attached) using a SQL query. Can some one please help with a sample SQL for th…Pinky Mukherjee 102 views 1 comment 0 points Most recent by Phani S-Oracle Reporting and Analytics for HCM -
BIP Report - How to calculate exact AgeSummary: Hi All, Can anyone please confirm the query to calculate the exact Age in BIP report. I tried multiple functions like Datediff & Months_between but, they are no…Sagar Perala 126 views 2 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
Can we pass SYSDATE in Share report link URL of reportWe need to pick sysdate instead of static date in report Link. eg: https://fa-****-saasfaprod1.fa.ocs.oraclecloud.com:443/xmlpserver/Custom/XXXX/Reports and Analytics/Co…Sourabh Patial 61 views 13 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
query of Negotiation modifications IP addressSummary: Need to report on Negotiation's modifications IP address Content (please ensure you mask any confidential information): Hi All, I would like to know, is it poss…sultank 21 views 1 comment 0 points Most recent by Jun Ye-Support-Oracle Reporting and Analytics for HCM