BI Publisher
Discussion List
-
How to get the total work hours in rtfSummary: I have a client who does not enter the hours in OTL. but under payslip they want no of hours(Bi weekly payroll - 80 hrs for 2 week). now I need to customise the…Chetan Madhusudan 3 views 0 comments 0 points Started by Chetan Madhusudan Receivables & Collections -
Delivery of balance forward bills stops in Retry In Progress statusSummary: Delivery of balance forward bills stops in Retry In Progress status Content (please ensure you mask any confidential information): You're about to run create a …Yuma Suzuki-Oracle 146 views 8 comments 0 points Most recent by Samyak Tomar Receivables & Collections
-
Error handling in Dunning Letters?Summary: Error handling in Dunning Letters. Example: when there is no email address or dunning recipient specified for a customer then the 'Send dunning letters' job pro…Harsha Valasani 14 views 1 comment 0 points Most recent by Jesús Vega-Oracle Receivables & Collections
-
Each line must have a unique combination of INTERFACE_LINE_CONTEXT and INTERFACE_LINE_ATTRIBUTE valuSummary: Hi team, I was trying to test one edge case, where I wanted to process already imported invoices. but few errored out with Duplicate invoice number which is exp…
-
How to track email delivery status for the emails (invoice, dunning) sent to customers?Summary: Oracle Fusion Accounts Receivable (AR) sends high volumes of customer emails daily, such as Invoices, Customer Statements, and Dunning Letters. However, there i…
-
Where the BI Template is defined for Invoice Print TemplateSummary: Where the BI Template is defined for Invoice Print Template Content (please ensure you mask any confidential information): We have made a minor change to our BI…
-
REST API to get sales Order line tax amountI am looking for Sales order tax amount for each line. In front end i am able to see tax amount for each line. but when I check it through API, I am getting only total t…
-
How to Add a Project Filter Parameter to the Print Receivables Transactions ESS JobHello everyone, I would like to add a new parameter called “Project” to the Print Receivables Transactions ESS Job in Oracle Fusion Cloud. Objective: The goal is to be a… -
How can I add distributions to the Print receivables seeded report after customizationHi Team, I’m facing an issue while adding the Distributions data as a separate data set in the Print Receivables Report. The problem is related to data grouping: When I …
-
Funds Capture Batch Acknowledgments FormatsSummary Unable to find the Format to customize or to review the structure of the file formatContent Hi, we are not able to find any format listed for "Inbound" formats u…
-
How to customize email body and subject and split it by invoice number/customer name?Summary:Hi team, We request some support in modifying the SJG Dunning letter (Reminder emails for unpaid invoices). The email notification to customers/clients only rece…Somnagho_in-Oracle 111 views 1 comment 0 points Most recent by Jesús Vega-Oracle Receivables & Collections
-
Run a BIP report and get the output via REST APISummary: We are trying to run a BIP Report via REST API, but getting 404 not found error. /services/rest/v1/reports/{reportPath}/run Content (please ensure you mask any …Abhilash G S 278 views 5 comments 1 point Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP -
Printing Count Field in RA_CUSTOMER_TRX_ALLSummary: Hi All, We are trying to use the Printing Count field in the RA_CUSTOMER_TRX_ALL table. The requirement is as follows: For the first three prints, the invoice s…
-
Customer registration number is not display in printed INVSummary: Customer registration number is not display in printed INV Content (please ensure you mask any confidential information): In the previous month, the "CUST_TAX_R…
-
How to Reset the BICC Extract To last run Date via APISummary: Hi Team, we have requirement to reset to the BICC extract to last run date based on any failures. Can some one please let me know if this is possible via any AP…
-
fbdi "CustomerImport" for adding sites to an existing customerWe need to use the FBDI to add some sites to an existing customer, how can we use the CustomerImport for that requirement?
-
How to suppress credit memo for print email but Invoices should be allowed?Summary: Content (please ensure you mask any confidential information): We need an ability where Credit memo should be suppressed/restricted for print email to the custo…
-
After 25A, customers whose profile is set to XML invoice delivery method are not searchableSince 25A, we can’t search for customers in the From/To Customer fields of custom ESS jobs, even though we use the same CustomerAccountVO and CustomerVVO LOVs as the see…
-
Create customer statements to fetch open and closed statementsSummary: Hi, The Create Customer Statements (ESS) job currently returns both open and closed statements. Is there a supported way to run it so that it outputs only open …
-
How increase limit of rows in otbi analysisSummary: How increase limit of rows in otbi analysis Content (required): Customer have some Analysis created and he want to know if there are some possibility to export …Adriana Martins 1.3K views 8 comments 1 point Most recent by SureshRamanujam Receivables & Collections
-
Hitting the standard template in the 'View Image' of AR Invoice transactions.Hi Team, The custom template for the Print Receivables Transactions job is defined, but when clicking View Image in Receivables, the report defaults to the standard temp…Nirosha Yelicherla 31 views 2 comments 0 points Most recent by Nirosha Yelicherla Receivables & Collections
-
how can i get last date when customer was printed in final mode for a customer in oracle fusionHow can I get the last date when statement was printed in final mode for a customer in oracle fusion. Is that value stored in any table or is there any API that can be u…
-
Print Receivables process for 'Paper' batch when there are no eligible transactions ends in ErrorSummary: As far as I know there isn't a way to change this but we are wondering if there is a way to update how Print Receivables works when the 'Paper' batch for Print …
-
Ability to store Email ID on Order and then use it for sending invoices to customerSummary: Content (please ensure you mask any confidential information): Need an ability to capture ordering email id for credit card customers and use that to send an em…
-
Can we duplicate "Create Customer Statements" ess jobSummary: Hi, Can someone please help me in undrestanding if we can duplicate Create Customer Statements ess job. If yes, how do i call other child ess jobs after duplica…Shireesha 2 views 1 comment 0 points Most recent by Jeffrey Beltran-Oracle Receivables & Collections
-
How to default Invoice Template on customer basis?Summary: Content (please ensure you mask any confidential information): We have a requirement where we want to have separate invoice template on the basis of Credit card…
-
Issue while creating AR Customer Profile using we serviceHi, I tried to create Ar customer profile using the ReceivablesCustomerprofileservice webservice It was working perfectly before with me using the same combination of pa…
-
we don't have access to OTBI report subject areaSummary: We don't have access to otbi report subject role with custom role, we unable find the exact privilege was missing. kindly help us on this. Thank you.
-
Request to Exclude Zero-Amount Records from Standard Customer Statement ReportHi Team, We have requirement in the standard customer statement report output and require a solution or workaround to exclude zero-amount records from the report. For re…Raman_Balasubramaniam 40 views 3 comments 0 points Most recent by User_VQFGM Receivables & Collections
-
How to fetch Customer VAT number on Sales invoice reportSummary: Could someone please help which column, table stores Customer VAT number to add in the report. I have checked in the ZX_PARTY_TAX_PROFILE table for column rep_r…