Blog / Category
oracle receivables
11 articles in this category
Creating and Applying Receipts Through Lockbox Using FBDI
Step 1 – Create a Lockbox Navigate to Settings and Actions > Setup and Maintenance > Manage Lockbox, and define a new lockbox record. Step 2 – Confirm the Lockb…
Script to find the customer contact roles
Introduction This script will used to identify the customer contact roles SELECT DISTINCT Batch_Identifier, NULL interface_row_id, NULL import_status_code, ‘I’…
Script to find the customer contact points
Introduction This script will used to find the customer contact points. SELECT DECODE(cont_point.contact_point_purpose,’DUNNING’,cont_point.ORIG_SYSTEM_REFERENC…
AR: Use Invoice Accounting for Credit Memos profile option is set to Yes
Introduction: You can’t provide an account assignment for credit memo transactions when the AR: Use Invoice Accounting for Credit Memos profile option is set to…
AR Invoice Image Upload Using SOAP Request – Oracle Fusion
This blog contains sample payload to upload an image file in AR invoice attachments in Oracle Fusion Applications. During fusion implementation, we might come a…
AR Non Printed invoices report
Introduction: This report will display all the Non printed invoices details to business. select (SELECT B1.ACCOUNT_NUMBER FROM apps.hz_cust_accounts_all B1 WHER…
Query to get the OAC fields for the customers
Introduction: This query is about to get the advance collections related columns for the customers. SELECT HCA.CUST_ACCOUNT_ID, IST.STATUS_CODE STRATEGY_STATUS,…
AR Adjustments Query: AR XLA GL
SELECT glcc.segment1 company, glcc.segment2 LOCATION, glcc.segment3 cost_center, glcc.segment4 ACCOUNT, &nb…
AR Transactions Query: AR XLA GL
SELECT glcc.segment1 company, glcc.segment2 LOCATION, glcc.segment3 cost_center, glcc.segment4 ACCOUNT, &nb…
AR Receipt Query: AR XLA GL
SELECT glcc.segment1 company, glcc.segment2 LOCATION, glcc.segment3 cost_center, glcc.segment4 ACCOUNT, &nb…
AR Receipt Distribution Query: AR XLA GL
SELECT glcc.segment1 co, glcc.segment2 loc, glcc.segment3 cc, glcc.segment4 acct, glcc.segment5 prod, glcc.segment6 chan,&nb…