BI Publisher
Discussion List
-
DATE_ADD function ErrorSummary: Hi Everyone! I am try to add specific year to the hire date using Date_add function, but it is throwing "Missing right parenthesis error". Could any one help me… -
Were Does The 'Generate Audit Report' Data Model reside in BI Publisher.Summary: Hi there, Were Does The 'Generate Audit Report' Data Model resides in BI Publisher ? Content (required): Does anyone know where the data model linked to the 'Ge…
-
Fusion BI Report Output file name along with current date and timeSummary: Fusion BI Report Output file name along with current date and time Content (required): Hi Team Can someone help me how to add date and time in the custom BI rep…[Deleted User] 2.2K views 4 comments 2 points Most recent by Kavitha Balaiah Reporting and Analytics for HCM
-
How do we obtain a report of the notes associated with a lead?Summary: We need to obtain a report to obtain the relationship of leads with the notes that have been created. Content (required): We tried to build this report across s…SERGIO BARRETO 61 views 1 comment 0 points Most recent by Syed Misbauddin-Support-Oracle Reporting & Analytics for Sales -
Oracle BIP Report Issue with RTF templateSummary: Seeking a solution to fix the corrupted RTP template. Content (required): Enhancing the existing rtf template to add a new field. However, the new field value d… -
Specialization and Course assignment records relationSummary Tables for specialization and course assignment relation recordsContent Hello Folks Can anyone in this forum help me with information regarding the tables which …
-
Costing table link with gl tables in hcm fusionSummary: I am looking for the below tables Whether its linked with gl tables pay_costs pay_cost_allocations_f pay_cost_allocations_keyflex GL_JE_BATCHES, GL_JE_HEADERS G…
-
Resignation/Termination Approval- Current/Pending Approver DetailsSummary: Resignation/Termination - Pending Approver Details Content (required): Hi All, There is a report requirement to show Resignation/ Termination approval -> curren…
-
Table to pull the ESS Scheduled Job definition details.Summary Required table which stores the ESS scheduled job defiinition details.Content Hi Experts, I would like to know from which table we can pull the ESS Job definitio…Charan Kollipara 118 views 3 comments 1 point Most recent by Vijaya Sekhar A-Oracle Reporting and Analytics for HCM
-
Invoice line Level DFF Information on PPR XMLSummary: Hi Experts, We got a requirement to capture AP Invoice line-level DFF information on Separate Remittance Advice. When we generate PPR XML, we are able to identi…Akhil Ch-Oracle 21 views 2 comments 1 point Most recent by Neeraj Pandey-Oracle Payables, Payments & Cash Management
-
REST - API for AR InvoiceSummary: We have a requirement to populate BILLING_PERIOD_START_DATE and BILLING_PERIOD_END_DATE in the AR lines level while creating AR invoice with REST API. Is there …Sam Samaddar 41 views 1 comment 0 points Most recent by Andreea Laura Panait-Oracle Receivables & Collections
-
Report on Employee's Time in Current RoleSummary: Content (required): We're looking to build a report that show us how long an employee has been in their current. Do anyone have recommendations or samples? Vers…Ratha Sun 44 views 1 comment 0 points Most recent by Melanie Mahon-Oracle Reporting and Analytics for HCM
-
How to take Resignation Submission date?Summary: How to take Resignation Submission date? Content (required): Hi All, Report requirement to show employee's Resignation Submission Date. From which table we can …Venkatesan 31 views 5 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
State tax details in hcm fusionSummary: I am looking for the below details in the state tax setup level state tax type state Minimimum wage state of the tax defined Please guide me to refer the table …
-
Column order in BIP ReportSummary: Column order in BIP Report Content (required): Hi, We are trying to have specific order of columns in our BIP report (CSV output). Earlier it was word layout wh…
-
We have a requirement to capture the attachments on the AP invoice as links in a custom BIP reportWe have a requirement to capture the attachments on the AP invoice as links in a custom BIP report. Not only the IDR attachments but any manual attachment with the type …KanikaGupta 363 views 1 comment 0 points Most recent by Siva Chittapragada-Oracle Payables, Payments & Cash Management
-
Help getting interview date - BI report for ORC.Summary: Hello experts, Need input for getting interview date for an ORC report i am working on. This is my first time working on ORC related tables. I can see this tabl…Jithin Mathews 93 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Unable to pull data from FA_BALANCES_REP_GT table in the seeded Reserve Summary reportSummary Unable to pull data from FA_BALANCES_REP_GT table in Reserve Summary report due to this in an Oracle only internal reportContent I'm trying to find a table/table…User_2025-01-30-23-52-10-842 178 views 2 comments 0 points Most recent by Mirela Tomoiu-Oracle Reporting and Analytics for ERP -
User_2025-10-10-00-14-09-209 41 views 2 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
In PO Print PDF report , how can we avoid canceled line in PDF outputSummary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):Kumar Nandan-Oracle 42 views 2 comments 0 points Most recent by Goopikrishnan Jayaraman-Oracle Reporting and Analytics for SCM -
I'm looking below columns in otbi or any reference reportSummary: Hi , I'm looking below columns in otbi or any reference report ,any help me on below columns. Thanks, Ajay Content (required): Opening EL leave balance /DOJ (Da…AjayKumar Maddipati 41 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Need to edit Subject in Enterprise Onboarding mail- ChecklistWelcomeReportSummary: Wanted to customize the Enterprise Onboarding email subject being sent. Content (required): We want to display the first name in place of full name in the Enter…Gourabh Choudhary 51 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Unbale to get Notice Period UOM token details for Offer creation in XML file?Summary: Unbale to get Notice Period UOM token details for Offer creation in XML file? Content (required): Unbale to get Notice Period UOM token details for Offer creati…
-
Need Enterprise Onboarding Template NameSummary: Wanted to customize the Enterprise Onboarding email being sent. Content (required): We need the path of the template. We want to display the first name in place…Gourabh Choudhary 51 views 3 comments 0 points Most recent by Ramanathan Sockalingam Reporting and Analytics for HCM
-
Need SQL for data model list of values for Time Card Time TypeSummary: I need to add a parameter to a BI Publisher Report that has the values from the Time Type field from the Time Card. I have the following SQL written for the lis… -
Special Characters in BIP ReportSummary: have requirement of replacing special characters coming in the description column of the BIP report with following: Double quotes replace with '"' need to …Rajdeep Chavda 255 views 0 comments 0 points Started by Rajdeep Chavda Reporting and Analytics for HCM
-
Bursting To FTP server Not WorkingSummary: Bursting To FTP server Not Working Content (required): Hi All, I have developed one report where I want to place the file in the ftp server and for that i have …Pritam Das 272 views 8 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP
-
Geography Mappings in Oracle HCM CloudSummary: How is data from hz_geographies mapped to per_addresses for countries other than the US Content (required): I am working on a Peoplesoft to Oracle HCM Cloud imp…NathanParry 113 views 1 comment 0 points Most recent by Sebastien Mariller Reporting and Analytics for HCM
-
calculation card link with legal employerSummary: we are trying to fetch the below calculation card with specific legal employer Could you please let me know if any query is available or guide me on the linking…