Category 338-2
Discussion List
-
AR to GL Reconciliation Report: Unable to extract/ Drill down the difference amountSummary: Unable to extract/ Drill down the difference amount of unapplied receipts in AR to GL reconciliation report. Note: I'm able to see Hyper link is available to ex… -
SQL query to extract Customer data in 'CustomerImportTemplate' FBDI formatSummary: Hi Team, I am looking for an SQL query to extract customer data in 'CustomerImportTemplate' FBDI format, if anyone has it, could you please share it? Content (p…PraveenSarikonda 853 views 2 comments 1 point Most recent by PraveenSarikonda Receivables & Collections
-
SLA Rule for Credit Memos based on Accounting date of Invoice being CreditedSummary: Looking to override Receivables accounting on a CM relating to an Inv accounted in a prior Financial Year Content (required): We have a requirement to override …Chris Alexander 167 views 2 comments 1 point Most recent by Chris Alexander Receivables & Collections
-
Not able to find existing bank accounts in Customer SiteSummary: Business not able to find any of the existing bank accounts under payment Instrument tab for Customer site (Manage Customers). Content (please ensure you mask a…reshma.a 300 views 5 comments 0 points Most recent by Andreea Laura Panait-Oracle Receivables & Collections
-
Customer load 19 sheet FBDI IssuesSummary: 1) After loading new customer using 19 sheet FBDI , load is completed but while navigating to Account - Profile History, screen gets frozen and not able to do a…Mayank_Agrawal 230 views 10 comments 0 points Most recent by Mayank_Agrawal Receivables & Collections
-
Cross reference field on AR invoice FBDISummary: Hello, We are using fbdi for uploading AR invoices. We need to populate cross reference field on the AR invoice header. But this field is not available. Pls let…Vaibhav Kumar 346 views 1 comment 0 points Most recent by Phil DeCoster - Support-Oracle Receivables & Collections
-
Memo Line by Customer WiseDo we have option to restrict memo lines by customer wiseSandeep Nihalani 17 views 4 comments 0 points Most recent by Sandeep Nihalani Receivables & Collections
-
Can we use DFF as filter in 'findCustomerAccount' operation of 'CustomerAccountSerivce' webserviceHi, We have a requirement to filter the CustomerAccount and contacts information only by using a DFF (configured at Account Contacts level).We are passing CustomerAccoun…
-
Revenue Contingency on Payment not working for Late Charge InvoiceHello, Our requirement is to have revenue contingency for AR late charge invoices...that means unless customer pays the amount for late charge invoices..it will be on un…
-
What SetId value should be set in create customer account SOAP interface?Summary: I'm trying to create a customer via REST & SOAP APIs in Oracle Cloud ERP (referring to A Simple Guide to ERP Cloud Customer Creation through integration). And I…
-
Customer statement for multi yearsClient has a requirement to generate multiple year statements for all open and close transactions. Is it possible to achieve through "Customer Statements" and "Statement…Gayatri Sharma 46 views 1 comment 0 points Most recent by Andreea Laura Panait-Oracle Receivables & Collections
-
How does auto accounting works in ReceivablesWe have autoaccounting setup for revenue account to source from standard line however on the transaction, there is no inventory item but there is a standard memo line. T…Deepansh Malik 17 views 1 comment 0 points Most recent by Andreea Laura Panait-Oracle Receivables & Collections
-
How to Define Parameter Based DFF segments in Receivables AR Invoice?We have a DFF in AR Receivables Lines screen and want to fetch one of the DFF field LOV based on the value of another Receivable standard field value. So need to know "H…Birendra Kamal 16 views 1 comment 0 points Most recent by Richa Priya-Oracle Receivables & Collections
-
Derive revenue recognition accounting date based on DFF valueSummary: Derive revenue recognition accounting date based on DFF value Content (please ensure you mask any confidential information): We import invoice from 3rd party sy…
-
Credit checking based Past Due Invoices.Summary: Suppose customer has credit limit of $50000 and open Invoice amount as on date is $20k but customer is not paying the invoices. Is there any way to put new orde…
-
Need to create Chargebacks with manual numberingWe have Open chargebacks in legacy system which are synced with High Radius as outbound for reconciliation, cash applications, collections etc. Our aim is to bring the o… -
Can I net transactions across Legal EntitySummary: Is it possible to create netting across Legal Entity? Content (please ensure you mask any confidential information): Hi Experts. Is it possible to create nettin…
-
How to update ORIG_SYSTEM_REFERENCE filed of HZ_CUST_ACCT_SITES_ALLSummary: customer site was interfaced with wrong ORIG_SYSTEM_REFERENCE value to EPR fusion from an external system. Now we encountered error when tried to interface cust…Mohamed Iqbal Jahangeer 131 views 8 comments 0 points Most recent by Mohamed Iqbal Jahangeer Receivables & Collections
-
Update Site level customer profile via FBDISummary: Update Site level customer profile via FBDI Content (required): Hi, I am updating site level customer profile via FBDI. And I have download the CustomerImportTe…Yuejie Yan-Oracle 882 views 3 comments 0 points Most recent by KaranRaj-Oracle Receivables & Collections -
Can we use the Document number as receipt number?Summary: Customer is asking if we can use the document number in create receipt as Receipt number since customer is requiring automatic document sequencing cause current…
-
Receivables Aging by General Ledger Account ReportSummary: We are developing a custom report to show us aging 13 buckets we are not able to reconcile it with the standard we are facing issues with credit memo refund pro…Shadaab Ahmed 27 views 1 comment 0 points Most recent by Veronica Stefan-Oracle Receivables & Collections
-
DFF created in Flexfield Code- RA_CUSTOMER_TRX not available in OTBISummary: Hi, We set up a Descriptive Flexfield (DFF) under Miscellaneous tab within the "RA_CUSTOMER_TRX" at the Create Transaction Page in the Accounts Receivable Modul…
-
How to correct address for Customer in Oracle fusionSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Bhargav Aritakula 59 views 4 comments 1 point Most recent by Sairam Surampalli-Support-Oracle Receivables & Collections
-
Update Receipt Application Applied Amount via SOAP or RESTSummary: Content (please ensure you mask any confidential information): Need to update the transaction application applied amount on a receipt via REST or SOAP. Can anyo…Rory Mullin 59 views 2 comments 0 points Most recent by Sairam Surampalli-Support-Oracle Receivables & Collections
-
Job role or privileges for receivables customer creationSummary: We are migrating AR customer from legacy system and we are try to build an integration which will trigger the customer creation process automatically. Please le…Subhasish-OC 108 views 3 comments 0 points Most recent by Sairam Surampalli-Support-Oracle Receivables & Collections
-
Restrict Expiration Year Dropdown List to 10 Years on Create Customer Credit Card ScreenSummary: The Expiration Year dropdown list on the Create Credit Card for customer account is displaying 20 years. Is there a way to restrict this list to 10 years. Versi…
-
Another user has changed the row with primary key oracle.jbo.Key[222 TRANSACTIONS CREDIT_MEMO 126969Summary: Is it possible to delete transaction lines on imported (and not accounted, not printed) transactions (autoinvoice)? Content (required): After importing transact…
-
How to setup netting settlement sequence to gapless?Summary: After setup for netting, netting settlement can be created but the settlement number are generated with big gap. Would like to know if we can change it to gaple…
-
Bringing exact tax amount in AR Invoice through Auto Invoice FBDI using memo lineSummary: I would like to bring exact tax amount in AR Invoice, reason no rounding & different tax rates from legacy ERP to Oracle Cloud ERP using Memo Line trough AutoIn…Mayank_Agrawal 106 views 5 comments 0 points Most recent by Daniel S.-Oracle Receivables & Collections
-
Unable to add New contacts using the Simplified Customer TemplateHi, I am Unable to add New contacts using the Simplified Customer Template, everytime it is giving the same error as below "An account site with this combination of cust…