Reports
Discussion List
-
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 106 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 2 views 2 comments 0 points Most recent by Sreekanth Kandula Supply Chain Planning and Collaboration -
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 …
-
Trial Balance Report IssueIn Report credit side are just totals wherein it should have been broken according to each related account, like shown in the debit side, below is the 2 SS with wrong on…Vivek Makwana 2 views 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany
-
FRS - Option to get the 'Prompt' of the COA segment in the POV instead of the segment nameSummary: Hi All, We had a requirement to change the segment name of the Future segment. Since it had multiple implications as suggested in the forum we have only changed…Vipusha Chandrakumaran 13 views 1 comment 1 point Most recent by Andreea Brem-Oracle General Ledger & Intercompany
-
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 73 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 92 views 1 comment 0 points Most recent by Priya_Ananda Reporting and Analytics for HCM
-
Which table store node descriptionSummary: Which table stores node description Content (please ensure you mask any confidential information): I have to pull in the node description for a cost centre on m…CKleu 2 views 1 comment 1 point Most recent by Mihaela Cozma GL-Oracle General Ledger & Intercompany
-
customization of Payment process request WF notificationsSummary: customization of Payment process request WF notifications Content (please ensure you mask any confidential information): Hi All, Is it possible to customize PPR…Venkatesan 3 views 1 comment 1 point Most recent by Stephen Westerfield-Oracle Payables, Payments & Cash Management
-
FRS - To get the end date of the period selected at the report running parameterSummary: Content (please ensure you mask any confidential information): Hi All, Do we have any option to get the end date of the period which is selected while running t…Vipusha Chandrakumaran 12 views 1 comment 0 points Most recent by Anca A-Oracle General Ledger & Intercompany
-
Validate OTBI Table Access for User based on Item Class RulesSummary: We have assigned the group “HPSA_CHANGE_REQUESTER” to Item Class “IC_HPSA”. And then assigned the role “HPSA_CHANGE_REQUESTER” to some users in order to assure …
-
Procurement BU missing in Top 10 Spend by CategorySummary: Procurement BU missing in Top 10 Spend by Category Content (please ensure you mask any confidential information): Hi Experts, Would like to reach out to you on …
-
Calling another template in RTF left-justifies the alignment instead of justifySummary: Content (please ensure you mask any confidential information): Hi all, I am calling another template within my rtf template and it's working great, but the issu…Steph96 30 views 1 comment 1 point Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP -
What is the difference between Uploading a BIP report vs. Archiving a BIP ReportSummary: There are two options to take a copy or get a copy of Data Model and Reports. XMLPServer and click on Upload/Download Catalog folder and Archive/Unarchive Conte…Earth place 13 views 1 comment 1 point Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
BurstingSummary: Hi team I have a requirement where I should extract list of the reports name in which we have used bursting? Content (please ensure you mask any confidential in…User_S6U3H 21 views 2 comments 1 point Most recent by Swapnil Kashid Reporting and Analytics for ERP
-
Is that possible to find that does report has used bursting by sql querySummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…User_S6U3H 11 views 2 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for ERP
-
Merge Two OTBI Subject AreaSummary Develop a OTBI report by Merging two OTBI Subject AreaContent I have a requirement to develop OTBI report using two OTBI subject areas. Following OTBI subject ar…
-
Asset Transaction Real time is not showing dataSummary: when I select Asset number and invoice number just these two columns from several folders of the above Asset subject area, report is not fetching any data, howe…
-
Group Project Tasks by Task NameSummary Group Project Tasks by Task NameContent We have a standardized work breakdown structure and would like to compare costs for the same task across projects, right …Prasanna Reka-OC 38 views 1 comment 0 points Most recent by Cindi Jacobsen Reporting and Analytics for ERP -
I am trying to run Modelo Verification report for code 340 spain. But it is not providing any data.I am trying to run Modelo Verification report for code 340 for spain implementation . But output is coming blank. I have created AP Invoices with all required parameters…
-
Oracle Procurement Punchout Definition tableNavigation - Procurement - Catalogs - Manage Catalogs - Punchout Catalog We are trying to build a bip report to query all the punchout catalog information. We are not ab…
-
scheduled report not getting data in output filewe have scheduled a report on daily basis to the SFTP folder using the destination while scheduling reports. Reports are scheduling but not showing data in the output ge…Dara Nagasai 89 views 1 comment 1 point Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP -
How to we call multiple Standard Packages in Data ModelSummary: As part of our requirement we need club two standard FA report columns. Two report called two different Standard Default Packages and in Report triggers also. C…Sarala B-Oracle 48 views 1 comment 1 point Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
Approvals Configuration for ReportsSummary: This was basically a requirement by an client who need an approach for delivering the configuration of the business rules to facilitate internal charges in the …Bhavish Kumar B 5 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
Approvals Configuration for ReportsSummary: This was basically a requirement by an client who need an approach for delivering the configuration of the business rules to facilitate internal charges in the …Bhavish Kumar B 12 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
Is it possible to get the Metric on Access logSummary: Request you to help me to get the metric on access log, usage of forms, reports Content (please ensure you mask any confidential information): Version (include …Srinivasrao 2 views 1 comment 1 point Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
Digital Signature showing invalid for Adobe Acrobat ReaderSummary: Digital signature showing invalid when viewed in Adobe Acrobat Reader Content (please ensure you mask any confidential information): Digital Signature showing i…Abhishek Parmar 1 view 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
CUPS Server Printer Setup in ERP BIPSummary: Hi Team, we have below requirement and need to understand. Can some one please help on this. The print server has been installed in Azure with the CUPS service …PrasadN 12 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
How to get Amount in Words in Arabic language in excel template with Saudi currencySummary: I have total eg: 21113.75 and it should show in output arabic of 'Twenty-One Thousand One Hundred Thirteen Saudi Riyals And Seventy-Five Halala'. I am able to g…Rahul K-Oracle 34 views 1 comment 2 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
How to create a hyperlink to another sheet within same excel -BIP report Excel templateSummary: I am trying to create an Excel template in which there are 2 tabs. One will have budget control balance details and other sheet will have PO details. Expected f…Rekha Jose 23 views 1 comment 1 point Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP