Technical

Oracle Cloud Fusion R13 

Cloud Fusion R13 - Technical Video

Cloud Fusion Order to Cash (O2C) cycle with Table Flow	https://freelancer4oracle.blogspot.com/O2C
Cloud Fusion Procure to Pay (P2P) cycle with Table Flow	https://freelancer4oracle.blogspot.com/P2P

• Oracle Cloud Fusion R13 Multi Organization tables

• Oracle Cloud Fusion R13 Financials OTBI subject area to database tables  mapping spreadsheets

• Oracle Cloud Fusion R13 Financial and Supply Chain Management (SCM) OTBI subject areas  to database tables mapping spreadsheets

Oracle Cloud Fusion R13 Complex SQL

SQL QUERY FOR DETAIL INFORMATION OF UNRECONCILED BANK AND BOOK TRANSACTIONS	https://freelancer4oracle.blogspot.com/1
SQL QUERY FOR PAYABLES NON-RECONCILED JOURNALS	https://freelancer4oracle.blogspot.com/2
SQL QUERY FOR GETTING UNRECONCILED LINES FROM RECEIVABLES	https://freelancer4oracle.blogspot.com/3
SQL QUERY FOR UNRECONCILED  PAYROLL  TRX	https://freelancer4oracle.blogspot.com/4
SQL QUERY FOR PAYABLES NON-RECONCILED JOURNALS	https://freelancer4oracle.blogspot.com/5
SQL QUERY FOR GETTING UNRECONCILED LINES FROM RECEIVABLES	https://freelancer4oracle.blogspot.com/6
SQL QUERY FOR UNRECONCILED  PAYROLL  TRX	https://freelancer4oracle.blogspot.com/7
SQL QUERY  FOR EXTERNAL TRANSACTIONS	https://freelancer4oracle.blogspot.com/8
SQL QUERY  FOR MANUAL JOURNAL IN GL	https://freelancer4oracle.blogspot.com/9
SQL QUERY  FOR MANUAL JOURNAL IN XLA	https://freelancer4oracle.blogspot.com/10
SQL QUERY  FOR POPULATES CLOSE BALANCE FOR BANK TRANSACTIONS	https://freelancer4oracle.blogspot.com/11
SQL QUERY  FOR JOURNAL TOTAL	https://freelancer4oracle.blogspot.com/12
SQL QUERY  FOR GST	https://freelancer4oracle.blogspot.com/13
SQL QUERY FOR TDS	https://freelancer4oracle.blogspot.com/14
SQL QUERY for CGST and IGST	https://freelancer4oracle.blogspot.com/15
SQL QUERY for PO Details	https://freelancer4oracle.blogspot.com/16

Oracle Cloud Fusion R13 Account Payable (AP)  Cash Requirement  SQL	AP 1 SQL
Oracle Cloud Fusion R13 Account Payable (AP) Expenses SQL	AP 2 SQL
Oracle Cloud Fusion R13 Account Payable (AP) Invoice Payments SQL	AP 3 SQL

Oracle Cloud Fusion R13 Account Payable (AP) Invoices and Lines	AP 4 SQL
Oracle Cloud Fusion R13 Account Payable (AP) Suppliers SQL	AP 5 SQL

Oracle Cloud Fusion R13 Account Payable (AP) Advances in Selected Currency SQL	AP 6 SQL

Oracle Cloud Fusion R13 Account Payable (AP) Bank Account Listing - draft SQL

AP 7 SQL

Oracle Cloud Fusion R13 Account Payable (AP) Credit Memo Matching - draft SQL	AP 8 SQL
Oracle Cloud Fusion R13 Account Payable (AP) Invoice Aging - draft SQL	AP 9 SQL
Oracle Cloud Fusion R13 Account Payable (AP)  Invoice on Hold - draft SQL	AP 10 SQL

Oracle Cloud Fusion R13 Account Payable (AP) Credit Memo Matching - draft SQL	AP 11 SQL
Oracle Cloud Fusion R13 Account Payable (AP) Payment Register - draft SQL	AP 12 SQL
Oracle Cloud Fusion R13 Account Payable (AP) Payment Terms Listing - draft SQL	AP 13 SQL

Oracle Cloud Fusion R13 Account Payable (AP) Prepayment Balance SQL

AP 14 SQL

Oracle Cloud Fusion R13 Supply Chain Management (SCM) SQL

-- SQL to Obtain ALL copied/Returned orders where original order is known in Oracle Cloud 

   Fusion R13

-- SQL to obtain Fulfillment Lines on the Original Orders where original 

   order is known in Oracle Cloud Fusion R13

-- SQL to Obtain Original order where Copied/Returned order is known in Oracle Cloud Fusion R13

-- SQL to obtain Fulfillment Lines on the Original Orders where the Copied/Return Order 

   is known in Oracle Cloud Fusion R13

-- SQL to show receiving transactions for the Return Order in Oracle Cloud Fusion R13

-- SQL can be run from BI to obtain Customer information in Oracle Cloud Fusion R13

-- SQL BILL TO information on Order Header in Oracle Cloud Fusion R13

-- SQL BILL TO  and SHIP TO information on Order Line in Oracle Cloud Fusion R13

-- SQL FOR Errors reported for Orders entered from UI in Oracle Cloud Fusion R13

-- SQL FOR Errors reported for imported OrderS in Oracle Cloud Fusion R13

Oracle Apps EBS R12 

Oracle Apps EBS R12 - Technical Video

Oracle Apps EBS R12 Order to Cash (O2C) cycle with Table Flow	https://freelancer4oracle.blogspot.com/p/o2c
Oracle Apps EBS R12 Procure to Pay (P2P) cycle with Table Flow	https://freelancer4oracle.blogspot.com/p2p

Oracle Apps EBS R12 Order to Cash (O2C) cycle with Table Flow

https://freelancer4oracle.blogspot.com/p/o2c

 Oracle Apps EBS R12 Procure to Pay (P2P) cycle with Table Flow

https://freelancer4oracle.blogspot.com/p2p

• Oracle Apps EBS R12 Multi Organization tables

• Oracle Trading Community Architecture (TCA)

• Oracle EBS R12 Architecture

• Oracle R12 Trading Community Architecture (TCA)