BI Publisher
Discussion List
-
Customer invoice to get attached to invoice page after e-invoicingSummary: Invoice Print should be attached on invoice work area. There should be some schedule process which we can run and invoice print gets saved on the billing work a…Jeetesh Singh 3 views 1 comment 0 points Most recent by Sairam Surampalli-Support-Oracle Receivables & Collections -
Join Condition in BIPSummary: Hi Team, Recently, we have created a report to take out the questions and answers of the learner in a new content but when we are trying to join WLF_SCORM_INTER…
-
Custom folder structureSummary: My client wants to change the Custom folder structure. My client does not want path to be Shared Folders > Custom > Human Capital Management. My client wants to…Consultant Ian 13 views 2 comments 0 points Most recent by Consultant Ian Reporting and Analytics for HCM -
Terminated Employee QuerySummary: Can anybody Please share a query where the Terminated Employee should be Pulled in the query on the Day of Termination as Active Record. Content (please ensure …MilanMohanty 1.5K views 1 comment 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM -
How to report on days in state/phase through BIPSummary: We would need to create a datamodel showing when a submission entered a certain phase/state to calculate the times in phase/state. You can see similar informati…
-
we need a sample payment file for rtgs payment methodwe are implementing payments for customer and they want a payment file which has rtgs payment method so we need a sample payment file for rtgs payment method Thanks, Sai…Sai Divya Kolachana 11 views 1 comment 0 points Most recent by AnamariaRoman-Oracle Payables, Payments & Cash Management
-
General Ledger Report - Cash BasisSummary: Hi Team, I would like to extract or build a custom report for General Ledger in oracle fusion with the below columns data. Required columns are: GL Date Transac…Sesha Sailini 201 views 1 comment 0 points Most recent by Lakshmi Alagappan-Oracle General Ledger & Intercompany
-
BPM Notification audit informationHi Team We have a requirement to get the audit log for BPM notifications. If anybody worked on similar requirement, please share the solution/document. Thanks Umang SainiSaini 22 views 3 comments 0 points Most recent by Parag Hiremath Payables, Payments & Cash Management
-
New fields not showing any data in rtf template for document of recordsHello, I have one Document of record which is working fine but requirement is to add 3 new columns in that , For example Notice period/Hours and contract so i added all …Mirza_Adeel 241 views 0 comments 0 points Most recent by Mirza_Adeel Reporting and Analytics for HCM -
Not able to fetch Recommended Courses in the Both OTBI & BI ReportsSummary: Hi Everyone, We have created reports in the BI and OTBI to fetch all the assigned courses of Required, recommended, and Voluntary. However, we are not able to s… -
Exclude Data Models in BI Search ResultsWe don't want end users to see data models in BI. We have followed the typical approach of saving data models in a Data Models folder where the permissions on the folder… -
What is the alternative of EXTRACTVALUE function and how to use it?Summary: Hi All, As EXTRACTVALUE function is no longer supported in Oracle SQL, the Data Models designed using EXTRACTVALUE is throwing error. The alternative is suggest…Robinson Ng 101 views 3 comments 0 points Most recent by Jordan Ritchie Reporting and Analytics for HCM
-
sql statement to get the performance document current taskSummary: sql statement to get the performance document current task Content (please ensure you mask any confidential information): Hi Team, I need these below two column…Malak 1K views 3 comments 0 points Most recent by Himavarsha Sathpadi Reporting and Analytics for HCM
-
Need assistance on Bursting report for Visa and Passport expirationSummary: Hi, Our requirement: The alert should trigger Worker and AOR on Worker passport expires. The Notification should be sent before 30days. Currently Alert composer…RamkumarKadhiravan 1 view 0 comments 0 points Most recent by RamkumarKadhiravan Reporting and Analytics for HCM -
Ho do i add PO number to the 'Receivables Aging by General Ledger Account Report'Summary: Need to Add PO Number detail in 'Receivables Aging by General Ledger Account Report'. For that we are trying to customize the same for that but as the main quer…Kasi Eswari 21 views 1 comment 0 points Most recent by Sairam Surampalli-Support-Oracle Receivables & Collections
-
How to return the max value based on a column?Summary: Content (please ensure you mask any confidential information): I've created a report using Workforce Learning - Learning Records Real Time subject area. The fol…Giuseppe Cannova 82 views 2 comments 0 points Most recent by Sai Darbha-Oracle Reporting and Analytics for HCM -
Error message: ORA-01898: too many precision specifiersSummary: Error message: ORA-01898: too many precision specifiers Content (please ensure you mask any confidential information): Hi, we have run the SQL query I attached,…Barile Alberto 322 views 1 comment 0 points Most recent by Fazal Subhan Reporting and Analytics for HCM
-
How to link WLF_LEARNING_ITEMS_F_TL and WLF_SCORM_INTERACTIONS to create a BI Publisher report?Summary: Hi Team, We are trying to create a report to take out the questions and responses of the learners. In order to take out the information from WLF_SCORM_INTERACTI…
-
Ability to report out who joins talent community but does not apply to a job postingWe went live a few months ago with ORC, and in our setup we enabled the talent community and have it showing on the job search results page with a general application be…Rob Stahly 22 views 1 comment 0 points Most recent by Dawn C-Support-Oracle Reporting and Analytics for HCM
-
Creation of positive pay files with bank account appending to the file nameSummary: Creation of positive pay files with bank account appending to the file name Content (please ensure you mask any confidential information): Creation of positive …Arun0130 41 views 3 comments 1 point Most recent by Bogdan Nita-Oracle Payables, Payments & Cash Management
-
How to extract ship to customer and ship to site name?Hi, How to extract ship to customer and ship to site in a receivables table? We only found id. Thanks, Regards
-
Unapplied receipts dashboardSummary: We have a customer who is experiencing a challenge with the AR unapplied receipts dashboard, it displays unapplied credits but does not display credits that are…Maria Smith- de Novo Solutions 11 views 2 comments 0 points Most recent by Maria Smith- de Novo Solutions Receivables & Collections
-
BIP Data Model Error: ORA-22835: Buffer too small for CLOB to CHAR or BLOB to RAW conversion (actualSummary BIP Data Model Error: ORA-22835: Buffer too small for CLOB to CHAR or BLOB to RAW conversion (actual: 4445, maximum: 4000)Content Hi, Can anyone please suggest a…Manisha Chakraborty 150 views 10 comments 0 points Most recent by Viswanadh Reporting and Analytics for HCM
-
Query to get Rejected Expense Details in which need exact columns where Comments will be storeHi Team, We have built a Integration to perform the Expense operations like Approve, Reject, Request_Info. Need table where I can see the data for Rejected Expenses Comm…
-
SQL How to get point information for questions at manage activities -> (i) information -> ViewSQL How to get point information for questions at manage activities -> (i) information -> View Content (please ensure you mask any confidential information): Version (in…
-
Query to get department from PAY_COSTS tableSummary: Need to link the department to the PAY_COSTS table. How can I link the department (organization_id) to the PAY_COSTS table through other tables? Content (please…luke.syv8 1 view 1 comment 0 points Most recent by Rakesh Ghosh-Oracle Reporting and Analytics for HCM
-
How to retrieve data from excel dataset into Fast formula?Summary: How to retrieve data from excel dataset into Fast formula? Content (please ensure you mask any confidential information): I have this data model with excel base…
-
Unable to add table or link to a oracle analytics deliversWe have the next análisis with the next details: this is the text in the notificatión: [u] Hola, @2 [/u][br/] Recuerda que debes registrar tus vacaciones en la plataform…
-
need sql query / table name to get system ip and host name Against transactionsSummary: i need to get system details against each transaction. ex: some one created 1 transaction then need to know through which system it got created (system ID , hos…Eswaraiah.chikkala 41 views 1 comment 0 points Most recent by Alexandru Dicu-Oracle Fusion Applications Administration