BI Publisher
Discussion List
-
Courses Link table name for LMS reportFrom which table we can get the course link in bi reports. Can anyone help me with the table name. Thanks, Dara NagasaiDara Nagasai 1 view 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Person details are coming as blank in the reportHi Team, We have a requirement to build a query with Card program name,Transaction Amount,Transaction Date, Employee Name and Employee Number. We used below in the query… -
Audit of BIP Report ChangesSummary: Audit of BIP Report Changes Content (please ensure you mask any confidential information): Hi Team, Greetings! Is there any available feature to track or audit …Parag Hiremath 44 views 2 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
do you know which table store the records of attached Contracts page Details in fusion?Summary: do you know which table store the records of attached Screen Details in fusion. Content (please ensure you mask any confidential information): Version (include …B.Anil 11 views 1 comment 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for SCM
-
SQL to pull Number of Days between two dates (one is a Parameter Date)?I'm currently using BIP Report. This sequel works on me if I'd like to use SYSDATE: TO_NUMBER(TRUNC(SYSDATE) - TO_DATE(TO_CHAR(SEN.SENIORITY_DATE, 'YYYY-MM-DD'),'YYYY-MM… -
Has anyone been able to set up bursting to get the AP remittance pdf file sent to the FTP server?Summary: Send remittance pdf file to the FTP server for bar coding and printing Content (please ensure you mask any confidential information): We are producing our AP re…Sarah_Ward 41 views 2 comments 0 points Most recent by Sarah_Ward Payables, Payments & Cash Management
-
Need query to resignation approved employeesHi, I have a requirement to send emails to employees whose resignation is approved. So I want to use bursting to send emails to employees. Can anyone help me out with th…Dara Nagasai 41 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
BI Report Access Issue - User Unable to Open and Access Report.Hello Community, I'm facing an issue with a BI Publisher HCM user information report. A specific user is unable to open and access the report, and I'm hoping someone can…Omran Zeaiter 285 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Japanese Addition or All Asset Detail by Asset Type Report 132 Characters - Role required to run esswhat is the role required to run the report ess job - Japanese Addition or All Asset Detail by Asset Type Report 132 Characters.PL Karthick Ramanathan 11 views 1 comment 0 points Most recent by Shawna Green-Support-Oracle Assets
-
Is there any way to create bulk users and assign them bulk roles. Also any limitations involved?Summary: Is there any way to create bulk users and assign them bulk roles. Also any limitations involved? Content (required): Is there any way to create bulk users and a…Lucky Sharma 91 views 7 comments 1 point Most recent by CHANDRESHWAR DWIVEDI Reporting and Analytics for HCM -
Looking for sql script to get Salesperson Account ReferencesWe need sql query Salesperson Account References. Anybody can help to provide the sql or related table?Guocheng-Oracle 136 views 1 comment 0 points Most recent by Sairam Surampalli-Support-Oracle Receivables & Collections
-
How to have payment amount in a cheque be in a different language other than englishSummary: I would like to know if we can have the payment amount for an invoice cheque be written in french depending on the language of the supplier site or depending on…Marina Girgis 31 views 2 comments 0 points Most recent by Marina Girgis Payables, Payments & Cash Management -
Options for logo in email body invoice (other then HTML link)Hi, We are looking for a way to put a logo in the email body of emails for receivables invoices. I started looking for options and often came across the method in which …MennovD 73 views 1 comment 0 points Most recent by Andreea Laura Panait-Oracle Receivables & Collections
-
XML Publisher/BI Publisher make text bold in XDOFX IF condictionSummary: Content (required): Hi I have this field COMPONENT_NAME from my data model. I've created a table wizard with a repeating group for all the values in COMPONENT_N…Nicolas Vahman 281 views 4 comments 0 points Most recent by Prameesha Reporting and Analytics for HCM
-
How to generate SAT compliant XML AR invoices for Mexico?Summary: We are doing Mexico implementation and need to know if there is any seeded way to generate compliant XML for AR invoices Content (please ensure you mask any con…
-
How do I pull the exact same timecard data that appears on the Oracle Team Time Cards screen?Summary: I need to create a data model that pulls the exact same data that appears on the Team Time Cards screen. We have OTBI reports that use the "Workforce Management…BeachDreamer 91 views 1 comment 0 points Most recent by Mohamed Mahrir Reporting and Analytics for HCM -
How to update US 1099 Report for custom Format layoutSummary: My team has a requirement to add some custom updates to the Oracle generated US 1099 report. The need is to have multiple sections. The top 1/3 of the page bein…Tim Smith99 331 views 2 comments 0 points Most recent by Dhaval Patel-Oracle Payables, Payments & Cash Management
-
"SQL or ORA exceptions caused due to invalid sql" Error MessageSummary: "SQL or ORA exceptions caused due to invalid sql" Error Message Content (please ensure you mask any confidential information): Hi, we built a report based on th…
-
Table to find Net Book Value of an AssetIn which table is Net Book Value stored? Navigation: Assets-> Asset Enquiry -> Search for an Asset -> Financial Tab -> Net Book Value column
-
how to add dynamic values inside message content in BIP report schedulingSummary: I would like to know whether we can add parameter values under "message" while scheduling the report . The screen shot is given below. Content (please ensure yo…Simi_SS 81 views 6 comments 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales
-
Do we have any Relation between Contract and Ar Invoices in Oracle fusion and primary keysDo we have any Relation between Contract and Ar Invoices in Oracle fusion and Common columns in tablesB.Anil 85 views 1 comment 0 points Most recent by Andreea Laura Panait-Oracle Receivables & Collections
-
Can one invoice contain lines from different expense reports from expenses?Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Yasasree Boosireddy-Oracle 31 views 4 comments 0 points Most recent by Soumya Ranajn Dash-Oracle Expenses
-
In what particular subject area can Date of Fill, Time to fill and Time to Hire be found?I'd like to pull the following columns within the Recruiting Subject Areas: Date of Fill - Returns the date/time when the requisition was most recently filled. Time to F…Welsey 12 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Oracle Standard ESS Job for 'Collection Aging 4 bucket Report'Summary: We have a Business Requirement is to default few of the report parameter values in 'Custom Collections Aging 4 Bucket Report ' in ESS Job which we had customize…Abba Ravindrababu 22 views 3 comments 0 points Most recent by Daniel S.-Oracle Receivables & Collections
-
Calculating NBV for partially retired AssetSummary: Calculating NBV for partially retired Asset Content (please ensure you mask any confidential information): How to consult the current Net Book Value in the asse…
-
Add manager in "CC" for custom alertsSummary: Hi experts, I would like to add manager in "cc" for custom alerts, is it possible? if so, how can I do that? Thank you Regards, Alessandra Content (please ensur… -
Custom Alerts: if conditionsHello everyone, I would like to create a custom alert related to a course and an offering with "if" conditions, just like: If offering ILT/Blended --> do this else --> d…