BI Publisher
Discussion List
-
Report Error- Oracle HCM BIP ReportSummary: Error populates for a HR Admin user with data security that excludes specific HR depts. The report parameters page does not load for these types of users. This …Erica Williams 61 views 11 comments 1 point Most recent by Erica Williams Reporting and Analytics for HCM -
Sync process for Account Profile Start Date to Account Established Date is not workingSummary: I am trying to sync Account Profile Start Date to Account Established Date by following the below doc but it is not working: How To Sync Customer Profile Start …Rahul Kumar Gupta.-Oracle 13 views 1 comment 0 points Most recent by Rahul Kumar Gupta.-Oracle Receivables & Collections -
Extracting Requisitions from Career SitesSummary: Hello Guys, We would like to create an analysis or a data model that allows us to extract all requisitions posted on various career sites. Currently, we are enc…Giuseppe Iacono 1 view 0 comments 0 points Most recent by Giuseppe Iacono Reporting and Analytics for HCM -
Property Tax Report - Unable to modify Asset State ParameterSummary: Hi , PFB details - 1) We want to pass 'All' Values in Asset State Parameter of Property Tax Report. However, by default there is no option to select 'All values… -
How to translate BIP Report Parameter TitleSummary: We have a requirement to translate the report parameter label. We couldn't get any link from Community or MOS to check the translation. We would require your su…
-
Sql query to get shipment method of orders in oracle fusonDear All, how will get shipment/delivery method of Orders in oracle fusion
-
How to report on OLC External Providers?Hi, How can we report on the External Provider related information? Is there any OTBI way to pull that data? (Learning Content Item Real Time doesn't work for us unfortu… -
External Provider learningSummary: External Provider learning Content (please ensure you mask any confidential information): Hello experts, we would like to create a BIP report with the details o… -
Requirement to show Project Number on Expense Report Workflow notificationSummary: Business requirement is to show the project number on the expense reports workflow notification Content (please ensure you mask any confidential information): I…
-
is there an possibility to add additional parameters to the customized seeded ESS jobSummary: Hi Team, We have requirement to customize the print receivable invoice seeded program, where we need to add additional parameters to the customized Seeded ESS j…Manoj Kumar Kande 31 views 3 comments 0 points Most recent by Manoj Kumar Kande Receivables & Collections
-
Lineage document comparing PeopleSoft tables with Oracle Fusion tablesSummary: We need to migrate PeopleSoft Finance and HCM tables/fields to Oracle Fusion Financials and HCM. Could you please provide the lineage document comparing PeopleS…
-
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 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 12 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 15 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…