Posts

Sub-Queries in Oracle SQL

-
Image
 Sub-Queries in Oracle SQL   SNO Type of Sub-Quries 1 Single-Row Sub-Queries 2 Multi-Row Sub-queries 3 Co-Related Sub-Queries 4 Inline Views 5 Scalar Sub-Queries   Single-Row Sub-Queries Returns one value SELECT <columns> FROM <table_name> WHERE <col_name> <OP> (SELECT STMNT); > , >=, <, <=, =. <>     A single-row subquery in Oracle SQL is a subquery (a query nested inside another query) that returns only one row. Ø   It can be used in Select, Where, and Having clauses. Ø   The main/outer query uses the inner query result as its conditions. Ø   If a single-row sub-query returns more than one row, then you will get an error Ø   ORA-01422: exact fetch returns more than the requested number o...
Post a Comment
Read more

P2P Cycle in Oracle Fusion

-
Image
  Procure to Pay (P2P) process in Oracle Fusion ERP
Post a Comment
Read more

About Natural Account in Oracle Fusion

-
Image
      About Natural Account in Oracle Fusion (Documented by Venkat) ****************************************************** How is the Natural Account identified and mapped in the Oracle Fusion GL Table?   Step 1:  A journal entry is created using a code combination. Step 2:  The combination includes multiple segments (Company, Department, Natural Account, etc.). Step 3:  The  Accounting Flexfield Definition  identifies the Natural Account segment (e.g., SEGMENT3). Step 4:  That segment value (e.g., 5100) determines the account type (e.g., Expense)       GL_CODE_COMBINATIONS Table                                            Holds up to 30 segment columns (SEGMENT1 to SEGMENT30).                    ...
Post a Comment
Read more

Joins in Oracle SQL

-
Image
 Joins ========== Primary Forign Key Relation Ship DEPT ((DEPTNO PK-Primary Key)  EMP (DEPTNO FK-Foreign Key) Cross Join ---------- select empno, ename, job, dname , loc from emp, dept; select empno, ename, job, dname , loc from emp, dept where ename='SCOTT'; Result: EMPNO ENAME JOB DNAME LOC ------------------------------------------ 7788 SCOTT ANALYST ACCOUNTING NEW YORK 7788 SCOTT ANALYST RESEARCH DALLAS 7788 SCOTT ANALYST SALES CHICAGO 7788 SCOTT ANALYST OPERATIONS BOSTON ------------------------------------------ Equi-Join --------- select empno, ename, job, dname , loc from emp, dept where 1=1 and emp.deptno=dept.deptno and ename='SCOTT'; Result: EMPNO, ENAME, JOB, DNAME, LOC --------------------------------------- 7788 SCOTT ANALYST RESEARCH DALLAS select empno, ename, job, dname , loc from emp, dept where 1=1 and emp.deptno=dept.deptno --and ename='SCOTT'; Result: EMPNO, ENAME, JOB, DNAME, ...
Post a Comment
Read more