SQL is used to extract the security rules that are defined in the system. The parameter is Accounting Flex Structure SELECT ffvr.flex_value_rule_name, ffvr.description, ffvr.error_message, DECODE( ffvrl.include_exclude_indicator, ‘I’, ‘Include’, ‘E’, ‘Exclude’,…
Read MoreIntroduction 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 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 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 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 Morecreate or replace PROCEDURE XX_VALIDATE_DEBIT_INVOICE(errbuf OUT VARCHAR2, retcode OUT VARCHAR2, p_batch_run_id IN NUMBER, p_org_id IN NUMBER, P_stg_id IN NUMBER, p_debit_memo_num IN VARCHAR2) IS L_ORG_ID NUMBER:=p_org_id; L_SOB_ID NUMBER; L_USER_ID NUMBER; l_resp_id…
Read MoreIf we want to display multiple error messages in OAF page. We need to use the code as follows: arraylist errmsg = new ArrayList(); if(pageContext.getParameter(“Type”).equals(“”)) { errMsg.add(new OAException(“Type cannot be…
Read MoreIntroduction: This Post illustrates the steps required to upload the GL budget data using the interface program. Steps Create the Staging Table. Compile the given Package. Register the Concurrent Program…
Read MoreOracle Cloud Guard, a new Oracle Cloud Infrastructure (OCI) service designed to maintain a strong security in OCI. Cloud Guard is just one of the new services that are part…
Read More