BI Publisher
Discussion List
-
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 11 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 1 view 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 13 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
-
Query for recepit method in AR transactionI want to display trx_number and the receipt method used in this transaction. Someone knows the query?ACNROMA2023 25 views 3 comments 0 points Most recent by Raghuram Saradka-Oracle Receivables & Collections
-
We need a query to retrieve the AR remittance batch approver's name and approval dateHi, We have arequirement to retrieve the approver name and approval date for a remittancebatch. Could you please confirm if there’s an existing table, column, or queryth…
-
During the Merge process, where the impacted Transactions are getting stored?Hi, We have an option to merge one customer (ABC) with another (XYZ). After the Customer Merge Process, the Merged customer (XYZ) is reflected in the already created tra…
-
Send Dunning Letters log says contact information is missing for customer, we require SQL queries.Summary: Send Dunning Letters log says contact information is missing for customer; we require SQL queries to create custom report to add these error detail of the custo…
-
How to get the bank account assigned to a party siteSummary: We need to list all bank accounts being used by sa party site. Bank accounts that we can see when we navigate to Manage Suppliers page Content (required): We ar…