set 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 MoreExpense Report Processing for Terminated Employee To enter an Expense report for an employee, the employee has to be Active. The expense code looks at the Hire Date…
Read More1099 Invoices Processing Every Year January the subject of 1099 processing shoots to the top of the priority list for many AP Managers. Remembering exactly what was…
Read More