Introduction: This API will create Item categories in EBS. SET SERVEROUTPUT ON; DECLARE v_return_status VARCHAR2(1) := NULL; v_msg_count NUMBER := 0; v_msg_data VARCHAR2(2000); v_errorcode VARCHAR2(1000); …
Read MoreIntroduction: This script will extract the AP open invoices select aia.invoice_num, aia.invoice_currency_code, DECODE(aia.PAYMENT_STATUS_FLAG,’N’,’UN-PAID’,’P’,’Partial Paid’,’Y’,’PAID’) PAYMENT_STATUS_FLAG , aia.invoice_date, aps.vendor_name, apss.vendor_site_code, aila.line_number, aia.invoice_amount, aila.amount line_amount, pha.segment1 po_number, aila.line_type_lookup_code, apt.name Term_name, gcc.concatenated_segments distributed_code_combinations,…
Read MoreIntroduction: This script will used to extract the AR partial credit memo’s with reference invoice details. select c.trx_number CM_Number, c.trx_date CM_DATE, (select a1.account_number from hz_cust_accounts_all a1 where a1.cust_account_id=c.bill_to_customer_id)CM_Customer_Number, d.line_type CM_LINE_TYPE,…
Read MoreIntroduction. This API will used to adjust the Fixed asset details like life_in_months and etc. declare l_trans_rec FA_API_TYPES.trans_rec_type; l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type; l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type; l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type; l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type; l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type; l_inv_tbl FA_API_TYPES.inv_tbl_type;…
Read MoreIntroduction: This scripts will used to extract the customer bank information in fusion. SELECT IBY_EBA.*,hp.party_name, CA.ACCOUNT_NUMBER, cbb.bank_branch_name Branch_name FROM hz_cust_accounts ca, hz_parties hp, iby_external_payers_all IBY_PAYEE, iby_pmt_instr_uses_all IBY_PAYEE_USES ,…
Read MoreIntroduction: This script will extract the accounting rule and trx source wise invoice counts. SELECT C.NAME RULE_NAME, D.NAME SOURCE_NAME, count(A.TRX_NUMBER), DECODE(A.ORG_ID,’XX’,’IM US OU’,’XXX’,’IM CANADA OU’) OU_NAME FROM RA_CUSTOMER_TRX_ALL A ,…
Read MoreIntroduction: This script will used to extract the AR accounted receipts details. select ‘HEADERS’ “FILE_IDENTIFIER” ,DECODE(ou.name,’IM US BU’,’IM US OU’,’IM CA BU’,’IM Canada OU’,ou.name) “BU_NAME”, cr.RECEIPT_NUMBER “Receipt Numder”, cr.type,crh_current.status “Current…
Read MoreIntroduction: This procedure is used to extract the adjustments from EBS for Cloud Import. create or replace PROCEDURE XXXX_AR_ADJ_EXTRACT_CLOUD ( errbuf OUT VARCHAR2, retcode OUT VARCHAR2, p_org_id IN NUMBER, p_trx_date_from…
Read MoreIntroduction 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…
Read MoreIntroduction 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,…
Read More