select (SELECT hou.NAME FROM apps.hr_operating_units hou WHERE 1 = 1 AND hou.organization_id = aps.org_id) ou_name, (SELECT paym.payment_method_code FROM APPS.iby_ext_party_pmt_mthds paym WHERE IEPA.ext_payee_id = paym.ext_pmt_party_id and aps.vendor_site_id = iepa.supplier_site_id –AND ass.supplier_site_id…
Read Moreselect aia.INVOICE_NUM ,aba.batch_name ,aia.INVOICE_AMOUNT ,aia.PAY_GROUP_LOOKUP_CODE INv_group ,aia.INVOICE_CURRENCY_CODE ,aia.CREATION_DATE ,To_char(aia.creation_date,’MONTH’) InvCreation_Month ,aia.INVOICE_DATE ,aia.SOURCE ,aia.INVOICE_TYPE_LOOKUP_CODE INVOICE_TYPE ,PAYMENT_METHOD_CODE INVOICE_PAY_METHOD ,aia.amount_paid amount_paid ,aia.description ,aia.doc_sequence_value VOUCHER_NUM ,(select max(aila.ACCOUNTING_DATE) from apps.ap_invoice_lines_all aila where aila.invoice_id = aia.invoice_id…
Read Moreset serveroutput on; DECLARE l_contact_point_rec HZ_CUST_ACCOUNT_ROLE_V2PUB.CUST_ACCOUNT_ROLE_REC_TYPE; l_role_id NUMBER := 0; l_cust_acct_id NUMBER := 0; l_obj_num NUMBER := 0; p_party_id HZ_PARTIES.party_id % TYPE; x_msg_count NUMBER; x_msg_data VARCHAR2(2000) := NULL; x_return_status VARCHAR2(1000)…
Read MoreSET SERVEROUTPUT ON; SET DEFINE OFF; DECLARE l_organization_rec HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE; l_party_rec HZ_PARTY_V2PUB.PARTY_REC_TYPE; –l_party_obj_version NUMBER; x_profile_id NUMBER; x_return_status VARCHAR2(1); x_msg_count NUMBER; x_msg_data VARCHAR2(4000); CURSOR C1 IS SELECT ICNU.CUST_NUMBER, ICNU.CURR_NAME, ICNU.CORRECT_NAME, ICNU.STATUS, HCA.PARTY_ID,…
Read MoreThis integration will integrate IR/ISO based on upload file from APEX application that has been created as custom.Once file been uploaded lot based data based on FIFO basis will be…
Read MoreSetup to create Tax Journals This Document explains the configuration needed for Journal level taxes.
Read MoreFusion Reporting Sequence Step by step process to create reporting sequencing in Fusion
Read MoreFusion document sequence This document tells how to create a document sequence in Fusion and process setep’s
Read Morecustomer-bank-account This is to know how to add multiple customers which share the same bank account details. user cannot add the bank details directly, using oracle specified process in this…
Read Morecustom-role-and-custom-lookup-creation-in-fusion This document describes how create a custom role and custom lookup in Oracle Fusion. In this document we have listed all the required setup details with screen shot to…
Read More