BI Publisher
Discussion List
-
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 78 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 301 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 130 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
-
I am unable to find out the table which stored the frequency of the workflow remindersI am unable to find out the table which stored the frequency of the workflow reminders in oracle hcm fusion.Kindly let me know if any one is aware of the sameUser_NQOB7 1 view 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
Mail notification sending limitSummary: Hi Experts, Using Oracle Fusion HCM Cloud, is there a limit on the maximum number of people a BIP report can be sent using bursting? Regards, Sumit Upadhyaya Co…Sumit Upadhyaya 51 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM -
Flow Ess job definition running long time.Hi, We have created a flow which will execute HCM Extract, While we ran the Flow it taking too long time, but separately if I run that Extract it is completing with in s…Kiran Kollamsetti 11 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
How to fetch Person Type from Assignment Details from Fusion TablesSummary How to fetch Person Type from Assignment Details from Fusion TablesContent Hi, I need to fetch Person Type (which shows value: 'Regular' in front-end Employee Ma…User_MC37Q 2.9K views 11 comments 0 points Most recent by Manu Choudhary Reporting and Analytics for HCM -
How to get report on learning item associated with communitySummary: Content (please ensure you mask any confidential information): We are looking for SQL to fetch list of learning items associated with topic community. we tried …
-
How to retrieve 'Exempt from Long Term Care' associated with Washington tax card from backend table?Summary: I am trying to locate 'Exempt from Long Term Care' linked to the Washington Regional Tax Card in the backend table, but I cannot find the base name in the backe…Swapna Udaiyar 61 views 7 comments 0 points Most recent by Gabriela Ichim-Oracle Reporting and Analytics for HCM
-
Unable to test Connection while using SFTP serverSummary: Hi Team, While is try to add a new connection with SFTP server, by giving all host, port , username and pwd and try to establish connection , it is getting fail…Dhilipkumaar-Oracle 61 views 2 comments 0 points Most recent by Dhilipkumaar-Oracle Reporting and Analytics for HCM -
Report/Table which shows future MPA(Multiperiod Accounting) Entries for an AHCSSummary: Report/Table which shows future MPA(Multiperiod Accounting) Entries for an AHCS(Accounting Hub) Journal Source Content (please ensure you mask any confidential …Himanshu_Parmar827 21 views 2 comments 0 points Most recent by Himanshu_Parmar827 Subledger Accounting & Accounting Hub
-
Table to fetch number of required activities in an offeringSummary: I'm trying to fetch the number of activities in an offering in the following tables, but there are no results: WLF_LI_ACTIVITY_DETAILS_V WLF_LRNR_COMPLETION_DET…
-
oracle project subledger querySummary: I am trying to construct a query to subledger detail for Projects source, but find that the sql below does not return any detail for revenue, no data is returne…Robert of STAU 21 views 2 comments 0 points Most recent by Robert of STAU General Ledger & Intercompany
-
Associating Independent and Dependent Value Sets to BIP Report Parameters in Oracle Fusion HCM CloudSummary Associating Independent and Dependent Value Sets to BIP Report Parameters in Oracle Fusion HCM Cloud – A Worked ExampleContent The business requirement is to cre…AshishERPCloud 160 views 3 comments 5 points Most recent by Dasari Dileep Reporting and Analytics for HCM -
In which table is stored the info that a vat register is finalized?we need the oracle cloud name of the table in Receivables, that store the infoACNROMA2023 21 views 4 comments 0 points Most recent by Sairam Surampalli-Support-Oracle Receivables & Collections
-
Query to get Requisition Template name in ORCHi, I have requirement to get Requisition Template name from Basic Information. navigation --> My Client Group - Hiring - Requisition (number) - Details - Basic Informat…Rajdeep Chavda 286 views 10 comments 0 points Most recent by YASHWANTH GOWDA H R Reporting and Analytics for HCM
-
Has anyone has experience with updating the 1099 NEC Copy B template?We are looking to make some changes to our 1099 NEC Copy B pdf template. Does anyone has some experience editing the pdf template?Jay Ruthiran 1 view 2 comments 0 points Most recent by Jay Ruthiran Payables, Payments & Cash Management