oracle receivables

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…

AR Receipt Query: AR XLA GL

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, glcc.segment7 proj, ” “CODECOMBO desc”, xal.accounting_date, gjh.je_source, gjh.je_category CATEGORY, gjb.NAME batch, gjh.NAME “JOURNAL name”, ” “JE SEQ…

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