BI Publisher
Discussion List
-
In BIP template how can i get columns printed by and printed on ?Summary: Hi Team, we have BIP template how can i get columns printed by and printed on ? Thanks, Ajay Content (please ensure you mask any confidential information): Vers…AjayKumar Maddipati 11 views 3 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
How to query for encumbrance amount on an Open status Purchase OrderSummary: We currently have PO139487 that has a status = Open. We are trying to query the tables to identify the encumbrance amount of $ 8,773 (35,700.00 - 26,927.00) usi… -
OTBI and BIP Report Scheduling - Ideal Time WindowHi all, Just a quick question I'm hoping someone can answer. Is there a preferred time for scheduling OTBI and BIP reports during the day? Any times to avoid / best time… -
How to remove blank line from RTF template report output?There is a BI report(RTF Template) with the following data as output: Name: DOB: Gender: DOJ: The requirement is to hide DOB(both text and the value) for a certain c… -
Can we control the delivery option runtime in HCM Extract?Summary: Can we control the delivery option runtime? Like send the Email Report based on a Parameter set during submission of extract? when we submit an extract, if i su…
-
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 42 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 12 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. 21 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 45 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 94 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…