BI Publisher
Discussion List
-
Fetching employee using BIP query if employee have Job changes and TerminationSummary: Fetch the details of employee who have job changes and termination details of employee Content (required): Hi, I am working on BIP query to fetch the details of…Kamini Kaushik-Oracle 558 views 4 comments 0 points Most recent by gclampitt Reporting and Analytics for HCM -
How to create Bursting without linking / upload attachment to a Transaction?Summary: Hello, we are using a customized Datamodel for the Print Receivable Transactions process. We also use our own bursting which creates multiple PDFs for a transac…Frank.Steinjan 34 views 1 comment 0 points Most recent by Andreea Laura Panait-Oracle Receivables & Collections
-
OTBI Training Tutorials on YouTubeSummary OTBI Training Tutorials posted on YouTubeContent 26 OTBI, BIP & SmartView tutorials are now available on YouTube, Oracle Learning Library and Oracle HCM Cloud R1…User720640-Oracle 462 views 8 comments 2 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Which Table Holds "Access level" From The Compensation Worksheet ?Summary: SQL query to fetch Access Level in report. Content (please ensure you mask any confidential information): I need to fetch "Access level" From The Compensation W…Tamseel Aijaz 13 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
how to default invoice template on collection dashboard preview screenIn collection dashboard when you select customer delinquency there is option of preview, when i click on preview it;s picking INFUSION default template . How to default …charanjeet 2 views 1 comment 0 points Most recent by Vitalie Rusanovschi-Oracle Receivables & Collections
-
How to auto increment the date parameters of the seeded report?Summary: I need to schedule the report on a monthly basis and will auto increment the said parameters. Payables Invoice Register: -From Entered Date -To Entered Date -Ac…Mikee Tamonan 52 views 5 comments 1 point Most recent by Venk Kudire- Support-Oracle Payables, Payments & Cash Management
-
How to compare output of two files in oracle fusionSummary: We've created a custom BIP report to get the salaries of each employee. This output from the publisher, we wanted to match with the document with same format wh…zafarkhan 25 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Is it possible to set separate Permissions for My Folder and Custom folder (under Shared Folders)?Summary: The requirement is to provide access to create Data Model, Report and Analysis under My Folder in Oracle BI Catalog and for the same user provide read-only acce…
-
How can we get the Project information in subject areas 'Fixed Assets - Asset Transactions Real TimeSummary: Hello Team, I am using this subject area to get the asset transactional details. But unfortunately, I am unable to get all the details such as Project informati…Suhitha K-Oracle 21 views 1 comment 0 points Most recent by Nidhi Chhajed Reporting and Analytics for ERP
-
How can we apply calculation at column level in OTBI reportSummary: We have a requirement to put condition at column level to find out requisition which has approved days greater than 60days. EX- We have a report at dashboard, w…Manish_Chauhan 13 views 3 comments 0 points Most recent by gclampitt Reporting and Analytics for HCM
-
Meaning of Obsolete Status in WLF LEARN EVENT tableSummary: Meaning of Obsolete Status in WLF LEARN EVENT table Content (please ensure you mask any confidential information): Hi Team, Greetings! It has been observed that… -
Referencing parent and parent of parent xml data for bip templateSummary: I want to call a parent two and three levels up from my main for-each statement. How do I achieve this? Content (required): This is my xml layout My code is bas…
-
Is it possible to create a pivot table "view" in Excel BI Publisher?Summary: Is it possible to create a pivot table "view" and one with a report in a regular table? Content (please ensure you mask any confidential information): I'm tryin… -
Historical Date Reporting - BIPWhat would be the equivalent OTBI's SET VARIABLE PARAM_EFFECTIVE_DATE='2006-05-18'; in a data model. I am trying to create a BIP report where users can enter an as of da… -
SQL script for job roles inherited by data rolesSummary: Trying to build a query to fetch users with their data roles and inherited job roles. I am able to fetch the data roles and job role assigned assigned directly …Vaishnavi Agrawal 104 views 3 comments 0 points Most recent by Ranveer.Tiwari-Oracle Reporting and Analytics for ERP
-
The column "Accounting Status" on Manage Invoice screen is which table information?Summary: From which table can I get the "Partially accounted" in the attached image? Content (required): PATH :: HOME>Invoices>Task:Manage Invoices I want to get the val…REI TSUKAHAR-Oracle 780 views 6 comments 0 points Most recent by MarkGauthier Payables, Payments & Cash Management
-
Condition to display active customer accounts/sites in Customers extract OTBI ReportSummary: Hi, We used subject area named "Receivables- Customer real time" to create an OTBI to extract customer master. however, we couldn't find a column in any folder …
-
Required REST API to get Predefined Validations undern Manage Payment MethodsSummary: Hi Team, We need REST API to get Predefined Validations and their parameters undern Manage Payment Methods setup and attached screenshot for reference. Content …
-
Link between ZX_RULES_B and ZX_STATUS_B in oracle fusion TaxSummary: Got a requirement to link these two tables to generate report for Tax Rate and Rule Content (please ensure you mask any confidential information): Version (incl…
-
How to Join ZX_LINES and XLA_AE_LINES to Get Tax Details (Rate, Amounts etc.)Good Day Experts, How can I join ZX_LINES and XLA_AE_LINES? I have a custom tax report where subledger debit/credit amount (Item Expense or Revenue) is displayed then th…
-
Please let us know how we can add the Attachment column in an OTBI report for ReceivablesSummary: Please let us know how we can add the Attachment column in an OTBI report for Receivables subject area, prefarably Receivables- Real Time Transaction subject ar…
-
Dunning Letter email - missing body text messageHi, We are implementing advance collection and setup all items for dunning letter email. We are able to get the email with PDF as attachment but email body message is bl…
-
Custmization on AR Transaction Image ,error occurred File name must end with .xdoz / .xdmz / .xssz /Hi Team , when I changing the query, system asking for Lexical parameter . For this issue , I found below documentHow To Work With the Lexical Parameter Value When Custo…Sandeep.kumar2454 21 views 4 comments 0 points Most recent by Sandeep.kumar2454 Reporting and Analytics for ERP
-
sSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…5372189952873 1 view 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for ERP
-
Does anyone have the Payables invoice register report as oracle SQL QUERY.I want to create a BI report that is the same as the payable invoice register (the one seeded in Schedule process ) , due to filtering option (i can't filter by invoice …Omran Zeaiter 32 views 1 comment 0 points Most recent by Shivam Chauhan-Oracle Payables, Payments & Cash Management
-
Clarification on Manual Payment Workflow in Learning ModuleHi Team, I have a question regarding the learning module. I created a course and added manual payment. I then applied an override at the Offering level using "Edit Offer…
-
How to XML extract for Send Separate Remittance Advice (SRA) in Oracle Fusion PaymentsSummary: Content (required): We need to modify the report layout and need the XML data for testing purposes. How can we obtain the XML extract for Send Separate Remittan…DPM 1.1K views 6 comments 0 points Most recent by Prassanna_Srinivasan Payables, Payments & Cash Management
-
How to add multiple Digital Signature based on Legal Entity for Print Receivables Transactions job.Summary: There is a requirement to attach the Digital Signature to AR invoice dynamically based on Legal Entity (digital signature varies for each LE). For this requirem…
-
Dunning Letters - Send to Printer - How to?Summary: Hi all, How/Where do you configure the printer setup for the Dunning Letter distribution using bursting? Content (please ensure you mask any confidential inform…