BI Publisher
Discussion List
-
New record character in eText Template does not workI am creating a BIP report using etext template and filled in the format setup table in the template like the image below. (New record character: Carriage return) But wh… -
SQL query to fetch number of direct reportees to a line managerSummary: I want to build a BI report where I need to fetch the count of direct reportees to the Line Manager. Content (please ensure you mask any confidential informatio…Tamseel Aijaz 883 views 2 comments 0 points Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM -
Secured List Views for compensation worksheet displaySummary: HCM table of Secured List Views for compensation worksheet display Content (please ensure you mask any confidential information): Version (include the version y…Tamseel Aijaz 2 views 2 comments 0 points Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM -
Need Header even No Data returns on BI Publisher output (CSV)Summary Header is not coming in BI report when No Data returns (CSV)Content In My BI Report, I am passing date as a parameter. When No Data Returns for date parameter, H…User_6U8NQ 414 views 7 comments 0 points Most recent by Jahnavi Konduru Reporting and Analytics for HCM -
Transactions Print Data Model Lexical ReferencesSummary: Content (please ensure you mask any confidential information):In the data model Transactions Print, we added a custom line of code to the Header data set and up…Rory Mullin 55 views 1 comment 0 points Most recent by Andreea Laura Panait-Oracle Receivables & Collections -
../ directory path reference tag in RTF is not working properly in BI Analytics.Summary: ../ directory path reference tag in RTF is not working properly in BI Analytics. Content (please ensure you mask any confidential information): We are using the…Lokesh Ramesh 1 view 0 comments 0 points Most recent by Lokesh Ramesh Reporting and Analytics for HCM -
REST API for Salary, Payroll elements and StocksSummary: Content (please ensure you mask any confidential information): Hello experts, do you know where retrieving REST API for Salary, Payroll Elements and Stocks? Kin…Valerio Curzi 24 views 7 comments 0 points Most recent by Shyam Rajbhar Reporting and Analytics for HCM -
exceeds the maximum limit error even after using filterSummary: exceeds the maximum limit error even after using filter Content (please ensure you mask any confidential information): Hi Team, Greetings! We are getting below …Parag Hiremath 14 views 2 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
Payroll Report Pulling Wrong Assignment Manager in BI ReportI'm working on updating a Payroll Last Row Validation Report. It is currently pulling the wrong assignment manager for the last effective dated change on their employmen…Nicole A. 21 views 6 comments 0 points Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM -
Unable to get the Enterprise Seniority Date Person level in OTBISummary: Hi all, I am not able to find the field related to Enterprise Seniority Date Person Level in OTBI using the subject area Workforce Management – Worker Assignmen…Deepak Bhatt 1K views 38 comments 1 point Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Customer needs to add a customer class parameter to "Send Dunning Letter" ESS JOB.Hi, Customer needs to add a customer class parameter to "Send Dunning Letter" ESS JOB. Can we achieve this requirement by customizing this seeded ESS job? Please suggest…Vinita.V 41 views 5 comments 0 points Most recent by Rasheed - Fusion Support Engineer-Oracle Receivables & Collections -
Send dunning letter ESS jobHi, We have a business requirement to customize the Send Dunning Letter ESS job, we have customized the 'Send Dunning Letter' ESS job, but when I try to submit it, an er…Venkateswari 122 views 9 comments 0 points Most recent by Rasheed - Fusion Support Engineer-Oracle Receivables & Collections -
"General Ledger Journal and Subledger Transaction Mapping Report"HI Team, is it possible to get sql behind report "General Ledger Journal and Subledger Transaction Mapping Report" /shared/Financials/General Ledger/Account Analysis Gen…SushmaMeesala006 43 views 5 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP -
Intelligent Payment/ Dynamic Discounting NotificationsHow does the Intelligent Payment/ Dynamic Discounting Notifications get sent out to suppliers on a weekly basis through a scheduled process job?Anushree Chitranshu 11 views 3 comments 0 points Most recent by AnamariaRoman-Oracle Payables, Payments & Cash Management -
Need a table or query to get Latest open period column in Manage Intercompany Period StatusSummary: Hi Support, We need a table for the column's "Latest open period" and "Open Transactions" under the setup Manage Intercompany Period Status. We have the table F… -
Concatenate elements in eText templateSummary: Concatenate elements in eText Positive Pay template Content (please ensure you mask any confidential information): I am looking to concatenate two data elements…KDR 344 views 3 comments 0 points Most recent by Alexandra Tam -Oracle Payables, Payments & Cash Management -
We need the below fields data from Manage Subledger Accounting OptionsSummary: Hi Team, We are unable to find the table where the information of "Accounting Processing Options","Transfer to General Ledger Processing Options" under the setu… -
Customer is looking for audit reports which they have enabled audit for business objects.Summary: Customer is looking for audit reports which they have enabled audit for business objects related to human resources product. But, the information available is n…Prasad Singamaneni-Oracle 71 views 10 comments 0 points Most recent by Chris_V Receivables & Collections -
Add a hyperlink to an image in a BI Publisher Interactive reportSummary: In an interactive report, it is possible to add a link to text using the appropriate icon, but how do you do it on an image? Thank you Content (please ensure yo…Guido Masciello 31 views 6 comments 0 points Most recent by Guido Masciello Reporting and Analytics for HCM -
SQL to get the activity completion status of learners.Hi, We have a requirement to get the activity completion status of each learners. In our set up a offering can have multiple activities, a learner might have completed f… -
SQL query to get offering start date and end date in learn module in fusion HCMContent Hi All, I am working in a requirement where I need the following details: Offering Name, Offering start date, Course Name, Person number enrolled in the offering… -
BIP Bursting report failsSummary: Creating a report that will be emailed (bursting) to employees that have outstanding PCard charges that need to be added to a report for reconciliation. The rep…Kaz Myskiw 104 views 9 comments 0 points Most recent by Cosmin Foslea Reporting and Analytics for ERP -
BI Publisher report that shows learning activities scoreSummary: Activity score not showing in BIP Content (required): Hi, I'm trying to build a BI Publisher Report with information about learning activities inside courses. I…Vasco 495 views 10 comments 1 point Most recent by Prasanth Subbaiahh-Oracle Reporting and Analytics for HCM -
Exist a report that show all page composer in the ERP?Exist a report that show all page composer in the ERP?Cristian Gonzalez S 1 view 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for ERP -
Asset - manually enter invoice number not in table fa_asset_invoices.Summary: How to query asset that was entered manually. Invoice number,po number that was entered manually isn't populating in fa_asset_invoices so is there another way t…