Join the https://t.me/OracleApps88 group or message me at @apps88 (https://t.me/apps88)
or (+91) 9059574321 in Telegram, to get more information on Oracle
EBS R12/Cloud (Fusion) applications.
|
Topic
|
Link
|
|
AP -
Account Payables
|
|
|
Oracle Supplier Creation with API
|
|
|
Adding Attachments to Invoices/Purchase Orders Through PL/SQL
|
|
|
AP-SLA-GL Link Query
|
|
|
Query to display Finacial Options details in Oracle apps R12
|
|
|
Query to Display Payables Options Details In Oracle Apps R12
|
|
|
Linking GL Lines and AP Invoice Tables in R12
|
|
|
Oracle GL, AP, AR, FA and CASH Standard Features Differences
between 11i and R12
|
|
|
Query to Get Oracle Payable Account Details
|
|
|
Query to get the Oracle Payment Details
|
|
|
Query to Find the Validated Invoices in AP
|
|
|
Payables Open Interface Tables Details
|
|
|
Oracle Application (INV, PO, OM, AP and GL) Tables
|
|
|
Oracle Interfaces(ITEMS,QOH,PO,PO REQ,AP,SO) and APIs(HRMS)
|
|
|
Query to Find the Validated Invoices in AP
|
|
|
GL, AP, AR, QOH and PO Interface Tables and Conversion Process
|
|
|
Oracle Distribution Tables
|
|
|
Oracle Payments Query
|
|
|
API to Cancel the Oracle AP Invoice
|
|
|
AP-SLA-GL Link Query
|
|
|
General Ledger(GL) to Account Payables(AP)
|
|
|
To Select Prepayment Invoice Status in Oracle Payables
|
|
|
REPAY INVOICE DETAILS
|
|
|
Script to extract expense invoices for a Company for given
period Query
|
|
|
AP To GL Extraction Queries
|
|
|
Oracle Payment Process Request(PPR) Query
|
|
|
How to Show More Than 5 Payments One Time in Payment Dashboard
|
|
|
Oracle Procure To Pay (P2P) Queries
|
|
|
Procure to Pay Cycle Query
|
|
|
PROCURE TO PAY CYCLE QUERY WITH RECEIPTS
|
|
|
Procure to Pay query without receipts
|
|
|
A ‘P2P’ query which Populates all PO details:
|
|
|
AR -
Account Receivables
|
|
|
Query to get the Oracle Order to Cash (O2C) Details
|
|
|
Account Receivable(AR) Important Tables in Oracle Applications
|
|
|
Oracle Receivables(AR) Tables Information
|
|
|
Query to get Oracle Receivables Details
|
|
|
Oracle Receivable Query for AR Sales TAX
|
|
|
Oracle Receivable Reconciliation Query
|
|
|
Relation between AR,GL and XLA modules
|
|
|
Query to get the Customer Name, Account number, Transaction
number , Receipt and Amount details
|
|
|
Query to get the Order number,party name, ship to address and
bill to address details
|
|
|
GL, AP, AR, QOH and PO Interface Tables and Conversion Process
|
|
|
Single Insert Script for Oracle AR Invoice Creation with
Interface Approach
|
|
|
API to delete Receivable Invoice from backend
|
|
|
Query To Get Receipt Accounting Entries
|
|
|
Oracle R12 Account Receivable (AR) Invoice Creation throw API
|
|
|
Oracle Sales Order Joins with Shipping details and Customer data
|
|
|
Oracle AR Invoice Tax Details
|
|
|
Oracle Auto Invoice Interface Tables
|
|
|
Oracle Receivable Table Information
|
|
|
Query To Display Transaction Type Details In Receivables
|
|
|
Query to get Customer Name, Number and Address
|
|
|
AR To GL Query
|
|
|
AR Customer Interface R12
|
|
|
Oracle Receivable Contacts Query
|
|
|
Oracle Receivable Bill to and Ship to Address Queries
|
|
|
Oracle Receivables Bill To Query
|
|
|
Oracle Receivables SHIP TO query
|
|
|
AR Customer Query
|
|
|
HZ(TCA) Tables in Oracle Receivables
|
|
|
AR Cash Receipt using API
|
http://oracleapps88.blogspot.in/2011/09/ar-cash-receipt-using-api.html
|
|
GL -
General Ledgers
|
|
|
Query to Get the Oracle GL Balances
|
|
|
Query to Get Oracle Payable Account Details
|
|
|
Oracle General Ledger – Overview of Table Structure
|
|
|
Query to get the Subledger Transfer to GL details
|
|
|
Oracle GL Daily Conversion Rates Details
|
|
|
Oracle GL Budget Interface Details
|
|
|
Query to Get Actuals Vs Budget Values in Oracle General Ledger
|
|
|
Query to Get Org Name, Location, Business Group Name, Legal
Entiry Name and Operationg Unit Name
|
|
|
Query to Get Multiple Transfer to GL
|
|
|
GLRTB2 - GL Trail Balance Additional Segment Deatils Query
|
|
|
Query to Get Oracle Ledger, Legal Entity and Operating Units
|
|
|
Query To Display Security Rules Details in Genaral Ledger
|
|
|
General Ledger Queries
|
|
|
General Ledger(GL) to Account Payables(AP)
|
|
|
MASS ALLOCATION MIGRATION - DATALOAD CLASSIC LAYOUT
|
|
|
EXTRACT MASS ALLOCATIONS INTO A DATALOAD Format
|
|
|
GL INTERFACE SUMMARY
|
|
|
LEGAL ENTITIERS & ORGANIZATIONS
|
|
|
GL SUMMARY TEMPLATE DEFINITIONS
|
|
|
Function to Get the GL Code Combination Account Description
|
|
|
GL PERIOD STATUSES
|
|
|
SEGMENT VALUE SET LISTINGS
|
|
|
SET OF BOOKS CONFIGURATION OVERVIEW
|
|
|
MASS ALLOCATION FORMULA REVIEW SCRIPT
|
|
|
GL JOURNAL LINES WITH AP SOURCE REFERENCE FIELDS
|
|
|
GL JOURNAL BASED TRIAL BALANCE
|
|
|
GL Journal Header Summary
|
|
|
GL INTERFACE DETAIL
|
|
|
FSG REPORTS AND COMPONENTS OVERVIEW
|
|
|
CHART OF ACCOUNTS STRUCTURE
|
|
|
GL : CChart of Account Segment Hierarchy Ranges
|
|
|
GL BALANCES & MOVEMENTS
|
|
|
GL AUTOPOST DEFINITIONS
|
|
|
GL : ADI Journal Balances
|
|
|
To Check Period Status(open/close) of different Oracle Apps
modules
|
|
|
Relation between AR,GL and XLA modules
|
|
|
GL, AP, AR, QOH and PO Interface Tables and Conversion Process
|
|
|
AR To GL Query
|
|
|
AP-SLA-GL Link Query
|
|
|
Linking GL Lines and AP Invoice Tables in R12
|
|
|
Oracle GL, AP, AR, FA and CASH Standard Features Differences
between 11i and R12
|
|
|
Oracle Application (INV, PO, OM, AP and GL) Tables
|
|
|
GL, AP, AR, QOH and PO Interface Tables and Conversion Process
|
|
|
AP-SLA-GL Link Query
|
|
|
General Ledger(GL) to Account Payables(AP)
|
|
|
AP To GL Extraction Queries
|
|
|
Query to Get the Oracle AR Invoice Account Details
|
|
|
Queries to Check All SL Entries for an AP Invoices
|
|
|
INV -
Inventory
|
|
|
Oracle Inventory Table Flow
|
|
|
Oracle Distribution Tables
|
|
|
Oracle Items Extract Query
|
|
|
Oracle Apps Inventory KEY Tables
|
|
|
This is an inventory form query for few fields which are
important.
|
|
|
INVENTORY Queries
|
|
|
Oracle Item Extract Query
|
|
|
Oracle Inventory Metalink Note Ids
|
|
|
Query to get the transaction id ,INVENTORY_ITEM_ID, Item
description and LIST_PRICE_PER_UNIT details
|
|
|
All modules Interface Tables
|
|
|
Query to find Item template attribute values :
|
|
|
Query to get item status attribute controls :
|
|
|
Query to get item attributes under status control :
|
|
|
To Check Open inventory Periods
|
|
|
Oracle Inventory Item Creation With API
|
|
|
Oracle Inventory Item Interface Details
|
|
|
Oracle Inventory Process Move Order API
|
|
|
Oracle Bills Of Material (BOM) Interfaces
|
|
|
Oracle API For Assign the Item to catalog
|
|
|
Oracle API For Item Process
|
|
|
Oracle Item Conversions
|
|
|
Oracle Applications INV, BOM and WIP Table Joins
|
|
|
Oracle INV, BOM and WIP Table Joinings
|
|
|
All modules Interface Tables
|
|
|
Oracle Bills Of Material (BOM) Interfaces
|
|
|
Oracle BOM Query
|
|
|
Oracle WIP Job Status and OSP Receipts in Discrete MFG
Industries
|
|
|
How to resubmit pending/ error Transactions in WIP
|
|
|
WIP Job Status and OSP Receipts in Discrete Mfg Industries
|
|
|
WIP Queries
|
|
|
Oracle WIP Tables
|
|
|
On Hand Quantity on any historical date Query
|
|
|
API to get Lot On-hand, Available to Reserve and Transactable
Quantites
|
http://oracleapps88.blogspot.com/2011/08/api-to-get-lot-on-hand-available-to.html
|
|
Oracle Applications INV,PO,SUPPLIERS,OM and Work Order tables
|
|
|
Oracle Inventory 11i and R12 Tables
|
|
|
MTL_TRANSACTION_TYPES
|
|
|
MTL_TXN_REQUEST_LINES
|
|
|
MTL_TXN_REQUEST_HEADERS
|
|
|
Get On Hand Quantities through API
|
|
|
MTL_SYSTEM_ITEMS_B
|
|
|
On Hand Quantity on any historical date Query
|
|
|
PO -
Purchase Orders
|
|
|
Usual Oracle Applications PO Tables
|
|
|
Query To Find the Drop Ship Purchase Orders
|
|
|
Oracle Order Management and Purchase Order Scripts
|
|
|
Oracle Purchase Orders Hierarchy Query
|
|
|
Oracle Purchase Order Metalink Note Ids
|
|
|
Oracle R12 Order Management and Purchase Orders Data Fix Patches
and Scripts
|
|
|
Approved PO without notification of specific Employee
|
|
|
The following Query gives you the PO Details in R12 which have receipts
and which don't have Invoices.
|
|
|
PO Queries
|
|
|
Getting the Position Name and Supervisor Id by Oracle User Login
Name
|
|
|
Oracle Purchase Order 11i and R12 Tables
|
|
|
List of Approvers for a Purchase Order in Position Hierarchy
|
|
|
PO ALL RECEIPTS Query
|
|
|
Query to Get PO Receipt Received and Shipment Quantity Details
|
|
|
Adding Attachments to Invoices/Purchase Orders Through PL/SQL
|
|
|
How to Use Dynamic Queries To Determine Approvers for
iProcurement Requisitions - Example Based on Requisition Line Requester
|
|
|
How to Configure AME To Route Requisitions to the Requester's
(Not Preparer's) Next Position In the Default Position Hierarchy
|
|
|
Oracle Purchare Order (PO) Queries
|
|
|
PO Interface Tables
|
|
|
PO Tables
|
|
|
Single Query For P To P Cycle
|
|
|
Purchase Requisition to Purchase Order Query
|
|
|
PO - Script to Create Oracle Purchase Order Receipt from Backend
|
|
|
Oracle Purchase Order Single Insert Script Process
|
|
|
Script to Cancel the Purchase Order with API
|
|
|
Oracle Purchase Order Single Insertion Script
|
|
|
Blancket Purchase Order(Invoice) Single Insert In Oracle 11i
|
|
|
PO's Without Requesition Query
|
|
|
PO, Supplier and Invoice Query
|
|
|
Debugging PO Query
|
|
|
Canceled Requisitions Query
|
|
|
SO PO Requesition Query
|
|
|
Oracle PO Approval Metrics
|
|
|
OM -
Order Management
|
|
|
Effected Tables in Order Management in Different Stages
|
|
|
Oracle Order Management Flow
|
|
|
Sales Order , Customer and Receipts Related Quries
|
|
|
How to Setup and Verify Audit Changes to Orders using Audit
History
|
|
|
Script to Add #WFM_CC Attribute to the orders
|
|
|
How to find order header information
|
|
|
Oracle Sales Order Joins with Shipping details and Customer data
|
http://oracleapps88.blogspot.com/2015/06/oracle-sales-order-joins-with-shipping.html
|
|
Oracle Order Management and Purchase Order Scripts
|
|
|
Query to get the Order and transaction details
|
|
|
Query to get the delivery Order ,order_status ,ordered quantity
and shipped quantity details
|
|
|
API Script for Oracle Order Header Close
|
|
|
Query To Find the Drop Ship Purchase Orders
|
|
|
Oracle Order Management Metalink Note Ids
|
http://oracleapps88.blogspot.com/2015/09/oracle-order-management-metalink-note.html
|
|
Oracle R12 Order Management and Purchase Orders Data Fix Patches
and Scripts
|
|
|
Sales Order Hold Information Queries
|
|
|
Oracle Sales Order Query(OM)
|
|
|
OM Query
|
|
|
Oracle Order Management Manufacturing Release Metalink Ids
|
|
|
Oracle Order Management Configurator Metalink Ids
|
|
|
OM - Oracle API Script for Ship Confirm Process in Order
Management
|
|
|
Oracle API Script for Pick Release in OM
|
|
|
Assign delivery detail to delivery Through API Script in Order
Mangement
|
|
|
Create Deliver Through API script in Order Management
|
|
|
Create Order, Order Line and Book the Order through API Script
in Oracle Applications
|
|
|
Oracle Order Creation With API
|
|
|
Oracle Order Management Installation, Diagnostics and Patches
Metalink Ids
|
|
|
Oracle Advanced Pricing Metalink Ids
|
|
|
Oracle iStore Metalink Note Ids
|
|
|
Oracle Order Management FlexFields, Reports Metalink Ids
|
|
|
Oracle Order Management Invoice, Hold, Credit and Workflow
Metalink Ids
|
http://oracleapps88.blogspot.com/2015/09/oracle-order-management-invoice-hold.html
|
|
AuditTrail on Oracle Application OE_ORDER_LINES_ALL Table to
keep the History
|
|
|
Oracle R12 Order Management and Purchase Orders Data Fix Patches
and Scripts
|
|
|
Order Management Tables
|
|
|
OM Flow With Tables
|
|
|
Sales Order Details:
|
|
|
Oracle Order Managment 11i and R12 Tables
|
http://oracleapps88.blogspot.com/2011/11/oracle-order-managment-11i-and-r12.html
|
|
OE_LINES_IFACE_ALL
|
|
|
OE_PROCESSING_MSGS _VL
|
|
|
OE_PROCESSING_MSGS
|
|
|
OE_TABLES [OM tables]
|
|
|
Sales Order , Customer and Receipts Related Quries
|
|
|
SO PO Requesition Query
|
|
|
Getting Customer Address of a Sales Order Query
|
http://oracleapps88.blogspot.com/2011/06/getting-customer-address-of-sales-order.html
|
|
Oracle SALES ORDER
|
|
|
HRMS
- Humanr Resources
|
|
|
Query
to to find the Employee Supervisor name
|
http://oracleapps88.blogspot.in/2013/11/query-to-to-find-employee-supervisor.html
|
|
http://oracleapps88.blogspot.in/2013/11/low-level-employee-supervisor.html
|
|
|
http://oracleapps88.blogspot.in/2013/06/oracle-hrms-appraisal-status-query.html
|
|
|
http://oracleapps88.blogspot.in/2013/03/postion-hierarchy-details-with-superior.html
|
|
|
http://oracleapps88.blogspot.in/2013/02/employee-superviser-query.html
|
|
|
Loading
Competency Profile for Employees
|
http://oracleapps88.blogspot.com/2016/08/loading-competency-profile-for-employees.html
|
|
Script to
Update the Employee(per_all_people_f) and User(fnd_user) Email address
through API
|
http://oracleapps88.blogspot.com/2015/04/script-to-update-employeeperallpeoplef.html
|
|
Query to
get The Organization Details
|
http://oracleapps88.blogspot.com/2015/02/query-to-get-organization-details.html
|
|
Query to
fetch element details for all employees in Oracle HRMS
|
http://oracleapps88.blogspot.com/2015/01/query-to-fetch-element-details-for-all.html
|
|
Oracle
Interfaces(ITEMS,QOH,PO,PO REQ,AP,SO) and APIs(HRMS)
|
http://oracleapps88.blogspot.com/2014/10/oracle-interfacesitemsqohpopo-reqapso.html
|
|
Oracle
HRMS Competence Tables
|
http://oracleapps88.blogspot.com/2014/06/oracle-hrms-competence-tables.html
|
|
Oracle HRMS Scripts(Queries) - Entry Value
|
http://oracleapps88.blogspot.com/2014/04/oracle-hrms-scriptsqueries-entry-value.html
|
|
Oracle HRMS Scripts(Queries) - Employee Supervisor
|
http://oracleapps88.blogspot.com/2014/04/oracle-hrms-scriptsqueries-employee_6495.html
|
|
Oracle HRMS Scripts(Queries) - Employee Elements
|
http://oracleapps88.blogspot.com/2014/04/oracle-hrms-scriptsqueries-employee_5.html
|
|
Oracle HRMS Scripts(Queries) - Employee Relation
|
http://oracleapps88.blogspot.com/2014/04/oracle-hrms-scriptsqueries-employee.html
|
|
http://oracleapps88.blogspot.in/2013/02/hrms-employee-query_6701.html
|
|
|
http://oracleapps88.blogspot.in/2012/09/hr-employee-salary-update-api.html
|
|
|
http://oracleapps88.blogspot.in/2012/09/hr-employee-supervisor-update-api.html
|
|
|
http://oracleapps88.blogspot.in/2012/09/hr-employee-organization-update-api.html
|
|
|
http://oracleapps88.blogspot.in/2012/07/getting-position-name-and-supervisor-id.html
|
|
|
http://oracleapps88.blogspot.in/2011/06/designation-of-employee-query-in-oracle.html
|
|
|
Oracle
HRMS Scripts(Queries) - Contacts
|
http://oracleapps88.blogspot.com/2014/04/oracle-hrms-scriptsqueries-contacts.html
|
|
Oracle
HRMS Query - Absence
|
http://oracleapps88.blogspot.com/2014/04/oracle-hrms-query-absence.html
|
|
Oracle
HRMS Query - Position
|
http://oracleapps88.blogspot.com/2014/04/oracle-hrms-query-position.html
|
|
Oracle
HRMS API's
|
http://oracleapps88.blogspot.com/2013/04/oracle-hrms-apis.html
|
|
Oracle
HRMS Tables
|
http://oracleapps88.blogspot.com/2012/08/oracle-hrms-tables.html
|
|
To Update
Grade For a Position(per_valid_grade)
|
http://oracleapps88.blogspot.com/2012/12/to-update-grade-for-positionpervalidgra_10.html
|
|
Oracle HRMS Appraisal Status Query
|
http://oracleapps88.blogspot.com/2013/06/oracle-hrms-appraisal-status-query.html
|
|
Employees who have a
certain Element Entries with no values
restrictions
|
|
|
Oracle
HRMS Implementation Hints
|
|
|
HRMS (Human Resources useful information)
|
|
|
Oracle HR / Payroll Important Tables
|
|
|
http://oracleapps88.blogspot.in/2013/11/query-to-find-out-all-earning-and.html
|
|
|
http://oracleapps88.blogspot.in/2013/11/query-to-find-all-active-employees-and.html
|
|
|
http://oracleapps88.blogspot.in/2013/11/query-to-find-out-payroll-costing.html
|
|
|
http://oracleapps88.blogspot.in/2013/11/oracle-payroll-costing-detail-query.html
|
|
|
http://oracleapps88.blogspot.in/2013/02/oracl-payroll-query_25.html
|
|
|
http://oracleapps88.blogspot.in/2013/02/oracl-payroll-query.html
|
|
|
http://oracleapps88.blogspot.in/2013/02/oracle-payroll-queries.html
|
|
|
http://oracleapps88.blogspot.in/2012/03/payroll-tables.html
|
|
|
Query to Find Pay run Result Values in Oracle Payroll
|
http://oracleapps88.blogspot.com/2016/01/query-to-find-pay-run-result-values-in.html
|
|
Query to to find the Employee Supervisor name
|
|
|
Query to Find All Active Employees and Current Salary
|
|
|
Query to Find out all Earning and Deduction Elements and values
after Payroll Run
|
|
|
PA -
Project Accounting
|
|
|
Absence Integration with
OTL Projects Layout
|
|
|
PA_PROJECT_PUB.CREATE_PROJECT
- Creating Project, Task and ChildTask with API
|
|
|
To update the Project
Task through API - PA_PROJECT_PUB.UPDATE_TASK
|
|
|
TO Update the Oracle
Project Budget Line and Baseline Project Through API
|
|
|
Project Accounting CLIENT
EXTENSION Packages List
|
|
|
Project Accounting
Queries
|
|
|
Project Accounting Tables
|
|
|
Oracle Application Object Library(AOL)
|
|
|
User
|
|
|
|
|
|
Responsibility
|
|
|
|
|
|
Concurrent Request
|
|
|
Track and Trace E-Business Suite Concurrent Request - EBS
Logs, O/S Process IDs, Locks
|
|
|
|
|
|
Concurrent Program
|
|
|
|
|
|
Menu
|
|
|
|
|
|
Functions
|
|
|
|
|
|
Flex Fields
|
|
|
|
|
|
Profile Option
|
|
|
|
|
23 comments:
I like this blog and found really useful.for all EBS related complex queries..
Its like dictionary for technical APPS developer..
Thanks!
Thank You Avinash ...:)
Thank you for the resource
very much informative site! Many thanks for your wonder ful effort!
Awesome Information great Work Raj!!!!!
Awesome Site!!!!! Very useful site.Great Work.
Super work.
Awesome Work...Keep it up
Nice Blog very Useful ...................
very helpful
This is an awesome collection of Knowledge. Thank you
It is very helpful and it kind of Apps Technical Dictionary for the apps technical guys, I appreciate efforts Raj
Thank You Raj
That's G R E A T ! ! !
Hi, For MassAllocations, is it possible to identify the original source of the allocated amount?
For example, assume the following entries were generated:
Record 1: Original Entry / Cost Center ABC / Account 50000 / Amount $100 <-- Original Booking
Record 2: MassAllocation / Cost Center ABC / Account 79999 / Amount <$100> <-- Reverse out ABC balance (use default 79999 account)
Record 3: MassAllocation / Cost Center XYZ / Account 79999 / Amount $100 <-- Allocate balance of ABC to XYZ
Record 4: MassAllocation / Cost Center XYZ / Account 79999 / Amount <$100> <-- Reverse out XYZ balance
Record 5: MassAllocation / Cost Center 123 / Account 79999 / Amount $100 <-- Allocate balance of XYZ to 123
Essentially, if I'm pulling from GL_JE_LINES, GL_JE_HEADERS, GL_CODE_COMBINATIONS, GL_SETS_OF_BOOKS, etc., is there an indicator that would allow me to trace the $100 entry booked to Cost Center 123 (i.e. Record 5) back to the original source (i.e. Cost Center ABC)?
Any useful scripts and/or guidance would be much appreciated.
Thanks,
Michael
Fantastic website mate.
Useful staff thank you
Greate Website.....
Hats off to you...appreciated your efforts.
great efforts.. oracle apps at single place
Great information... Just i started going through the pages..Really great documents... thanks a lot
Hello Raju,
Thanks for information shared..Is there any command we can find When last patch applied in which Oracle EBS specific products ?
Thanks,
Pratyush Nigam
If you are facing any issues while copying the Code/Script or any issues with Posts, Please send a mail to OracleApp88@Yahoo.com or message me at @apps88 (https://t.me/apps88) in telegram.
Please update Fusion queries
Post a Comment