BI Publisher
Discussion List
-
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 48 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 55 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 3.1K 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 73 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 23 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 162 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 26 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 315 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 3 views 2 comments 0 points Most recent by Jay Ruthiran Payables, Payments & Cash Management
-
Running an AOR report that includes who is assigned to the AORSummary: Is there a way to run an AOR report of who is assigned to each AOR and include whether the assignee is included or excluded from contacts. Content (please ensur…Angelique Cole 62 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
SQL to get the list of permission assigned to Dashboard SectionSummary: SQL to get the list of permission assigned to Dashboard Section Content (please ensure you mask any confidential information): Version (include the version you …ISHWTW 1 view 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM
-
Public Holiday Report in BI PublisherSummary: Anyone has a sample SQL Code for the Public Holiday Report using BIP? I am currently having trouble connecting the PER_CALENDAR_EVENTS_VL to Node IDs to get the…User_2025-02-04-07-19-57-588 71 views 3 comments 0 points Most recent by Robert A Reporting and Analytics for HCM -
SCORM ReportingContent Has anyone had any success with creating a SCORM report in OTBI or BI? Would really appreciate help with this. Many thanks MelissaUser_2025-02-06-11-18-47-896 34 views 13 comments 0 points Most recent by Teja Arepalle Reporting and Analytics for HCM
-
Query to find the Certificates from Talent Profile, linked with Learn Course AssignmentsHi All, I've located the query to retrieve the Qualification Certificate from the Talent Profile and also the Learn Course Assignments. However, I'm unable to establish …
-
Is there any seeded report that employees can use to list personal data stored on them?Summary: We have a request to make available in ESS a report to list all personal data stored by the company on the employee. Is there any GDPR seeded report for this? T…Lluis 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Selecting multiple default values in prompts in BI reports and OTBI AnalysisContent I have a requirement where I need to select multiple values in the prompts in the BI reports and OTBI analysis. For example: Consider the column 'Assignment Stat… -
Table name for Assign As column in learning pageHi Experts, Can someone please help me with the table name for 'Assign As' column. Thanks & Regards, DineshDinesh Jaini 11 views 1 comment 0 points Most recent by Dinesh Jaini Reporting and Analytics for HCM
-
Be Able to Select Desired Currency Before Running the ReportHi, Is it possible to make the user able to select desired currency before running a report built in BI Publisher? Adding a prompt on currency would convert the amounts …Lucian Hidis 36 views 1 comment 0 points Most recent by Prabha.R Oracle-Oracle Reporting & Analytics for Sales
-
I need help setting up an account hierarchy to allow business users to view it in the cloud GLHello Support Community, I need help setting up "Account Hierarchy Management" to allow business users to view it in the cloud general ledger. Currently, they have acces…Prakash Vattapalli 35 views 3 comments 0 points Most recent by Rohan Kamat General Ledger & Intercompany
-
BIP notification sender nameSummary: Hello Experts, We have a requirement where we need to update the Sender name of the notifications being sent thru BIP, for example, Payslip notifications or not…AprilleLyn 13 views 3 comments 0 points Most recent by Dhilip Kumar P. Reporting and Analytics for HCM
-
Certificate Title LOV is BlankSummary: Certificate Title LOV is Blank in the Configure Catalog Defaults page. We have certificate folder the custom folder. We have also provided the required privileg…