BI Publisher
Discussion List
-
AgingbyGeneralLedgerAccount_Understanding the Receivables Aging by GL Account ReportAgingbyGeneralLedgerAccount_The following three questions are asked about the Receivables Aging by GL Account report: ・There are 546 items when outputting CSV, but I wo…Yuma Suzuki-Oracle 6 views 0 comments 0 points Started by Yuma Suzuki-Oracle Receivables & Collections -
ESS job is takeing more time to run the reportSummary: while scheduling report from analytics schedule report it is takeing less time to run, but while trying to run from schedule process it is takeing more time Con…Charan Kumar Reddy Lingala 48 views 8 comments 0 points Most recent by veerendranath pulivarthi-Oracle Fusion Applications Administration
-
Add a document outside fusion which can be sent to customers using Print Receivables Transactions.Summary: We have a requirement where an additional document is required to be sent to customers along with the AR Invoice. This document is outside Oracle Fusion. Need t…Shefali Lakhani 17 views 1 comment 0 points Most recent by Andreea Laura Panait-Oracle Receivables & Collections -
Can we Print incomplete AR Transactions in Print Receivables Transactions ESS JobCan we Print incomplete AR Transactions in Print Receivables Transactions ESS JobSidh 8 views 1 comment 0 points Most recent by Andreea Laura Panait-Oracle Receivables & Collections
-
Is it possible to run the Create Customer Statements job for a date rangeOur Business Users want to be able to run the AR 'Create Customer Statements' job for a specific date range so as to filter out old transaction history. They also want t… -
Steps involved to integrate Oracle Fusion ERP to ZATCA using OIC integration (KSA)Summary: Need to integrate Oracle Fusion ERP to ZATCA portal. Kindly let me know the steps involved on how to create XML as per Saudi Preferred format. Content (please e…
-
Can attachment query within bursting be updated to get attachments from OM or SMC modulesSummary: We have a business case where attachments from Order or subscription need to be sent along with invoice copies. While this is achievable by manually going and a… -
In what subject area can i find the XML delivery related fieldsSummary: On the manage transaction page, I see two fields related to electronic invoicing / XML devlivery Ready for XML Delivery XML Delivery Status XML Delivery Error M… -
Receivables - Customer Real Time OTBI is not showing any report dataSummary: We have an OTBI report where we are using Receivables - Customer Real Time subject Area. When I run the report, its not showing any data. I have BI admin, Accou…
-
Bursting Issue in Balance Forward Billing ReportSummary: We are encountering an issue with bursting in the customized Balance Forward Billing seeded report. Content (please ensure you mask any confidential information…
-
How to join ra_customer_trx_all (AR Header Table) with projects tables to get the project NumberSummary: We are Trying to get the 'Project number' field in the 'Manage Transactions' Header Screen inside 'Billable' in Receivables. We are unable to find direct join t…PrerakKhandelwal 294 views 2 comments 0 points Most recent by Jesús Vega-Oracle Receivables & Collections
-
We are trying to customise the Standard Receivables Aging by General Ledger Account reportSummary: We are trying to customise the Standard Receivables Aging by General Ledger Account report and from the seeded output, we see that the accounted amounts has bee…
-
How to get text attachment information from customised "Invoice Print Report" using SQL QuerySummary: Extract text attachment on customised "Invoice Print Report" data model when run via ESS job Content (please ensure you mask any confidential information): A si…
-
Bill-to-Customer Tax Registration NumberIn transactions, the 'Bill-to Customer Tax Registration Number' is stored in which table and column?Shireesha 5 views 1 comment 0 points Most recent by Andreea Laura Panait-Oracle Receivables & Collections
-
Duplicate of Print Receivables Transactions Report fails to reach parameter selectionSummary: I have created a duplicate of the Print Receivables Transactions Report to be able to add an additional parameter to the report. Upon duplication the process sh…
-
Third-Party Control Account Balances Report - Include Zero Amount BalancesHello, In the Third-Party Control Account Balances Report there is a parameter with name "Include Zero Amount Balances", you can select either Yes or No in this paramete…
-
Customization of Create Customer Statements: Generate Log(unable to edit dataset)Summary: We have a requirement to add the receipt date and receipt number to the standard 'Create Customer Statements: Generate Log' report. We're trying to achieve this…VENKATA SWAMY BATHINA-Oracle 43 views 2 comments 0 points Most recent by VENKATA SWAMY BATHINA-Oracle Receivables & Collections
-
Transactions Print Data Model Lexical ReferencesSummary: Content (please ensure you mask any confidential information):In the data model Transactions Print, we added a custom line of code to the Header data set and up…Rory Mullin 24 views 1 comment 0 points Most recent by Andreea Laura Panait-Oracle Receivables & Collections
-
Customer needs to add a customer class parameter to "Send Dunning Letter" ESS JOB.Hi, Customer needs to add a customer class parameter to "Send Dunning Letter" ESS JOB. Can we achieve this requirement by customizing this seeded ESS job? Please suggest…Vinita.V 31 views 5 comments 0 points Most recent by Rasheed - Fusion Support Engineer-Oracle Receivables & Collections
-
Send dunning letter ESS jobHi, We have a business requirement to customize the Send Dunning Letter ESS job, we have customized the 'Send Dunning Letter' ESS job, but when I try to submit it, an er…Venkateswari 119 views 9 comments 0 points Most recent by Rasheed - Fusion Support Engineer-Oracle Receivables & Collections
-
Customer is looking for audit reports which they have enabled audit for business objects.Summary: Customer is looking for audit reports which they have enabled audit for business objects related to human resources product. But, the information available is n…Prasad Singamaneni-Oracle 78 views 10 comments 0 points Most recent by Chris_V Receivables & Collections
-
How does Print Receivables Transactions divides the transactions into batches for processingSummary: Hi, We have queries on the functionality of following Standard process: Parent Job-Print Receivable Transaction Child Job- Print Receivables Transactions: Invoi…Pooja K 15 views 1 comment 0 points Most recent by Rasheed - Fusion Support Engineer-Oracle Receivables & Collections
-
I can't see report of import autoinvoceI can't click on republish and download the pdf of the import. Maybe I need a privilege, I don't know.
-
How does the ar_bpa_print_requests table get populated?Summary: We are getting timeout issue when trying to print an invoice using the Print Receivable Program. However, this issue only happens if the delivery method of an I…marc.joed.de.guzman 70 views 2 comments 0 points Most recent by marc.joed.de.guzman Receivables & Collections
-
Where to Get Custmer Data Model and Table RelationshipsSummary: To support our integration designs with other systems we need to get access to the Custmer Data Model and Table Relationships. Is this anywhere avilable? Only d…
-
Ability to extract in bulk printed pdf attached against AR transactionsSummary: We enabled the feature allowing attaching printed pdfs against AR transactions . “Printed Transaction Copy” (Category) are all attached against printed AR trans…Oliver Lemaire 26 views 1 comment 0 points Most recent by Andreea Laura Panait-Oracle Receivables & Collections
-
In the Customer merge How to get Original Party site details?We recently performed a customer merge activity in the non-PROD instance. To track the details of this activity, we developed a BIP report to display both the old and me…
-
How do I customize and run Invoice Print Report from Receivables?Summary: We have requirement to customize Invoice Print Report from Receivables. We want to know if there is any document present which guides us on how to step by step …Amit Dey 9 views 1 comment 0 points Most recent by Sairam Surampalli-Support-Oracle Receivables & Collections
-
How can i caculate in BI Publisher rtf templete the number of days between report day and Due date?Summary: Hello! Trying to create a report of Open Receivables Transaction. So i have the column of Due Date () and i'm running the report with parameter of As of Date ( …Yftach Paschur-Oracle 17 views 1 comment 0 points Most recent by Mallik Durgumpudi-Oracle Receivables & Collections -
concatenate data elements with line break in BI excel templateSummary: It is concatenating with supp_name,supp_name2,supp_name3 columns separated by ',' . In my case comma "," also displaying for null cases. Hence i am trying to d…