BI Publisher
Discussion List
-
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 127 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 42 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 13 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 359 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 33 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 101 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 492 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… -
Which table or view contains the 'Evaluation' field displayed on the Activity page of the LearningSummary: Which table or view contains the 'Evaluation' field displayed on the Activity page of the Learning Module? Content (please ensure you mask any confidential info… -
Sql query to obtain avg rating for one learning report in BI publisherSummary: Rating column for Learning Report Content (please ensure you mask any confidential information): I am working one report about learnings and i need to calculate… -
Need to run the BIP report with one parameter which is having 500k Values .Summary: Hi All, I have a requirement to run the BIP report for 500k records which we will pass as a PARAMETER to the report . Please suggest the ideal way to do it . Is… -
What to do with high data volume in Accounting hub ?I have a few questions concerning FAH accounting engine and ERP UI. Given that our XLA_AE_LINES table has reached almost 2 billion rows in one and a half year after impl…Francois Desjardins 21 views 1 comment 0 points Most recent by Razvan Paduraru-Oracle Subledger Accounting & Accounting Hub -
Where can I configure date tolerance for PO and AP Invoice matching in Oracle Cloud?Hi everyone, I'm encountering an issue when trying to match a Purchase Order (PO) with an Accounts Payable (AP) Invoice. The error message indicates that "This line has …Engel 113 views 2 comments 0 points Most recent by Abdelaziz Safwat Payables, Payments & Cash Management -
Print Receivables transaction ReportHi team, We have requirement where for Germany we have to print AR invoice report in german and english language both. But when we run the schedule process 'Print Receiv…vikram khengare 11 views 1 comment 0 points Most recent by Rasheed - Fusion Support Engineer-Oracle Receivables & Collections -
Payment Process Request Status RTF Templatein Payment Process Request Status RTF Template, Get_Variable working directly without declaring Set_Variable. Anybody experienced same in RTF? If I use Set_Variable syst…KISHAN BUSSA 3 views 1 comment 0 points Most recent by Janaki Ankam-Oracle Payables, Payments & Cash Management -
How to get Node name and description from Manage Account Hierarchies: Specify NodesSummary: I need to get this value for a report, someone knows in which table this information is? Content (please ensure you mask any confidential information): Version …Diego Zegarra 31 views 1 comment 7 points Most recent by veerendranath pulivarthi-Oracle General Ledger & Intercompany -
Tables for Audit Report Page Details that are under Tools Tab in UI PageSummary: We need to build a BI report that extracts the Audit Report Details under Tools tab as Shown in below image. Could anyone please suggest the tables that have th…Chandana Priya-Oracle 33 views 5 comments 0 points Most recent by Melissa Goodrich Reporting and Analytics for SCM -
Blank pages in my BIP ReportSummary: Student Statements with 0 balances printing blank page Content (please ensure you mask any confidential information): I have developed a custom student statemen… -
OTBI report to pull purchase order issued from each punchout and catalogSummary: OTBI report to pull purchase order issued from each punchout and catalog Content (please ensure you mask any confidential information): Hi Team, We have require…Nidhi Chhajed 11 views 2 comments 0 points Most recent by Nidhi Chhajed Reporting and Analytics for SCM