oracle receivables

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 Lockbox…

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’ Insert_Update_Indicator, hcar.ORIG_SYSTEM_REFERENCE Contact_Role_Orig_Sys_Ref, hoc.ORIG_SYSTEM_REFERENCE||’-‘||’REL’ Rel_Src_Sys_Ref, hcar.role_type, NULL Role_Level, NULL Primary_Role, NULL…

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_REFERENCE||’-DUN’,’COLLECTIONS’,cont_point. ORIG_SYSTEM_REFERENCE||’-COLL’,’BUSINESS’,cont_point.ORIG_SYSTEM_REFERENCE||’-BUSS’,cont_point.ORIG_SYSTEM_REFERENCE) Cnct_Point_Orig_Sys_Ref, hpsub.ORIG_SYSTEM_REFERENCE Party_Orig_Sys_Ref, hpobj.ORIG_SYSTEM_REFERENCE Party_Site_Orig_Sys_Ref, cont_point.Primary_flag, ‘I’ Insert_Update_Indicator, cont_point.contact_point_type, cont_point.contact_point_purpose, DECODE(cont_point.email_address,’x’,NULL,cont_point.email_address)email_address, cont_point.email_format, cont_point.phone_area_code, cont_point.phone_country_code, cont_point.phone_extension, cont_point.phone_line_type,…

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 Yes. Cause: RA_INTERFACE_DISTRIBUTIONS_ALL tab should…

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 across a client requirement to upload…

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 WHERE A.BILL_TO_CUSTOMER_ID=B1.CUST_ACCOUNT_ID)ACCOUNT_NUMBER, (SELECT E.PARTY_SITE_NUMBER FROM apps.hz_cust_acct_sites_all C, apps.hz_cust_site_uses_all D, apps.hz_party_sites E,…

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, ISTT.STRATEGY_NAME, (SELECT ISWI.STATUS_CODE FROM IEX_STRATEGY_WORK_ITEMS ISWI WHERE ISWI.STATUS_CODE IN(‘OPEN’,’PRE-WAIT’) AND ISWI.STRATEGY_ID=IST.STRATEGY_ID…

AR Adjustments Query: AR XLA GL

SELECT glcc.segment1 company, glcc.segment2 LOCATION, glcc.segment3 cost_center, glcc.segment4 ACCOUNT, glcc.segment5 product_line, glcc.segment6 channel, glcc.segment7 project, (SELECT flex_value || ‘ ‘ || fvt.description FROM apps.gl_code_combinations glc, apps.fnd_flex_values fv, apps.fnd_flex_values_tl fvt WHERE…

AR Transactions Query: AR XLA GL

SELECT glcc.segment1 company, glcc.segment2 LOCATION, glcc.segment3 cost_center, glcc.segment4 ACCOUNT, glcc.segment5 product, glcc.segment6 channel, glcc.segment7 project, (SELECT flex_value || ‘ ‘ || fvt.description FROM apps.gl_code_combinations glc, apps.fnd_flex_values fv, apps.fnd_flex_values_tl fvt WHERE…

We take you from best practices to next practices of software implementation

Solutions that Ensure You Stay Ahead of Competition

Your Partner for Strategic Technology Solutions

Guiding Your Digital Transformation Journey