Introduction A flexfield is a customizable flexible data field that you can customize according to business needs without coding. Oracle Applications uses two types of flexfields, key flexfields and descriptive flexfields. A key flexfield is…
Read MoreThe prepayment matching program is the child program of the Autoinvoice import program and it is expected to trigger immediately after the Autoinvoice import is completed as per the intended…
Read MoreISTORE SETUP CATALOG CREATION Go to the below responsibility:- iStore Administrator 1. Navigate to Catalog Tab to see Hierarchy. 2. Click Section image in Accessories Section which is root section.…
Read MoreThe below is the query which will provide the supplier bank details: SELECT vendor_name supplier_name, segment1 supplier_number, ass.vendor_site_code site_code, ieba.bank_account_name, ieba.bank_account_num, ieba.masked_bank_account_num, (select user_name from apps.fnd_user where user_id=ieba.last_updated_by) updated_by, to_char(ieba.last_update_date,’dd-Mon-yy…
Read More5 Things not do with APEX 5.0 for Easy upgrading These are below following high level observations on the bottle neck factors while upgrading Apex 5 to the latest versions. They are Should use the Apex In build Utilities. Should not Use any…
Read MoreVarious Date Converter, Formatter and Validations Reusable Methods in OAF /**=============================================== * Methods related to Date Operation Starts Here * =================================================*/ /** * Method that returns the current system date.…
Read MoreASL Setup Validation ASL (Approved supplier list) setup validation for Local and Global The local setup we have to pass the parameter location code, item and Vendor code for global…
Read MorePO Receipt WEB ADI Interface: This is a interface, in Oracle EBS using web ADI, push raw data in custom staging table and then custom program does all validation and…
Read MoreThis blog describes the step by step process of Project Expenditures data conversion in Fusion Application using File Based Data Import. FBDI Template: ProjectUnprocessedMiscellaneousExpenditureItemImportTemplate.xlsm Interface Tables: PJC_TXN_XFACE_STAGE_ALL Base Table: PJC_EXP_ITEMS_ALL…
Read Morecreate or replace PROCEDURE xx_open_period ( errbuf OUT VARCHAR2, retcode OUT VARCHAR2, errmsg OUT VARCHAR2, p_from_org_id IN NUMBER, p_to_org_id IN NUMBER ) IS l_user_id NUMBER; l_resp_id NUMBER; l_appl_id NUMBER; l_org_id…
Read More