BI Publisher
Discussion List
-
How to call an OIC integration from BIP reportSummary: I have created an app driven integration with two request parameter. How can I submit the integration from BIP report? Content (required): I got a blog https://…Ananya Sadhukhan 4.8K views 19 comments 0 points Most recent by Adi Salomons Oracle-Oracle Reporting and Analytics for ERP -
ExternalReportWSSService runreport data is inconsistentSummary: When we call a HCM report which has employee info, the contact details info-the phone number value is coming inconsistently. Sometime it gives a empty/null valu…KarthikeyanPK 32 views 2 comments 1 point Most recent by KarthikeyanPK Reporting and Analytics for ERP
-
Is there a tool or a way of extracting all a list of all reports OTBI, BIP and OACHi All, Is there a tool or a way of extracting all a list of all reports OTBI, BIP and OAC. Thanks & Regards, Keerthana SekarKeerthana Sekar 81 views 8 comments 0 points Most recent by Dimple-Nagesh-Support-Oracle Reporting and Analytics for ERP
-
Fusion to SFTP - File got corruptedSummary: By bursting query we are transferring a fusion report to SOA SFTP. But in SOA SFTP the files seems to have missing lines. i.ie., Fusion report has 18k lines in … -
BLOB in sql query datamodel, how to display readable values?Summary: In BI in a datamodel, how to display in readable format a BLOB value? select adhocschedule from fusion.request_history This value only displays: ��¿¿ ¿dgodard22 101 views 4 comments 0 points Most recent by Rajesh Kumar Gunda Reporting and Analytics for ERP
-
Sql query to get PO Change Order line Details.Summary: Required sql query to get following PO Change Order line Details. Columns: Attribute Change From and Change To Content (please ensure you mask any confidential …Praneeth Nalluri 563 views 1 comment 0 points Most recent by Fazal Subhan Reporting and Analytics for ERP
-
Unresolved Account Permission getting added to BI catalogue in oracle ERP after deployment.Summary: we are migrating the BI Data model and Report along with folder structure to higher environment in ERP cloud, we are facing issue where an "unresolved account" …Praveen Kumar P 31 views 2 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for ERP
-
Query to fetch project and Time card entries(OTL)Summary: Hi Team, We need a table where the project number and time card entires details or SQL query Content (please ensure you mask any confidential information): We n…
-
How to get green check mark and Time along with Digital Signature in Oracle BIPI have a requirement to print the Digital Signature with Green Check mark and Time using RTF Template in BI Publisher(Sample Attached). Let me know how can we achieve th…
-
Need PVO details for PER_USER and PER_USER_HISTORY?Summary: I am looking BICC Tag for PER_USER, PER_USER_HISTORY I've found "HcmTopModelAnalyticsGlobalAM.UserAM.UserPVO" this PVO has history id so I assume this is for PE…RameshBabuJambula 43 views 3 comments 1 point Most recent by RameshBabuJambula Reporting and Analytics for ERP
-
ExternalReportWSSService in SOAP UI does not give correct BIP Report responseHello All, I am facing issue in OIC New Hire Integration between Oracle HCM Cloud and Ceridian Dayforce. In OIC Service, SOAP API call(ExternalReportWSSService) to BIP R…Taruna Sharma 81 views 1 comment 0 points Most recent by Shankar-Oracle Reporting and Analytics for ERP
-
AP_HOLDS_ALL record deleted from the tableSummary: Hi All, we are trying to build a dashboard for AP invoices and related holds. During some tests, we notices that some record in the table ap_holds_all disappear…
-
How to handle data access security in Custom BI ReportsSummary: We have the requirement to restrict data in custom BIP reports based on business unit access for the user in Fusion. For example, if report is built for 'XYZ' b…
-
BIP 12.2.1.4 desktop flagged with Malicious with high threat scoreSummary: Software packaging team has restricted BIP 12.2.1.4 desktop installation due to high threat score. Need a workaround so that we can continue to use BIP desktop …
-
Is there a way to limit what tables a user can query in OTBI?We have a support team that's requesting access to write Data Model queries in OTBI. Our concern is restricting them to only the financial tables. Does anyone know if th… -
Oracle Fusion table for AP transactionsSummary: We are currently creating two BIP report to pull AP transactions. The first BIP report needs to pull AP transactions from GL table and the second BIP report sho…Gel Romero 31 views 2 comments 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management
-
I am not able to access data model through report edit section, page showing as unresponsiveWhen I am trying to access a BI report to attach a data model through Edit section of the report, page is showing as Page Unresponsive in DEV instance, can i delete the …Shahid Qureshi 165 views 8 comments 0 points Most recent by Mahesh Kumar C Reporting and Analytics for ERP
-
Is it true that oracle is planning to deprecate webservice datasets from BI Data Model?Is it true that oracle is planning to deprecate webservice datasets from BI Data Model? and if its true, what are all the dataset types that will be retained in the futu…Abhilash K - Deloitte USI 21 views 2 comments 1 point Most recent by Abhilash K - Deloitte USI Reporting and Analytics for ERP -
BI Reporting restricting by segment value depending on UserSummary: I am looking for a way of resticting a BI report by a segment value depending on the user accessing the reports. Ideally by assigning a segment to a user withn …JHould 11 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
I need to get OTBI Report Link with parameter like BIP ReportSummary: Hi Team I am looking for deep link or OTBI report link so that I can hit the URL directly by passing parameters. We have this feature in BIP to get the link , b…sailesh_cloudare 1 view 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP -
BI publisher reports using Custom Subject Area objects show Slow PerfomanceSummary: Hi, we defined several custom objects in our sandbox and created Custom subject areas to develop reports by using fusion bi publisher In general, reports are wo…Joseph Rodriguez 21 views 1 comment 1 point Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
ORA-29400: data cartridge error ORA-10260: PGA limit (20000 MB) exceeded - process terminatedSummary: We are running a custom report that have recover more than 1.2 million of records and cheking the XML Data this have over the 1GB, when we executed this report …Darwin HP 111 views 1 comment 1 point Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP -
How to get details of intransit_time(MSC_INTERORG_SHIP_METHODS) in Sourcing Rule with sql queryHow to get details of intransit_time(MSC_INTERORG_SHIP_METHODS) in Sourcing Rule with sql query(Fusion). SELECT INTRANSIT_TIME FROM msc_interorg_ship_methods mism, msc_s…Sreekanth Kandula 1 view 2 comments 0 points Most recent by Sreekanth Kandula Supply Chain Planning and Collaboration
-
Is there a Oracle DB package / function to retrieve a country code from a given location_id?Summary: Hello, I'm looking for a Package / function which I can use in a BIP datamodel to retrieve a country code for a given location id. Some of the seeded datamodel …Frank.Steinjan 1 view 2 comments 1 point Most recent by Frank.Steinjan Reporting and Analytics for ERP
-
how to get production instance name in BIP reportSummary: How to check via SQL in BIP report whether the instance is Production vs non Production ? we have a requirement to put a check in the BIP report so that emails …
-
Need the table name that stores job history of BIP reports submitted through BI publisher dashboardSummary: Need the table name that stores job history of BIP reports submitted through BI publisher dashboard but not the Scheduled processes page. (I know the ESS_REQUES…Chetan Konda 1.3K views 8 comments 0 points Most recent by Natarajasuthan K Reporting and Analytics for ERP -
using trigger for BIP reportSummary: I am trying to use a trigger for a BIP report and schedule. Content (please ensure you mask any confidential information): I only want to deliver the report whe… -
can not find new option under file menu in FRS to create a batch in BI cataloguecan not find new option under file menu in FRS to create a batch in BI catalogue
-
Getting Error while calling US 1099 Payments reportSummary: Hi Team, We are getting Error while calling US 1099 payments report. Error Details : java.sql.SQLSyntaxErrorException: ORA-00904: "CPI"."CLEARING_CCID": invalid…SukaShah 71 views 1 comment 1 point Most recent by Dhaval Patel-Oracle Payables, Payments & Cash Management
-
Require to fetch Roles and Data Access assigned to employees for BIP report in Oracle HCMSummary: Staff List by System Role Report Content (please ensure you mask any confidential information): Where do I find these fields - Data Access Permissions, Data Acc…Pradnya_Pampatwar 91 views 1 comment 0 points Most recent by Priya_Ananda Reporting and Analytics for HCM