For Example, two countries the Natural account for Cash Clearing account should hit 1460020, this is to identify the TnE Cash Reimbursements. The following configurations needs to be updates Manage…
Read MoreCash Management Reconciliation Error (Trying to match the lines and reconcile. However, system throws an error as it exceeds the limit of 10000.) Below attached error screenshot Solution Create…
Read MoreIntroduction/ Issue: Unable to Generate Accounting for Receipt GRNs Why we need to do / Cause of the issue: Unable to Generate Accounting for Receipt Accounting. Create Accounting for Receiving…
Read MoreIntroduction/ Issue: Employees Forced to Include At least One Aged Corporate Card Transactions. Why we need to do / Cause of the issue: Employee unable to claim expense due to…
Read MoreIntroduction: This blog has the script to get the Non po invoice details in Oracle Cloud application for Audit purpose. Cause of the issue: Auditor wanted to see the Non-PO…
Read MoreIntroduction: This blog has the script to get the credit memo application details in Oracle Cloud application for Audit purpose. Cause of the issue: Auditor wanted to see the credit…
Read More1. Overview This blog explains about, How to Set Current Record Color -Multi Color. 2. Technologies and Tools Used The following technology has been used to achieve the same. Ø Oracle FORMS 3. Use Case Create a Simple Tabular Block Create Visual Attribute with color Gray -Name it as ODD Create Visual Attribute with color Blue -Name it as Event In When-New-Record-InstanceCreate a Procedure 4. Architecture Oracle FORMS FORM Builder 5. Examples Step 1: Create one procedure in forms. Code: PROCEDURE Visual_attribute_dis_alt_rec IS cur_itm VARCHAR2 (80); cur_block VARCHAR2 (80) := :SYSTEM.Cursor_Block; curr_record NUMBER; BEGIN cur_itm := GET_BLOCK_PROPERTY (cur_block, FIRST_ITEM); WHILE (cur_itm IS NOT NULL) LOOP cur_itm := cur_block || ‘.’ || cur_itm; Curr_record := :SYSTEM.Cursor_Record; IF MOD (curr_record, 2) = 1 THEN SET_ITEM_INSTANCE_PROPERTY (cur_itm,…
Read More1. Overview This blog explains about, how we can Email validation using PLSQL function. 2. Technologies and Tools Used The following technology has been used to achieve the same. Ø Oracle PLSQL 3. Use Case To Create one function in database 18C 4. Architecture Oracle Database Using Database 18C ORALCE PL/SQL 5. Examples Step 1: Create one function in Database. Create one function in database. Code: CREATE FUNCTION f_email_validate (pi_email_id IN OUT VARCHAR2) RETURN BOOLEAN IS lv_n_check_len NUMBER; lv_b_check_in_at BOOLEAN; lv_b_check_in_dot BOOLEAN; lv_v_extn VARCHAR2 (10); BEGIN lv_n_check_len := LENGTH (pi_email_id); pi_email_id := LOWER (pi_email_id); SELECT REPLACE (pi_email_id, ‘ ‘, ”) INTO pi_email_id FROM DUAL; SELECT REPLACE (pi_email_id, ‘”‘, ”) INTO pi_email_id…
Read MoreIntroduction: This blog explains Network Access control list. What is an ACL? Access Control List is a Network security feature that filters traffic on Layer 3 (IP Address) and Layer…
Read MoreStep:-1 Check invalid Invalid Component:- SQL> SELECT COMP_NAME FROM DBA_REGISTRY WHERE STATUS=’INVALID’; COMP_NAME ——————————————————————————– Oracle XML Database Step:-2 execute the below packages and triggers ALTER PACKAGE XDB.DBMS_CLOBUTIL COMPILE BODY ;…
Read More