Customer
Discussion List
-
Can ayone share SQL scripts to retrieve the data from Fusion for the19 tabs in the Customer FBDISummary: We have a requirement to create and update customer data using the FBDI template, Like Customer Emails and Contact points etc. If anyone has the SQL scripts for…Baskara Sateesh-Oracle 13 views 1 comment 0 points Most recent by Jesús Vega-Oracle Receivables & Collections -
how to update profile history at account and site level using FDBII have tried plenty of time to update profile history at account and site level but its throwing out error. Can someone help me with what all sheet and field we need to …
-
Email being sent to customer when address is incorrectSummary: We're experiencing some issues with email addresses when it comes to customers. When "Print Receivables Transactions" is ran, for some reason there are some ema…coral.gallego 63 views 8 comments 0 points Most recent by Andreea Laura Panait-Oracle Receivables & Collections
-
Assigning collectors to customers on basis of locationsSummary: Hi all, Currently, Oracle seeded functionality for the Collections module only allows collector assignment at the Business Unit (BU) level. There does not appea…
-
Customer Email Address for Manually Created Contact Point is not updating through FBDI.Hello, Trying to update customer contact point email addresses using the FBDI template with the two sheets "HZ_IMP_PARTIES_T" and "HZ_IMP_CONTACTPTS_T". After loading an…
-
Privileges for FSCM REST Services customerAccountSitesLOV and receiptMethodAssignmentsSummary: Hi all, We require the lowest level privileges for following FSCM REST Services: fscmRestApi/resources/11.13.18.05/customerAccountSitesLOV fscmRestApi/resources…Mike Pee 24 views 2 comments 0 points Most recent by Marius Neagu - Oracle Support-Oracle Receivables & Collections
-
How to derive Party Source system & Account Source Reference values for the existing customersSummary: How to derive Party Source system & Account Source system Reference values for the existing customers, i want the sample sql query we have a 2500 Customers for …
-
Need to Display Only Receipt/Transaction Number (Without Labels) in AR Statement ReportHi all, We have a requirement to customize the Generate Statement Report and display only the Receipt or Transaction number in Reference field (AR_STATEMENT_LINE_CLUSTER…
-
is there any REST Api to udpate Customer Account Site DFF?Need to update DFF segments on Customer Account Site DFF in oracle fusion using REST API.
-
Customer bill to site – cannot add new reference account due to missing BUI created new business organization I’m trying to add reference account to customer bill to site (Account Address Set value is ENTERPRISE) But the new BU is not at the L… -
Need to add a value to the Account Status dropdownSummary: We need to add a value to the Account Status dropdown, as Bankrupt, under the Profile Class at the Account Level of an customer. Which lookup code/task allows u…
-
Do we have any process to know the Inactive customers list in receivables Oracle fusion?We have a requirement to get the list of Active and Inactive Customers in Receivables. I have tried to search in advance search add fields In manage customers but don't … -
Unable to create a text field in customer account DFF that allows 1000 characters.We are trying to create a DFF at customer Account level and our requirement is to create a text field that allows 1000 characters whereas data type chracter system is no…
-
REST API to GET Customer Account level information with Attribute "Account termination Date"Hello, We have a custom VBCS UI where we need to restrict Active Customer Accounts only and exclude where customers where "Account Termination Date" is populated. We nee…
-
Org Level Contact - Person RelationshipSummary: Trying to Create a Org Contact in fusion (A Person with contact to be created and linked to a Organization) Content (please ensure you mask any confidential inf… -
How to remove other primary address in customer data management?Summary: We have a customer record with 3 addresses marked as primary. We are unable to set the actual primary address as the primary address due to this. Is there a way…mary.claire.s.recio 7 views 0 comments 0 points Started by mary.claire.s.recio Receivables & Collections
-
How to delete customer contacts at the tables which is not seen in the UISummary: For one of our customer, invoices are sent to email id's that are not in the distribution list as per customer account or site level contacts. We found that Ora…
-
How to update the customer site level DFF details in bulk oracle fusionHi, We want to update the customer site level DFF details for multiple customers, we want to know how we can achieve it. Is there any FBDI or from customer creation spre… -
Customer contact and email id upload/update option is available or notSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
how to specify contact prefix in customer FBDISummary: Hi Team We are uploading customer using 19 pages Oracle Fusion Trading Community Model Data Import program since we want to specify customer fax phone number. B… -
Not able to import customer profile sitesSummary Not able to import customer profile sitesContent Team, We have followed this note (How Can Customer Account Level Profiles be Imported, After Customer Account Re…Surya01 751 views 16 comments 2 points Most recent by Guggilam Vinay Kumar Receivables & Collections -
Ship-to Site Number field is missing in the Receivables Transactions Real Time subject area for OTBISummary: I need to add *Ship-To Site Number field and I don't see it available under Receivables Transactions Real Time subject area. Please suggest if it's available in…Rahul Kumar Gupta.-Oracle 34 views 4 comments 0 points Most recent by Matt Lennon - Terillium Receivables & Collections -
Updated customer account attributes not found in systemSummary: Hi Team, I've updated attribute8 in customer account additional information for around 350 customers with FBDI file. The customer data import was successfully c…
-
enter a combination of the CUST_SITEUSE_ORIG_SYSTEM and CUST_SITEUSE_ORIG_SYS_REFSummary: I am geting this error when i am trying to import both BILL to and Ship to for the same ID Content (please ensure you mask any confidential information): Why do…Ritika Mishra 13 views 1 comment 0 points Most recent by Jesús Vega-Oracle Receivables & Collections
-
Bill to address in credit memoI created a credit memo from an invoice, and when I click complete, this error appears: a bill_to_address_id cannot be null in a complete invoice because a billing addre…ACNROMA2023 5 views 1 comment 0 points Most recent by Mahesh Adivishnu-Oracle Receivables & Collections
-
customer import using FBDI as an integrationSummary: We have a requirement to create customers of type ORGANIZATION using FBDI template. I understand that we need to have batch created everytime and batch id has t…Pradeep Kumar Sundararajan 11 views 1 comment 0 points Most recent by Pradeep Kumar Sundararajan Receivables & Collections
-
How to create Customer Site Profile using SOAP and assign Collector?I’m trying to create a Customer Site Profile in Oracle Fusion using SOAP services. I need to assign the Profile Class as "DEFAULT" and set the Collector as "Default Coll…
-
Unable to Edit the Reciprocal Flag in Customer Account RelationshipsHello, We created a relationship between two customer accounts with the reciprocal flag left unchecked. Now we would like to update this relationship to enable the recip…Chinni Susruth 3 views 1 comment 0 points Most recent by Jesús Vega-Oracle Receivables & Collections
-
Customer site assign to different BU set with same site detailsSummary: Customer account site needs to assign different BU set with same site number and address including profile class and contact details Content (please ensure you …
-
How to Nullify PAYMENT_TRXN_EXTENSION_ID for Inactive Debit AuthorizationsSummary: How to Nullify PAYMENT_TRXN_EXTENSION_ID for Inactive Debit Authorizations → In the RA_CUSTOMER_TRX_ALL table, there are transactions associated with an inactiv…Sachi Jain-Oracle 36 views 2 comments 0 points Most recent by Mohit Baid-Oracle Receivables & Collections