What is the Item Revision?

Krishh

• Dec 26th, 2012

Item Revision:

Suppose we have an item and if it requires some changes or adding something like a new item/modification in the qty at that time we a Revision takes place called as Item Revision. It is stored in MTL_ITEM_REVISIONS.

Thanks,
Krishh

Answer Question  Select Best Answer

Which attributes need to be checked in order to get the item in PO form?

PRAHASITH

• Jul 16th, 2012

Inventory
purchasing
bom
om

Answer Question  Select Best Answer

Briefly explain about the reports you developed as Oracle apps scm consultant??

Sushant Baban Sawant

• Nov 10th, 2016

I developed 5+ reports in scm. For e.g. Purchase order report, purchase order print report, AFE report, GRN Accounting details report etc. 1. In purchase order report and purchase order print re...

Answer Question  Select Best Answer

How many forms/reports have you designed/customised.

md nasim akhter

• Aug 19th, 2015

Two forms and 50 reports

Answer Question  Select Best Answer

Why we used compulsory executable in report registration ?
what is the main purpose of executable?

Debasmita Sur Dam

• Jul 16th, 2015

The purpose of executable is to links the execution file with concurrent program and the method used to execute it. Actually the name and application (Application name determine in which directory str...

Answer Question  Select Best Answer

What is the purpose of ON-POPULATE-DETAILS ON-CHECK-DELETE-MASTER? What happens when delete ON-POPULATE-DETAILS ON-CHECK-DELETE-MASTER?

veerendra reddy

• Aug 24th, 2015

On_check_delete_master,on_populate_details are used to check the records whether details are exit or not
when we create the non isolated automatically this two triggers are created and one more trigger is created i.e on_clear_details trigger

Answer Question  Select Best Answer

What is the difference between Credit Memo and Debit Memo in AR and AP?

Parakram

• Apr 19th, 2016

AR: In AR Debit Memo is Positive, which means organization is going to receive more money on a particular transaction which might be raised because they want to add freight charge or any other addit...

Answer Question  Select Best Answer

How to Refresh External table?

Ajesh

• May 2nd, 2016

Write a select statement on external table and replace the file with same structure to refesh the data in the external table

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

you cannot attach the APPCORE library to CUSTOM because it would cause a recursion problem (because CUSTOM is attached to APPCORE). As of Oracle Applications Release 11i, you may attach the APPCORE2 library to CUSTOM. The APPCORE2 library duplicates most APPCORE routines with the following packages:
APP_ITEM_PROPERTY2
APP_DATE2
APP_SPECIAL2
These packages contain the same routines...

Ashutosh

• Sep 8th, 2007

You can call APPCORE from Custom.pll or a customized library which is then called from Custom.pll and it may even work fine but you will face issues while converting pld to pll.DBAs need pld to pll conversion to log comments about modifications as they don't use D2K.

P.Maria Varuvel Raj

• Jan 7th, 2006

hi You cann't call appcore library from custom library.Becuase the Custom.pll is itself attached (called ) by APPCORE pll.So once you try to call Appcore in forms a indefinite cycle.So instead yo...

Answer Question  Select Best Answer

Ashok

• May 19th, 2006

There are 2 flexfields in AR1.Sales Location 2.Teritory Of which sales location is mandatory.A sales tax is calculated by considering the ship-to information.Teritory flexfield is optional.Ashok

Bonthu N Reddy

• Feb 14th, 2006

           There r two Flex fields available in AR 1) SALES TAX LOCATION.2)TERRITORY.Cheers,Bonthu N Reddy.

Answer Question  Select Best Answer

Bonthu

• Feb 13th, 2006

By Using Cursor.Cheers.Bonthu N Reddy.

PRATIK GHOSHAL

• Jan 4th, 2006

We can use bulk collect in a collection.

Answer Question  Select Best Answer

srikanth

• Jul 10th, 2007

Documentation can be done based on the org. requirements, for apps we are mainly using BR100 and MD50, configuration settings we?have to do in this documents, BR100 is the functional document, MD50 i...

gony

 Profile Answers by gony Questions by gony

• Jun 7th, 2006

HI,  Ther are various types of documents that you will come across in any software development. If u are familiar with SDLC (Software Development Life Cycle) then u must have already heard about ...

Answer Question  Select Best Answer

Manishas

 Profile Answers by Manishas Questions by Manishas

• Apr 1st, 2007

If Your Responsibility is disable then you have to  just remove to_date under effective dates. But to do this change System Administration responsibility must be on.Navigation : System Administration -->User-->Detail Responsibility Block.

Jugander

• Nov 4th, 2005

Use oracle utility FNDCPASS to reset the password

Answer Question  Select Best Answer

Bonthu N Reddy

• Jan 11th, 2007

Lot of questions :-)1) You can get the oracle application documentations and user guides, sample code at this site .http://www.oracle.com/technology/documentation/applications.html2)  A set ...

braghu

• Dec 25th, 2005

profile options are used to change the  beheviour of oracle  applications forms,reports and programs at run time.there are  four types of profile options in oracle--1.site level2.applic...

Answer Question  Select Best Answer

madhu

• Nov 6th, 2006

   ru    bandhavi      study   1st class   to    tenth  class   in YELLANDU  khammam&...

sameer

• Jan 14th, 2006

yes i hav also came across such an error u hav to set the sequence name for the parameters like check if when u hav defined ur sequence u shud define it for the same category, check ur periods as this...

Answer Question  Select Best Answer

Trimbak Mahajan

• Jul 17th, 2006

1) create P_from_date and P_to_date are user bind parameters 2) Create LP_WHERE_CLS lexical parameter.3) Write below code in the After Parameter Form Trigger   If :p_from_date is not Nu...

user_pc

• Apr 11th, 2006

 To use a lexical parameter in the query of your data model, prefix it with a '&' (ampersand)example SELECT ename FROM emp WHERE &lp_lexical_valThe value of p_lexical_val may be set in th...

Answer Question  Select Best Answer

Manikandan.M

• Sep 11th, 2007

Yes we can use the view if you use multiorg view example (oe_order_headers)?then we need to set the operating unit for that view so we need to execute the following package before report triggerfnd_client_info.set_org_context(org_id);

Denzy

 Profile Answers by Denzy Questions by Denzy

• Feb 13th, 2006

Yes we can use a view.If the table on which the view is based is updated, we can call a procedure in the Before report trigger of the report to update the view and then retreive the data from the view...

Answer Question  Select Best Answer

Nitin Motghare

• Sep 26th, 2006

Hi,I Struck up with API used to Create a Value Sets Runtimely.Can u Help Me to know the name of API to Create a values Set Runtimely in Oracle AppsThanksNitin9823564113

Denzy

 Profile Answers by Denzy Questions by Denzy

• Feb 13th, 2006

set heading offset echo offSet pages 999set long 90000spool C:\TEMP\create_script.sqlselect dbms_metadata.get_ddl('VIEW','AP_INVOICES','APPS') from dual;spool off

Answer Question  Select Best Answer

rahul.gatade

 Profile Answers by rahul.gatade Questions by rahul.gatade

• Apr 13th, 2008

For Registering any PL/SQL stored Procedure as a concurrent program we need to include two mandatory parameters for that procedure,1) ERRBUF    OUT VARCHAR22) RETCODE OUT NUMBERThe 1st ...

Vijay Gurme

• Jun 21st, 2006

There are two two types of codes that arereturn while registering the PL/SQL procedureThese are 1) errbuf2)retcode

Answer Question  Select Best Answer