Join the OracleApps88 Telegram group @OracleApps88to get more information on Oracle EBS R12/Oracle Fusion applications.

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 or +91 905 957 4321 in telegram.

SCRIPTS

Please Like and Share our FaceBook page to get more details on Oracle Applications
https://www.facebook.com/pages/Oracle-Applications/712588392100243

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




22 comments:

AVINASH K. said...

I like this blog and found really useful.for all EBS related complex queries..

Its like dictionary for technical APPS developer..

Thanks!

Raju Chinthapatla said...

Thank You Avinash ...:)

Jagannadh said...

Thank you for the resource

shekhar said...

very much informative site! Many thanks for your wonder ful effort!

Unknown said...

Awesome Information great Work Raj!!!!!

triveni said...

Awesome Site!!!!! Very useful site.Great Work.

Abhijit said...

Super work.

Unknown said...

Awesome Work...Keep it up

Unknown said...

Nice Blog very Useful ...................

Unknown said...

very helpful

Olutayo Oluwole said...

This is an awesome collection of Knowledge. Thank you

Anonymous said...

It is very helpful and it kind of Apps Technical Dictionary for the apps technical guys, I appreciate efforts Raj
Thank You Raj

Anonymous said...

That's G R E A T ! ! !

Anonymous said...

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

Unknown said...

Fantastic website mate.

Unknown said...

Useful staff thank you

Abhi Rajpoot said...

Greate Website.....

Nauman Khalid said...

Hats off to you...appreciated your efforts.

Unknown said...

great efforts.. oracle apps at single place

Durga Prasad said...

Great information... Just i started going through the pages..Really great documents... thanks a lot

prasoon said...

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

Raju Chinthapatla said...

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.

Post a Comment

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 or +91 905 957 4321 in telegram.
Best Blogger TipsGet Flower Effect