aksesa

 Profile Answers by aksesa Questions by aksesa

• Apr 5th, 2010

Normally when we want to process the bulk records that time we use the parameterized cursor.Eg: If we want to extract certain PO details every day for DATA WAREHOUSE extract then we have to use the parameterized Cursor. In cursor parameter we can pass status of PO, Extract Date etc.

trraka

 Profile Answers by trraka Questions by trraka

• Jan 23rd, 2008

Parametrized Cursors are frequently used when picking the data from master -detail tables .(Generally in interfaces) Or the same table with header as well as line informationcursor c1 is select a...

Answer Question  Select Best Answer

aksesa

 Profile Answers by aksesa Questions by aksesa

• Apr 5th, 2010

We can use ROLE in Workflow which will send the notification to user_id (email address present for that user id).

Answer Question  Select Best Answer

aksesa

 Profile Answers by aksesa Questions by aksesa

• Apr 5th, 2010

In parameter in stored procedure is passing by refrence. OUT parameter is passing by value. If we want to use pass OUT parameter as passing by value then we can use NOCOPY for OUT parameter which will be used as passing by reference.

Senthil

• Aug 6th, 2007

IN parameter and IN OUT Parameter are the parameters can be passed by reference or Valur whereas OUT parameters are passed by value.

Answer Question  Select Best Answer

aksesa

 Profile Answers by aksesa Questions by aksesa

• Apr 1st, 2010

API are application program interface. API are provided by Oracle in PLSQL code. Whenever you want to either load or update data in base tables like PO_HEADERS_ALL or FND_PROFILE_OPTIONS bulk records ...

sudheer12d

 Profile Answers by sudheer12d Questions by sudheer12d

• Jan 18th, 2007

Hi API - Application Program Interface It is an inbuilt PL/SQL coding which explains the particular functionality which interfaces legacy to Apps.We use it by running the concurrent program; executable as one of the concerned API.Cheers Sudheer

Answer Question  Select Best Answer

Why we register a table in apps schema by using ad_dd.register_table procedure

jith_in

 Profile Answers by jith_in Questions by jith_in

• Feb 25th, 2010

We register the table using ad_dd for the sole purpose of using the same in flexfields and alerts.

VijayAkumalla

 Profile Answers by VijayAkumalla Questions by VijayAkumalla

• Nov 18th, 2008

We register a custom table in the custom schema. Then give all permissions to APPS schema. Reason being, when stored procedures or functions are written to perform DMLs on the custom table, it is done from APPS schema.

Answer Question  Select Best Answer

agouthaman

 Profile Answers by agouthaman Questions by agouthaman

• Feb 19th, 2010

FSG (Financial Statement Generator) is a tool for reporting on account balance by period. Accounting flexfield, accounting periods and type of balance these are the details which make the rowset and column set. Column set overrides rowset.

Divya

• Sep 26th, 2005

Column set provided while defining Columns you should have checked the "Override Row Calculations" checkbox.

Answer Question  Select Best Answer

agouthaman

 Profile Answers by agouthaman Questions by agouthaman

• Feb 19th, 2010

Standard GL period types are Month, Quarter and Year. But User defined periods can also be used.

vmbv

• Nov 30th, 2005

Then come to Oracle Apps.It is best for u

Answer Question  Select Best Answer

What is the table column link between ONT and PO?

selvaspak

 Profile Answers by selvaspak Questions by selvaspak

• Jan 12th, 2010

In the ONT table OE_ORDER_HEADERS_ALL.ORIG_SYS_DOCUMENT_REF is matched with the Requisition Table PO_REQUISITION_HEADERS_ALL.SEGMENT1 for Internal Requisition Type only(STOCK Transfer)Regards,SSG

Answer Question  Select Best Answer

BarunHazra

 Profile Answers by BarunHazra Questions by BarunHazra

• Dec 22nd, 2009

Yes, as long as the descriptive flexfield use seperate columns 

audiresri

 Profile Answers by audiresri Questions by audiresri

• Feb 25th, 2009

Yes we can add a DFF if table already have a data. Thanks, Sreeni

Answer Question  Select Best Answer

Explain the basic of Picking Rule.

pnarapuram

 Profile Answers by pnarapuram Questions by pnarapuram

• Nov 20th, 2009

Picking rules tells which items have to be picked first from  the inventories/sub inventory for shipping.Thanks and RegardsPradeep Narapuram

Answer Question  Select Best Answer

What is Item Master Organization in Oracle Inventory? What is its use?

jphanireddy

 Profile Answers by jphanireddy Questions by jphanireddy

• Nov 20th, 2009

This is not Mandatory but recommanded by Oracle. Master Org is used only for Item defination. And later it can be assign to other Organization (Child Organization). You can restrict item attributes at master level or Chlid Organization Level.

madaninterview

 Profile Answers by madaninterview Questions by madaninterview

• May 15th, 2008

To create any item we  use  item master organization responsibility madan

Answer Question  Select Best Answer

Please advise

naeemq

 Profile Answers by naeemq Questions by naeemq

• Oct 29th, 2009

Oracle Support should provide you a complete plan of action in case of a patch failure. If they do not provide you complete plan of action ask for it.In case of a patch failure, different patches need different steps to be taken. There is no universal plan of action after a patch has failed.

Devesh Gupta

• Jun 7th, 2006

If you have wasted your time  in main patch near about 8 to 10hrs.,then you should take backup of FND_INSTALL_PROCESSES,AD_DEFFERED_JOBS and baclup of restart files which extension is .bk9,rf9 nd...

Answer Question  Select Best Answer

Define Legal Entity

ash0917

 Profile Answers by ash0917 Questions by ash0917

• Aug 30th, 2009

The Legal Entity represents a legal company for which the user prepares tax reports. Tax identifiers and other relevant information are assigned to this entity.

Answer Question  Select Best Answer

Hi, Can anyone of you give me some points on what are the major differences between Oracle 11i and R12 on the below modules 1. iProcurement 2. Purchasing 3. iStores Waiting for your reply. Thanks, Vikram

bhaskarapps

 Profile Answers by bhaskarapps Questions by bhaskarapps

• Jul 2nd, 2009

1. In Oracle 11i 3c's i.e Currency, Calendar, Char of AccountIn R12 4c's
include sub-ledger account also2. In invoice screen invoice lines

Apps_Dragon

 Profile Answers by Apps_Dragon Questions by Apps_Dragon

• Nov 28th, 2008

1) Oracle Purchasing Release 12.0 speeds up daily purchasing tasks with an enhanced Professional Buyers Work Center. Based on the latest web-based user interface models, the Work Center is a ce...

Answer Question  Select Best Answer

Will there be any pre-defined responsibility in the system that can be used?

nileshtabhane

 Profile Answers by nileshtabhane Questions by nileshtabhane

• Jun 23rd, 2009

For the responsibility you need to set the profile option HR:Query only mode as yes

Answer Question  Select Best Answer

hey...if any of the fields in sql loader script.. eg.. empname is Jain,anisha then how can we handle this ' , ' in Jain,anisha while using csv file in a sql loader

siddhshah

 Profile Answers by siddhshah Questions by siddhshah

• Jun 22nd, 2009

One needs to enter the value with double quotes like "Jain, Anisha" to all the values so the comma can be stored in the columns.

harishkrishnagowda

 Profile Answers by harishkrishnagowda Questions by harishkrishnagowda

• Apr 4th, 2008

Its better to remove ',' for that column using replace commandsFor egREPLACE(TRANSLATE(empname, ',{}[]%"?*~&$|/@''', '    '),'    ')

Answer Question  Select Best Answer

selvakumarapps

 Profile Answers by selvakumarapps Questions by selvakumarapps

• May 20th, 2009

Conversions: It's nothing but transfer of data from other application ?to oracle application(it's one time data transfer). eg SAP(data) to Oracle APPS(data).Interfaces: It's nothing but transfer of d...

Christopher Joseph

• Aug 26th, 2006

Upgrading your data to a newer version is not Conversion, Its Data Migration.Conversion is as correctly mentioned, a One time activity to Convert the Data from a Legacy System to be loaded into Apps Tables. Interfaces: They are periodically run for exchange of data between Apps and Non-Apps Systems.

Answer Question  Select Best Answer

What is Journal Import.How do I import vendor info into purchasing.Thank u,

nakul.v

 Profile Answers by nakul.v Questions by nakul.v

• May 6th, 2009

GL Journal Import is a Standard Open Interface Program provided by Oracle Applications to import Journal Data from legacy systems/or even from Payables,Receivables,Inventory into GL Tables.Interface Table :GL_INTERFACEBase Tables : GL_JE_BATCHESGL_JE_HEADERSGL_JE_LINESGL_BALANCES.

rajeshnrk8

 Profile Answers by rajeshnrk8 Questions by rajeshnrk8

• Mar 10th, 2009

Journal Import is the program is used to import the data from the Interface table to main table.

Answer Question  Select Best Answer

Because of the Receipt Close percentage defined in the Default tabbed region of Purchasing Options.

sajasand

 Profile Answers by sajasand Questions by sajasand

• May 5th, 2009

If the invoice approval matching is set to the 2-way matching then the PO will close as soon as it approved

Answer Question  Select Best Answer

What is the difference between direct path and conventional path?

arifmahmud

 Profile Answers by arifmahmud Questions by arifmahmud

• Apr 20th, 2009

When you use SQL loader by default it use conventional path to load data. This method competes equally with all other oracle processes for buffer resources. This can slow the load. A direct path l...

Answer Question  Select Best Answer