BI Publisher
Discussion List
-
Is it possible to see the Old Value and New Values for Project Management Changes in Audit Data?Summary: I am trying to identify Project Management changes in BIP tables, specifically Project Org or "CARRYING_OUT_ORGANIZATION_ID" . We need to include the historic d…Kimberly Showman 24 views 2 comments 0 points Most recent by Kimberly Showman Reporting and Analytics for ERP -
How to restrict users from accessing cost centers that doesn't belong to them in FRS?I enabled a Segment Value Security Rule to restrict users from seeing cost centers that don’t belong to them. The users are correctly restricted in the Journals area — t…Jibin 12 views 1 comment 0 points Most recent by Global Oracle Support-Oracle General Ledger & Intercompany
-
Download Excel template BIP Report using SOAP Web ServicesSummary: We are currently using the following two web services to schedule and download BIP reports: soapWsdlUrlSchedule: https://{instance-name}.oraclecloud.com/xmlpser… -
Tables to pull the data for the eligibility profiles under compensation profile usage.Hello Team, The requirement is to pull the data for the eligibility profiles under compensation profile usage which are assigned to grade ladder. Please suggest the tabl…Saurabh_Mharolkar 96 views 18 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Supplier master Alias name tableSummary: Need a query to get the Supplier master Alias name Content (please ensure you mask any confidential information): Hi, we are maintaining some naming conversion …Mamdouh Ahmed 11 views 2 comments 0 points Most recent by Mamdouh Ahmed Reporting and Analytics for SCM
-
Can you send me a sample of email notification for payment approval workflowWe are not yet using the payment approval workflow. I only want is to see the format or template and details when we received the notification for approval.GRACE SORIANO 1 view 3 comments 0 points Most recent by Venkatesh Padamwar Payables, Payments & Cash Management
-
Standard report to see the default expense account of an employeeSummary: The client is looking for any standard reports to check the default expense account assigned to an employee Content (please ensure you mask any confidential inf… -
Can we customize Print Receivables Transactions report Bursting query from emai To FTP/SFTP ?Summary: Client requirement is to receive AR transaction PDF to FTP location rather sending it via email so want to customize Print Receivables Transactions Bursting que…RupaliGahalot 322 views 17 comments 0 points Most recent by User_NF6P4 Reporting and Analytics for ERP
-
Image in Email Body of BI bursting query along with static AttachmentSummary Image in Email Body of BI bursting query along with static AttachmentContent Hello All, I have a report that needs to be bursted I have a static attachment in it…AvishekNandi 538 views 5 comments 0 points Most recent by Amit_Ekbote Reporting and Analytics for HCM
-
P60 reprint blank in document records but showing in flow correctlySummary: An employee had set their document delivery preferences to not have an online copy for a P60 produced. This resulted in the employee not having a P60 created in… -
Payment method details in the tables on the providersSummary: I need to identify which Oracle Cloud Fusion table stores the “Default” and “Payment Method” attributes within the Payments section of a supplier's main site (s…Cristian Rojas 31 views 3 comments 0 points Most recent by Md_Anees-Oracle Payables, Payments & Cash Management
-
How to read csv from content server?Summary: Content (please ensure you mask any confidential information): I need to show in report results from csv uploaded in content server, what is the table to query?…Stefano_Mazzocca 1 view 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for HCM -
Invoice Approval Notification: Task details aren't available for this task. (FUN-720809)Summary: Our Invoice approvals are based on mail & one user has been getting "Task details aren't available for this task. (FUN-720809)" & notification is empty without …Sujatha Kumari 64 views 7 comments 0 points Most recent by Larissa Meid Payables, Payments & Cash Management
-
SQL query to get position in performance documentSummary: SQL query to get position in performance document Content (please ensure you mask any confidential information): Could you please advise on the SQL query needed…
-
Need Help on Source Table for Manage Common Options for Payables and Procurement:Summary: need to find table for Manage Common Options for Payables and Procurement. want value for default distributions -liability, prepayment Content (please ensure yo…
-
Is there a way to prevent user from running a report for other BU other than they ownSummary: We have a requirement to prevent user from getting data for BU's other than the one they are assigned to. how to achieve this for BIP report Content (please ens…
-
how DOCUMENT_CLOB gets populated in IBY_TRXN_DOCUMENTS table?We have requirements to create custom payment documents. We are reusing ISO20022CGI.xsl file from Disbursement Payment File Formats. The data model has SELECT DOCUMENT_C…KabirB 513 views 7 comments 0 points Most recent by Koteswara Rao Kandula Payables, Payments & Cash Management -
Bill management portal link custom template not workingSummary: The welcome email has a portal link, we have customised this to pick the value from a profile variable but the custom template is not being picked. Content (ple…
-
Blank line at the end of etext template output fileBlank line at the end of etext template output file.BASWANTH 11 views 1 comment 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM
-
How can we pull last day of current month in eText templateSummary: How can we pull last day of current month in eText template Content (please ensure you mask any confidential information): Hi Team, Our bank wants last day of m…Nidhi Chhajed 72 views 5 comments 0 points Most recent by Jehosheba Amruthaluri Reporting and Analytics for ERP
-
Exception: oracle.xdo.servlet.CreateException: java.lang.SecurityException: Security violationSummary: Failure: Due to oracle.xdo.server.ReportException: oracle.xdo.servlet.CreateException: java.lang.SecurityException: Security violation Content (please ensure yo…Parag Hiremath 1.1K views 12 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
Learning Table Details to fetch Learning Access Group related fields along with access group membersSummary: I have requirement create BIP report to fetch all learning item along with access group related details like Access Group selection method, Access group Run as,…Kamini Kaushik-Oracle 254 views 5 comments 0 points Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM
-
oracle cloud hcm bi publisher absences error handling reportHas someone written or found documentation for the steps to write an oracle cloud hcm bi publisher absences error handling report (or similar) that writes error messages…
-
is there a way to restrict the use of commas in receivables transaction line descriptionHi We are using Fusion Receivables , is there a way to restrict the use of commas in receivables transaction line description. Since the extract of transactions are sent…
-
Oracle Fusion Cloud – SQL to Extract Report-Level Permissions for All Reports (BI Publisher, OTBI)Hello Experts, We are working in Oracle Fusion Cloud (SaaS) and need to extract report-level security/permissions for all available reports in the system. Scope includes…Noorul Ariff1986 146 views 2 comments 1 point Most recent by Jehosheba Amruthaluri Reporting and Analytics for ERP
-
Need to make dynamic file name in BIP reportWe have a requirement to place the BIP report to SFTP server , file name should be dynamic as 'Filename_(sysdate-15)_(sysdate-3)'. I tried to make the filename as Filena…Anjali_Kumari4121 259 views 5 comments 0 points Most recent by CharanBochker Reporting and Analytics for HCM
-
Bi report changes are not reflecting on ORC offer preview pageSummary: Bi report details with recent changes are not reflecting on candidate's application preview offer Page. Content (please ensure you mask any confidential informa…Muzammil_789 34 views 4 comments 0 points Most recent by Muzammil_789 Reporting and Analytics for HCM
-
User Login Activity QuerySummary: We have a contractor and would like to measure his level of effort within our company. Is there an existing query or report that shows how many times a specific…usr_a.nv 82 views 20 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM