ORACLE FUSION CLOUD

Tuesday, January 17, 2017

Query to find Form attached to Responsibility and users ~ Oracle Applications Technical

Query to find Form attached to Responsibility and users ~ Oracle Applications Technical

- January 17, 2017

Email This BlogThis!Share to Twitter Share to Facebook Share to Pinterest

No comments:

Post a Comment

Newer Post Older Post Home

Subscribe to: Post Comments (Atom)

Types of animations

Animation is a diverse and creative field with a variety of styles that artists and filmmakers use to bring their visions to life. Here are ...

Approval Management Engine FAQ

Approval Management Engine FAQ 1. AME – What is it? i. AME is a simple to use Rules Engine for Defining Approval Policy ii. AME is ...
Register Custom Tables in Oracle Apps

Register Custom Tables in Oracle Apps Say you have a custom table called “ERPS_EMPL...
Query to find Organization information ,Tables and links ,ORGANIZATION_ID BASED ON SHIP TO BRANCH PLANT

OU & ORG ID & ORG CODE & ORG NAME ================================== select OPERATING_UNIT,ORGANIZATION_ID,ORGANIZATION_CODE...

Home

Labels

-LINK BETWEEN po_headers_all AND oe_order_headers_all
-Query to Check PO Quantities received for an item in a given date range
.UNCOSTED MATERIAL
.UNPROCESSED MATERIAL
‘Initialization SQL Statement – Custom’ ( FND_INIT_SQL );
"Do not close this window until processing completes"
“TKProf Basic OverviewPerformance Tools Quick Reference Guide”
(HZ_CUSTOMER_PROFILE_V2PUB.CREATE_CUSTOMER_PROFILE
(HZ_LOCATION_V2PUB.CREATE_LOCATION
(HZ_PARTY_SITE_V2PUB.CREATE_PARTY_SITE)
(LPN)
02c query
11I
12
21days
Accessing Approval Management Engine (AME)
Account Payable
Account Payable flow
Account Payables All Posts
Account Payables Tables
Account Receivable All Posts
account receivable Setup Payment Terms
Account Receivables
Accounting Entries in Oracle Fusion Cloud Application
Accrual Basis Accounting for Oracle Apps Beginners
Accruals in R12
Accruals Query
Action History on PO and REQ
add a field ITEM_TYPE_CODE
Add customer name to Report
Add SubTotals for Selling Price and List Price
Add Text at Start and End of Each Line Notepad++
Advance Pl/sql
after lockdown
After R12 Clone: Consult the OPP service log for details
after21days
AGGREGATE FUNCTIONS
AIM
AIM Document List
Alert
Alert in Oracle Apps
Alerts In Oracle Apps
ALERTS Interview Questions and Answers in Oracle Apps
ALL QUERy
all the users who have access to a responsibility
All Workflow Related posts links
AME
AME ALL POSTS
amount
Analyatic Fnuctions
Analytic Functions
AND
and forall
and its Parameters information
and receipt number
and Theme Parks Offering Virtual Tours
AOL
AOL : Valueset – A Beginner’s Guide
Aol Objects
AOL QUERIES
AP
AP Invoice Technical Details
AP Invoice Technical Details with Functional Inputs
AP invoice to XLA link
AP Payment Administrator Setup in R12
AP Payment Testing in R12
ap Queries
AP Supplier Conversion Using API
AP to GL Link in oracle apps
AP_EXPENSE_REPORT_HEADERS_ALL
AP_Queries
AP_VENDOR_PUB_PKG
api
API HZ_CUST_ACCOUNT_V2PUB.CREATE_CUST_ACCT_RELATE
API hz_party_v2pub.create_organization
API to Create a Customer Account
API to Create a Customer Profile
API to Create a Customer Site
API to Create a Customer Site Use
API to Create a Party Site
API to Create a Party Site Use
API to create a Person Type Party and Customer Account
API to Create a Phone Number (Contacts)
API to create customer Addresses
API to create Group
API to create Party and Customer Account.HZ_CUST_ACCOUNT_V2PUB.CREATE_CUST_ACCOUNT
API to get the formatted contact details
API to populate loc_id HZ_LOCATIONS
API to update a Customer Account Relationship
API to Update a Customer Account TCA R12
API to Update a Customer Account TCA R12 (HZ_CUST_ACCOUNT_V2PUB.UPDATE_CUST_ACCOUNT
API to update a Customer Profile TCA R12
API to Update Customer Address in Oracle TCA R12
Application Architecture Single Tier Architecture
Applications Directory and File Types
Applications Form Trace
apps
apps ap tables
APPS ERP DOCUMENTS
APPS QUERIES
apps quires
Apps Report Customization's
apps reports
APPS TABLES(PO
APPS TECHNICAL
apps.bne_contents_b bcb
apps.bne_contents_tl ct
apps.bne_integrators_tl bit
apps.fnd_program.executable Queries
apps.fnd_program.register
ar
AR Adjustments to GL query
AR INV Validations
AR Invoice Mandatory Columns
AR Invoice Open Interface
AR Invoice Query
AR queries
ar query
ar receipt
AR Receipt and Bank Statement Reconciliation oracle apps
ar receipt QUERIES
AR Receipts to GL
AR Receipts to GL link in oracle R12
AR Tables
AR to GL Link
ar to gl query in r12
AR TO HZ LINK
AR Transactions
AR_PAYMENTS_INTERFACEBranches
AR_Queries
AR_RECEIPT_API_PUB.CREATE_CASH
Assign Receipt method to Customer via API in Oracle Apps R12
attachments
Autoinvoice
AUTOLOCK BOX CONCEPTS IN R12
AutoLock Box In R12
Autolockbox: Standard Oracle Receipt Rejection reasons
Automatic Receipts
Automatic Receipts And Remittance In R12
AUTOTRACE Option in sqlplus
Awaiting Shipping Query pICKED BUT NOT SHIPPED
Back order status
BAD File
Bank model
bank query
Bank Statement Loader In R12
Bank Tables in Oracle apps r12
Bank-accounts-supplier-and-customer
banking
banktables
Barcode with BI publisher report
BASED ON MATERIAL TRANSACTIONS ACTIVE ORGANIZATION QUERY
Basic Accounting
Basic Troubleshooting
BETWEEN/NOTBETWEEN
billing
BIP Bursting
BLANKET SALES AGREEMENT TABLES
Blanket Sales Order
BOL
BOM
Bom Explosion Query
BOM; OM
Booked
Booked and Saved
Bored at Home
break the page
BULK COLLECT
Business life cycle
Cash Management
Cash Management ALL Posts
Cash Management Setup Check List
Cash Management: Cash Cycle
Cash management: Manual reconciliation of Miscellaneous Transaction
CE
CE BANKS
Changing existing report
Checking order progress from back end.R12
checking Profile Option
Checking Purchase Order Approval History for a specific member of
Checking Requisition Approval History for a specific member of staff
cience-experiments-and-activities
CM
code to Convert column to row
Cogs Query oracle apps 12
COGS query R12
Col Usages from specific table
communication details
Compare two text files in Notepad++
Comparison between SAP and Oracle Apps
Complete flag and Customer name.
Complete Order to Cash(O2C) Techno-Functional flow in R12
Concurrent Executables
Concurrent program
Concurrent Program Definition Trace
concurrent program from back end
Concurrent program Queries
concurrent program schedules ; requestset schedules ;oracle apps r12; application developer ;fnd_concurrent_requests ;concurrent_program;Check Periodic Alert';
Concurrent Program/Request Scheduling
Concurrent request running longer
connect by
Constraints
Control file
Control file with parameters
Conversion Using API
Conversions
Converting rows into columns using pivot function
Core HR Basic Concepts
COST OF GOODS SOLD
costing errors
COUNT
course
COVID19
covid19india
Create Accounting Program:
Create New Custom Form Oracle Applications
Create Party of type Organization in Oracle TCA
Create profile with the best plan-
Create XML Publisher report without RDF
CREATING A SUPPLIER IN R12
Creating Custom Webadi Template in Oracle Apps
Creating First OAF Page In Project
Creation of Set Of Books
Credit Check Functionality in Order Management
creditcard sale order queries
CRM
CUBE
current date
currentdate
CURRVAL
Cursor
cursors
cust name
cust no
customer
CUSTOMER API
CUSTOMER API
Customer Balance Revaluation Report
Customer Bank Account Details Report XML Report
Customer Conversion
CUSTOMER CONVERSION IN ORACLE APPS R12 via API's - OVERVIEW
customer discounts
Customer Import using API's
Customer Information
customer invoice details
Customer Master Information
customer phone number
customer query
Customer Tables
D2k Interview Question
Data Definition
Data File
Data Flow from APto XLA to GL
Data Flow from AR to XLA to GL
data manipulation operation not legal on this view
Dataloader
Date Functions
date of invoice
DCL
DDL
Debugging an Internal Requisition which not turned to an Internal Sales Order
Decode Functions
Deferred COGS: How to use this feature of Oracle Apps R12
Define Bank And Bank
Define Bank;Define Grants and Roles;Setups for Defining the Banks;Define Branch;Define Bank Account;Add Operating unit to your bank;Defining Internal Bank Accounts;Defining Customer Bank Accounts;
Delete Concurrent Program from the Back-End
Delivery line statuses
Demonstration of XML bursting
dense_rank
denserank
dependent
Developer tips
Developer tips; Easy test editing ;Notepad++
Developing and Registering Procedures with Oracle Application
DFF
Diff between 11i and R12 Apps Technical
Difference between 11i and R12 module wise
Difference between Case and Decode
Difference between drop and truncate and delete
Difference Between NVL and NVL2
Difference between Party and Customer
Difference between Stored Procedure and Function
Difference between Valuesets and Lookups
Different types of LPN (licence plate number) Status in WMS module
Different Types of Tables in Oracle Apps
discount grace days
Discounts
Discrepancy
Distinct
DML
Document Sequence
DOCUMENTS
Documentsin Oracle Application
DQL
DRILL DOWN FROM GL INTO AP
Drop Ship Query Query Drop Ship Sales Order
DROPSHIP
Dual Table
Duplicate Shipments SQL Query SQL Query sql query to find duplicate shipments
E-Business Tax Notes -- R12
eading zeros truncated for excel report
Easy test editing
EB-Tax Setup Tables in Oracle APPS
EBIZ TAX
EBS LOGIN URL from database;How to find Oracle Applications Login URL from database
email procedure
Employee Conversion
Employee Details
Employee Hierarchy Process
Enable Diagnostics in Oracle apps
enable macros
Enable Personalization on OAF Page
Enable SQL Trace in Oracle Apps R12
ENABLE TRACE FOR CONCURRENT PROGRAMS IN ORACLE APPS R12
Enable/Disable the parameter field Dynamically in Oracle apps Concurrent Program
Enabling Notepad++ Dark Theme
End User Details
ENGLISH
Equi Join
ERP
ERP INTRODUCTION
Error in Workflow ORA-04061: existing state of has been invalidated
Europe Localization
European Post-Install Steps
Event Handling In Oracle Core Contracts
EXCEPTIONS
EXECUTE IMMEDIATE
Execution plan
experience
Expertenglishlanguagetraining
explain plan
Explain Plan in Toad
External tables:
FA
faq
Financial Statement Generated Report
Find Receipt based on PO Header_ID
Find Table And View Objects Behind OAF Page
Firing Sequence Of Form triggers
first
Fixed Assets GL
Flat file
Flex-field Qualifiers and Segment Qualifiers - "Natural Account"
FLEXFIELDS
FND Debug log;debugging;
fnd load
FND Tables: Oracle Applications AOL Objects
FND_FORM_CUSTOM_RULE
FND_GLOBAL.APPS_INITIALIZE in oracle applications
FND_NEW_MESSAGES
FNDLOAD Scripts
FNDLOAD Upload and Download Commands For Different AOL Components
FORALL
form
Form Personalization
Form Personalization: Create Journal Entry From Subledger Journal Entries Form In AP
form triggers
format numbers as text
forms
Forms Personalization
Four Tier Architecture
Function
Function consultant
Function Not Available To This Responsibility. Change Responsibilities Or Contact Your System Administrator
Functional Components
FUNCTIONAL MODULES Multi Orgs Multiple Organizations
Functions
Fusion
FusionBursting
GENERAL
General Ledger
General Ledger – Basic Accounting Concept | General Ledger Account Types and Accounting formula
General Ledger All Posts
geography's without Jurisdiction's in oracle apps eb-tax
German VAT for On-Account Receipts Report
Germany localization
Germany-Specific Setup and Processes;
GET FLEXFIELD DATA INTO REPORT
get the invoices and order details
GL
Gl to Ap Drilldown Query R12
GL Entries with AP Payments
GL Entries with the AR Transaction
GL Period Close
GL QUERIES
Gl Report
Gl to ar Drill down Query
GL_PERIOD_STATUSES
grace days
Group by clause
group functions and joins
GROUPING Functions and GROUPING SETS
Handling Exceptions in Bulk Operations
Having clause
Hierarchical Queries - Start with Connect by
history tables
Hold Release
How Do You Turn Off Or Disable Tax Calculation In R12 E-Business Tax (EBTax)
How the start with CONNECT BY clause in Oracle works
How to change HR Workflow Notification approvals In AME for SSHR.
How to check total outstanding you need to pay to a Supplier
How to check workflow status from backend
how to create report in oracle apps and run
How to Create Responsibility in Oracle Apps
How To Define Customize Web ADI Layout In R12
How to Develop Report with out Parameters?
How to Display Leading Zeros in XMLP Report
How to enable Oracle apps Diagnostics
How to enable trace for a USER session
How to find the Package associated with A WEBADI Integrator
How to find the Tracefile using SID in Oracle
How to Generate a Useful SQL Execution Plan
How to Implement User Profiles?
How to join GL tables with XLA (SubLedger Accounting) tables
How to Migrate/Transfer Workflow/Custom business events
How to open Periods in Oracle Apps
How to print multi layouts multi currency multi language in xml publisher
How To Restrict A Customer To Create Foreign Currency Transaction In Transaction Workbench
How to Run the SQL script from the Concurrent Program?
How to submit the concurrent request from shell scripts
How to submit XML Report using a PL/SQL Script
How to survive (and even thrive) during lockdown with kids
How to update EBS XML Publisher Temporary Directory
How To Upload AP Invoices Using Oracle WebADI Custom Integrator
How to use Case and DECODE function???
How to view Customer Bank Account Details
How to view other user output file in application
How To Void Confirmed Payment Batch In R12 Under Payment Manager
HR_EMPLOYEE_MIGRATION
HRMS
HRMS Modules
hz
HZ_CONTACT_POINT_V2PUB.CREATE_CONTACT_POINT
HZ_CUST_ACCOUNT_SITE_V2PUB.CREATE_CUST_ACCT_SITE
HZ_CUST_ACCOUNT_SITE_V2PUB.CREATE_CUST_SITE_USE
HZ_CUST_ACCOUNT_V2PUB.CREATE_CUST_ACCOUNT
HZ_CUST_ACCOUNT_V2PUB.UPDATE_CUST_ACCT_RELATE
HZ_CUSTOMER_PROFILE_V2PUB.UPDATE_CUSTOMER_PROFILE
HZ_FORMAT_PHONE_V2PUB.PHONE_DISPLAY
HZ_LOCATION_V2PUB.UPDATE_LOCATION
HZ_PARTY_SITE_V2PUB.CREATE_PARTY_SITE_USE
HZ_PARTY_V2PUB.CREATE_GROUP
hz_payment_method_pub.create_payment_method
HZ_TAX_ASSIGNMENT_V2PUB. CREATE_LOC_ASSIGNMENT
IBY_EXT_BANK_ACCOUNTS
Identifying Duplicate Shipments
IDS BUSY
iexpense
iExpenses Table
Important Base tables all modules GL
important links
IMPORTANT QUERIES
IMPORTANT SQL QUERIES
in oracle apps r12
in specific condition?
in XMLP?
IN/NOTIN
Inbound Interface
Incomplete Bank Statements SQL Query
Incomplete Invoice Report
INCOMPLETE INVOICES REPORT
Incomplete Work Orders
independent
INDEX:
India localization
INDIA LOCKDOWN
indiaafter21days
indiafightcovid19
ink inventory material transaction with GL journal entry. Gl inv link
INNTERFACES
Insert Script for Open AR Transaction (Credit Memo) for R12
Insert Script for Open AR Transaction (Invoice) for R12
Insert Script for Standard POs
Inserting XML Data Type
INSTEAD OF triggers
Integration of base product schema by using APPS schema
Integration of Oracle Apps Modules
INTERFACE TABLES
Interface Trip Stop Functionality
Interfaces
interim tables
INTERSECTION
interview questions
Interview questions FAQ Oracle apps r12 and PLSQL
introduction
INV
INV period closing Queries
INV period closing details all in one Query
INV period closing Queries
Inv quantity;
INV queries
Inv to gl Link Query R12
INV_QUERIES
Inventory interview questions
inventory organizations for an operating unit
invoice
Invoice Aging Report
Invoice History Report
invoice no
Invoice Number and Receipt Number With one of the Input
Invoice Validated
invoice_amount oracle apps r12 sql query to find order amount
Invoices not picked by PPR
Invoking SQL*Loader
IProcurement
iProcurement Setup Document and it's basic flows in R12.2
IS
item conversion
Item Conversion Update
item conversions
Item Interface
item query
Items On Hand Qty
Join between OM
joining between OM
JOINS
Joins between OM and AR
joins between various tables in Internal Sales order (ISO)
Journal Import in GL
Journal Posting Issue and resolution
Journal reversal in GL
Key Flex Fields
KIDS ACTIVITIES
last
last page
layout in the backend
Learn to avoid the mutating table problem in Oracle
learninggamesforkids
Legal Entity Name
Lexical Parameters
License Plate Number
Life Cycle of Business
LIKE/NOT LIKE
line and qualifier at header level in R12
Link Between AP and GL with XLA tables in R12
Link Between AR and GL with XLA tables
link between IBY and HZ
link Between per_all_people and per_all_positions
link between sales order and purchase order in Oracle apps r12
Link Between Transaction Number and Receipt Number in AR
links
List of Orders which are pick released on Sysdate
Lockbox
lockdown
Longreunning sql; tuning;performance ;
Lookup
LPN
LTOM
Material Transactions Query
MATHS
MAX
MBOL
Message_text
migration
MIN
MINUS
Miscellaneous Metalink Performance Articles
MO: Security Option
MOAC
MOAC: Multi-Org Access Control
Modification of Oracle Java mailer
modifier and qualifier using API in R12
modifier header
modilockdown
Monitor/Restart/Bounce Workflow Agent Listener
Month end close
multi layouts
Multi-Org Access Control
Multiple Organizations in Oracle Application
multiple orgs
Museums
Mutating table error
Mutating Table Exceptions
NEXTVAL
NOCOPY
Not Null
Notepad++
Notepad++ tips
Notify when SO is booked or new line is entered on booked order
NUMBER AND CHARACTER FUNCTIONS
NVl
NVL2
O2C
o2c apps R12
O2C full cycle in oracle R12
o2c functional flow
o2c query
o2c query r12
O2C R12
O2c Tables R12
OAF
OAF ALL POSTS
OAF Apache Bounce Steps in R12.2
OAF Forms Trace
OAF Importer commands;OAF
OAF Interview Questions
OAF INTRODUCTION
OE_PRICE_ADJUSTMENT
OFSAA – Oracle Financial Services Analytical Application Installation Overview
OM
om conversions
OM flow
OM Link AR
OM links
OM QUERIES
OM Query
OM Related queries Oracle Apps BOM Tables and Queries
OM TABLES
OM to GL Drill Down Query
OM to GL links
OM TO GL query
OM_Queries
OM: Over Shipment Tolerance
On Delete Cascade
Onhand quantity
Open Notifications - PO
Open Notifications - Req
Operating Unit Details
Operators
OR
ORA-01732
ORA-erreros
oracl faq
ORacle
Oracle 12i - How to create accounting and transfer JE's to GL using SLA
Oracle Account Payables(AP)
Oracle Alert - Basics
Oracle Application Framework (OAF) Tutorials
Oracle Applications : Forms :Query Find window
Oracle Applications :Oracle Unified Methodology (OUM)
Oracle Applications :OUM and AIM
Oracle Applications Concurrent Request phase codes and status codes
Oracle Applications Modules List:
ORACLE APPLICATIONS TECHNICAL
ORACLE APPLICATIONS TECHNICAL INTRODUCTION
oracle apps
Oracle apps Complete links Module wise
Oracle Apps Interview Questions
Oracle Apps Credit Card: Process in iExpense and Payables
Oracle apps discounts
Oracle apps Documantation
Oracle Apps file Architecture
Oracle Apps Forms Basics
Oracle APPS Forms:Zoom functionality
Oracle apps Important Queries
oracle apps interview Questions
oracle apps interviewQuestions
oracle apps introduction
Oracle Apps Inventory Accounts: Inventory Accounts and their Description
oracle apps Querys
Oracle apps r12 invoiced quantity variance with the ordered quantity
Oracle Apps R12 Subledger Accounting Tables and joins
Oracle Apps Receivables (AR) Tables
Oracle Apps Receivables Accounting entries
Oracle APPS Releated Queries
oracle apps shortcut keys
Oracle Apps TCA Tables
oracle apps technical
Oracle apps Topic wise links
Oracle Apps XML Interface design Considerations
Oracle Apps XML Interface: Design
Oracle Apps;Desktop Integration Manager;Desktop Integrator
Oracle Apps: Balance Sheet and Profit and Loss Reports
Oracle Apps: Forms Personalization Tables
Oracle Apps: Kill a Locked session through Toad
Oracle Apps: LDT Commands
Oracle Apps: Payables Table structure
Oracle Apps: R12 Payment Document Setup
Oracle Apps: Working with Oracle Forms
Oracle BI Publishe
Oracle BI Publisher
Oracle BI Publisher Interview Questions
Oracle Cash Management
Oracle Cash Management Introduction
Oracle Cash Management Setups
Oracle Cursor Basics
Oracle Database Administration(DBA)
oracle developers tips
Oracle EBS AR
Oracle eBusiness Suite :R12-Cash management enhancements
Oracle ERP - Hierarchical BOM Query
oracle faq
ORACLE FINANCIAL ACCOUNTING HUB (FAH)
ORACLE FINANCIAL ACCOUNTING HUB (FAH)- PART 2
Oracle Financial Module
Oracle Forms
Oracle Fusion Cloud
Oracle HRMS – Some Important Tables
Oracle HRMS;
Oracle iExpense Report Tables with Policy Violation Details
Oracle iExpense Setups and Common issues
Oracle iExpenses flow
Oracle Inventory: Material status Control
Oracle Inventory(INV)
Oracle mutating trigger table errors
Oracle Notifications: How to Modify standard contend
oracle Order Management Line Status
Oracle P2P Accounting entries
Oracle Payable
oracle performance Tips
Oracle PL/SQL Important Topics
Oracle PL/SQL: Coalesce Function
Oracle Procedure to Search for a Particular String/Character
Oracle Property Manager Conversion
Oracle Purchase Order(PO)
Oracle Purchasing Approval Hierarchies
Oracle Purchasing Report Queries
Oracle Purchasing Tables
Oracle R12 AR Auto Lockbox Process
Oracle Receivables API for Cancelling Receipt
Oracle Receivables API for Invoice and Receipt Creation
Oracle Receivables Create Credit memo against Invoice
Oracle Report Triggers
Oracle Reporting Tools and types of Reports in oracle apps
Oracle Reports
Oracle SCM Functional Interview Questions: Inventory
Oracle SQL :Normalization
Oracle Workflow Most Frequently Used Queries
Oracle XML Publisher Report: An Invalid character was found in text content
Oracle XML Publisher Report: Number/Date format in Excel
OracleOrder to Cash tables: O2C tables
ORDER
Order by Clause
order by Item Name
order Delivery details query
Order details with Gl
Order Discount Detail Report
Order Entered
order management
Order Management - tables and links
ORDER MANAGEMENT ALL POSTS
Order Management Tables and its details
Order Management tables and links
order querey
order tables
Order to Cash Cycle Step by step hands on
Order to Cash full cycle and Techno-Functional flow in R12
Order_amount
Orders by Item Report
ORDERS WITH THE ITEM
OUTBOUND
Outbound Interface
Outbound Interface in oracle apps
OUTPUT POST PROCESSOR (OPP) LOG CONTAINS ERROR “JAVA.LANG.OUTOFMEMORYERROR”
Over Shipment Tolerance
Overview of Automatic Receipts and Remittance.
Overview of Menus and Function Security
Overview Of payable
P2P
p2p flow
p2p query
PA
package
packages
page numbers
Party
Payment Process Requests
payment tables
PENDING
Pending LCM Interface
Pending Material
Pending Receiving
PENDING SHIPPING TRANSACTIONS
Pending Shop Floor Move
Pending WIP Costing
Pending WSM Interface
Performance tuning
Performance tunings
Period End Process In Cash Management R12
Period Status(OPEN/CLOSE)
Pick Confirmed
PL/SQL Developer: Can't Connect to Database Error
PL/SQL Script to Generate XML Tags for XMLP Report
Please contact your System Administrator.
PLSGL
PLSQL
PLSQL interview Questions
PLSQl Interview Questions Part 1
PLSQl Interview Questions Part 2
PLSQl Interview Questions Part 3
PLSQl Interview Questions Part 4
PLSQL Collections
PLSQL ERRORS NULL VALUES
PLSQl Interview Questions
PLSQL Interview Questions And Answers
PLSQL: Procedural Structured Query Language
PO
PO Requisition and purchase order PO REQ link to PO
PO & INV SUBLEDGERS FROM ORACLE
PO and SO link
PO Approval Hierarchy Query -R12
PO Approval History Query in Oracle apps
Po Delete
PO Output for Communication Report
PO Position Hierarchy in Oracle Apps
po quantities
po query
PO Receipt
po receipts query
po scripts
po tables
PO TO GL LINK IN R12
PO to gl query
po to invoices query
po types
PO_DOCUMENT_CONTROL_PUB.CONTROL_DOCUMENT
po_headers_sv1.delete_po
PO_queries
Post QuickCash
PPR
PPR failure
PRAGMA
pragma autonomous_transaction real time example
pragmaAUTONOMOUS_TRANSACTION
prepayments and credit/debit memos.oracle reports
Primary Key
PRINT ORDERS BY CUSTOMER WISE
Printed Requisitions Report
Printer Setup
Printing Bar Code in Oracle Reports and XML Publisher Reports
Procedure
PROCEDURE AND FUNCTION
procedures
Process Flows
Procure to Pay Frequently Asked Questions
Profile Option Trace
Profile Option Values for Responsibility
PSEUDO COLUMNS
Purchase Order
Purchase order All Posts
Purchase Order Report
Purchase order salsesorder link r12
Purchasing Useful Scripts
Querey
QUERIES
QUERY
Query used to review the requisition
Query for find Concurrent Program Trace file Path Location in Oracle Apps
Query to Concurrent Program running and status checking with Parameters
QUERY TO CHECK CUSTOMER AND SUPPLIER DATA
Query to check Detailed Message of Error code code Given by API
QUERY TO CHECK PERIODS STATUS
Query to check Sales order Quantities ordered for an item in a given date range
Query to Compare Responsibility between users
Query to fetch Level -1 BOM : BOM:
Query to find invoices which are pending to be paid for more than 60 days invoices paid during past 6 months
Query to find a list of all the forms
Query to find all elements attached to employee in oracle apps
Query to find all the responsibility names from which we can run a particular concurrent program
Query to find AP Supplier Remittance Email Addresses
Query to find Application Short Name of a module
Query to find attachments of a contract
Query to find Bank details is R12
Query to find complete Supplier Details Bank
Query to find Concurrent job run time
Query to find Concurrent Program attached to Which Responsibility
Query to Find Concurrent Program Responsibility
Query to find Costing Error Date wise
Query to find customer site level contact points R12
Query to find detailed information regarding Locks in Oracle Database
Query to find DFF
Query to find few business groups
Query to find Form attached to Responsibility and users
QUERY TO FIND LIST OF RESPONSIBILITIES ASSIGNED TO A PARTICULAR USER
Query to find locks information in details | Oracle Databas
Query to find Oracle Alert
Query to find Organization information
Query to find out Responsibilities assigned to a user
Query to find Person and Position R12
Query to Find POs which not used Blanket Purchase Agreement
Query to find profile Option values using SQL
Query to Find Receipt Class
Query to find Requisitions Approval Pending
Query to find Templates details XML publisher reports
Query to find the Descriptive Flex Field (DFF) fields attached to a Context Code in Oracle APPS
Query to find the Owner name of the Table
Query to find the scheduled concurrent programs
Query to find the SQL_ID from SQL_TEXT | Oracle Database ;dba QUERIES;PERFORMANCE TUNING;sql_ID;sqL text ; v$sqlarea;Gv$sqlarea;
Query to find the SQL_ID from SQL_TEXT | Oracle Database ;dba QUERIES;PERFORMANCE TUNING;sql_ID;sqL text ; v$sqlarea;Gv$sqlarea; Useful scripts oracle Database;
Query to find the Tracefile using SID in Oracle Database
Query to Find the USername who locked the given table
Query to finde total Received Qty in Oracle apps R12
Query to get all menu names in oracle apps
Query to get AP Invoice lines Tax details in Oracle Fusion
Query to get Business Group
Query to get open invoices for customers R12
Query To Get PO Number
Query to Get Profile value at any level
Query to get Purchase Order and requisition in Oracle Fusion
Query to get the order and invoice details
Query to get WebADI Details in Oracle APPS
Query TO list all purchase document types IN oracle apps
query to list customer details
Query to list Freight From Discount Excluded Records in Oracle APPS
Query to retrieve KFF's in Oracle E-Business Suite
Query to retrieve Transaction
Query to retrieve Transaction & Receipt details.
Query which gives the joining between OM
Query;
r12
R12 assign same bank account to multiple suppliers
R12 E-Business Tax (EBTax) 'How To' documents [ID 580438.1]
R12 GL Drilldown to AR
R12 GL Drilldown to AR Functional
R12 INTERFACES
R12 multiorg
R12 party
r12 partyes
r12 receipt
r12 recepit
R12 scripts
R12 SQL Query to differentiate Customer and Suppliers Data
R12 Supplier/Site/Banking Drilldown
r12 suppliers
R12 tables
R12 TCA (TRADING COMMUNITY ARCHITECTURE)
R12 TDS
R12 Uploading a Journal using Web ADI
R12 Uploading a Journal using Web ADI : Step by Step
R12: AR to GL Query [For AR Transaction/Invoice] | Oracle
R12: Detailed Troubleshooting Guide For AUTOSELECT Issues: When PPR Does Not Select Expected Invoices
R2 PO and so link
racle Web ADI Integrator using Desktop Integration Framework GUI
rank
Rdf
Rdf Change
rdf report change
RDF triggers
Realtime Tickets
Receipt Conversion
Receipt Class and its GL Combination Query
receipt conversion
Receipt Creation
Receipt Status in Receivables
Receipts tables
Receivables R12
Receivables Setups In R12
Reconciled in Cash Management(R12)
Refcursor
References
Register executable from back end
Remittance Bank Account
Removing existing DFF
report
REPORT BULIDER PROBLEM
Report customization
Report Development steps
Report Development steps and registering and running in oracle application
Report modification
REPORT REGISTRATION STEPS
Report with input Parameters
Reports
repot bulider not working
Requisition
Responsibilities assigned to a specific user
responsibilities assigned to a use
Responsibilities not Visible on Home Page
Returns by Reason Report
RICE
RICE Components
Role of Technical Consultant
ROLLUP
ROWID
ROWNUM
Run-time error '1004': Method 'VBProject' of object '_Workbook' failed
SALES ORDER
Sales order conversion
SALES ORDER Quantities
SALES ORDER QUERIES
Sales order query
sales order Query R12
SALES ORDER R12
salesorder
SCIENCE
SCM ( Supply Chain Management )
Script to Monitor and tune Oracle Database
Security Rules In R12
select clause
Self Service Page trace
send email
Send Email Through PL/SQL code
Session Leve trace
SET OPERATORS
Setting Up Oracle Payables for Oracle Cash Management Integration
Setting Up Oracle Receivables for Oracle Cash Management Integration
Setting Up Tax Recovery Rates
shell script
shellscript
ship confirm
Ship Confirmed
shipping
shipping networks Query
Show Notepad++ tabs in multiple lines
Simple Food Menu XML File
site
site level contact points
SLA
Some Standard Oracle
Some Standard Oracle Apps Report Customization's
special
SPEL in OAF
spelling-games-vocabulary-games
SQL
SQL – PL SQL
sql date;
SQL Developer Tool
SQL FUNCTIONS
SQL INTRODUCTION
SQL Loader
SQL QUERIES
SQL Queries for checking Profile Option Values
SQL Query
SQL Trace and TKPROF
SQL Tuning
SQL_ID
sql*plus report
SQL/PLSQL ALL POSTS
Sqlerrors
SQLLoader
staging tables
Standards for Report Developments in Oracle Apps
Steps to allow other Users who having same Responsibility To view Your Output File
Steps to Migrate BI Publisher Reports to Production
stored procedure
Structure of OAF
Sub programs in pl/sql
Subledger Accounting
Subqueries
SUM
Supplier Conversion
suppliers
Suppliers in TCA - A dive into Vendor Tables in R12
Syntax
Syntax to develop the control file.
SYS ADMIN
SYSDATE
Table Register
table value set
Tables
Tables affected from Order to Cash in Oracle EBS
Tables and links
tables joins
tables oracle
tax address and accounting information
Tax Rates Has been defined
Tax Regime:
tca
TCA / Oracle Receivables
TCA ALL POSTS
Tca R12
TCL
TDS
TDS in Accounts Payable - India Localization
technical
Technical;Debugging
Template
The 37 best websites for learning a new skill
THE AFTERMATH OF COVID-19
The value assigned at Responsibility level and Responsibility Name If it is assigned to any resp
There Are No Valid Navigations For This Responsibility
Three Tier Architecture
TIME
TKPROF:How to read Tkprof
To find Responsibility we can run the concurrent Request
TO FIND PROMOTION/MODIFIER APPLIED ON AN ORDER:
to findout Executable
To Get Invoices not paid & partially paid
To get the Current time of the DB
To get the Profile option information at all
To get the time of the particular
TO PRINT CUSTOMER DATA IN SEPARATE PAGES
total invoice relevant to customer
Trading Community Architecture (TCA)
Transaction Interface Tables
Triggers
Triggers in Oracle Forms
Trip details
TROUBLESHOOTING: Tuning Slow Running Queries
Two Tier Architecture
Types of executables
Types of Natural Accounts in Accounting
Types of value sets
Unbooked Orders Detail Report
Uncosted Material/WSM
UNCOSTED WSM TRANSACTIONS
UNION
UNION ALL
Unique
unix basics
unix commands
Unix Shell Script For Oracle Apps
Unprocessed Material
UNSHIPPED ORDERS
use section break?
Useful Scripts Oracle Database
User profiles
Using UTL_FILE
UTILFILE-INBOUND
V$SESSION_WAIT
Validating Receipt Number
validations
value sets
Value sets Tables
Vendor contact Update API
Versions
VIEWS AND SEQUENCES
Web ADI
Web adi error
Web adi error 12.1.3
Web adi tables
Web-ADI Template Settings for Microsoft Excel
webadi
WEBADI ALL POSTS
WEBADI Common Issues
WEBADI Common Issues - Oracle EBS R1
webadi create document
Webadi step by step r12
What Are Standards for Report Developments in Oracler Apps?
What are Steps for Report Development in Apps?
What is IFRS
What is Multi Org?
What is SQL* Loader?
What is TCA
What is Value Sets? What are Types Of Value Sets?
Who Columns
Why is my hint ignored;Useful Scripts Oracle Database;
WIP
WIP)
WMS LPN Context
WMS LPN R12
Workflow
workflow mailer
WORKFLOW MAILER DEBUGGING
WORKFLOW MAILER DEBUGGING SCRIPT
Workflow Notifications to Users/Roles
Workflow Query
workflow status workflow activity_status
Working with Stored Procedures and Packages
WSH
XLA to GL
XLA_SUB_LEDGER
xml
xml bursting
XML Data Template
xml publisher
XML PUBLISHER ALL POSTS
Xml publisher Report
XML publisher reports (RTF) Check printing
XML publisher Tips
xml reports
XML sample file
Xml tmplate
xml tutorial
XXX is not a valid responsibility
XXX is not a valid responsibility for the current user. Please contact your System Administrator
z_party_contact_v2pub.create_org_contact - API to create a Contact person for an organization in Oracle TCA
Zoos

live

Weekly

Query to find complete Supplier Details Bank ,tax address and accounting information

Supplier with complete bank , tax and address details ap to ZX links AP to Gl link AP supplier to Bank link supplier with Tax codes...
Query to find Organization information ,Tables and links ,ORGANIZATION_ID BASED ON SHIP TO BRANCH PLANT

OU & ORG ID & ORG CODE & ORG NAME ================================== select OPERATING_UNIT,ORGANIZATION_ID,ORGANIZATION_CODE...
Query to retrieve Transaction & Receipt details. r12

Query to retrieve Transaction & Receipt details. SELECT rcta.trx_number transaction_number , haou1.name operating_unit , rct...
Gl to Ap Drill down Query R12, General ledger link to Account payables R12,AP To Gl

GL to AP Drilldown Query R12 also checkout GL to AR Drill down Query http://appserptechnical.blogspot.my/2015/08/gl-to-ar-drill-do...
Order Management Tables and its details

Order Management Tables and its details Order Management Tables. Entered oe_order_headers_all 1 record created in header...
Web-ADI Template Settings for Microsoft Excel

Web-ADI Template Settings for Microsoft Excel Often times, WebADI can be very confusing to work with. There are just too many issues...
AR to HZ Table Link

AR to HZ Table Link SELECT HP.PARTY_NAME CUSTOMER_NAME FROM HZ_PARTIES HP, RA_CUSTOMER_TRX_ALL RCTA, HZ_C...
How to improve blog performance

Improving the performance of a blog can involve a variety of strategies, including optimizing the website's technical infrastructure, im...
QUERY TO CHECK PERIODS STATUS (OPEN/CLOSE) FOR ALL MODULES

SELECT ROWID, (SELECT application_short_name FROM fnd_application fa WHERE fa.application_id = gps.application_id ) application...
PO to invoice Query PO to AP link

Purchase order to invoice SELECT poh.org_id "ORGANIZATION", poh.segment1 "PO NO", poh.creation_date &q...

Labels

QUERIES (43)
oracle apps (36)
ar (29)
IMPORTANT QUERIES (28)
PLSQL (27)
OM (25)
r12 (22)
SQL (19)
ar query (18)
GL (17)
PO (17)
AP (15)
oracle apps introduction (15)
APPS QUERIES (14)
CUSTOMER API (14)
INV (14)
apps (14)
Oracle apps Important Queries (13)
Workflow (12)
AOL (10)
Workflow Query (10)
AOL QUERIES (9)
Oracle Forms (9)
Rdf Change (9)
api (9)
rdf report change (9)
AR queries (8)
O2C (8)
PLSQL interview Questions (8)
Some Standard Oracle Apps Report Customization's (8)
po query (8)
OM QUERIES (7)
SALES ORDER (7)
apps quires (7)
oracle apps technical (7)
Alert (6)
CUSTOMER API (6)
ERP INTRODUCTION (6)
INV queries (6)
apps reports (6)
interview questions (6)
tca (6)
xml (6)
AME (5)
Account Payables All Posts (5)
Aol Objects (5)
Form Personalization (5)
Rdf (5)
Report customization (5)
Tca R12 (5)
Xml publisher Report (5)
hz (5)
xml publisher (5)
02c query (4)
API to Create a Customer Account (4)
AR Tables (4)
CM (4)
Cash Management (4)
Conversions (4)
EBIZ TAX (4)
INV_QUERIES (4)
Notepad++ tips (4)
PLSQL Interview Questions And Answers (4)
Procedure (4)
SQL Loader (4)
SQLLoader (4)
Useful Scripts Oracle Database (4)
ar receipt (4)
o2c query (4)
salesorder (4)
value sets (4)
Account Receivables (3)
BOM (3)
BULK COLLECT (3)
COVID19 (3)
Concurrent program (3)
Customer Conversion (3)
Functions (3)
GL QUERIES (3)
Interfaces (3)
MOAC (3)
OAF Forms Trace (3)
ORacle (3)
Oracle Apps Receivables (AR) Tables (3)
PLSQL: Procedural Structured Query Language (3)
R12 Uploading a Journal using Web ADI : Step by Step (3)
Reports (3)
SQL – PL SQL (3)
TCA / Oracle Receivables (3)
WSH (3)
Web ADI (3)
XLA_SUB_LEDGER (3)
XML Data Template (3)
ar to gl query in r12 (3)
oracle apps interview Questions (3)
staging tables (3)
webadi (3)
11I (2)
ALL QUERy (2)
AP to GL Link in oracle apps (2)
API to Create a Customer Profile (2)
APPS TABLES(PO (2)
APPS TECHNICAL (2)
AP_Queries (2)
AR Invoice Open Interface (2)
AUTOLOCK BOX CONCEPTS IN R12 (2)
Add Text at Start and End of Each Line Notepad++ (2)
Alert in Oracle Apps (2)
Apps Report Customization's (2)
AutoLock Box In R12 (2)
Automatic Receipts And Remittance In R12 (2)
Barcode with BI publisher report (2)
CUSTOMER CONVERSION IN ORACLE APPS R12 via API's - OVERVIEW (2)
Changing existing report (2)
Conversion Using API (2)
Create Accounting Program: (2)
Data Flow from AR to XLA to GL (2)
Date Functions (2)
Debugging an Internal Requisition which not turned to an Internal Sales Order (2)
Developer tips; Easy test editing ;Notepad++ (2)
Difference between 11i and R12 module wise (2)
Difference between Stored Procedure and Function (2)
Discounts (2)
E-Business Tax Notes -- R12 (2)
ERP (2)
Employee Details (2)
Enabling Notepad++ Dark Theme (2)
Explain Plan in Toad (2)
External tables: (2)
FORALL (2)
Firing Sequence Of Form triggers (2)
HZ_CUST_ACCOUNT_V2PUB.CREATE_CUST_ACCOUNT (2)
INNTERFACES (2)
Invoking SQL*Loader (2)
NVl (2)
Notepad++ (2)
O2C R12 (2)
O2c Tables R12 (2)
OAF (2)
OAF ALL POSTS (2)
OAF Importer commands;OAF (2)
OM TABLES (2)
OM flow (2)
OM links (2)
OM_Queries (2)
ORACLE APPLICATIONS TECHNICAL (2)
Oracle APPS Releated Queries (2)
Oracle BI Publisher (2)
Oracle Fusion Cloud (2)
Oracle Inventory(INV) (2)
Oracle iExpense Report Tables with Policy Violation Details (2)
Outbound Interface (2)
Overview of Menus and Function Security (2)
P2P (2)
PA (2)
PLSQl Interview Questions Part 1 (2)
PO_queries (2)
Pending WIP Costing (2)
Pending WSM Interface (2)
Performance tunings (2)
Pick Confirmed (2)
Procure to Pay Frequently Asked Questions (2)
Purchase Order (2)
QUERY (2)
Query to find AP Supplier Remittance Email Addresses (2)
R12 Supplier/Site/Banking Drilldown (2)
R12 TCA (TRADING COMMUNITY ARCHITECTURE) (2)
Receipt Status in Receivables (2)
SLA (2)
SQL Tuning (2)
SYSDATE (2)
Ship Confirmed (2)
WEBADI Common Issues (2)
WIP (2)
Web adi error (2)
Web-ADI Template Settings for Microsoft Excel (2)
XML publisher Tips (2)
cust name (2)
customer (2)
faq (2)
first (2)
iexpense (2)
important links (2)
indiaafter21days (2)
indiafightcovid19 (2)
invoice (2)
item conversion (2)
last (2)
links (2)
oracle developers tips (2)
order management (2)
package (2)
receipt conversion (2)
technical (2)
unix basics (2)
xml bursting (2)
xml tutorial (2)
"Do not close this window until processing completes" (1)
(HZ_CUSTOMER_PROFILE_V2PUB.CREATE_CUSTOMER_PROFILE (1)
(HZ_LOCATION_V2PUB.CREATE_LOCATION (1)
(HZ_PARTY_SITE_V2PUB.CREATE_PARTY_SITE) (1)
(LPN) (1)
-LINK BETWEEN po_headers_all AND oe_order_headers_all (1)
-Query to Check PO Quantities received for an item in a given date range (1)
.UNCOSTED MATERIAL (1)
.UNPROCESSED MATERIAL (1)
12 (1)
21days (1)
AGGREGATE FUNCTIONS (1)
AIM (1)
AIM Document List (1)
ALERTS Interview Questions and Answers in Oracle Apps (1)
AME ALL POSTS (1)
AND (1)
AOL : Valueset – A Beginner’s Guide (1)
AP Invoice Technical Details (1)
AP Invoice Technical Details with Functional Inputs (1)
AP Payment Administrator Setup in R12 (1)
AP Payment Testing in R12 (1)
AP Supplier Conversion Using API (1)
AP invoice to XLA link (1)
API HZ_CUST_ACCOUNT_V2PUB.CREATE_CUST_ACCT_RELATE (1)
API hz_party_v2pub.create_organization (1)
API to Create a Customer Site (1)
API to Create a Customer Site Use (1)
API to Create a Party Site (1)
API to Create a Party Site Use (1)
API to Create a Phone Number (Contacts) (1)
API to Update Customer Address in Oracle TCA R12 (1)
API to Update a Customer Account TCA R12 (1)
API to Update a Customer Account TCA R12 (HZ_CUST_ACCOUNT_V2PUB.UPDATE_CUST_ACCOUNT (1)
API to create Group (1)
API to create Party and Customer Account.HZ_CUST_ACCOUNT_V2PUB.CREATE_CUST_ACCOUNT (1)
API to create a Person Type Party and Customer Account (1)
API to create customer Addresses (1)
API to get the formatted contact details (1)
API to populate loc_id HZ_LOCATIONS (1)
API to update a Customer Account Relationship (1)
API to update a Customer Profile TCA R12 (1)
APPS ERP DOCUMENTS (1)
AP_EXPENSE_REPORT_HEADERS_ALL (1)
AP_VENDOR_PUB_PKG (1)
AR Adjustments to GL query (1)
AR INV Validations (1)
AR Invoice Mandatory Columns (1)
AR Invoice Query (1)
AR Receipt and Bank Statement Reconciliation oracle apps (1)
AR Receipts to GL (1)
AR Receipts to GL link in oracle R12 (1)
AR TO HZ LINK (1)
AR Transactions (1)
AR to GL Link (1)
AR_PAYMENTS_INTERFACEBranches (1)
AR_Queries (1)
AR_RECEIPT_API_PUB.CREATE_CASH (1)
AUTOTRACE Option in sqlplus (1)
Accessing Approval Management Engine (AME) (1)
Account Payable (1)
Account Payable flow (1)
Account Payables Tables (1)
Account Receivable All Posts (1)
Accounting Entries in Oracle Fusion Cloud Application (1)
Accrual Basis Accounting for Oracle Apps Beginners (1)
Accruals Query (1)
Accruals in R12 (1)
Action History on PO and REQ (1)
Add SubTotals for Selling Price and List Price (1)
Add customer name to Report (1)
Advance Pl/sql (1)
After R12 Clone: Consult the OPP service log for details (1)
Alerts In Oracle Apps (1)
All Workflow Related posts links (1)
Analyatic Fnuctions (1)
Analytic Functions (1)
Application Architecture Single Tier Architecture (1)
Applications Directory and File Types (1)
Applications Form Trace (1)
Assign Receipt method to Customer via API in Oracle Apps R12 (1)
Autoinvoice (1)
Autolockbox: Standard Oracle Receipt Rejection reasons (1)
Automatic Receipts (1)
Awaiting Shipping Query pICKED BUT NOT SHIPPED (1)
BAD File (1)
BASED ON MATERIAL TRANSACTIONS ACTIVE ORGANIZATION QUERY (1)
BETWEEN/NOTBETWEEN (1)
BIP Bursting (1)
BLANKET SALES AGREEMENT TABLES (1)
BOL (1)
BOM; OM (1)
Back order status (1)
Bank Statement Loader In R12 (1)
Bank Tables in Oracle apps r12 (1)
Bank model (1)
Bank-accounts-supplier-and-customer (1)
Basic Accounting (1)
Basic Troubleshooting (1)
Blanket Sales Order (1)
Bom Explosion Query (1)
Booked (1)
Booked and Saved (1)
Bored at Home (1)
Business life cycle (1)
CE (1)
CE BANKS (1)
COGS query R12 (1)
COST OF GOODS SOLD (1)
COUNT (1)
CREATING A SUPPLIER IN R12 (1)
CRM (1)
CUBE (1)
CURRVAL (1)
Cash Management ALL Posts (1)
Cash Management Setup Check List (1)
Cash Management: Cash Cycle (1)
Cash management: Manual reconciliation of Miscellaneous Transaction (1)
Checking Purchase Order Approval History for a specific member of (1)
Checking Requisition Approval History for a specific member of staff (1)
Checking order progress from back end.R12 (1)
Cogs Query oracle apps 12 (1)
Col Usages from specific table (1)
Compare two text files in Notepad++ (1)
Comparison between SAP and Oracle Apps (1)
Complete Order to Cash(O2C) Techno-Functional flow in R12 (1)
Complete flag and Customer name. (1)
Concurrent Executables (1)
Concurrent Program Definition Trace (1)
Concurrent Program/Request Scheduling (1)
Concurrent program Queries (1)
Concurrent request running longer (1)
Constraints (1)
Control file (1)
Control file with parameters (1)
Converting rows into columns using pivot function (1)
Core HR Basic Concepts (1)
Create New Custom Form Oracle Applications (1)
Create Party of type Organization in Oracle TCA (1)
Create XML Publisher report without RDF (1)
Create profile with the best plan- (1)
Creating Custom Webadi Template in Oracle Apps (1)
Creating First OAF Page In Project (1)
Creation of Set Of Books (1)
Credit Check Functionality in Order Management (1)
Cursor (1)
Customer Balance Revaluation Report (1)
Customer Bank Account Details Report XML Report (1)
Customer Import using API's (1)
Customer Information (1)
Customer Master Information (1)
Customer Tables (1)
D2k Interview Question (1)
DCL (1)
DDL (1)
DFF (1)
DML (1)
DOCUMENTS (1)
DQL (1)
DRILL DOWN FROM GL INTO AP (1)
DROPSHIP (1)
Data Definition (1)
Data File (1)
Data Flow from APto XLA to GL (1)
Dataloader (1)
Decode Functions (1)
Deferred COGS: How to use this feature of Oracle Apps R12 (1)
Define Bank And Bank (1)
Define Bank;Define Grants and Roles;Setups for Defining the Banks;Define Branch;Define Bank Account;Add Operating unit to your bank;Defining Internal Bank Accounts;Defining Customer Bank Accounts; (1)
Delete Concurrent Program from the Back-End (1)
Delivery line statuses (1)
Demonstration of XML bursting (1)
Developer tips (1)
Developing and Registering Procedures with Oracle Application (1)
Diff between 11i and R12 Apps Technical (1)
Difference Between NVL and NVL2 (1)
Difference between Case and Decode (1)
Difference between Party and Customer (1)
Difference between Valuesets and Lookups (1)
Difference between drop and truncate and delete (1)
Different Types of Tables in Oracle Apps (1)
Different types of LPN (licence plate number) Status in WMS module (1)
Discrepancy (1)
Distinct (1)
Document Sequence (1)
Documentsin Oracle Application (1)
Drop Ship Query Query Drop Ship Sales Order (1)
Dual Table (1)
Duplicate Shipments SQL Query SQL Query sql query to find duplicate shipments (1)
EB-Tax Setup Tables in Oracle APPS (1)
EBS LOGIN URL from database;How to find Oracle Applications Login URL from database (1)
ENABLE TRACE FOR CONCURRENT PROGRAMS IN ORACLE APPS R12 (1)
ENGLISH (1)
EXCEPTIONS (1)
EXECUTE IMMEDIATE (1)
Easy test editing (1)
Employee Conversion (1)
Employee Hierarchy Process (1)
Enable Diagnostics in Oracle apps (1)
Enable Personalization on OAF Page (1)
Enable SQL Trace in Oracle Apps R12 (1)
Enable/Disable the parameter field Dynamically in Oracle apps Concurrent Program (1)
End User Details (1)
Equi Join (1)
Error in Workflow ORA-04061: existing state of has been invalidated (1)
Europe Localization (1)
European Post-Install Steps (1)
Event Handling In Oracle Core Contracts (1)
Execution plan (1)
Expertenglishlanguagetraining (1)
FA (1)
FLEXFIELDS (1)
FND Debug log;debugging; (1)
FND Tables: Oracle Applications AOL Objects (1)
FNDLOAD Scripts (1)
FNDLOAD Upload and Download Commands For Different AOL Components (1)
FND_FORM_CUSTOM_RULE (1)
FND_GLOBAL.APPS_INITIALIZE in oracle applications (1)
FND_NEW_MESSAGES (1)
FUNCTIONAL MODULES Multi Orgs Multiple Organizations (1)
Financial Statement Generated Report (1)
Find Receipt based on PO Header_ID (1)
Find Table And View Objects Behind OAF Page (1)
Fixed Assets GL (1)
Flat file (1)
Flex-field Qualifiers and Segment Qualifiers - "Natural Account" (1)
Form Personalization: Create Journal Entry From Subledger Journal Entries Form In AP (1)
Forms Personalization (1)
Four Tier Architecture (1)
Function (1)
Function Not Available To This Responsibility. Change Responsibilities Or Contact Your System Administrator (1)
Function consultant (1)
Functional Components (1)
Fusion (1)
FusionBursting (1)
GENERAL (1)
GET FLEXFIELD DATA INTO REPORT (1)
GL Entries with AP Payments (1)
GL Entries with the AR Transaction (1)
GL Period Close (1)
GL_PERIOD_STATUSES (1)
GROUPING Functions and GROUPING SETS (1)
General Ledger (1)
General Ledger All Posts (1)
General Ledger – Basic Accounting Concept | General Ledger Account Types and Accounting formula (1)
German VAT for On-Account Receipts Report (1)
Germany localization (1)
Germany-Specific Setup and Processes; (1)
Gl to Ap Drilldown Query R12 (1)
Gl Report (1)
Gl to ar Drill down Query (1)
Group by clause (1)
HRMS (1)
HRMS Modules (1)
HR_EMPLOYEE_MIGRATION (1)
HZ_CONTACT_POINT_V2PUB.CREATE_CONTACT_POINT (1)
HZ_CUSTOMER_PROFILE_V2PUB.UPDATE_CUSTOMER_PROFILE (1)
HZ_CUST_ACCOUNT_SITE_V2PUB.CREATE_CUST_ACCT_SITE (1)
HZ_CUST_ACCOUNT_SITE_V2PUB.CREATE_CUST_SITE_USE (1)
HZ_CUST_ACCOUNT_V2PUB.UPDATE_CUST_ACCT_RELATE (1)
HZ_FORMAT_PHONE_V2PUB.PHONE_DISPLAY (1)
HZ_LOCATION_V2PUB.UPDATE_LOCATION (1)
HZ_PARTY_SITE_V2PUB.CREATE_PARTY_SITE_USE (1)
HZ_PARTY_V2PUB.CREATE_GROUP (1)
HZ_TAX_ASSIGNMENT_V2PUB. CREATE_LOC_ASSIGNMENT (1)
Handling Exceptions in Bulk Operations (1)
Having clause (1)
Hierarchical Queries - Start with Connect by (1)
Hold Release (1)
How Do You Turn Off Or Disable Tax Calculation In R12 E-Business Tax (EBTax) (1)
How To Define Customize Web ADI Layout In R12 (1)
How To Restrict A Customer To Create Foreign Currency Transaction In Transaction Workbench (1)
How To Upload AP Invoices Using Oracle WebADI Custom Integrator (1)
How To Void Confirmed Payment Batch In R12 Under Payment Manager (1)
How the start with CONNECT BY clause in Oracle works (1)
How to Create Responsibility in Oracle Apps (1)
How to Develop Report with out Parameters? (1)
How to Display Leading Zeros in XMLP Report (1)
How to Generate a Useful SQL Execution Plan (1)
How to Implement User Profiles? (1)
How to Migrate/Transfer Workflow/Custom business events (1)
How to Run the SQL script from the Concurrent Program? (1)
How to change HR Workflow Notification approvals In AME for SSHR. (1)
How to check total outstanding you need to pay to a Supplier (1)
How to check workflow status from backend (1)
How to enable Oracle apps Diagnostics (1)
How to enable trace for a USER session (1)
How to find the Package associated with A WEBADI Integrator (1)
How to find the Tracefile using SID in Oracle (1)
How to join GL tables with XLA (SubLedger Accounting) tables (1)
How to open Periods in Oracle Apps (1)
How to print multi layouts multi currency multi language in xml publisher (1)
How to submit XML Report using a PL/SQL Script (1)
How to submit the concurrent request from shell scripts (1)
How to survive (and even thrive) during lockdown with kids (1)
How to update EBS XML Publisher Temporary Directory (1)
How to use Case and DECODE function??? (1)
How to view Customer Bank Account Details (1)
How to view other user output file in application (1)
IBY_EXT_BANK_ACCOUNTS (1)
IDS BUSY (1)
IMPORTANT SQL QUERIES (1)
IN/NOTIN (1)
INCOMPLETE INVOICES REPORT (1)
INDEX: (1)
INDIA LOCKDOWN (1)
INSTEAD OF triggers (1)
INTERFACE TABLES (1)
INTERSECTION (1)
INV period closing Queries (1)
INV period closing Queries (1)
INV period closing details all in one Query (1)
IProcurement (1)
IS (1)
Identifying Duplicate Shipments (1)
Important Base tables all modules GL (1)
Inbound Interface (1)
Incomplete Bank Statements SQL Query (1)
Incomplete Invoice Report (1)
Incomplete Work Orders (1)
India localization (1)
Insert Script for Open AR Transaction (Credit Memo) for R12 (1)
Insert Script for Open AR Transaction (Invoice) for R12 (1)
Insert Script for Standard POs (1)
Inserting XML Data Type (1)
Integration of Oracle Apps Modules (1)
Integration of base product schema by using APPS schema (1)
Interface Trip Stop Functionality (1)
Interview questions FAQ Oracle apps r12 and PLSQL (1)
Inv quantity; (1)
Inv to gl Link Query R12 (1)
Inventory interview questions (1)
Invoice Aging Report (1)
Invoice History Report (1)
Invoice Number and Receipt Number With one of the Input (1)
Invoice Validated (1)
Invoices not picked by PPR (1)
Item Conversion Update (1)
Item Interface (1)
Items On Hand Qty (1)
JOINS (1)
Join between OM (1)
Joins between OM and AR (1)
Journal Import in GL (1)
Journal Posting Issue and resolution (1)
Journal reversal in GL (1)
KIDS ACTIVITIES (1)
Key Flex Fields (1)
LIKE/NOT LIKE (1)
LPN (1)
LTOM (1)
Learn to avoid the mutating table problem in Oracle (1)
Legal Entity Name (1)
Lexical Parameters (1)
License Plate Number (1)
Life Cycle of Business (1)
Link Between AP and GL with XLA tables in R12 (1)
Link Between AR and GL with XLA tables (1)
Link Between Transaction Number and Receipt Number in AR (1)
List of Orders which are pick released on Sysdate (1)
Lockbox (1)
Longreunning sql; tuning;performance ; (1)
Lookup (1)
MATHS (1)
MAX (1)
MBOL (1)
MIN (1)
MINUS (1)
MO: Security Option (1)
MOAC: Multi-Org Access Control (1)
Material Transactions Query (1)
Message_text (1)
Miscellaneous Metalink Performance Articles (1)
Modification of Oracle Java mailer (1)
Monitor/Restart/Bounce Workflow Agent Listener (1)
Month end close (1)
Multi-Org Access Control (1)
Multiple Organizations in Oracle Application (1)
Museums (1)
Mutating Table Exceptions (1)
Mutating table error (1)
NEXTVAL (1)
NOCOPY (1)
NUMBER AND CHARACTER FUNCTIONS (1)
NVL2 (1)
Not Null (1)
Notify when SO is booked or new line is entered on booked order (1)
O2C full cycle in oracle R12 (1)
OAF Apache Bounce Steps in R12.2 (1)
OAF INTRODUCTION (1)
OAF Interview Questions (1)
OE_PRICE_ADJUSTMENT (1)
OFSAA – Oracle Financial Services Analytical Application Installation Overview (1)
OM Link AR (1)
OM Query (1)
OM Related queries Oracle Apps BOM Tables and Queries (1)
OM TO GL query (1)
OM to GL Drill Down Query (1)
OM to GL links (1)
OM: Over Shipment Tolerance (1)
OR (1)
ORA-01732 (1)
ORA-erreros (1)
ORACLE APPLICATIONS TECHNICAL INTRODUCTION (1)
ORACLE FINANCIAL ACCOUNTING HUB (FAH) (1)
ORACLE FINANCIAL ACCOUNTING HUB (FAH)- PART 2 (1)
ORDER (1)
ORDER MANAGEMENT ALL POSTS (1)
ORDERS WITH THE ITEM (1)
OUTBOUND (1)
OUTPUT POST PROCESSOR (OPP) LOG CONTAINS ERROR “JAVA.LANG.OUTOFMEMORYERROR” (1)
On Delete Cascade (1)
Onhand quantity (1)
Open Notifications - PO (1)
Open Notifications - Req (1)
Operating Unit Details (1)
Operators (1)
Oracle 12i - How to create accounting and transfer JE's to GL using SLA (1)
Oracle APPS Forms:Zoom functionality (1)
Oracle Account Payables(AP) (1)
Oracle Alert - Basics (1)
Oracle Application Framework (OAF) Tutorials (1)
Oracle Applications : Forms :Query Find window (1)
Oracle Applications :OUM and AIM (1)
Oracle Applications :Oracle Unified Methodology (OUM) (1)
Oracle Applications Concurrent Request phase codes and status codes (1)
Oracle Applications Modules List: (1)
Oracle Apps Interview Questions (1)
Oracle Apps Credit Card: Process in iExpense and Payables (1)
Oracle Apps Forms Basics (1)
Oracle Apps Inventory Accounts: Inventory Accounts and their Description (1)
Oracle Apps R12 Subledger Accounting Tables and joins (1)
Oracle Apps Receivables Accounting entries (1)
Oracle Apps TCA Tables (1)
Oracle Apps XML Interface design Considerations (1)
Oracle Apps XML Interface: Design (1)
Oracle Apps file Architecture (1)
Oracle Apps: Balance Sheet and Profit and Loss Reports (1)
Oracle Apps: Forms Personalization Tables (1)
Oracle Apps: Kill a Locked session through Toad (1)
Oracle Apps: LDT Commands (1)
Oracle Apps: Payables Table structure (1)
Oracle Apps: R12 Payment Document Setup (1)
Oracle Apps: Working with Oracle Forms (1)
Oracle Apps;Desktop Integration Manager;Desktop Integrator (1)
Oracle BI Publishe (1)
Oracle BI Publisher Interview Questions (1)
Oracle Cash Management (1)
Oracle Cash Management Introduction (1)
Oracle Cash Management Setups (1)
Oracle Cursor Basics (1)
Oracle Database Administration(DBA) (1)
Oracle EBS AR (1)
Oracle ERP - Hierarchical BOM Query (1)
Oracle Financial Module (1)
Oracle HRMS – Some Important Tables (1)
Oracle HRMS; (1)
Oracle Inventory: Material status Control (1)
Oracle Notifications: How to Modify standard contend (1)
Oracle P2P Accounting entries (1)
Oracle PL/SQL Important Topics (1)
Oracle PL/SQL: Coalesce Function (1)
Oracle Payable (1)
Oracle Procedure to Search for a Particular String/Character (1)
Oracle Property Manager Conversion (1)
Oracle Purchase Order(PO) (1)
Oracle Purchasing Approval Hierarchies (1)
Oracle Purchasing Report Queries (1)
Oracle Purchasing Tables (1)
Oracle R12 AR Auto Lockbox Process (1)
Oracle Receivables API for Cancelling Receipt (1)
Oracle Receivables API for Invoice and Receipt Creation (1)
Oracle Receivables Create Credit memo against Invoice (1)
Oracle Report Triggers (1)
Oracle Reporting Tools and types of Reports in oracle apps (1)
Oracle Reports (1)
Oracle SCM Functional Interview Questions: Inventory (1)
Oracle SQL :Normalization (1)
Oracle Workflow Most Frequently Used Queries (1)
Oracle XML Publisher Report: An Invalid character was found in text content (1)
Oracle XML Publisher Report: Number/Date format in Excel (1)
Oracle apps Complete links Module wise (1)
Oracle apps Documantation (1)
Oracle apps Topic wise links (1)
Oracle apps discounts (1)
Oracle apps r12 invoiced quantity variance with the ordered quantity (1)
Oracle eBusiness Suite :R12-Cash management enhancements (1)
Oracle iExpense Setups and Common issues (1)
Oracle iExpenses flow (1)
Oracle mutating trigger table errors (1)
OracleOrder to Cash tables: O2C tables (1)
Order Discount Detail Report (1)
Order Entered (1)
Order Management - tables and links (1)
Order Management Tables and its details (1)
Order Management tables and links (1)
Order by Clause (1)
Order details with Gl (1)
Order to Cash Cycle Step by step hands on (1)
Order to Cash full cycle and Techno-Functional flow in R12 (1)
Order_amount (1)
Orders by Item Report (1)
Outbound Interface in oracle apps (1)
Over Shipment Tolerance (1)
Overview Of payable (1)
Overview of Automatic Receipts and Remittance. (1)
PENDING (1)
PENDING SHIPPING TRANSACTIONS (1)
PL/SQL Developer: Can't Connect to Database Error (1)
PL/SQL Script to Generate XML Tags for XMLP Report (1)
PLSGL (1)
PLSQL Collections (1)
PLSQL ERRORS NULL VALUES (1)
PLSQl Interview Questions Part 2 (1)
PLSQl Interview Questions Part 3 (1)
PLSQl Interview Questions Part 4 (1)
PLSQl Interview Questions (1)
PO Requisition and purchase order PO REQ link to PO (1)
PO & INV SUBLEDGERS FROM ORACLE (1)
PO Approval Hierarchy Query -R12 (1)
PO Approval History Query in Oracle apps (1)
PO Output for Communication Report (1)
PO Position Hierarchy in Oracle Apps (1)
PO Receipt (1)
PO TO GL LINK IN R12 (1)
PO and SO link (1)
PO to gl query (1)
PO_DOCUMENT_CONTROL_PUB.CONTROL_DOCUMENT (1)
PPR (1)
PPR failure (1)
PRAGMA (1)
PRINT ORDERS BY CUSTOMER WISE (1)
PROCEDURE AND FUNCTION (1)
PSEUDO COLUMNS (1)
Party (1)
Payment Process Requests (1)
Pending LCM Interface (1)
Pending Material (1)
Pending Receiving (1)
Pending Shop Floor Move (1)
Performance tuning (1)
Period End Process In Cash Management R12 (1)
Period Status(OPEN/CLOSE) (1)
Please contact your System Administrator. (1)
Po Delete (1)
Post QuickCash (1)
Primary Key (1)
Printed Requisitions Report (1)
Printer Setup (1)
Printing Bar Code in Oracle Reports and XML Publisher Reports (1)
Process Flows (1)
Profile Option Trace (1)
Profile Option Values for Responsibility (1)
Purchase Order Report (1)
Purchase order All Posts (1)
Purchase order salsesorder link r12 (1)
Purchasing Useful Scripts (1)
QUERY TO CHECK CUSTOMER AND SUPPLIER DATA (1)
QUERY TO CHECK PERIODS STATUS (1)
QUERY TO FIND LIST OF RESPONSIBILITIES ASSIGNED TO A PARTICULAR USER (1)
Querey (1)
Query used to review the requisition (1)
Query TO list all purchase document types IN oracle apps (1)
Query To Get PO Number (1)
Query for find Concurrent Program Trace file Path Location in Oracle Apps (1)
Query to Concurrent Program running and status checking with Parameters (1)
Query to Compare Responsibility between users (1)
Query to Find Concurrent Program Responsibility (1)
Query to Find POs which not used Blanket Purchase Agreement (1)
Query to Find Receipt Class (1)
Query to Find the USername who locked the given table (1)
Query to Get Profile value at any level (1)
Query to check Detailed Message of Error code code Given by API (1)
Query to check Sales order Quantities ordered for an item in a given date range (1)
Query to fetch Level -1 BOM : BOM: (1)
Query to find invoices which are pending to be paid for more than 60 days invoices paid during past 6 months (1)
Query to find Application Short Name of a module (1)
Query to find Bank details is R12 (1)
Query to find Concurrent Program attached to Which Responsibility (1)
Query to find Concurrent job run time (1)
Query to find Costing Error Date wise (1)
Query to find DFF (1)
Query to find Form attached to Responsibility and users (1)
Query to find Oracle Alert (1)
Query to find Organization information (1)
Query to find Person and Position R12 (1)
Query to find Requisitions Approval Pending (1)
Query to find Templates details XML publisher reports (1)
Query to find a list of all the forms (1)
Query to find all elements attached to employee in oracle apps (1)
Query to find all the responsibility names from which we can run a particular concurrent program (1)
Query to find attachments of a contract (1)
Query to find complete Supplier Details Bank (1)
Query to find customer site level contact points R12 (1)
Query to find detailed information regarding Locks in Oracle Database (1)
Query to find few business groups (1)
Query to find locks information in details | Oracle Databas (1)
Query to find out Responsibilities assigned to a user (1)
Query to find profile Option values using SQL (1)
Query to find the Descriptive Flex Field (DFF) fields attached to a Context Code in Oracle APPS (1)
Query to find the Owner name of the Table (1)
Query to find the SQL_ID from SQL_TEXT | Oracle Database ;dba QUERIES;PERFORMANCE TUNING;sql_ID;sqL text ; v$sqlarea;Gv$sqlarea; (1)
Query to find the SQL_ID from SQL_TEXT | Oracle Database ;dba QUERIES;PERFORMANCE TUNING;sql_ID;sqL text ; v$sqlarea;Gv$sqlarea; Useful scripts oracle Database; (1)
Query to find the Tracefile using SID in Oracle Database (1)
Query to find the scheduled concurrent programs (1)
Query to finde total Received Qty in Oracle apps R12 (1)
Query to get AP Invoice lines Tax details in Oracle Fusion (1)
Query to get Business Group (1)
Query to get Purchase Order and requisition in Oracle Fusion (1)
Query to get WebADI Details in Oracle APPS (1)
Query to get all menu names in oracle apps (1)
Query to get open invoices for customers R12 (1)
Query to get the order and invoice details (1)
Query to list Freight From Discount Excluded Records in Oracle APPS (1)
Query to retrieve KFF's in Oracle E-Business Suite (1)
Query to retrieve Transaction (1)
Query to retrieve Transaction & Receipt details. (1)
Query which gives the joining between OM (1)
Query; (1)
R12 E-Business Tax (EBTax) 'How To' documents [ID 580438.1] (1)
R12 GL Drilldown to AR (1)
R12 GL Drilldown to AR Functional (1)
R12 INTERFACES (1)
R12 SQL Query to differentiate Customer and Suppliers Data (1)
R12 TDS (1)
R12 Uploading a Journal using Web ADI (1)
R12 assign same bank account to multiple suppliers (1)
R12 multiorg (1)
R12 party (1)
R12 scripts (1)
R12 tables (1)
R12: AR to GL Query [For AR Transaction/Invoice] | Oracle (1)
R12: Detailed Troubleshooting Guide For AUTOSELECT Issues: When PPR Does Not Select Expected Invoices (1)
R2 PO and so link (1)
RDF triggers (1)
REPORT BULIDER PROBLEM (1)
REPORT REGISTRATION STEPS (1)
RICE (1)
RICE Components (1)
ROLLUP (1)
ROWID (1)
ROWNUM (1)
Realtime Tickets (1)
Receipt Conversion (1)
Receipt Class and its GL Combination Query (1)
Receipt Creation (1)
Receipts tables (1)
Receivables R12 (1)
Receivables Setups In R12 (1)
Reconciled in Cash Management(R12) (1)
Refcursor (1)
References (1)
Register executable from back end (1)
Remittance Bank Account (1)
Removing existing DFF (1)
Report Development steps (1)
Report Development steps and registering and running in oracle application (1)
Report modification (1)
Report with input Parameters (1)
Requisition (1)
Responsibilities assigned to a specific user (1)
Responsibilities not Visible on Home Page (1)
Returns by Reason Report (1)
Role of Technical Consultant (1)
Run-time error '1004': Method 'VBProject' of object '_Workbook' failed (1)
SALES ORDER QUERIES (1)
SALES ORDER Quantities (1)
SALES ORDER R12 (1)
SCIENCE (1)
SCM ( Supply Chain Management ) (1)
SET OPERATORS (1)
SPEL in OAF (1)
SQL Developer Tool (1)
SQL FUNCTIONS (1)
SQL INTRODUCTION (1)
SQL QUERIES (1)
SQL Queries for checking Profile Option Values (1)
SQL Query (1)
SQL Trace and TKPROF (1)
SQL/PLSQL ALL POSTS (1)
SQL_ID (1)
SUM (1)
SYS ADMIN (1)
Sales order conversion (1)
Sales order query (1)
Script to Monitor and tune Oracle Database (1)
Security Rules In R12 (1)
Self Service Page trace (1)
Send Email Through PL/SQL code (1)
Session Leve trace (1)
Setting Up Oracle Payables for Oracle Cash Management Integration (1)
Setting Up Oracle Receivables for Oracle Cash Management Integration (1)
Setting Up Tax Recovery Rates (1)
Show Notepad++ tabs in multiple lines (1)
Simple Food Menu XML File (1)
Some Standard Oracle (1)
Sqlerrors (1)
Standards for Report Developments in Oracle Apps (1)
Steps to Migrate BI Publisher Reports to Production (1)
Steps to allow other Users who having same Responsibility To view Your Output File (1)
Structure of OAF (1)
Sub programs in pl/sql (1)
Subledger Accounting (1)
Subqueries (1)
Supplier Conversion (1)
Suppliers in TCA - A dive into Vendor Tables in R12 (1)
Syntax (1)
Syntax to develop the control file. (1)
TCA ALL POSTS (1)
TCL (1)
TDS (1)
TDS in Accounts Payable - India Localization (1)
THE AFTERMATH OF COVID-19 (1)
TIME (1)
TKPROF:How to read Tkprof (1)
TO FIND PROMOTION/MODIFIER APPLIED ON AN ORDER: (1)
TO PRINT CUSTOMER DATA IN SEPARATE PAGES (1)
TROUBLESHOOTING: Tuning Slow Running Queries (1)
Table Register (1)
Tables (1)
Tables affected from Order to Cash in Oracle EBS (1)
Tables and links (1)
Tax Rates Has been defined (1)
Tax Regime: (1)
Technical;Debugging (1)
Template (1)
The 37 best websites for learning a new skill (1)
The value assigned at Responsibility level and Responsibility Name If it is assigned to any resp (1)
There Are No Valid Navigations For This Responsibility (1)
Three Tier Architecture (1)
To Get Invoices not paid & partially paid (1)
To find Responsibility we can run the concurrent Request (1)
To get the Current time of the DB (1)
To get the Profile option information at all (1)
To get the time of the particular (1)
Trading Community Architecture (TCA) (1)
Transaction Interface Tables (1)
Triggers (1)
Triggers in Oracle Forms (1)
Trip details (1)
Two Tier Architecture (1)
Types of Natural Accounts in Accounting (1)
Types of executables (1)
Types of value sets (1)
UNCOSTED WSM TRANSACTIONS (1)
UNION (1)
UNION ALL (1)
UNSHIPPED ORDERS (1)
UTILFILE-INBOUND (1)
Unbooked Orders Detail Report (1)
Uncosted Material/WSM (1)
Unique (1)
Unix Shell Script For Oracle Apps (1)
Unprocessed Material (1)
User profiles (1)
Using UTL_FILE (1)
V$SESSION_WAIT (1)
VIEWS AND SEQUENCES (1)
Validating Receipt Number (1)
Value sets Tables (1)
Vendor contact Update API (1)
Versions (1)
WEBADI ALL POSTS (1)
WEBADI Common Issues - Oracle EBS R1 (1)
WIP) (1)
WMS LPN Context (1)
WMS LPN R12 (1)
WORKFLOW MAILER DEBUGGING (1)
WORKFLOW MAILER DEBUGGING SCRIPT (1)
Web adi error 12.1.3 (1)
Web adi tables (1)
Webadi step by step r12 (1)
What Are Standards for Report Developments in Oracler Apps? (1)
What are Steps for Report Development in Apps? (1)
What is IFRS (1)
What is Multi Org? (1)
What is SQL* Loader? (1)
What is TCA (1)
What is Value Sets? What are Types Of Value Sets? (1)
Who Columns (1)
Why is my hint ignored;Useful Scripts Oracle Database; (1)
Workflow Notifications to Users/Roles (1)
Working with Stored Procedures and Packages (1)
XLA to GL (1)
XML PUBLISHER ALL POSTS (1)
XML publisher reports (RTF) Check printing (1)
XML sample file (1)
XXX is not a valid responsibility (1)
XXX is not a valid responsibility for the current user. Please contact your System Administrator (1)
Xml tmplate (1)
Zoos (1)
account receivable Setup Payment Terms (1)
add a field ITEM_TYPE_CODE (1)
after lockdown (1)
after21days (1)
all the users who have access to a responsibility (1)
amount (1)
and Theme Parks Offering Virtual Tours (1)
and forall (1)
and its Parameters information (1)
and receipt number (1)
ap Queries (1)
apps ap tables (1)
apps.bne_contents_b bcb (1)
apps.bne_contents_tl ct (1)
apps.bne_integrators_tl bit (1)
apps.fnd_program.executable Queries (1)
apps.fnd_program.register (1)
ar receipt QUERIES (1)
attachments (1)
bank query (1)
banking (1)
banktables (1)
billing (1)
break the page (1)
checking Profile Option (1)
cience-experiments-and-activities (1)
code to Convert column to row (1)
communication details (1)
concurrent program from back end (1)
concurrent program schedules ; requestset schedules ;oracle apps r12; application developer ;fnd_concurrent_requests ;concurrent_program;Check Periodic Alert'; (1)
connect by (1)
costing errors (1)
course (1)
covid19india (1)
creditcard sale order queries (1)
current date (1)
currentdate (1)
cursors (1)
cust no (1)
customer discounts (1)
customer invoice details (1)
customer phone number (1)
customer query (1)
data manipulation operation not legal on this view (1)
date of invoice (1)
dense_rank (1)
denserank (1)
dependent (1)
discount grace days (1)
eading zeros truncated for excel report (1)
email procedure (1)
enable macros (1)
experience (1)
explain plan (1)
fnd load (1)
form (1)
form triggers (1)
format numbers as text (1)
forms (1)
geography's without Jurisdiction's in oracle apps eb-tax (1)
get the invoices and order details (1)
grace days (1)
group functions and joins (1)
history tables (1)
how to create report in oracle apps and run (1)
hz_payment_method_pub.create_payment_method (1)
iExpenses Table (1)
iProcurement Setup Document and it's basic flows in R12.2 (1)
in XMLP? (1)
in oracle apps r12 (1)
in specific condition? (1)
independent (1)
ink inventory material transaction with GL journal entry. Gl inv link (1)
interim tables (1)
introduction (1)
inventory organizations for an operating unit (1)
invoice no (1)
invoice_amount oracle apps r12 sql query to find order amount (1)
item conversions (1)
item query (1)
joining between OM (1)
joins between various tables in Internal Sales order (ISO) (1)
last page (1)
layout in the backend (1)
learninggamesforkids (1)
line and qualifier at header level in R12 (1)
link Between per_all_people and per_all_positions (1)
link between IBY and HZ (1)
link between sales order and purchase order in Oracle apps r12 (1)
lockdown (1)
migration (1)
modifier and qualifier using API in R12 (1)
modifier header (1)
modilockdown (1)
multi layouts (1)
multiple orgs (1)
o2c apps R12 (1)
o2c functional flow (1)
o2c query r12 (1)
om conversions (1)
oracl faq (1)
oracle Order Management Line Status (1)
oracle apps Querys (1)
oracle apps interviewQuestions (1)
oracle apps shortcut keys (1)
oracle faq (1)
oracle performance Tips (1)
order Delivery details query (1)
order by Item Name (1)
order querey (1)
order tables (1)
p2p flow (1)
p2p query (1)
packages (1)
page numbers (1)
payment tables (1)
po quantities (1)
po receipts query (1)
po scripts (1)
po tables (1)
po to invoices query (1)
po types (1)
po_headers_sv1.delete_po (1)
pragma autonomous_transaction real time example (1)
pragmaAUTONOMOUS_TRANSACTION (1)
prepayments and credit/debit memos.oracle reports (1)
procedures (1)
query to list customer details (1)
r12 partyes (1)
r12 receipt (1)
r12 recepit (1)
r12 suppliers (1)
racle Web ADI Integrator using Desktop Integration Framework GUI (1)
rank (1)
report (1)
repot bulider not working (1)
responsibilities assigned to a use (1)
sales order Query R12 (1)
select clause (1)
send email (1)
shell script (1)
shellscript (1)
ship confirm (1)
shipping (1)
shipping networks Query (1)
site (1)
site level contact points (1)
special (1)
spelling-games-vocabulary-games (1)
sql date; (1)
sql*plus report (1)
stored procedure (1)
suppliers (1)
table value set (1)
tables joins (1)
tables oracle (1)
tax address and accounting information (1)
to findout Executable (1)
total invoice relevant to customer (1)
unix commands (1)
use section break? (1)
validations (1)
webadi create document (1)
workflow mailer (1)
workflow status workflow activity_status (1)
xml reports (1)
z_party_contact_v2pub.create_org_contact - API to create a Contact person for an organization in Oracle TCA (1)
‘Initialization SQL Statement – Custom’ ( FND_INIT_SQL ); (1)
“TKProf Basic OverviewPerformance Tools Quick Reference Guide” (1)

Blog Archive

► 2024 (2)
- ► May (2)

► 2023 (1)
- ► March (1)

► 2022 (105)
- ► October (8)
- ► February (12)
- ► January (85)

► 2021 (24)
- ► May (18)
- ► April (5)
- ► March (1)

► 2020 (20)
- ► May (8)
- ► April (10)
- ► March (2)

► 2019 (15)
- ► December (14)
- ► March (1)

► 2018 (19)
- ► October (1)
- ► June (1)
- ► May (2)
- ► April (1)
- ► March (14)

▼ 2017 (155)
- ► November (5)
- ► August (2)
- ► July (3)
- ► May (3)
- ► March (4)
- ► February (26)
- ▼ January (112)

► 2016 (283)
- ► December (8)
- ► November (7)
- ► October (2)
- ► September (6)
- ► August (4)
- ► July (81)
- ► May (6)
- ► April (23)
- ► March (134)
- ► February (10)
- ► January (2)

► 2015 (19)
- ► November (3)
- ► August (2)
- ► July (4)
- ► April (7)
- ► March (3)

► 2014 (63)
- ► December (3)
- ► November (3)
- ► October (2)
- ► July (4)
- ► June (6)
- ► May (18)
- ► April (13)
- ► March (6)
- ► February (8)

Categories

-LINK BETWEEN po_headers_all AND oe_order_headers_all
-Query to Check PO Quantities received for an item in a given date range
.UNCOSTED MATERIAL
.UNPROCESSED MATERIAL
‘Initialization SQL Statement – Custom’ ( FND_INIT_SQL );
"Do not close this window until processing completes"
“TKProf Basic OverviewPerformance Tools Quick Reference Guide”
(HZ_CUSTOMER_PROFILE_V2PUB.CREATE_CUSTOMER_PROFILE
(HZ_LOCATION_V2PUB.CREATE_LOCATION
(HZ_PARTY_SITE_V2PUB.CREATE_PARTY_SITE)
(LPN)
02c query
11I
12
21days
Accessing Approval Management Engine (AME)
Account Payable
Account Payable flow
Account Payables All Posts
Account Payables Tables
Account Receivable All Posts
account receivable Setup Payment Terms
Account Receivables
Accounting Entries in Oracle Fusion Cloud Application
Accrual Basis Accounting for Oracle Apps Beginners
Accruals in R12
Accruals Query
Action History on PO and REQ
add a field ITEM_TYPE_CODE
Add customer name to Report
Add SubTotals for Selling Price and List Price
Add Text at Start and End of Each Line Notepad++
Advance Pl/sql
after lockdown
After R12 Clone: Consult the OPP service log for details
after21days
AGGREGATE FUNCTIONS
AIM
AIM Document List
Alert
Alert in Oracle Apps
Alerts In Oracle Apps
ALERTS Interview Questions and Answers in Oracle Apps
ALL QUERy
all the users who have access to a responsibility
All Workflow Related posts links
AME
AME ALL POSTS
amount
Analyatic Fnuctions
Analytic Functions
AND
and forall
and its Parameters information
and receipt number
and Theme Parks Offering Virtual Tours
AOL
AOL : Valueset – A Beginner’s Guide
Aol Objects
AOL QUERIES
AP
AP Invoice Technical Details
AP Invoice Technical Details with Functional Inputs
AP invoice to XLA link
AP Payment Administrator Setup in R12
AP Payment Testing in R12
ap Queries
AP Supplier Conversion Using API
AP to GL Link in oracle apps
AP_EXPENSE_REPORT_HEADERS_ALL
AP_Queries
AP_VENDOR_PUB_PKG
api
API HZ_CUST_ACCOUNT_V2PUB.CREATE_CUST_ACCT_RELATE
API hz_party_v2pub.create_organization
API to Create a Customer Account
API to Create a Customer Profile
API to Create a Customer Site
API to Create a Customer Site Use
API to Create a Party Site
API to Create a Party Site Use
API to create a Person Type Party and Customer Account
API to Create a Phone Number (Contacts)
API to create customer Addresses
API to create Group
API to create Party and Customer Account.HZ_CUST_ACCOUNT_V2PUB.CREATE_CUST_ACCOUNT
API to get the formatted contact details
API to populate loc_id HZ_LOCATIONS
API to update a Customer Account Relationship
API to Update a Customer Account TCA R12
API to Update a Customer Account TCA R12 (HZ_CUST_ACCOUNT_V2PUB.UPDATE_CUST_ACCOUNT
API to update a Customer Profile TCA R12
API to Update Customer Address in Oracle TCA R12
Application Architecture Single Tier Architecture
Applications Directory and File Types
Applications Form Trace
apps
apps ap tables
APPS ERP DOCUMENTS
APPS QUERIES
apps quires
Apps Report Customization's
apps reports
APPS TABLES(PO
APPS TECHNICAL
apps.bne_contents_b bcb
apps.bne_contents_tl ct
apps.bne_integrators_tl bit
apps.fnd_program.executable Queries
apps.fnd_program.register
ar
AR Adjustments to GL query
AR INV Validations
AR Invoice Mandatory Columns
AR Invoice Open Interface
AR Invoice Query
AR queries
ar query
ar receipt
AR Receipt and Bank Statement Reconciliation oracle apps
ar receipt QUERIES
AR Receipts to GL
AR Receipts to GL link in oracle R12
AR Tables
AR to GL Link
ar to gl query in r12
AR TO HZ LINK
AR Transactions
AR_PAYMENTS_INTERFACEBranches
AR_Queries
AR_RECEIPT_API_PUB.CREATE_CASH
Assign Receipt method to Customer via API in Oracle Apps R12
attachments
Autoinvoice
AUTOLOCK BOX CONCEPTS IN R12
AutoLock Box In R12
Autolockbox: Standard Oracle Receipt Rejection reasons
Automatic Receipts
Automatic Receipts And Remittance In R12
AUTOTRACE Option in sqlplus
Awaiting Shipping Query pICKED BUT NOT SHIPPED
Back order status
BAD File
Bank model
bank query
Bank Statement Loader In R12
Bank Tables in Oracle apps r12
Bank-accounts-supplier-and-customer
banking
banktables
Barcode with BI publisher report
BASED ON MATERIAL TRANSACTIONS ACTIVE ORGANIZATION QUERY
Basic Accounting
Basic Troubleshooting
BETWEEN/NOTBETWEEN
billing
BIP Bursting
BLANKET SALES AGREEMENT TABLES
Blanket Sales Order
BOL
BOM
Bom Explosion Query
BOM; OM
Booked
Booked and Saved
Bored at Home
break the page
BULK COLLECT
Business life cycle
Cash Management
Cash Management ALL Posts
Cash Management Setup Check List
Cash Management: Cash Cycle
Cash management: Manual reconciliation of Miscellaneous Transaction
CE
CE BANKS
Changing existing report
Checking order progress from back end.R12
checking Profile Option
Checking Purchase Order Approval History for a specific member of
Checking Requisition Approval History for a specific member of staff
cience-experiments-and-activities
CM
code to Convert column to row
Cogs Query oracle apps 12
COGS query R12
Col Usages from specific table
communication details
Compare two text files in Notepad++
Comparison between SAP and Oracle Apps
Complete flag and Customer name.
Complete Order to Cash(O2C) Techno-Functional flow in R12
Concurrent Executables
Concurrent program
Concurrent Program Definition Trace
concurrent program from back end
Concurrent program Queries
concurrent program schedules ; requestset schedules ;oracle apps r12; application developer ;fnd_concurrent_requests ;concurrent_program;Check Periodic Alert';
Concurrent Program/Request Scheduling
Concurrent request running longer
connect by
Constraints
Control file
Control file with parameters
Conversion Using API
Conversions
Converting rows into columns using pivot function
Core HR Basic Concepts
COST OF GOODS SOLD
costing errors
COUNT
course
COVID19
covid19india
Create Accounting Program:
Create New Custom Form Oracle Applications
Create Party of type Organization in Oracle TCA
Create profile with the best plan-
Create XML Publisher report without RDF
CREATING A SUPPLIER IN R12
Creating Custom Webadi Template in Oracle Apps
Creating First OAF Page In Project
Creation of Set Of Books
Credit Check Functionality in Order Management
creditcard sale order queries
CRM
CUBE
current date
currentdate
CURRVAL
Cursor
cursors
cust name
cust no
customer
CUSTOMER API
CUSTOMER API
Customer Balance Revaluation Report
Customer Bank Account Details Report XML Report
Customer Conversion
CUSTOMER CONVERSION IN ORACLE APPS R12 via API's - OVERVIEW
customer discounts
Customer Import using API's
Customer Information
customer invoice details
Customer Master Information
customer phone number
customer query
Customer Tables
D2k Interview Question
Data Definition
Data File
Data Flow from APto XLA to GL
Data Flow from AR to XLA to GL
data manipulation operation not legal on this view
Dataloader
Date Functions
date of invoice
DCL
DDL
Debugging an Internal Requisition which not turned to an Internal Sales Order
Decode Functions
Deferred COGS: How to use this feature of Oracle Apps R12
Define Bank And Bank
Define Bank;Define Grants and Roles;Setups for Defining the Banks;Define Branch;Define Bank Account;Add Operating unit to your bank;Defining Internal Bank Accounts;Defining Customer Bank Accounts;
Delete Concurrent Program from the Back-End
Delivery line statuses
Demonstration of XML bursting
dense_rank
denserank
dependent
Developer tips
Developer tips; Easy test editing ;Notepad++
Developing and Registering Procedures with Oracle Application
DFF
Diff between 11i and R12 Apps Technical
Difference between 11i and R12 module wise
Difference between Case and Decode
Difference between drop and truncate and delete
Difference Between NVL and NVL2
Difference between Party and Customer
Difference between Stored Procedure and Function
Difference between Valuesets and Lookups
Different types of LPN (licence plate number) Status in WMS module
Different Types of Tables in Oracle Apps
discount grace days
Discounts
Discrepancy
Distinct
DML
Document Sequence
DOCUMENTS
Documentsin Oracle Application
DQL
DRILL DOWN FROM GL INTO AP
Drop Ship Query Query Drop Ship Sales Order
DROPSHIP
Dual Table
Duplicate Shipments SQL Query SQL Query sql query to find duplicate shipments
E-Business Tax Notes -- R12
eading zeros truncated for excel report
Easy test editing
EB-Tax Setup Tables in Oracle APPS
EBIZ TAX
EBS LOGIN URL from database;How to find Oracle Applications Login URL from database
email procedure
Employee Conversion
Employee Details
Employee Hierarchy Process
Enable Diagnostics in Oracle apps
enable macros
Enable Personalization on OAF Page
Enable SQL Trace in Oracle Apps R12
ENABLE TRACE FOR CONCURRENT PROGRAMS IN ORACLE APPS R12
Enable/Disable the parameter field Dynamically in Oracle apps Concurrent Program
Enabling Notepad++ Dark Theme
End User Details
ENGLISH
Equi Join
ERP
ERP INTRODUCTION
Error in Workflow ORA-04061: existing state of has been invalidated
Europe Localization
European Post-Install Steps
Event Handling In Oracle Core Contracts
EXCEPTIONS
EXECUTE IMMEDIATE
Execution plan
experience
Expertenglishlanguagetraining
explain plan
Explain Plan in Toad
External tables:
FA
faq
Financial Statement Generated Report
Find Receipt based on PO Header_ID
Find Table And View Objects Behind OAF Page
Firing Sequence Of Form triggers
first
Fixed Assets GL
Flat file
Flex-field Qualifiers and Segment Qualifiers - "Natural Account"
FLEXFIELDS
FND Debug log;debugging;
fnd load
FND Tables: Oracle Applications AOL Objects
FND_FORM_CUSTOM_RULE
FND_GLOBAL.APPS_INITIALIZE in oracle applications
FND_NEW_MESSAGES
FNDLOAD Scripts
FNDLOAD Upload and Download Commands For Different AOL Components
FORALL
form
Form Personalization
Form Personalization: Create Journal Entry From Subledger Journal Entries Form In AP
form triggers
format numbers as text
forms
Forms Personalization
Four Tier Architecture
Function
Function consultant
Function Not Available To This Responsibility. Change Responsibilities Or Contact Your System Administrator
Functional Components
FUNCTIONAL MODULES Multi Orgs Multiple Organizations
Functions
Fusion
FusionBursting
GENERAL
General Ledger
General Ledger – Basic Accounting Concept | General Ledger Account Types and Accounting formula
General Ledger All Posts
geography's without Jurisdiction's in oracle apps eb-tax
German VAT for On-Account Receipts Report
Germany localization
Germany-Specific Setup and Processes;
GET FLEXFIELD DATA INTO REPORT
get the invoices and order details
GL
Gl to Ap Drilldown Query R12
GL Entries with AP Payments
GL Entries with the AR Transaction
GL Period Close
GL QUERIES
Gl Report
Gl to ar Drill down Query
GL_PERIOD_STATUSES
grace days
Group by clause
group functions and joins
GROUPING Functions and GROUPING SETS
Handling Exceptions in Bulk Operations
Having clause
Hierarchical Queries - Start with Connect by
history tables
Hold Release
How Do You Turn Off Or Disable Tax Calculation In R12 E-Business Tax (EBTax)
How the start with CONNECT BY clause in Oracle works
How to change HR Workflow Notification approvals In AME for SSHR.
How to check total outstanding you need to pay to a Supplier
How to check workflow status from backend
how to create report in oracle apps and run
How to Create Responsibility in Oracle Apps
How To Define Customize Web ADI Layout In R12
How to Develop Report with out Parameters?
How to Display Leading Zeros in XMLP Report
How to enable Oracle apps Diagnostics
How to enable trace for a USER session
How to find the Package associated with A WEBADI Integrator
How to find the Tracefile using SID in Oracle
How to Generate a Useful SQL Execution Plan
How to Implement User Profiles?
How to join GL tables with XLA (SubLedger Accounting) tables
How to Migrate/Transfer Workflow/Custom business events
How to open Periods in Oracle Apps
How to print multi layouts multi currency multi language in xml publisher
How To Restrict A Customer To Create Foreign Currency Transaction In Transaction Workbench
How to Run the SQL script from the Concurrent Program?
How to submit the concurrent request from shell scripts
How to submit XML Report using a PL/SQL Script
How to survive (and even thrive) during lockdown with kids
How to update EBS XML Publisher Temporary Directory
How To Upload AP Invoices Using Oracle WebADI Custom Integrator
How to use Case and DECODE function???
How to view Customer Bank Account Details
How to view other user output file in application
How To Void Confirmed Payment Batch In R12 Under Payment Manager
HR_EMPLOYEE_MIGRATION
HRMS
HRMS Modules
hz
HZ_CONTACT_POINT_V2PUB.CREATE_CONTACT_POINT
HZ_CUST_ACCOUNT_SITE_V2PUB.CREATE_CUST_ACCT_SITE
HZ_CUST_ACCOUNT_SITE_V2PUB.CREATE_CUST_SITE_USE
HZ_CUST_ACCOUNT_V2PUB.CREATE_CUST_ACCOUNT
HZ_CUST_ACCOUNT_V2PUB.UPDATE_CUST_ACCT_RELATE
HZ_CUSTOMER_PROFILE_V2PUB.UPDATE_CUSTOMER_PROFILE
HZ_FORMAT_PHONE_V2PUB.PHONE_DISPLAY
HZ_LOCATION_V2PUB.UPDATE_LOCATION
HZ_PARTY_SITE_V2PUB.CREATE_PARTY_SITE_USE
HZ_PARTY_V2PUB.CREATE_GROUP
hz_payment_method_pub.create_payment_method
HZ_TAX_ASSIGNMENT_V2PUB. CREATE_LOC_ASSIGNMENT
IBY_EXT_BANK_ACCOUNTS
Identifying Duplicate Shipments
IDS BUSY
iexpense
iExpenses Table
Important Base tables all modules GL
important links
IMPORTANT QUERIES
IMPORTANT SQL QUERIES
in oracle apps r12
in specific condition?
in XMLP?
IN/NOTIN
Inbound Interface
Incomplete Bank Statements SQL Query
Incomplete Invoice Report
INCOMPLETE INVOICES REPORT
Incomplete Work Orders
independent
INDEX:
India localization
INDIA LOCKDOWN
indiaafter21days
indiafightcovid19
ink inventory material transaction with GL journal entry. Gl inv link
INNTERFACES
Insert Script for Open AR Transaction (Credit Memo) for R12
Insert Script for Open AR Transaction (Invoice) for R12
Insert Script for Standard POs
Inserting XML Data Type
INSTEAD OF triggers
Integration of base product schema by using APPS schema
Integration of Oracle Apps Modules
INTERFACE TABLES
Interface Trip Stop Functionality
Interfaces
interim tables
INTERSECTION
interview questions
Interview questions FAQ Oracle apps r12 and PLSQL
introduction
INV
INV period closing Queries
INV period closing details all in one Query
INV period closing Queries
Inv quantity;
INV queries
Inv to gl Link Query R12
INV_QUERIES
Inventory interview questions
inventory organizations for an operating unit
invoice
Invoice Aging Report
Invoice History Report
invoice no
Invoice Number and Receipt Number With one of the Input
Invoice Validated
invoice_amount oracle apps r12 sql query to find order amount
Invoices not picked by PPR
Invoking SQL*Loader
IProcurement
iProcurement Setup Document and it's basic flows in R12.2
IS
item conversion
Item Conversion Update
item conversions
Item Interface
item query
Items On Hand Qty
Join between OM
joining between OM
JOINS
Joins between OM and AR
joins between various tables in Internal Sales order (ISO)
Journal Import in GL
Journal Posting Issue and resolution
Journal reversal in GL
Key Flex Fields
KIDS ACTIVITIES
last
last page
layout in the backend
Learn to avoid the mutating table problem in Oracle
learninggamesforkids
Legal Entity Name
Lexical Parameters
License Plate Number
Life Cycle of Business
LIKE/NOT LIKE
line and qualifier at header level in R12
Link Between AP and GL with XLA tables in R12
Link Between AR and GL with XLA tables
link between IBY and HZ
link Between per_all_people and per_all_positions
link between sales order and purchase order in Oracle apps r12
Link Between Transaction Number and Receipt Number in AR
links
List of Orders which are pick released on Sysdate
Lockbox
lockdown
Longreunning sql; tuning;performance ;
Lookup
LPN
LTOM
Material Transactions Query
MATHS
MAX
MBOL
Message_text
migration
MIN
MINUS
Miscellaneous Metalink Performance Articles
MO: Security Option
MOAC
MOAC: Multi-Org Access Control
Modification of Oracle Java mailer
modifier and qualifier using API in R12
modifier header
modilockdown
Monitor/Restart/Bounce Workflow Agent Listener
Month end close
multi layouts
Multi-Org Access Control
Multiple Organizations in Oracle Application
multiple orgs
Museums
Mutating table error
Mutating Table Exceptions
NEXTVAL
NOCOPY
Not Null
Notepad++
Notepad++ tips
Notify when SO is booked or new line is entered on booked order
NUMBER AND CHARACTER FUNCTIONS
NVl
NVL2
O2C
o2c apps R12
O2C full cycle in oracle R12
o2c functional flow
o2c query
o2c query r12
O2C R12
O2c Tables R12
OAF
OAF ALL POSTS
OAF Apache Bounce Steps in R12.2
OAF Forms Trace
OAF Importer commands;OAF
OAF Interview Questions
OAF INTRODUCTION
OE_PRICE_ADJUSTMENT
OFSAA – Oracle Financial Services Analytical Application Installation Overview
OM
om conversions
OM flow
OM Link AR
OM links
OM QUERIES
OM Query
OM Related queries Oracle Apps BOM Tables and Queries
OM TABLES
OM to GL Drill Down Query
OM to GL links
OM TO GL query
OM_Queries
OM: Over Shipment Tolerance
On Delete Cascade
Onhand quantity
Open Notifications - PO
Open Notifications - Req
Operating Unit Details
Operators
OR
ORA-01732
ORA-erreros
oracl faq
ORacle
Oracle 12i - How to create accounting and transfer JE's to GL using SLA
Oracle Account Payables(AP)
Oracle Alert - Basics
Oracle Application Framework (OAF) Tutorials
Oracle Applications : Forms :Query Find window
Oracle Applications :Oracle Unified Methodology (OUM)
Oracle Applications :OUM and AIM
Oracle Applications Concurrent Request phase codes and status codes
Oracle Applications Modules List:
ORACLE APPLICATIONS TECHNICAL
ORACLE APPLICATIONS TECHNICAL INTRODUCTION
oracle apps
Oracle apps Complete links Module wise
Oracle Apps Interview Questions
Oracle Apps Credit Card: Process in iExpense and Payables
Oracle apps discounts
Oracle apps Documantation
Oracle Apps file Architecture
Oracle Apps Forms Basics
Oracle APPS Forms:Zoom functionality
Oracle apps Important Queries
oracle apps interview Questions
oracle apps interviewQuestions
oracle apps introduction
Oracle Apps Inventory Accounts: Inventory Accounts and their Description
oracle apps Querys
Oracle apps r12 invoiced quantity variance with the ordered quantity
Oracle Apps R12 Subledger Accounting Tables and joins
Oracle Apps Receivables (AR) Tables
Oracle Apps Receivables Accounting entries
Oracle APPS Releated Queries
oracle apps shortcut keys
Oracle Apps TCA Tables
oracle apps technical
Oracle apps Topic wise links
Oracle Apps XML Interface design Considerations
Oracle Apps XML Interface: Design
Oracle Apps;Desktop Integration Manager;Desktop Integrator
Oracle Apps: Balance Sheet and Profit and Loss Reports
Oracle Apps: Forms Personalization Tables
Oracle Apps: Kill a Locked session through Toad
Oracle Apps: LDT Commands
Oracle Apps: Payables Table structure
Oracle Apps: R12 Payment Document Setup
Oracle Apps: Working with Oracle Forms
Oracle BI Publishe
Oracle BI Publisher
Oracle BI Publisher Interview Questions
Oracle Cash Management
Oracle Cash Management Introduction
Oracle Cash Management Setups
Oracle Cursor Basics
Oracle Database Administration(DBA)
oracle developers tips
Oracle EBS AR
Oracle eBusiness Suite :R12-Cash management enhancements
Oracle ERP - Hierarchical BOM Query
oracle faq
ORACLE FINANCIAL ACCOUNTING HUB (FAH)
ORACLE FINANCIAL ACCOUNTING HUB (FAH)- PART 2
Oracle Financial Module
Oracle Forms
Oracle Fusion Cloud
Oracle HRMS – Some Important Tables
Oracle HRMS;
Oracle iExpense Report Tables with Policy Violation Details
Oracle iExpense Setups and Common issues
Oracle iExpenses flow
Oracle Inventory: Material status Control
Oracle Inventory(INV)
Oracle mutating trigger table errors
Oracle Notifications: How to Modify standard contend
oracle Order Management Line Status
Oracle P2P Accounting entries
Oracle Payable
oracle performance Tips
Oracle PL/SQL Important Topics
Oracle PL/SQL: Coalesce Function
Oracle Procedure to Search for a Particular String/Character
Oracle Property Manager Conversion
Oracle Purchase Order(PO)
Oracle Purchasing Approval Hierarchies
Oracle Purchasing Report Queries
Oracle Purchasing Tables
Oracle R12 AR Auto Lockbox Process
Oracle Receivables API for Cancelling Receipt
Oracle Receivables API for Invoice and Receipt Creation
Oracle Receivables Create Credit memo against Invoice
Oracle Report Triggers
Oracle Reporting Tools and types of Reports in oracle apps
Oracle Reports
Oracle SCM Functional Interview Questions: Inventory
Oracle SQL :Normalization
Oracle Workflow Most Frequently Used Queries
Oracle XML Publisher Report: An Invalid character was found in text content
Oracle XML Publisher Report: Number/Date format in Excel
OracleOrder to Cash tables: O2C tables
ORDER
Order by Clause
order by Item Name
order Delivery details query
Order details with Gl
Order Discount Detail Report
Order Entered
order management
Order Management - tables and links
ORDER MANAGEMENT ALL POSTS
Order Management Tables and its details
Order Management tables and links
order querey
order tables
Order to Cash Cycle Step by step hands on
Order to Cash full cycle and Techno-Functional flow in R12
Order_amount
Orders by Item Report
ORDERS WITH THE ITEM
OUTBOUND
Outbound Interface
Outbound Interface in oracle apps
OUTPUT POST PROCESSOR (OPP) LOG CONTAINS ERROR “JAVA.LANG.OUTOFMEMORYERROR”
Over Shipment Tolerance
Overview of Automatic Receipts and Remittance.
Overview of Menus and Function Security
Overview Of payable
P2P
p2p flow
p2p query
PA
package
packages
page numbers
Party
Payment Process Requests
payment tables
PENDING
Pending LCM Interface
Pending Material
Pending Receiving
PENDING SHIPPING TRANSACTIONS
Pending Shop Floor Move
Pending WIP Costing
Pending WSM Interface
Performance tuning
Performance tunings
Period End Process In Cash Management R12
Period Status(OPEN/CLOSE)
Pick Confirmed
PL/SQL Developer: Can't Connect to Database Error
PL/SQL Script to Generate XML Tags for XMLP Report
Please contact your System Administrator.
PLSGL
PLSQL
PLSQL interview Questions
PLSQl Interview Questions Part 1
PLSQl Interview Questions Part 2
PLSQl Interview Questions Part 3
PLSQl Interview Questions Part 4
PLSQL Collections
PLSQL ERRORS NULL VALUES
PLSQl Interview Questions
PLSQL Interview Questions And Answers
PLSQL: Procedural Structured Query Language
PO
PO Requisition and purchase order PO REQ link to PO
PO & INV SUBLEDGERS FROM ORACLE
PO and SO link
PO Approval Hierarchy Query -R12
PO Approval History Query in Oracle apps
Po Delete
PO Output for Communication Report
PO Position Hierarchy in Oracle Apps
po quantities
po query
PO Receipt
po receipts query
po scripts
po tables
PO TO GL LINK IN R12
PO to gl query
po to invoices query
po types
PO_DOCUMENT_CONTROL_PUB.CONTROL_DOCUMENT
po_headers_sv1.delete_po
PO_queries
Post QuickCash
PPR
PPR failure
PRAGMA
pragma autonomous_transaction real time example
pragmaAUTONOMOUS_TRANSACTION
prepayments and credit/debit memos.oracle reports
Primary Key
PRINT ORDERS BY CUSTOMER WISE
Printed Requisitions Report
Printer Setup
Printing Bar Code in Oracle Reports and XML Publisher Reports
Procedure
PROCEDURE AND FUNCTION
procedures
Process Flows
Procure to Pay Frequently Asked Questions
Profile Option Trace
Profile Option Values for Responsibility
PSEUDO COLUMNS
Purchase Order
Purchase order All Posts
Purchase Order Report
Purchase order salsesorder link r12
Purchasing Useful Scripts
Querey
QUERIES
QUERY
Query used to review the requisition
Query for find Concurrent Program Trace file Path Location in Oracle Apps
Query to Concurrent Program running and status checking with Parameters
QUERY TO CHECK CUSTOMER AND SUPPLIER DATA
Query to check Detailed Message of Error code code Given by API
QUERY TO CHECK PERIODS STATUS
Query to check Sales order Quantities ordered for an item in a given date range
Query to Compare Responsibility between users
Query to fetch Level -1 BOM : BOM:
Query to find invoices which are pending to be paid for more than 60 days invoices paid during past 6 months
Query to find a list of all the forms
Query to find all elements attached to employee in oracle apps
Query to find all the responsibility names from which we can run a particular concurrent program
Query to find AP Supplier Remittance Email Addresses
Query to find Application Short Name of a module
Query to find attachments of a contract
Query to find Bank details is R12
Query to find complete Supplier Details Bank
Query to find Concurrent job run time
Query to find Concurrent Program attached to Which Responsibility
Query to Find Concurrent Program Responsibility
Query to find Costing Error Date wise
Query to find customer site level contact points R12
Query to find detailed information regarding Locks in Oracle Database
Query to find DFF
Query to find few business groups
Query to find Form attached to Responsibility and users
QUERY TO FIND LIST OF RESPONSIBILITIES ASSIGNED TO A PARTICULAR USER
Query to find locks information in details | Oracle Databas
Query to find Oracle Alert
Query to find Organization information
Query to find out Responsibilities assigned to a user
Query to find Person and Position R12
Query to Find POs which not used Blanket Purchase Agreement
Query to find profile Option values using SQL
Query to Find Receipt Class
Query to find Requisitions Approval Pending
Query to find Templates details XML publisher reports
Query to find the Descriptive Flex Field (DFF) fields attached to a Context Code in Oracle APPS
Query to find the Owner name of the Table
Query to find the scheduled concurrent programs
Query to find the SQL_ID from SQL_TEXT | Oracle Database ;dba QUERIES;PERFORMANCE TUNING;sql_ID;sqL text ; v$sqlarea;Gv$sqlarea;
Query to find the SQL_ID from SQL_TEXT | Oracle Database ;dba QUERIES;PERFORMANCE TUNING;sql_ID;sqL text ; v$sqlarea;Gv$sqlarea; Useful scripts oracle Database;
Query to find the Tracefile using SID in Oracle Database
Query to Find the USername who locked the given table
Query to finde total Received Qty in Oracle apps R12
Query to get all menu names in oracle apps
Query to get AP Invoice lines Tax details in Oracle Fusion
Query to get Business Group
Query to get open invoices for customers R12
Query To Get PO Number
Query to Get Profile value at any level
Query to get Purchase Order and requisition in Oracle Fusion
Query to get the order and invoice details
Query to get WebADI Details in Oracle APPS
Query TO list all purchase document types IN oracle apps
query to list customer details
Query to list Freight From Discount Excluded Records in Oracle APPS
Query to retrieve KFF's in Oracle E-Business Suite
Query to retrieve Transaction
Query to retrieve Transaction & Receipt details.
Query which gives the joining between OM
Query;
r12
R12 assign same bank account to multiple suppliers
R12 E-Business Tax (EBTax) 'How To' documents [ID 580438.1]
R12 GL Drilldown to AR
R12 GL Drilldown to AR Functional
R12 INTERFACES
R12 multiorg
R12 party
r12 partyes
r12 receipt
r12 recepit
R12 scripts
R12 SQL Query to differentiate Customer and Suppliers Data
R12 Supplier/Site/Banking Drilldown
r12 suppliers
R12 tables
R12 TCA (TRADING COMMUNITY ARCHITECTURE)
R12 TDS
R12 Uploading a Journal using Web ADI
R12 Uploading a Journal using Web ADI : Step by Step
R12: AR to GL Query [For AR Transaction/Invoice] | Oracle
R12: Detailed Troubleshooting Guide For AUTOSELECT Issues: When PPR Does Not Select Expected Invoices
R2 PO and so link
racle Web ADI Integrator using Desktop Integration Framework GUI
rank
Rdf
Rdf Change
rdf report change
RDF triggers
Realtime Tickets
Receipt Conversion
Receipt Class and its GL Combination Query
receipt conversion
Receipt Creation
Receipt Status in Receivables
Receipts tables
Receivables R12
Receivables Setups In R12
Reconciled in Cash Management(R12)
Refcursor
References
Register executable from back end
Remittance Bank Account
Removing existing DFF
report
REPORT BULIDER PROBLEM
Report customization
Report Development steps
Report Development steps and registering and running in oracle application
Report modification
REPORT REGISTRATION STEPS
Report with input Parameters
Reports
repot bulider not working
Requisition
Responsibilities assigned to a specific user
responsibilities assigned to a use
Responsibilities not Visible on Home Page
Returns by Reason Report
RICE
RICE Components
Role of Technical Consultant
ROLLUP
ROWID
ROWNUM
Run-time error '1004': Method 'VBProject' of object '_Workbook' failed
SALES ORDER
Sales order conversion
SALES ORDER Quantities
SALES ORDER QUERIES
Sales order query
sales order Query R12
SALES ORDER R12
salesorder
SCIENCE
SCM ( Supply Chain Management )
Script to Monitor and tune Oracle Database
Security Rules In R12
select clause
Self Service Page trace
send email
Send Email Through PL/SQL code
Session Leve trace
SET OPERATORS
Setting Up Oracle Payables for Oracle Cash Management Integration
Setting Up Oracle Receivables for Oracle Cash Management Integration
Setting Up Tax Recovery Rates
shell script
shellscript
ship confirm
Ship Confirmed
shipping
shipping networks Query
Show Notepad++ tabs in multiple lines
Simple Food Menu XML File
site
site level contact points
SLA
Some Standard Oracle
Some Standard Oracle Apps Report Customization's
special
SPEL in OAF
spelling-games-vocabulary-games
SQL
SQL – PL SQL
sql date;
SQL Developer Tool
SQL FUNCTIONS
SQL INTRODUCTION
SQL Loader
SQL QUERIES
SQL Queries for checking Profile Option Values
SQL Query
SQL Trace and TKPROF
SQL Tuning
SQL_ID
sql*plus report
SQL/PLSQL ALL POSTS
Sqlerrors
SQLLoader
staging tables
Standards for Report Developments in Oracle Apps
Steps to allow other Users who having same Responsibility To view Your Output File
Steps to Migrate BI Publisher Reports to Production
stored procedure
Structure of OAF
Sub programs in pl/sql
Subledger Accounting
Subqueries
SUM
Supplier Conversion
suppliers
Suppliers in TCA - A dive into Vendor Tables in R12
Syntax
Syntax to develop the control file.
SYS ADMIN
SYSDATE
Table Register
table value set
Tables
Tables affected from Order to Cash in Oracle EBS
Tables and links
tables joins
tables oracle
tax address and accounting information
Tax Rates Has been defined
Tax Regime:
tca
TCA / Oracle Receivables
TCA ALL POSTS
Tca R12
TCL
TDS
TDS in Accounts Payable - India Localization
technical
Technical;Debugging
Template
The 37 best websites for learning a new skill
THE AFTERMATH OF COVID-19
The value assigned at Responsibility level and Responsibility Name If it is assigned to any resp
There Are No Valid Navigations For This Responsibility
Three Tier Architecture
TIME
TKPROF:How to read Tkprof
To find Responsibility we can run the concurrent Request
TO FIND PROMOTION/MODIFIER APPLIED ON AN ORDER:
to findout Executable
To Get Invoices not paid & partially paid
To get the Current time of the DB
To get the Profile option information at all
To get the time of the particular
TO PRINT CUSTOMER DATA IN SEPARATE PAGES
total invoice relevant to customer
Trading Community Architecture (TCA)
Transaction Interface Tables
Triggers
Triggers in Oracle Forms
Trip details
TROUBLESHOOTING: Tuning Slow Running Queries
Two Tier Architecture
Types of executables
Types of Natural Accounts in Accounting
Types of value sets
Unbooked Orders Detail Report
Uncosted Material/WSM
UNCOSTED WSM TRANSACTIONS
UNION
UNION ALL
Unique
unix basics
unix commands
Unix Shell Script For Oracle Apps
Unprocessed Material
UNSHIPPED ORDERS
use section break?
Useful Scripts Oracle Database
User profiles
Using UTL_FILE
UTILFILE-INBOUND
V$SESSION_WAIT
Validating Receipt Number
validations
value sets
Value sets Tables
Vendor contact Update API
Versions
VIEWS AND SEQUENCES
Web ADI
Web adi error
Web adi error 12.1.3
Web adi tables
Web-ADI Template Settings for Microsoft Excel
webadi
WEBADI ALL POSTS
WEBADI Common Issues
WEBADI Common Issues - Oracle EBS R1
webadi create document
Webadi step by step r12
What Are Standards for Report Developments in Oracler Apps?
What are Steps for Report Development in Apps?
What is IFRS
What is Multi Org?
What is SQL* Loader?
What is TCA
What is Value Sets? What are Types Of Value Sets?
Who Columns
Why is my hint ignored;Useful Scripts Oracle Database;
WIP
WIP)
WMS LPN Context
WMS LPN R12
Workflow
workflow mailer
WORKFLOW MAILER DEBUGGING
WORKFLOW MAILER DEBUGGING SCRIPT
Workflow Notifications to Users/Roles
Workflow Query
workflow status workflow activity_status
Working with Stored Procedures and Packages
WSH
XLA to GL
XLA_SUB_LEDGER
xml
xml bursting
XML Data Template
xml publisher
XML PUBLISHER ALL POSTS
Xml publisher Report
XML publisher reports (RTF) Check printing
XML publisher Tips
xml reports
XML sample file
Xml tmplate
xml tutorial
XXX is not a valid responsibility
XXX is not a valid responsibility for the current user. Please contact your System Administrator
z_party_contact_v2pub.create_org_contact - API to create a Contact person for an organization in Oracle TCA
Zoos

Simple theme. Theme images by gaffera. Powered by Blogger.