BI Publisher
Discussion List
-
Installments Associated with Collection Documents Listing Report for Brazil not worksSummary: There is a Report available in the Scheduled Process: "Installments Associated with Collection Documents Listing Report for Brazil" I tried to run in many diffe… -
AR print commercial documents burstingSummary: There is a bursting query in print commercial documents process. We have understood that emails can't be send through this process, wanted to check if FTP or an… -
Show original transaction's Remit To address on Credit MemoSummary: We'd like to have the Remit To address shown of the original transaction on all credit memos. We have one single remit-to address for each country set up, but i… -
Unapplying Credit Memo does not update AR_RECEIVABLE_APPLICATIONS_ALL.applied_customer_trx_idSummary: We tried deleting a credit memo through Manage Credit Memo Application so we are expecting that the ar_receivable_application_all. applied_customer_trx_id will …
-
Is it possible to create a customer index on Oracle Cloud ERP seeded tables?Summary: We are currently using a BIP report to extract recently created transactions from ra_customer_trx_lines_all, relying on the last_updated_date field. The report …Pradeep Moganti 11 views 1 comment 0 points Most recent by Daniel S.-Oracle Reporting and Analytics for ERP
-
Running Create Customer Statements (Statement Generation Report) Outside of UISummary: Is it possible to pass the parameters for the scheduled process "Create Customer Statement" to Fusion without doing so via the UI? We currently utilize OIC (Ora…
-
Ship-to ID's Not Populating In RA_CUSTOMER_TRX_ALL TableHi All, I can see RA_CUSTOMER_TRX_ALL table has all SHIP_TO Columns populated with NULL values. Have used SHIP_TO_PARTY_ID's to get SHIP TO information as per the oracle…
-
Transfer Customer Payment on Bill Management Portal to BankSummary: We are looking to transfer Customer Payment (Bank Method) on the Bill Management Portal to the Bank. Does anyone have any such integration experience with Wells…Suprit 12 views 1 comment 0 points Most recent by Andreea Laura Panait-Oracle Receivables & Collections
-
Do we have a delivered NACHA Format template for Fund Disbursement in Customer Payment?Summary: I am looking for a NACHA Format template for Fund Capture that can be used as a reference for customization. I am only able to see the NACHA Format available fo…Suprit 2 views 1 comment 0 points Most recent by Andreea Laura Panait-Oracle Receivables & Collections
-
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 1 view 1 comment 0 points Most recent by Vitalie Rusanovschi-Oracle Receivables & Collections
-
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 …
-
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…
-
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…
-
Can we develop a BI report for sending AR invoices via email to customers?Summary: Can we develop a BI report for sending AR invoices via email to customers? Since we need to send invoices to our customers after running a custom BI report. Or …
-
sample query to check Invoice/Credit Memo has been posted to GL?Hi Team, Need sample sql query to check Invoice/Credit Memo has been posted to GL or not in oracle cloud.
-
Need a package "ar_arxagmw_xmlp_pkg" logicSummary: There is mismatch found in the custom and seeded report (Receivables Aging by General Ledger Account Report) in the amount remaining balances. We would like to …
-
Is there a table where we could query/retrieve the match configuration rule attributes for CDM?Summary: We've a requirement to create a report showing the match rule and the rule attributes. We can use ZCH_MERGE_DETAILS_B to get the match rule name for merged reco…
-
Collections Dashboard - Expected Amount and Expected Data table detailsSummary: Need to know the source table that holds the below marked fields - Expected Collection Amount and Expected Collection Date. Able to get the Unpaid Reason from t…
-
Create Settlement Batch is not generating any fileSummary: I tried to create a transaction and ran the Create Receipt Remittance batch and after that run Create Settlement Batch, But after the Create Settlement Batch pr…
-
Changing Oracle out-of-the-box data model of invoice print templateSummary: We have a requirement in the invoice print template to group and print the Bundle Name for lines with a bundle and just the product name for lines that are not …
-
ar invoice dff freezed after invoice completionSummary: Hi Team, we have a requirement to update the Invoice line DFF after the receipt is created for that invoice and status needs to be updated based on the Json fil…Aru Chauhan 11 views 1 comment 0 points Most recent by Mallik Durgumpudi-Oracle Receivables & Collections
-
How can we disable Scheduled Process module under tools from user's account?Summary: We need to disable Scheduled Process module under tools from user's account, so that they can't run jobs manually. Content (please ensure you mask any confident…
-
How to see Rest api results? Which privilege I need?I have a custom page that shows customers data, but I think I need a privilege to access on Rest api service, because with standard AR roles I can't see nothing. someone…
-
Transaction Awaiting Consolidation ReportSummary: We had this report is EBS R12 and it will shows all the AR transactions including Credit Memo, Debit Memo and Chargeback. Shall we have the same kind of report …
-
what are the PVO's available for Legal Entity which can be used in Finance Module ESS JobHi, Could you please provide a list of PVO which can be used for Legal Entity in Finance Module ESS Job. Thanks, LakshmiLakshmiSahithi 1 view 1 comment 0 points Most recent by Mahesh Adivishnu-Oracle Receivables & Collections
-
Need to add new parameter to Seeded ESS Job "Print Receivables Transactions"Hi Team, We have a requirement to add new parameter (Intercompany Invoice Template) for seeded ESS job Print Receivables Transactions. there is already template paramete…LakshmiSahithi 22 views 1 comment 2 points Most recent by Sairam Surampalli-Support-Oracle Receivables & Collections
-
Certain fields from table HZ_PERSON_PROFILES are not visible in AR Customer MasterHi, Certain fields like Gender, Date of Birth, Date of Death, and Initials from HZ_PERSON_PROFILE are present in the backend HZ_PARTIES table but are currently unavailab…Rimoni Shah-Oracle 22 views 2 comments 0 points Most recent by Rimoni Shah-Oracle Receivables & Collections
-
NullPointerException in send dunning lettersHi Team, We have customized bursting query in seeded dunning report and getting 'exception in vectorjava.lang.NullPointerException' in Send Dunning Letters process. We a…Santhosh Kumar J 1 view 1 comment 0 points Most recent by Gopal Reddy-Oracle Receivables & Collections