Tuesday, January 11, 2022

Oracle apps Complete links Module wise


ORDER MANAGEMENT



Order Management Tables and its details

APPS TABLES(PO,AP,GL,OM,INV,AR,WIP)

INTRODUCTION TO INTERFACES & CONVERSION

INTERFACES & CONVERSION

Item conversion

Item Conversion Update

Sales order conversion


WMS LPN License Plate Number ,License Plate Numbers (LPNs) ,oracle lpn r12 ,

Different types of 

LPN (licence plate number) Status in WMS module

O2C full cycle in oracle R12

Order to Cash full cycle and Techno-Functional flow in R12

Debugging an Internal Requisition which not turned to an Internal Sales Order

Complete Order to Cash(O2C) Techno-Functional flow in R12
O2C Query R12 Order to Cash Query R12
o2c Queries and Tables , Order management important queries

Sales order Api conversion

Item Interface/Conversion Using API Item conversion through ApI


Order Management - tables and links,


Drop Ship Query Query to retrieve Drop Ship Sales Order, Purchase Order , Requisition


COGS query R12 ,COST OF GOODS SOLD, Cogs Query oracle apps 12


Order Management tables and links, OM links , Join between OM, WSH, AR Tables


Order to Cash Cycle Step by step hands on r12 OM flow



Drop-Ship Query


Delivery line statuses in detail


Order Delivery details query

COGS query R12 ,COST OF GOODS SOLD, Cogs Query oracle apps 12


oracle Order Management Line Status ,OM ,salesorder


OM TABLES ,Order Entered,Booked,Pick Confirmed,Ship Confirmed,Autoinvoice,Items On Hand 

Qty,Customer Information,Document Sequence,End User Details ,Blanket Sales Order,Hold Release


Query To Find Duplicate Item Category Code in R12


Query to Display All Sub inventories Setup



Interface Trip Stop Functionality,Interface trip stop program Technical details , ITS program


Query to find out Customer Master Information. Customer Name, Account Number, Address etc



Reason why an order line is in Back order status in shipping transactions from after pick release.

Shipping Networks Query R12


INV usefull Query


Query to find few business groups set up in the instance,A very important query to find out inventory 

organizations for an operating unit

Query to Display all categories that the Item Belongs Oracle apps R12


Query to find total Received Qty in Oracle apps R12



Returns by Reason Report


Orders by Item Report


Unbooked Orders Detail Report,PRINT ORDERS BY CUSTOMER WISE


Order Discount Detail Report,Add SubTotals for Selling Price and List Price


What is the difference between Cycle counting and Physical Inventory in Oracle Apps


INV Period closing Queries R12


INV period closing details all in one Query


Query to check Sales order Quantities ordered for an item in a given date range


Sales order query ,Order_amount , invoice_amount oracle apps r12 sql query to find order amount



Awaiting Shipping Query pICKED BUT NOT SHIPPED,UNSHIPPED ORDERS:


OM to GL Drill Down Query ,o2c Query ,OM Query ,Order details with Gl, OM TO GL query


Oracle apps r12 invoiced quantity variance with the ordered quantity OM: Over Shipment Tolerance


Important Queries Discrepancy in Onhand Qty


WMS LPN License Plate Number ,License Plate Numbers (LPNs) ,oracle lpn r12 ,Different types of 

LPN (licence plate number) Status in WMS module


Oracle SCM Functional Interview Questions: Inventory


Query to find Costing Error Date wise


Material Transactions Query


Credit Check Functionality in Order Management


Query to check discrepancy in stock R12 stock discrepancy


Query to Find Orders for specific item in r12


Query to finde orders with no stock for shipping in r12


INV period closing Important Queries R12


Query to check RTP stuck Records in R12


Tables affected from Order to Cash in Oracle EBS


Oracle Inventory: Material status Control


Oracle Apps Inventory Tables


Oracle Apps Inventory Accounts: Inventory Accounts and their Description



XML PuBLISHER BI PUBLISHER


How to update EBS XML Publisher Temporary Directory


Steps to Migrate BI Publisher Reports to Production


Create XML Publisher report without RDF


XML publisher reports (RTF) Check printing


Oracle XML Publisher Report: Number/Date format in Excel


Simple Food Menu XML File


Oracle XML Publisher Report: An Invalid character was found in text content


Oracle BI Publisher - Leading zeros truncated for excel reports - format numbers as text


Where do XML Publisher output files are stored?


PL/SQL Script to Generate XML Tags for XMLP Report(How to Display Leading Zeros in XMLP Report 

– Excel Output)


Oracle Fusion :- BIP Bursting In Oracle Fusion Cloud


How to update EBS XML Publisher Temporary Directory


Printing Bar Code in Oracle Reports and XML Publisher Reports




Query to find Templates details XML publisher reports


Maximum Number of record Per page using XML Publisher with RTF template


XML Publisher Templates by Example


XML publisher Tips


XML Bursting


TCA



Customer Import using API's


Oracle HRMS – Some Important Tables


Create a Customer Account Relationship API 

HZ_CUST_ACCOUNT_V2PUB.CREATE_CUST_ACCT_RELATE


Hz_party_contact_v2pub.create_org_contact - API to create a Contact person for an organization in 

Oracle TCA


Create Party of type Organization in Oracle TCA using API hz_party_v2pub.create_organization


CUSTOMER CONVERSION IN ORACLE APPS R12 via API's – OVERVIEW


API to Update Customer Address in Oracle TCA R12 (HZ_LOCATION_V2PUB.UPDATE_LOCATION)


API to update a Customer Profile TCA R12 

(HZ_CUSTOMER_PROFILE_V2PUB.UPDATE_CUSTOMER_PROFILE)


API to Update Customer Address in Oracle TCA R12 (HZ_LOCATION_V2PUB.UPDATE_LOCATION)

Query to find attachments of a contract


R12 : Trading Community Architecture(TCA)


API to Create a Customer Account for an existing Party TCA R12


Trading Community Architecture (TCA) Overview


Oracle Applications R12 Trading Community Architecture Tables


R12 TCA (Trading Community Architecture): TCA


API to Create a Phone Number (Contacts) TCA R12 (HZ_CONTACT_POINT_V2PUB.CREATE_CONTACT_POINT)

API to create customer Addresses in TCA R12 (HZ_LOCATION_V2PUB.CREATE_LOCATION)

API to create Group in TCA R12 (HZ_PARTY_V2PUB.CREATE_GROUP)

API to create Party and Customer Account in R12 (HZ_CUST_ACCOUNT_V2PUB.CREATE_CUST_ACCOUNT)

API to get the formatted contact details of a Party in oracle apps R12 (HZ_FORMAT_PHONE_V2PUB.PHONE_DISPLAY)


API to populate loc_id HZ_LOCATIONS R12 (HZ_TAX_ASSIGNMENT_V2PUB. CREATE_LOC_ASSIGNMENT )


API to update a Customer Account Relationship TCA R12 (HZ_CUST_ACCOUNT_V2PUB.UPDATE_CUST_ACCT_RELATE)




Account Payables



CREATING A SUPPLIER IN R12 (Functional and SUPPLIERS IN TCA)


PO to invoice Query PO to AP link


AP Invoice Technical Details with Functional Inputs


Gl to Ap Drill down Query R12, General ledger link to Account payables R12,AP To Gl


Invoice History Report


API AP_VENDOR_PUB_PKG.Update_Vendor_Site to update the Payment Method at Supplier Site


Account payable flow ,AP in oracle apps


AP Supplier Conversion Using API


Account Payables Tables


AP Supplier Conversion Using API


How to check total outstanding you need to pay to a Supplier R12


Oracle Apps: Payables Table structure


Oracle Apps: Payables Period Closing process( Payables month end closing)


Query to find AP Supplier Remittance Email Addresses



AP Invoice flow Technical Details with Invoice Functional


Create Mass Additions from Invoice Distributions in Payables



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



General Queries



Enable Trace In Oracle Apps


iExpenses Table ,Credit Card Transactions in Iexpense -> Process Flows


Important Query links r12


Query which gives the joining between OM, WSH, AR Tables


Create Concurrent Program From Backend


https://www.oracleapps2fusion.com/2016/09/po-approval-history-query-in-oracle-apps.html


Oracle Apps: Kill a Locked session through Toad


Oracle iExpense Report Tables with Policy Violation Details


Query To Find the Request Groups and Concurrent Programs


How to submit the concurrent request from shell scripts


Query to Display all categories that the Item Belongs Oracle apps R12


Difference between Valuesets and Lookups


Concurrent Programs Warning-Error: ERRBUFF and RETCODE


Query to find out Customer Master Information. Customer Name, Account Number, Address etc


Enable/Disable the parameter field Dynamically in Oracle apps Concurrent Program


OUTPUT POST PROCESSOR (OPP) LOG CONTAINS ERROR “JAVA.LANG.OUTOFMEMORYERROR”


How to enable FND Debug Log in oracle apps r12


How to enable and retrieve FND debug log messages [ID 433199.1]


ENABLE TRACE FOR CONCURRENT PROGRAMS IN ORACLE APPS R12


Enable Diagnostics in Oracle apps


How to update EBS XML Publisher Temporary Directory



APPS ERP DOCUMENTS


Oracle mutating trigger table errors


Learn to avoid the mutating table problem in Oracle


How to enable and retrieve FND debug log messages [ID 433199.1]



Miscellaneous Metalink Performance Articles


Miscellaneous Metalink Performance Articles 2


How to read Tkprof oracle Database performance tuning


Concurrent request running longer than expected, Concurrent request is not picking jobs


Query to check concurrent program schedules ,request set schedules oracle apps r12


Query to check concurrent program schedules ,request set schedules oracle apps r12


Query to Find the USername who locked the given table


Oracle Applications Modules List:


How to Implement User Profiles?


How the start with CONNECT BY clause in Oracle works


Query to find attachments of a contract


Query to find a list of all the forms in Oracle Applications that have been customized using Forms 

Personalization


Discounts ,discount grace periods in oracle apps r12 ,account receivable Setup Payment Terms


iProcurement Setup Document and it's basic flows in R12.2


GL,INV,AP,FA,INV,PO,BOM,WIP, INTERFACE TABLES


Oracle iExpenses flow


Oracle P2P Accounting entries



Query to check Detailed Message of Error code Given by API


How to find the Package/Procedure/View associated with A WEBADI Integrator


How to enable trace for a USER session


Script to Monitor and tune Oracle Database


How to Generate a Useful SQL Execution Plan


Enable SQL Trace in Oracle Apps R12


Oracle Procedure to Search for a Particular String/Character


Query to find locks information in details | Oracle Database


Query to find the SQL_ID from SQL_TEXT | Oracle Database


Query to find the Tracefile using SID in Oracle Database


Query to find profile Option values using SQL


Using Dataloader to load data in Oracle Apps


How to submit XML Report using a PL/SQL Script


Query to create user from backend oracle apps


How to restrict functions and menus available to a user in menus oracle apps r12


How to Create Responsibility in Oracle Apps


Overview of Menus and Function Security in oracle apps R12


Enable Diagnostics in Oracle apps


MOAC: Multi-Org Access Control


Responsibilities not Visible on Home Page


EBS LOGIN URL from database,How to find Oracle Applications Login URL from database


Oracle Applications Concurrent Request phase codes and status codes


Does anyone have an idea how to query to find Receipts in AR which have not been or are partially Reconciled in Cash Management(R12)?


Inserting XML Data Type


Oracle iExpense Setups and Common issues


Explain Plan in Toad


Oracle Property Manager Conversion


Workflow Notifications to Users/Roles


Event Handling In Oracle Core Contracts


Oracle Applications :OUM and AIM


Oracle Apps XML Interface design Considerations


40+ Useful Oracle queries that every Oracle developer must bookmark.


Oracle R11, R12 Important Queries (Concurrent , Inventory, Purchasing , HR, Payroll , OPM)


Oracle Apps XML Interface: Design



XXX is not a valid responsibility for the current user. Please contact your System Administrator

Oracle Apps: LDT Commands



INV usefull Query

Oracle Apps R12 MOAC and its impact


Query to find Responsibility for the Concurrent Program


Oracle Applications :Oracle Unified Methodology (OUM)


FND Tables: Oracle Applications AOL Objects


Oracle Apps Credit Card: Process in iExpense and Payables


Modification of Oracle Java mailer


R12 Oracle Project Accounting: Few Basic Concepts


QUERY TO CHECK PERIODS STATUS (OPEN/CLOSE) FOR ALL MODULES


Query to Find Concurrent Program Responsibility,Query To Find Responsibility to submit Concurrent Program



Oracle Apps



INTRODUCTION TO INTERFACES & CONVERSION

ORACLE APPLICATIONS TECHNICAL INTRODUCTION 11i R12

Development Steps For Procedure, Reports,Xml publisher Report,SQLLoader,Inbound Interface,Outbound Interface


Concurrent Request phase : inactive, status: no manager


Oracle Applications: Debugging Using Log Files


Oracle Apps Introduction 2


PRAGMA AUTONOMOUS_TRANSACTION


Life Cycle of Business ,Integration of Oracle Apps Modules


SQL Query to findout Executable, Concurrent Program and its Parameters information


Query to Compare Responsibility between users


Oracle Apps file Architecture, Applications Directory and File Types,Integration of base product schema 

by using APPS schema


Creation of Set Of Books


Value Sets in oracle apps Creation of user defined value sets


Oracle Reporting Tools and types of Reports in oracle apps,Report Development steps


Oracle Financial Module , Around 25 modules provided by the oracle financials



Application Architecture Single Tier Architecture ,Two Tier Architecture, Three Tier Architecture,Four 

Tier Architecture


Report Development steps and registering and running in oracle application ,how to create report in 

oracle apps and run


SQL LOADER,Steps in loading the flat file data into the database table,Syntax to develop the control file.


SQL Query to findout Executable, Concurrent Program and its Parameters information


Query to Find Concurrent Program Responsibility


,Query To Find Responsibility to submit Concurrent Program


What is Multi Org? in R12


Query to find EXEcutable name from concurrent program name


Register Executable from back end

Oracle EBS Application Shortcut Keys


Concurrent Program whose output has to be sent as an Email


FLEXFIELDS,DFF,Removing existing DFF,Key Flex Fields


FUNCTIONAL MODULES Multi Orgs Multiple Organizations,Multiple Organizations in Oracle 

Application


Disable Void check box in payment window for particular user only enable remaining users want to 

disable


Submitting the concurrent program from Tools menu using form personalization


QUERY TO FIND LIST OF RESPONSIBILITIES ASSIGNED TO A PARTICULAR USER


QL Query to findout Executable, Concurrent Program and its Parameters information


Query to find the Owner name of the Table


Which are Concurrent Executables in Oracle Apps? How many Types of Concurrent Programs?


Query to find Concurrent job run time


Query to find Concurrent Program attached to Which Responsibility


Query to find Person and Position R12 , link Between per_all_people and per_all_positions


Material Transactions Query


P2P Query in oracle apps R12


Query to find Form attached to Responsibility and users


Query to Concurrent Program running and status checking with Parameters


Query to find Costing Error Date wise


FNDLOAD Upload and Download Commands For Different AOL Components


To get the time of the particular ,To get the Current time of the DB


Query to find Organization information ,Tables and links ,ORGANIZATION_ID BASED ON SHIP TO 

BRANCH PLANT


Query to find Application Short Name of a module


Delete Concurrent Program from the Back-End


APP-FND-00222: Encountered an error while getting the ORACLE user account for your concurrent request.


What is SQL* Loader?


Outbound Interface in oracle apps using 'utl_file_dir'


BLANKET SALES AGREEMENT TABLES, TO FIND PROMOTION/MODIFIER APPLIED ON AN ORDER:

UTILFILE-INBOUND,OUTBOUND


Send Email Through PL/SQL code


Concurrent Program Queries


ORACLE API for Lookup Code and Value Creation


Vendor contact Update API


Profile Option Values for Responsibility


Query to find few business groups set up in the instance,A very important query to find out inventory 


organizations for an operating unit


Query for Employee Information: Oracle Apps Employee Data Extract


AOL : Valueset – A Beginner’s Guide


Query to find the scheduled concurrent programs


Hierarchical Queries - Start with Connect by


Query to find all the responsibility names from which we can run a particular concurrent program


Query to find the profile option values at all levels


Single insert script to create a modifier and qualifier using API in R12


QUERY TO CHECK PERIODS STATUS (OPEN/CLOSE) FOR ALL MODULES


DEVELOP A SQL * PLUS REPORT TO SHOW ALL JOURNALS WITH TAX REVENUE STATUS


Register Custom Tables in Oracle Apps


How to enable Oracle apps Diagnostics


Query to list Customer (Party), Account, Site data


OM to GL Drill Down Query ,o2c Query ,OM Query ,Order details with Gl, OM TO GL query


Script to find details of Data Definition, Template, File Name of a Concurrent Program


Queries to know Information about your Oracle Instance


Query to finde Template name from Request_id


SCRIPTS


Difference between Party and Customer


FNDLOAD to transfer AOL Objects from one instance to other




Account Receivable



ALL MODULES STANDARD REPORTS NAMES


AR Invoice Mandatory Columns


AR INV Validations


AP Supplier Conversion Using API


AR Invoice Open Interface


AR All Table Links


Create Concurrent Program From Backend


P2P Query in oracle apps R12

AR - Receipt Creation in Receivables R12



CUSTOMER CONVERSION IN ORACLE APPS R12 via API's – OVERVIEW


Insert Script for Open AR Transaction (Invoice) for R12


Query to get the order and invoice details,Joins between OM and AR


Payment Process Requests (PPRs) for Oracle Payables R12 Troubleshooting Guide


Insert Script for Open AR Transaction (Credit Memo) for R12

Automatic Receipts and Remittance In R12


AR Invoice Query


Query to find customer site level contact points R12 ,Customer phone number


CUSTOMER CONVERSION IN ORACLE APPS R12 via API's – OVERVIEW


Query to get open invoices for customers R12


Order Discount Detail Report,Add SubTotals for Selling Price and List Price


How to Find the Link Between Transaction Number and Receipt Number in AR


Query to find invoices which are pending to be paid for more than 60 days invoices paid during past 6 months


AUTOLOCK BOX CONCEPTS IN R12



Assign Receipt method to Customer via API in Oracle Apps R12 (hz_payment_method_pub.create_payment_method)


NCOMPLETE INVOICES REPORT, Add customer name to Report


Customer Balance Revaluation Report,TO PRINT CUSTOMER DATA IN SEPARATE PAGES



Receipt Conversion


Employee Conversion R12


AP/AR Netting Sample SQL query



Difference between 11i and R12 module wise


Oracle Apps Receivables (AR) Tables


AR Receipt and Bank Statement Reconciliation oracle apps


Link Between Transaction Number and Receipt Number in AR


APP-AR-96983 : User Write-off limit does not exist


Create Accounting Program:


Conditions Causing Invoice Not Selected for payment PPR issue R12


Oracle Apps: R12 Payment Document Setup


Autolockbox: Standard Oracle Receipt Rejection reasons


Oracle Receivables Create Credit memo against Invoice


Oracle Receivables API for Cancelling Receipt


Oracle Receivables API for Invoice and Receipt Creation


https://www.oracleapps2fusion.com/2017/01/oracle-receivables-api-for-invoice-and.html



How to create supplier as a customer in R12


Link between Supplier and Customer in R12


HZ tables in Oracle Receivables


Various Queries on Customer Data (HZ Tables)


Oracle Pending Transaction Queries


Oracle apps important tables


Oracle APPS Releated Queries


INTERFACES & CONVERSION



Interview questions


Procure to Pay Frequently Asked Questions


SQL LOADER FAQ


OAF Interview Questions


Oracle EBS AR / Interview questions focus


Questions asked in Oracle interview


PLSQL Important Question and Answers


PLSQl Interview Questions Part 1


PLSQl Interview Questions Part 2


Procure to Pay Frequently Asked Questions


PLSQl Interview Questions Part 3


PLSQl Interview Questions Part 4,


sql loader interview questions


Oracle SCM Functional Interview Questions: Inventory


AME Interview Question for oracle apps


oracle apps interview questions and answers


Lexical Parameters Interview Questions


Approval Management Engine FAQ


PLSQL important Question and Answers


oracle apps interview questions and answers


PLSQL Interview questions


Oracle Apps Interview Questions


Reports


German VAT for On-Account Receipts Report


Oracle Financials for Europe Post-Install Steps


Germany-Specific Setup and Processes


PO Output for Communication Report


Invoice History Report


Some Standard Oracle Apps Report Customization's


ALL MODULES STANDARD REPORTS NAMES


Register Custom Tables in Oracle Apps





Forms


Query to find a list of all the forms in Oracle Applications that have been customized using Forms Personalization


Oracle Apps Forms Basics


Oracle Apps: Working with Oracle Forms


Oracle APPS Forms:Zoom functionality


Oracle Developer 10g: frm-18103:fail to initialize the development Environment


Oracle Apps: Forms Personalization Tables


Firing Sequence Of Form triggers oracle apps



Forms Customization Overview

Create New Custom Form Oracle Applications

Triggers in Oracle Forms

Firing Sequence Of Form triggers

Basic Form Personalisation steps in Oracle apps

Form Personalization

Oracle Forms



Reports

Issues in Oracle RDF Reports


What Are Standards for Report Developments in Oracler Apps?


What is Value Sets? What are Types Of Value Sets?


How to Develop Report with out Parameters?


What are Steps for Report Development in Apps?


What are Types of Documents in Oracle Applications


Oracle Report Triggers


REPORT REGISTRATION STEPS


Invoice Aging Report Modifications ,To Get Invoices not paid & partially paid


UNABLE TO OPEN REPORT BUILDER 11G MINIMIZED TO TASK BAR


Returns by Reason Report


Printed Requisitions Report ,GET FLEXFIELD DATA INTO REPORT


Customer Balance Revaluation Report,TO PRINT CUSTOMER DATA IN SEPARATE PAGES


INCOMPLETE INVOICES REPORT, Add customer name to Report

legal_entity_id query

How to use sql developer



OAF

OAF Introduction


Difference Between OAF and Oracle Forms


Oracle Application Framework (OAF) Tutorials


Creating First OAF Page In Project


SPEL in OAF


Structure of oaf


OAF Importer commands


OAF Apache Bounce Steps


Enable Personalization on OAF Page


MD-50 of Sample Project in OAF


SQL Query to get all the personalization on the OAF pages in the application





WEBADI

Barcode with BI publisher report


Creating Custom Webadi Template in Oracle Apps


How to find the Package/Procedure/View associated with A WEBADI Integrator


Web-ADI Template Settings for Microsoft Excel


WEBADI Common Issues - Oracle EBS R12


R12 Uploading a Journal using Web ADI : Step by Step


Run-time error '1004': Method 'VBProject' of object '_Workbook' failed


Web-ADI Template Settings for Microsoft Excel


Create a Custom Oracle Web ADI Integrator using Desktop Integration Framework GUI


R12 Uploading a Journal using Web ADI : Step by Step





AME


AME in oracle apps r12


AME Setup in Oracle Apps


AME Interview Question for oracle apps


Approval Management Engine FAQ


Accessing Approval Management Engine (AME)



Purchase order


PO Approval History Query in Oracle apps


Query to find Requisitions Approval Pending


Printed Requisitions Report ,GET FLEXFIELD DATA INTO REPORT


Purchasing Useful Scripts


Insert Script for Standard Pos


Purchase Order PO Query Report


Oracle Purchasing Tables


PO to invoice Query PO to AP link


R12 Supplier/Site/Banking Drilldown PO Query


Query to Find POs which not used Blanket Purchase Agreement


ACTIVE ORGANIZATION QUERY R12 BASED ON MATERIAL TRANSACTIONS


Accruals Query , PO accruals r12 Query


SQl queries related to purchase order po in oracle apps r12 ;Debugging where po is struck in oracle apps r12 po flow

LINK BETWEEN po_headers_all AND oe_order_headers_all ,link between sales order and purchase 

order in Oracle apps r12


Query to retrieve Transaction & Receipt details. R12


Awaiting Shipping Query pICKED BUT NOT SHIPPED,UNSHIPPED ORDERS:


PO Output for Communication Report

Oracle Purchasing Report Queries


Query to list all Internal Requisitions that do not have an  associated Internal Sales order


Query to list all Purchase Requisition without a Purchase Order


Query to List all data entry from PR till PO


Query to list PO With there approval nvoice and payment details


PO Approval History Query in Oracle apps


PO Requisition and purchase order PO REQ link to PO


Query to Check PO Quantities received for an item in a given date range


PO CREATED And RECEIPT NOT DONE,For Partially received POS


How to create supplier as a customer in R12


Query to check discrepancy in stock R12 stock discrepancy


Query to find Receipt details based on PO number In R12 PO and RCV link PO and Receipt


Supplier Master Details in R12 Query


Query to check RTP stuck Records in R12


Find Receipt based on PO Header_ID , PO Receipt ,Query To Get PO Number, Invoice Number and 

Receipt Number With one of the Input


PO TO GL LINK IN R12 QUERY FOR PO TO GL ~ Oracle Applications Technical


PO Position Hierarchy in Oracle Apps


Drop Ship Query Query to retrieve Drop Ship Sales Order, Purchase Order , Requisition


Drop-Ship Query



General Ledger


Journal reversal in GL


Journal Import in GL


Journal Posting Issue and resolution


Flex-field Qualifiers and Segment Qualifiers - "Natural Account"


Accrual Basis Accounting for Oracle Apps Beginners


Oracle Apps R12 Subledger Accounting Tables and joins


TDS in Accounts Payable - India Localization


Oracle R12 - How to create accounting and transfer JE's to GL using SLA


PO TO GL LINK IN R12 QUERY FOR PO TO GL ~ Oracle Applications Technical


R12 Uploading a Journal using Web ADI : Step by Step


Important SQL queries and tables related to Oracle GL



Drilldown from GL to Inventory Transactions, Inv to gl Link Query R12,Inventory to General ledger links, r12 ,Inv to gl drill down


OM to GL Drill Down Query ,o2c Query ,OM Query ,Order details with Gl, OM TO GL query



Cash Management


Cash Management: Cash Cycle


How to view Customer Bank Account Details


Oracle Cash Management



Bank Tables in Oracle apps r12


R12 Supplier Bank – Techno Functional Guide


Oracle eBusiness Suite :R12-Cash management enhancements


Oracle Cash Management Setups


OVERVIEW OF CASH MANAGEMENT


BANK MODEL IN CASH MANAGEMENT – R12


Cash management: Manual reconciliation of Miscellaneous Transaction



The links between AP and IBY tables Ap vendor banks


Difference between 11i and R12 module wise


CE Banks interface tables oracle apps R12 ;Oracle Cash management important tables ;Error tables in CE ;Bank statement tables


Bank Tables in Oracle apps r12 ; Bank tables in oracle apps r12;


Error tables in CE 


Types of Banks in Oracle apps;


Important Tables of Internal Banks;


ImportantD

efine Bank: in oracle apps r12 ;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


R12: AP: How To Assign The Same External Bank Account To Multiple Suppliers


External Bank Tables;


CE Banks_interface tables oracle apps R12 ;


Links Between bank_Tables oracle apps r12



SQL/PLSQL

SQL INTRODUCTION

ORA-01732: data manipulation operation not legal on this view


Oracle PL/SQL Important Topics


ROLLUP, CUBE, GROUPING Functions and GROUPING SETS


Oracle PL/SQL: Coalesce Function


SQL Trace and TKPROF


SQL Trace and TKPROF


External tables


Using UTL_FILE In Oracle


SQL Tuning \


Bulk Collect And Forall in Oracle


Sub programs in PLSQL


Oracle Cursor Basics


Advance Pl/sql


Triggers


SQL QUERIE


Subqueries


Lexical Parameters Interview Questions



Constraints


Operators


NUMBER AND CHARACTER FUNCTIONS


VIEWS AND SEQUENCES


Functions,procedures,packages


EXCEPTIONS


cursor


PLSQL: Procedural Structured Query Language


PRAGMA AUTONOMOUS_TRANSACTION


How to work with Date Functions?? How to add days in current date?


DCL Data control Language , TCL -Transaction Control Language


collections


PLSQL Interview questions


SQL -- Structured Query Language


PLSQL important Question and Answers


PLSQL: Identify special characters in the string


Difference Between NVL and NVL2


Difference between Case and Decode



The below are somewritng a query with the select clause where we can Select some columns or all columns from the table… examples of


Oracle SQL :Normalization


PLSQL Collections


How to use Case and DECODE function???



Oracle APPS Releated Queries AD Patch tables ,FND Tables Patch Queries Fnd Queries ,Script for Patch Log Analysis :


How to work with Date Functions??


Procedure and function Syntax and Example


Procedure and function Syntax and Example


Bulk Binds (BULK COLLECT & FORALL) and Record Processing in Oracle


To get the time of the particular ,To get the Current time of the DB


Invoking SQL*Loader 1


Invoking SQL*Loader


PL/SQL: Stop Making the Same Performance Mistakes


SQL*Loader and external Tables


SQL Functions

RANK, DENSE_RANK, FIRST and LAST Analytic Functions

PRAGMA AUTONOMOUS_TRANSACTION



UNIX Shell Script


Unix Shell Script For Oracle Apps


Basic Shell Script Commands



WorkFlow


How to check workflow status from backend workflow status workflow activity_status

Monitor/Restart/Bounce Workflow Agent Listener


Error in Workflow ORA-04061: existing state of has been invalidated



Workflow Related Queries Link between PO and Work flow , Open Notifications - Req ,Open Notifications – PO

Oracle Notifications: How to Modify standard contend


How to Migrate/Transfer Workflow/Custom business events


Oracle Workflow Most Frequently Used Queries


SQL Query To Track The Status Of Notifications/Business Events That Are Waiting To Be Processed/That Have Errored Out:


SQL Query To Find Records That Are Pending In Each Of The Workflow Agent Listener Queues;



WORKFLOW MAILER DEBUGGING SCRIPT FOR DEBUGGING EMAILS ISSUES





Notepad ++


Compare two text files in Notepad++


Show Notepad++ tabs in multiple lines instead of scroll on tab bar


Enabling Notepad++ Dark Theme


Add Text at Start and End of Each Line Notepad++







No comments:

Post a Comment

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...