Oracle apps Topic wise links

Oracle apps Topic wise links

Complete Order to Cash(O2C) Techno-Functional flow in R12

https://www.oracleapps2fusion.com/2014/02/orader-to-cash-o2c-r12.html?m=0

SQL Functions

RANK, DENSE_RANK, FIRST and LAST Analytic Functions

https://www.oracleapps2fusion.com/2014/02/rank-denserank-first-and-last-analytic.html?m=0

R12 TCA (Trading Community Architecture): TCA

https://www.oracleapps2fusion.com/2014/02/r12-tca-trading-community-architecture.html?m=0

Oracle Applications R12 Trading Community Architecture Tables

https://www.oracleapps2fusion.com/2014/04/oracle-apps-tca-tables-oracle-apps-tca.html

R12 TCA (TRADING COMMUNITY ARCHITECTURE)

https://www.oracleapps2fusion.com/2014/04/r12-tca-trading-community-architecture.html

Trading Community Architecture (TCA) Overview

https://www.oracleapps2fusion.com/2014/05/overview-tradingcommunity-architecture.html

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

https://www.oracleapps2fusion.com/2014/02/api-to-create-customer-in-r12-links.html?m=0

Sales order Api conversion

https://www.oracleapps2fusion.com/2014/02/sales-order-api-conversion.html?m=0

Item Interface/Conversion Using API Item conversion through ApI

https://www.oracleapps2fusion.com/2014/02/item-conversion-through-api.html?m=0

AR - Receipt Creation in Receivables R12

https://www.oracleapps2fusion.com/2014/02/ar-receipt-creation-in-receivables-r12.html?m=0

XML Bursting

Bursting (Email report output) in XML Publisher reports

https://www.oracleapps2fusion.com/2014/02/xml-bursting.html?m=0

XML publisher Tips

https://www.oracleapps2fusion.com/2014/04/xml-publisher-tips.html

XML Publisher Templates by Example

https://www.oracleapps2fusion.com/2014/05/xml-publisher-templates-byexample.html

FNDLOAD to transfer AOL Objects from one instance to other

https://www.oracleapps2fusion.com/2014/03/fndload-to-transfer-aol-objects-from.html?m=0

Shell script tutorial

Basic Shell Script Commands

https://www.oracleapps2fusion.com/2014/03/shell-script-tutorial.html?m=0

P2P Query in oracle apps R12

https://www.oracleapps2fusion.com/2014/03/p2p-query-in-oracle-apps-r12.html?m=0

Concurrent Program whose output has to be sent as an Email

https://www.oracleapps2fusion.com/2014/03/concurrent-program-whose-output-has-to.html?m=0

Register Executable from back end

https://www.oracleapps2fusion.com/2014/03/register-executable-from-back-end.html

Create Concurrent Program From Backend

https://www.oracleapps2fusion.com/2014/03/create-concurrent-program-from-backend.html

O2C Query R12 Order to Cash Query R12

https://www.oracleapps2fusion.com/2014/04/o2c-query.html

UNABLE TO OPEN REPORT BUILDER 11G MINIMIZED TO TASK BAR

https://www.oracleapps2fusion.com/2014/04/unable-to-open-report-builder-11g.html

Purchase Order PO Query Report

https://www.oracleapps2fusion.com/2014/04/purchase-order-report.html

AR Invoice Query

AR All Table Links

https://www.oracleapps2fusion.com/2014/04/ar-query.html

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

Drop-Ship Query

https://www.oracleapps2fusion.com/2014/04/drop-ship-query.html

Oracle Apps Interview Questions

https://www.oracleapps2fusion.com/2014/04/oracle-apps-faq.html

PLSQL Interview questions

https://www.oracleapps2fusion.com/2014/04/interview-questions.html

Difference between Party and Customer

https://www.oracleapps2fusion.com/2014/04/difference-between-party-and-customer.html

R12 Supplier/Site/Banking Drilldown PO Query

https://www.oracleapps2fusion.com/2014/04/r12-suppliersitebanking-drilldown.html

Oracle Applications: Debugging Using Log Files

https://www.oracleapps2fusion.com/2014/04/oracle-applications-debugging-using-log.html

INTRODUCTION TO INTERFACES & CONVERSION

https://www.oracleapps2fusion.com/2014/05/interfaces-conversion.html

Oracle APPS Releated Queries

AD Patch tables ,FND Tables

Patch Queries Fnd Queries ,Script for Patch Log Analysis :

https://www.oracleapps2fusion.com/2014/05/oracle-apps-releated-queries.html

Sub programs in PLSQL

https://www.oracleapps2fusion.com/2014/05/sub-programs-in-plsql.html

Bulk Collect And Forall in Oracle

https://www.oracleapps2fusion.com/2014/05/bulk-collectforall.html

SQL Tuning

https://www.oracleapps2fusion.com/2014/05/bulk-collectforall.html

Using UTL_FILE In Oracle

https://www.oracleapps2fusion.com/2014/05/using-utlfile.html

External tables

https://www.oracleapps2fusion.com/2014/05/external-tables.html

SQL INTRODUCTION

https://www.oracleapps2fusion.com/2014/05/sql-introduction.html

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

https://www.oracleapps2fusion.com/2014/05/oracle-purchasing-report-queries.html

AP Supplier Conversion Using API

https://www.oracleapps2fusion.com/2014/05/ap-supplier-conversion-using-api.html

AR Invoice Open Interface

https://www.oracleapps2fusion.com/2014/05/ar-invoice-open-interface.html

AP Supplier Conversion Using API

https://www.oracleapps2fusion.com/2014/05/ap-supplier-conversion-using-api.html

AR INV Validations

https://www.oracleapps2fusion.com/2014/05/ar-inv-validations.html

AR Invoice Mandatory Columns

https://www.oracleapps2fusion.com/2014/05/ar-invoice-mandatory-columns.html

Oracle Forms

https://www.oracleapps2fusion.com/2014/05/oracle-forms.html

Form Personalization

https://www.oracleapps2fusion.com/2014/05/form-personalization.html

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

 Interface,Outbound Interface

https://www.oracleapps2fusion.com/2014/05/development-steps-for-procedure.html

Concurrent Request phase : inactive, status: no manager

https://www.oracleapps2fusion.com/2014/06/concurrent-request-phase-inactive.html

How to use sql develope

https://www.oracleapps2fusion.com/2014/06/how-to-use-oracle-sql-developer-tool.html

Lexical Parameters Interview Questions

https://www.oracleapps2fusion.com/2014/06/lexical-parameters-interview-questions.html

Some Standard Oracle Apps Report Customization's

https://www.oracleapps2fusion.com/2014/06/some-standard-oracle-apps-report.html