BI Publisher
Discussion List
-
BI Report: usage of fnd_sessions table first_connect and last_connect to track login time of usersSummary BI Report: usage of fnd_sessions table first_connect and last_connect to track login time of usersContent Hi, We have a BI report developed to track the login ti… -
How to fetch the Covered Levels of a Subscription using querySummary: How to fetch the Covered Levels of a Subscription using query Content (please ensure you mask any confidential information): How to fetch the Covered Levels of …Neelesh Varma 21 views 3 comments 0 points Most recent by Manoj Kumar-Support-Oracle Reporting & Analytics for Sales -
Reports APII am looking to get Rest API to get folder contents of Report Path Mentioned in Report and Analytics Catalog. I have found the SOAP API but it is using Username and Pass…Someshvar Bansal 22 views 1 comment 0 points Most recent by Manoj Kumar-Support-Oracle Reporting & Analytics for Sales
-
Learning Assignment Completion approval notification is blankSummary: Learning Assignment Completion approval notification is blank for line managers but administrators can view the details on the notification from bpm worklists C…
-
Ethnicity Formula broken in report after 24A updateSummary: We have a report that has been in use without issue for a few years. In this report, we are getting a general active headcount of employees and contractors with…Rob Stahly 52 views 13 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How to decide if a report to be developed in BIP or FAW?Summary: Content (please ensure you mask any confidential information): Based on what criteria should we use to determine if a report can be developed in BIP or FAW? Ver…Merlin Rajesh Avery 11 views 1 comment 0 points Most recent by Gayatri Chappalli-Oracle Reporting and Analytics for SCM -
Generate Purchase Withholding Report for Colombia report is not showing any OutputSummary: While we are submitting the above subjected report, its not showing any output and we have Invoice and WHT and Payment data for this country. Report is blank. C…
-
Learner assignments missing most recent changesSummary: Does anyone know how to identify learners whose learner assignments are missing the most recent changes by looking at the wlf_assignment_records_f table? Conten… -
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 1 view 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 Started 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 notificationhttps://us.v-cdn.net/6034893/uploads/ALRQMK77179Z/sufinexmnotifsubtemplate6.zip Summary: Business requirement is to show the project number on the expense reports workfl…
-
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 63 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