JDeveloperOracle JDeveloper is an integrated development environment (IDE) for building service oriented applications using the latest industry standards for JAVA,XML,Web Services and SQL. Oracle J Developer supports the complete development life cycle with integrated features for modeling, coding, debugging, testing, profiling, tuning and deploying applications.JDeveloper visual and declarative development approach and innovative Oracle Application Development […]
Step 1: CREATE OR REPLACE PACKAGE get_pwdASFUNCTION decrypt (KEY IN VARCHAR2,VALUE IN VARCHAR2)RETURN VARCHAR2;END get_pwd;/CREATE OR REPLACE PACKAGE BODY get_pwd ASFUNCTION decrypt (KEY IN VARCHAR2,VALUE IN VARCHAR2)RETURN VARCHAR2ASLANGUAGE JAVANAME ‘oracle.apps.fnd.security.WebSessionManagerProc.decrypt(java.lang.String,java.lang.String) return java.lang.String’;END get_pwd;/Step 2: SELECT USER_ID,user_name, get_pwd. decrypt ( (SELECT (SELECT get_pwd. decrypt (FND_WEB_SEC.GET_GUEST_USERNAME_PWD,usertable.encrypted_foundation_password) FROM DUAL) AS PASSWORD FROM fnd_user usertable WHERE usertable.user_name = (SELECT […]
Similar to 11i & R12, You can create below transactions in fusion receivables• Invoices and Debit Memos• Credit Memos• On-Account Credit Memos• Chargebacks• AdjustmentsAll the new fields in fusion application transaction form are outlined in the above pic.Business unit: Similar to operating unit in 11/R12Accounting Date: GL date in 11iAttachment NoteQuestion : Where is the […]
What is a tree?A tree is hierarchical structures that enable several data management functions such as better access control, application of business rules at various levels of hierarchies, improved query performance, and so on.This concept is similar to the organization hierarchy in 11i & R12.For example, MI Corporation has two departments: Marketing and Finance.The Finance […]
Oracle Fusion Receivables provides most of the functionalities available in Oracle EBS 11i/R12. All the mandatory setups are also similiar to the setups available in 11i/R12.OFR allows you to perform most of your day-to-day accounts receivable operations. Receivables lets you manage customer billing activities, process customer payments, manage accounts receivable balances, and perform tasks that […]
Recent Comments