Tuesday 19 July 2016

Oracle Form built-in

Description

Executes the key trigger that corresponds to the specified built-in subprogram. If no such key trigger exists, then the specified subprogram executes. This behavior is analogous to pressing the corresponding function key.

Syntax

PROCEDURE DO_KEY
(built-in_subprogram_name VARCHAR2);
Built-in Type restricted procedure
Enter Query Mode yes

Parameters

built-in_subprogram_name Specifies the name of a valid built-in subprogram.

Built-in Key Trigger Associated Function Key
BLOCK_MENU Key-MENU [Block Menu]
CLEAR_BLOCK Key-CLRBLK [Clear Block]
CLEAR_FORM Key-CLRFRM [Clear Form]
CLEAR_RECORD Key-CLRREC [Clear Record]
COMMIT_FORM Key-COMMIT [Commit]
COUNT_QUERY Key-CQUERY [Count Query Hits]
CREATE_RECORD Key-CREREC [Insert Record]
DELETE_RECORD Key-DELREC [Delete Record]
DOWN Key-DOWN [Down]
DUPLICATE_ITEM Key-DUP-ITEM [Duplicate Item]
DUPLICATE_RECORD Key-DUPREC [Duplicate Record]
EDIT_TEXTITEM Key-EDIT [Edit]
ENTER Key-ENTER [Enter]
ENTER_QUERY Key-ENTQRY [Enter Query]
EXECUTE_QUERY Key-EXEQRY [Execute Query]
EXIT_FORM Key-EXIT [Exit/Cancel]
HELP Key-HELP [Help]
LIST_VALUES Key-LISTVAL [List]
LOCK_RECORD Key-UPDREC [Lock Record]
NEXT_BLOCK Key-NXTBLK [Next Block]
NEXT_ITEM Key-NEXT-ITEM [Next Item]
NEXT_KEY Key-NXTKEY [Next Primary Key Fld]
NEXT_RECORD Key-NXTREC [Next Record]
NEXT_SET Key-NXTSET [Next Set of Records]
PREVIOUS_BLOCK Key-PRVBLK [Previous Block]
PREVIOUS_ITEM Key-PREV-ITEM [Previous Item]
PREVIOUS_RECORD Key-PRVREC [Previous Record]
PRINT Key-PRINT [Print]
SCROLL_DOWN Key-SCRDOWN [Scroll Down]
SCROLL_UP Key-SCRUP [Scroll Up]
UP Key-UP [Up]


** Built-in: DO_KEY
** Example: Simulate pressing the [Execute Query] key.
*/
BEGIN
Do_Key('Execute_Query');
END;

Monday 18 July 2016

How to remove special characters in oracle from field using form personalization

Condition
:INV_SUM_FOLDER.INVOICE_NUM <>   REGEXP_REPLACE(:INV_SUM_FOLDER.INVOICE_NUM,'[^a-zA-Z0-9]')  

Error Message :

 Invoice #. should be alphanumeric only

Test Script :

 

 Example code:-

PROCEDURE INV_NUM_Pro
  IS
  ln_bill_no VARCHAR2(100); -- INV_SUM_FOLDER.INVOICE_NUM
  ln_length        NUMBER := 0; 
  
  BEGIN       
      ln_bill_no := :INV_SUM_FOLDER.INVOICE_NUM;
      IF(:INV_SUM_FOLDER.INVOICE_NUM IS NOT NULL) THEN
       ln_length  := LENGTH(REPLACE(translate(UPPER(ln_bill_no),'0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ','000000000000000000000000000000000000'),'0',''));
          IF( NVL(ln_length,0) > 0) THEN
              fnd_message.set_string('Courier bill No. should be alphanumeric only');
              fnd_message.error;     
          RAISE form_trigger_failure;
          END IF;
      END IF;
  END INV_NUM_Pro

 Example code 1:-

BEGIN
IF(:XX_RECEIPT_ALLOCATION.COURIER_BILL_NO IS NOT NULL) THEN
  
    IF  :XX_RECEIPT_ALLOCATION.COURIER_BILL_NO <>   REGEXP_REPLACE(:XX_RECEIPT_ALLOCATION.COURIER_BILL_NO,'[^a-zA-Z0-9]')   THEN
              fnd_message.set_string('Courier bill No. should be alphanumeric only');
              fnd_message.error;     
            RAISE form_trigger_failure;
    END IF;
END IF;
END; 

Tuesday 12 July 2016

APP-FND-00222 Error

Error : APP-FND-00222 Error When Submitting a Custom Concurrent Request Registered under a Custom Application




Cause :

The custom application has not been assigned to any data group

Solution :

1.  Under the System Administrator responsibility 
          Navigate to Security --> Oracle --> DataGroup.
2.  Query up a data group (Standard Data Group is appropriate).
3.  A list of applications associated with the standard data group will appear.
4.  Click on FILE in the toolbar menu then click on NEW.
5.  In the Application column select the custom application from the LOV.
6.  Add an Oracle ID to the ORACLE ID column (APPS is appropriate)
7.  Save the changes.
8.  Resubmit the concurrent request.