Here we will discuss how to insert BLOB file in the database. For this we will create a table and then a procedure that will be used to insert records in the table. Use following script to create an employee table CREATE TABLE SV_EMP_PHOTO( ID NUMBER(3) NOT NULL, PHOTO_NAME VARCHAR2(40), PHOTO_RAW BLOB, EMP_NAME […]
Below are some of the different statuses of Sales Order Line with brief explanation OM = Order Management Sales order formSE = Shipping Transactions or execution form 1) Entered (OM): Order is saved but not booked 2) Booked (OM): Order is Booked. 3) Awaiting Shipping (OM): Order is booked but lines are not yet picked.Navigating to Shipping Execution, […]
From your command prompt, type sqlplus “/ as sysdba” Once logged in as SYSDBA, you need to unlock the scott account SQL> alter user scott account unlock; SQL> grant connect, resource to scott;
BEGINFND_USER_RESP_GROUPS_API.LOAD_ROW(X_USER_NAME => ‘ANATESH’,X_RESP_KEY => ‘APPLICATION_DEVELOPER’,X_APP_SHORT_NAME => ‘FND’,X_SECURITY_GROUP => ‘STANDARD’,X_OWNER => ‘SYSADMIN’,X_START_DATE => Trunc(sysdate),X_END_DATE => NULL,X_DESCRIPTION => NULL,X_LAST_UPDATE_DATE => Trunc(sysdate));COMMIT;END;
Calling messages: Following standard procedure can be called to show predefined oracle applications message through forms or concurrent programs. FND_MESSAGE.CLEAR – Clears the message stack of all the messages. FND_MESSAGE.DEBUG – Immediately displays the string passed to it as input parameter. FND_MESSAGE.ERASE – Clears the oracle Forms status line. FND_MESSAGE.ERROR – Displays an error message […]
Recent Comments