API “AP_AI_TABLE_HANDLER_PKG.DELETE_ROW” can be used to delete AP Invoice Data. This Script can be used when invoice accounting is not done. DECLARE CURSOR CUR1 IS SELECT AIA.ROWID,AIA.* FROM AP_INVOICES_ALL…
Read MoreBelow Pseudocode, DECLARE L_RESULT BOOLEAN; L_PO_HEADER_ID NUMBER; — := <PO_HEADER_ID> ; L_TYPE_LOOKUP_CODE VARCHAR2(20); — := <LOOKUP_CODE> ; L_VALIDATION VARCHAR2(10) := ‘N’; — := <VALIDATION_FLAG> ; CURSOR CUR_PO_DEL IS SELECT…
Read MoreWITH csv AS (SELECT ‘AA,BB,CC,D33D,EE,FFDD.MM,GG’ AS csvdata FROM DUAL) SELECT REGEXP_SUBSTR (csv.csvdata, ‘[^,]+’, 1, LEVEL) pivot_char FROM DUAL, csv CONNECT BY REGEXP_SUBSTR (csv.csvdata,'[^,]+’, 1, LEVEL) IS NOT NULL;
Read MoreCreate or Replace Function AMT_IN_WORDS ( P_TOT_AMT float, P_TRANSACTION_CURR Varchar2) return varchar2 IS InvalidNumberFormatModel EXCEPTION; PRAGMA EXCEPTION_INIT(InvalidNumberFormatModel,-1481); InvalidNumber EXCEPTION; PRAGMA EXCEPTION_INIT(InvalidNumber,-1722); TYPE GroupTableType IS TABLE OF VARCHAR2(30) INDEX BY BINARY_INTEGER;…
Read MoreOverview In order to disable New Record Button, Clear Button and Delete Button, Please follow below step Write the code in the Form Level Trigger (WHEN-NEW-BLOCK-INSTANCE) IF :XXBEX_PRO_BUDGET_HEADER_V.PROJECT_STATUS IN (‘PROJECT…
Read MoreWhen the Disposition Fields = (‘Complete’,’Accept’,’Accept with Variance’,’Reject’) Then Disable or READ ONLY the DFF Help -> diagnose -> custom code-> personalize Condition: Trigger Event: WHEN-NEW-ITEM-INSTANCE Trigger Object: GMDQSMPL.SAMPLE_NO Condition:…
Read MoreOverview Requirement: We have to change the “type” field LOV query for populating the custom values. To achieve this we have to follow the below process. Step-1: Login into the application…
Read MoreOverview Sometimes having a requirement to display all block data whenever form is open. In order to achieve please follow below step, Open Form builder> Open your custom form >Go…
Read MoreOnce any environment get refreshed in EBS, a new dbc file will be generated. Some times we will receive 500 internal error. To over come this we need to replace…
Read MoreIn OAF page, if user want to know how many characters entered in message text input field. Below is the code we need to use in process request. String…
Read More