Wednesday 10 January 2018

Oracle PLSQL Scripts and Important Oracle Apps SQL Queries



Oracle PLSQL Scripts and Important Oracle Apps SQL Queries.

Complete Tax Setups in Oracle Fusion


2. PLSQL Script to Fetch all Files Names from FTP Server
3.PLSQL script to Register Oracle Views from One Instance to Another automatically
4.PLSQL SCRIPT TO REGISTER PACKAGES FROM ONE INSTANCE TO ANOTHER  INSTANCE AUTOMATICALLY IN ORACLE APPS
5.PLSQL QUERY TO VIEW ALL INVENTORY ITEMS FOR BOM IN ORACLE APPS

6.PL SQL Script to Read data from Flat file in Oracle Apps
7.Understand Customer TCA Architecture
8.SQL Query to Fetch Accounting Flex Field segment Values with GL Account Description of all Segments
9.Oracle Apps Creditor Ledger SQL query
10.Oracle APPS R12 Creditor Ageing SQL query
11.SQL Query to Find Lock Sessions in Oracle Apps R12
12.Automate PLSQL script to download LDT files for all your Custom Concurrent Programs in Oracle Apps r12
13.Oracle Apps SQL query to Fetch AP invoice Rejection Reason in AP Interface
14. PLSQL Script to Show Amount in Words in Oracle Apps R12
15.How to Set Customer number Sequence as per Your Requirement in Oracle Apps r12
16.How to replace the default branding shown as E-Business Suite on homepage in R12 with Your Company Name
17.How to change Oracle Logo in Oracle Apps R12 Home Page
18.SQL Query to Fetch EBS Taxes with Operating Unit and GL Code in Oracle Apps r12
19.SQL Query to Fetch Oracle Customer Banking Details in Oracle apps R12
20.SQL Query to Fetch Oracle Apps User accounts with Responsibility Names in Oracle Apps R12 for Specific Operating Unit
21.Reconciliation of  AP and GL in Oracle Apps R12
22.How to Recover Deleted and Updated Data in Oracle Tables
23.GL Account Analysis SQL Query in Oracle Apps r12
24.Cash Bank Book Report Complete Logic in Oracle apps R12.
25.Item Master SQL Query in Oracle Apps R12
26.PLSQL Function To Get All customer Phone Number in Oracle Apps R12
27.Oracle Apps R12 Receiving Module Complete Details of the Tables and its Details
28.Item Master SQL Query in Oracle Apps R12
29.Oracle Apps Profile Option Change History SQL Query
30.Supplier Banking Information SQL Query in Oracle Apps
31.Oracle Apps SQL Query to Fetch GST TDS Calculation Report


 To Learn OAF Online , You can refer this Complete step by step OAF Tutorial

XML Tutorial

Oracle PLSQL Scripts and Important Oracle Apps SQL Queries

8 comments:

12345 said...

Good Blog , Thanks for sharing this informative article.
Oracle Fusion HCM Online Training
Oracle Fusion SCM Online Training
Oracle Fusion Financials Online Training
Big Data and Hadoop Training In Hyderabad

saicharan said...
This comment has been removed by the author.
saicharan said...
This comment has been removed by the author.
saicharan said...

Oracle Fusion SCM online Training

shaik shah said...

Excellent blog I visit this blog it's really awesome. The important thing is that in this blog content written clearly and understandable. The content of information is very informative.
Oracle Fusion HCM Online Training

Muralikrishna said...

good blog. your blog is really informative and helpful for me @ Rainbow Training Institute

Oracle Fusion HCM Online Training
Oracle Fusion SCM Online Training
Oracle Fusion Financials Online Training
Oracle Integration Cloud Online Training
Oracle Fusion Technical Online Training

Anonymous said...

I need the table to get estimated landed costs

Anonymous said...

I need the table name to get estimated landed costs in Oracle Apps 12.2.9

Post a Comment

Contact us for any Collaboration, Project Support & On Job Support Work

Name

Email *

Message *