BI Publisher
Discussion List
-
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 41 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 271 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 471 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 25 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 84 views 2 comments 0 points Most recent by Abdelaziz Safwat Payables, Payments & Cash Management -
How does Print Receivables Transactions divides the transactions into batches for processingSummary: Hi, We have queries on the functionality of following Standard process: Parent Job-Print Receivable Transaction Child Job- Print Receivables Transactions: Invoi…Pooja K 15 views 1 comment 0 points Most recent by Rasheed - Fusion Support Engineer-Oracle Receivables & Collections
-
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