BI Publisher
Discussion List
-
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 21 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 2 views 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 21 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…
-
Receivables Aging by General Ledger Account Report - seeded Datamodel not workingSummary: I have been able to customize the Receivables Aging by General Ledger Account Report to be more usefull, by using the seeded datamodel and creating a new report…Anders W. Langholm 21 views 7 comments 0 points Most recent by Tyrion Lannister Receivables & Collections -
Support Incremental is not enabling for BICC extractSummary: Hi Team, we are using application composer custom objects and looks like supports incremental is not getting enabled to this like it happen for seeded ones. Can…PrasadN 42 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
How to use if statement for comparing dates in BIP templateSummary: How to use if statement for comparing dates in BIP template Content (please ensure you mask any confidential information): I have customised the Customer Statem…Chez 1 view 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
Is there any predefined report showing customer wise trial balance ReportSummary: user requires Customer wise trial balance as well as Receivable balances customer wise. Do we have any predefined report? Content (please ensure you mask any co…Jeetesh Singh 23 views 1 comment 0 points Most recent by Sairam Surampalli-Support-Oracle Receivables & Collections
-
Edit Print Receivables Transactions ESS Job parameterSummary: Edit Print Receivables Transactions ESS Job parameter Content (required): I would like to be able to edit the Default 'Invoice Template Name' in the 'Print Rece…
-
How INTERFACE_HEADER_ATTRIBUTE2 to INTERFACE_HEADER_ATTRIBUTE6 RA_CUSTOMER_TRX_ALL from SubscriptionSummary: Need help in understanding how DFF Fields INTERFACE_HEADER_ATTRIBUTE2 to INTERFACE_HEADER_ATTRIBUTE6 in RA_CUSTOMER_TRX_ALL Table populated for transactions hav…
-
How can we get attachment to a BI report to be send through e-mail?Summary: Send attachment which is on invoice as part of email with the BI report over email through schedule Report Content (please ensure you mask any confidential info…
-
Program "Print Receivables Transactions" is completing with errorWe have a requirement to deliver the consolidated output to customer if he has multiple invoices which are eligible to print. We have changed the bursting key to achieve…ramesh.daniyala.mcd 79 views 2 comments 0 points Most recent by ramesh.daniyala.mcd Receivables & Collections
-
Print receivables program does not pick specific credit memo template?Summary: We have multiple Credit memo templates specific to each BU, the Print receivables program does not pick specific credit memo template. eg. Germany has a custom …
-
Does it mandatory to configure the mail server for dunning letter?Hi All, Does it mandatory to configure the mail server for dunning letter? Can we not use the oracle.com server, It works for invoice print and customers statement. Than…Gotham 1 view 1 comment 0 points Most recent by Sairam Surampalli-Support-Oracle Receivables & Collections
-
How to add Cust Account and Cust Site Info to 'Receivables Aging by General Ledger Account Report.Summary: How to add Cust Account and Cust Site Info to 'Receivables Aging by General Ledger Account Report. Content (required): Problem Description ---------------------…