Category 338
Discussion List
-
How to get AR billing transaction note plain text without html tag ?Hi All, I'd like to build a customer report about AR billing which contains note. While I found the note in backend table contains html tags. Note in the UI: SQL result… -
How to find the "Site Purpose Source Reference" of customers created manually from AR?Summary: When trying to do a mass update of customers, the simplified template, in the CUSTOMERS sheet, has a mandatory field called "Site Purpose Source Reference" whic…
-
Why is the SLA Source 'Warehouse Name' not working for the Event Class = Receivable?Need your help to derive the cost center from Mapping Set for the receivables class. We have common receivables transaction type and that is being used multiple inventor…Balram Katre-Oracle 1 view 0 comments 0 points Started by Balram Katre-Oracle Receivables & Collections -
Unable to update Customer Profile AttributeHello, We are getting error when attempting to make updates at the customer profile level. Context: We have three DFF that need to be updated : Actually only one DFF all…
-
Revenue adjustment shcedule / unshedule Revenue went greyedDear all i went into revenue adjustment and i found both Shedule and Unshedule Revenue are greyed any idea why ? and how i can enable them again Regards -
Need word document for grouping rule for a single customerSummary: In Receivable and Collections, For auto invoice need word document for grouping rule only for one customer Content (please ensure you mask any confidential info…Shiva Kumar Bandaru 41 views 3 comments 0 points Most recent by User_R3OR3 Receivables & Collections
-
Import Autoinvoice Invoices with total amount tax calculated in third party systemSummary: Hi All, Regarding importing transactions from third party system, I managed to import tax amount from source, by matching tax with line using reference field (f…Emel Serpegean-Oracle 3 views 0 comments 0 points Started by Emel Serpegean-Oracle Receivables & Collections
-
You must enter a combination of the {COLUMN1} and {COLUMN2} columns that's unique in the {TABLE_NAMESummary: loading customers and getting the above error The combination of columns {COLUMN1} and {COLUMN2} must be unique in table {TABLE_NAME}. Not sure what to correct …
-
Rest API or Soap Service to get Attribute4 value from HZ_CUST_ACCT_SITES_ALL tableSummary: Requirement is to get Attribute4 value from HZ_CUST_ACCT_SITES_ALL table using a Rest API or a SOAP Service Content (please ensure you mask any confidential inf…
-
How to create standard receipts in spreadsheet?Summary: We have reviewed the spreadsheet file but couldn’t find a column to apply the receipt to the invoice number. Therefore, we would like to know how to perform thi…
-
Write a BI Publisher SQL query to list all customers where 'Send Statement' is not checked,Summary: i Found out we cannot write this query in the BI Publisher and it can be done in the OTBI only if yes what is the reason and if possible please help us to fix t…
-
How to stop creating the bank account while importing lockbox file to Oracle?While importing the lockbox, the system is creating a new bank account for every payment by associating an MICR to the customer account. Is there a configuration availab…
-
Retrieve all positive and negative balance associated with a customer.Hi Team, We have a requirement to generate a list of all customers whose accounts have either a positive or negative balance. Could you please provide a detailed explana…
-
Need to customize receipt write off approval through BPM workflowSummary: We have the following business requirements related to the Receipt Write Off process: Notification on Insufficient Limit: The system should notify the user when…
-
FBDI AR:- Data Imported in Interface Table but Not Getting Picked During Import AutoInvoiceHi Team, We are loading AR invoices using FBDI in Oracle Fusion. The data is getting successfully imported into the interface table (RA_INTERFACE_LINES_ALL), but while r…sailesh_cloudare 19 views 1 comment 0 points Most recent by Sairam Surampalli-Support-Oracle Receivables & Collections -
How can we find Customer Details from VAT ID in Oracle ERPSummary: How can we find Customer Details from VAT ID in Oracle ERP Content (please ensure you mask any confidential information): Version (include the version you are u…
-
How do automatically add invoice lines when order and invoice amount is less than a threshold?How do automatically add invoice lines when order and invoice amount is less than a threshold? -
Receivables accounting rules depending on tax point basisOur client has 3 divisions which are conveyed by their first segment on the accounting key. The division is a BSV. They have three following divisions: DC250: for contra…Mariam Lefranc 23 views 4 comments 0 points Most recent by Daniela Petria-Oracle Subledger Accounting & Accounting Hub -
How to set up Receivables Payment Term with Cut off Date?Summary: Receivables Payment Term with Cut off Date Content (required): For Exp: "Term Logic= If Invoiced upto 26th of the month, due date is 25/24th etc(as required) of…
-
Automatic Receipts - Create receipts in one currency from transactions in another currencySummary: Hello, We have a requirement at our customer to create automatic receipts in EUR currency when transactions (debit memo in our case) are in foreign currency (XP… -
Automatic receipt generation for Cross-currency TransactionsCross-Currency Automatic Receipt Generation. Example : Transaction in Functional Currency. But received payment in multicurrency(other than Functional Currency) from Cus…Shivaprasad Vinukonda 12 views 3 comments 0 points Most recent by Valentin Zorelle Receivables & Collections
-
Cannot see the full list of AR approvalIf the bad debt adjustment is over approver A's approval limit, Approver A cannot see the pending approval in the transaction listing. How can all the approval item be s…
-
Collection Metrics Dashboard for all the customersHi Team, In 25B Oracle released the solution to access to collection metrics with operative roles, instead of AIC role. We would like to know if there is a way to see th…
-
Credit Card Customer Payments Failing in Bill Management Portal.Summary: We have tried make a credit card Payment from the Oracle Bill Management Portal using CyberSource gateway. We are getting below error message The payment system…
-
How to prevent the automatic application of credit memos created in Contracts to AR TransactionsSummary: Credit Memo created in Contract are applied to AR transactions automatically even when the Transaction is fully receipt. We would like to stop this auto applica…
-
AR Receipt acounting ->How to seperate discount applied transaction amount and tax amountHi Team, In the receipt print screen ->’Discount amount’ is applied transaction total including tax amount. So when looked at receipt accounting entries, there is only o…
-
Is it possible to based invoice due date on actual delivery date?Summary: Invoice due date should be based on delivery date instead of invoice date or shipping date. Content (please ensure you mask any confidential information): We st…Francisco Robinson-Oracle 3 views 0 comments 0 points Started by Francisco Robinson-Oracle Receivables & Collections -
Is it possible to include all dunning contacts in one dunning emailSummary: I believe for Print Receivables it is possible to have the invoice TO emails all included in the one email to all the contacts. I would like to know if this is …
-
clarification of setup steps for AR e-invoicingSummary: How to make the right setups for AR e-invoicing to Business Partners through a local Service Provider which is not seeded? Do I need to set up CMK, B2B Adapter …
-
Print Receivable Job Error ExceptionGET_REQUEST_DATAORA-20303: property executionTerritory not foundHi, We are continuously getting the Print Receivable Job Error for "Exception in GET_REQUEST_DATA forORA-20303: property executionTerritory not found for request" and in…Koteshwar Tippani 635 views 13 comments 0 points Most recent by saurabh.dixit Receivables & Collections