Wednesday, May 28, 2014

Customer Conversion/Interface Techniques in Oracle EBS R12

›
These 3 methods can all be used to create customer records. Following are some considerations to help you decide which method to use: Cu...
Saturday, May 17, 2014

Mandatory Column For GL_Interface

›
Column Purpose SEGMENT1 through SEGMENT30 Identifies the Accounting Flexfield segment values of the journal C...

Creating and Extracting a tar file

›
Creating a Tar file:- Step 1- Create a folder and dump the requested files in unix. Step 2- tar cvf <tar_file_name>.tar  *.* Ex...

Accounting FlexFields of Bank Account in R12

›
alter session set current_schema=apps; SELECT cba.Bank_Account_Name,   cbbv.Bank_Name,   cbbv.Bank_Branch_Name,   cba.Bank_Account_Num...

Request Set of a Concurrent Program

›
Provide Concurrent Program name to the following query. It lists all the Request Sets which are created with the Concurrent Program given....

Programs in a Request Set

›
Provide the Request Set name to the following query. It lists all concurrent programs of this Request Set. SELECT USER_CONCURRENT_PROGRA...

Query to find ORG_ID attached to a responsibility

›
SELECT * --fpov.profile_option_value              FROM applsys.fnd_profile_option_values fpov                 , applsys.fnd_profile_optio...
1 comment:

Examples of XMLCONCAT in PLSQL

›
SET serveroutput ON size 300000; DECLARE   LV_PAYMENT_TYPE_XML XMLTYPE;   l_string VARCHAR2(1000); BEGIN   SELECT XMLCONCAT(xmlelement...

How To Calculate Tax as Inclusive on an Invoice Oracle EBTax R12

›
Tax as Inclusive on an Invoice Oracle EBTax R12 The tax inclusive handling setting at the tax rate level takes precedence over all other...

Oracle Workflow Important Tables

›
Workflow Tables --Two classification of tables --Definition and Setup --if we have item key it is instance specific SELECT *...