BI Publisher
Discussion List
-
We need citizenship column in BIP querySummary: Hi Team, We unable to find the citizenship column and we checked on per_citizenships table also . any one help me on ? Thanks, Ajay Content (please ensure you m…AjayKumar Maddipati 61 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
With below sub query i'm getting error is ORA-01427: single-row subquery returns more than one rowHI Team, when i sepeartely run the below sub query is working fine but when i run the total below query I'm getting single-row subquery returns more than one row. how to…AjayKumar Maddipati 41 views 9 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
We need assistance in identifying table(s) that capture shipment errorsSummary: Hi Team, We are building a BI report to fetch errors that occur during the shipment process triggered by HighJump via REST API. Currently, the team identifies e…Sai Sreeram Gundepudi 1 view 1 comment 0 points Most recent by Jagan Nori-Oracle Reporting and Analytics for SCM -
FTP server setup for BIP - Save or Test connection not availableHi Team, I am trying to add FTP server setup. I can enter all the details but I do not see Save or Test connection. I should be a complete administrator, but seems I hav…SM_EP 21 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM -
HCM Table to fetch Saved SearchHello, I'd like to create a BI report to see whether employees have created their own Saved Searches on Document Record page. Do you know which HCM table store this piec… -
Chart in BIP ReportSummary: Hi All, We are working on one report, which includes a chart. In the report, we have to populate the chart based on the percentage of certification done in each…
-
How to retrieve Country of a Logged in User to be used in a value set of a DFFCreating a DFF to determine Yes/No based on country (and some other details) of the logged in user in the value set of the same. First is it possible at all, if yes then…Avik Chakraborty 11 views 1 comment 0 points Most recent by Srilatha S-Oracle Reporting and Analytics for HCM
-
Can we get Completed By and Task Start Time of Task/Activity?Summary: we need to pull Completed By and Task start time fields using BIP ? Do we have direct columns ? Content (please ensure you mask any confidential information): V…Kadali Harika 11 views 1 comment 0 points Most recent by Srilatha S-Oracle Reporting and Analytics for HCM
-
Where can I find the BIP tables storing the "Personal Brand Administration" related details?Summary: Hello, We have a requirement to fetch Personal Brand Administration related data, specifically the information under the "Skill Settings" section - "Skill Data …Prashanth Sangram-Oracle 11 views 1 comment 0 points Most recent by Srilatha S-Oracle Reporting and Analytics for HCM
-
Can we recall the triggered emails from scheduled reports via the system ?Hi All, Is there any possible ways to recall the triggered emails from scheduled reports via the system ? Regards, JebaJebarsan Thangam John Durai Raj 11 views 1 comment 0 points Most recent by Srilatha S-Oracle Reporting and Analytics for HCM
-
Possibly changing from CCD to CCD+. Where do we store additional data?Summary: We are looking at changing our ACH remittance from CCD to CCD+. I'm wondering where the information we'd put in the Addenda record (Record 7) would be stored in…
-
Trying to find the job details from the grade table through valid grades tableSummary: We are developing the grade ladder report in that we need to get the job details for the grades. However, we get duplicates due to the multiple valid grade IDs …Rengaraj G 11 views 1 comment 0 points Most recent by AnishaPatra-Oracle Reporting and Analytics for HCM
-
Customize/remove action button in infolets for fusion HCMSummary Customize/remove action button in infolets for fusion HCMContent We have a requirement where action button of infolets needs to be hidden for users. Please share…
-
Can learner upload First Aid certification when trying to complete a course which was assignedSummary: Can learner upload First Aid certification when trying to complete a course which was assigned to him through initiative or learning assignment. Is there any wa…
-
-
How to Create a BI report for BPM worklist fields in addition to TXN action and action Reason.Summary I have created a BI report for BPM worklist, along with action and action reaction from TXN header table which is and extract from XML_data_cache filed, but it i…
-
Allow Access to Only My FolderSummary: Allow Access to Only My Folder Content (please ensure you mask any confidential information): Hello experts, we wanto to allow only users with specific role to …Oriana L. 23 views 2 comments 0 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for HCM -
How to compare BU to TRU.I was wondering if there's a way to compare BU to TRU. I've tried using different logic to compare the two, but haven't had much luck. TRU has the official name, while B…Michael Angelo Lucena 1 view 1 comment 0 points Most recent by Srilatha S-Oracle Reporting and Analytics for HCM
-
Automating Print Receivables TransactionsSummary: I am trying to automate the running of "Print Receivables Transactions" by using the "submitRequest" action of the ESS Web Service. The job is kicked off in ESS…Lee Eslick-Huff 31 views 4 comments 0 points Most recent by Lee Eslick-Huff Receivables & Collections -
How to insert cover art image on Learning Catalog Course (Not stored as a BLOB file) in a BIP reportSummary Trying to insert cover image of course in OLC in BIP ReportContent Hi Team, In Oracle Learning Cloud, we can upload Cover Art images at course level and the imag…MandeepKGupta 96 views 3 comments 0 points Most recent by Daisy Quebrata-Oracle Reporting and Analytics for HCM
-
How to track the activity actual effort for Zoom meetingsSummary: How to track the activity actual effort for Zoom meetings Content (please ensure you mask any confidential information): Hi, We enabled Zoom as Virtual Classroo…
-
Employee / Line Manager / HR Specialist seeded analyticsSummary: Customer want to know any seeded list of Employee / Line Manager / HR Specialist analytics or dashboard Content (please ensure you mask any confidential informa…Suresh Manoj Kumar-Oracle 21 views 5 comments 0 points Most recent by Suresh Manoj Kumar-Oracle Reporting and Analytics for HCM -
Is it possible to encrypt BIP report with PBE HMAC-SHA256-512 and AES-256 or PBE with MD5 and DES?Summary: As stated in the question title: Is it possible to encrypt BIP report with PBE HMAC-SHA256-512 and AES-256 or PBE with MD5 and DES? We know that PGP Encryption … -
How can configure “Print” in page Record external learning experience for employeeSummary: Hello Dears, Our client needs to configure the button Print on this page, Me > View transcripts > Any non-catalog item Can we configure a button print here to d… -
Is there any BI reports table for Oracle Learning Cloud?Summary: So, we have a requirement where we want to create a report for Oracle learning cloud using BI report but didn't get any table values. Can you kindly share the t…
-
The job "print bills receivables report" doesn't show any OutputThe job ends in "succeded" but the report doesn't show anything. Someone can help me?
-
How to transfer the extract of a job set which is using a seeded report "Asset Cost Reserve Report".I have created a job set which will be running in parallel using the same report, but with different parameters. The only delivery channels present are Fax, Printers, Em…
-
RTF template: Repeating field/section in payslipSummary: We have a requirement for the payslip that the Name, Person Relationship Number, and Payroll Name should be repeated if the payslip data continues in the 2nd/ne…Mark Jayson Tamaray 31 views 8 comments 0 points Most recent by Mark Jayson Tamaray Reporting and Analytics for HCM