When we enter a Blanket Release data where it will be stored?

Sonal

• Jul 11th, 2015

Po_releases_all

Answer Question  Select Best Answer

What is PA Module? What are its main use & What are its Steps & Navigations?

Rajasekhar Reddy Adam

• Aug 1st, 2011

Oracle Projects is suite of modules which combines Project Costing Project Billing Project Foundation Project Management Project Resource Management and Project Portfolio Management Oracle ...

Answer Question  Select Best Answer

What is WHO column and how to insert a value in it?

neomukesh

 Profile Answers by neomukesh Questions by neomukesh

• Jun 26th, 2010

WHO columns are maintained to know who updates the particular rows ans when.last_update_date, last_updated_by, creation_date, created_by, last_update_login are 5 WHO columns. following information sho...

Answer Question  Select Best Answer

How many Flexfields are there in Oracle Receivables? What are they?

Praveen Kumar Reddy

• Sep 4th, 2014

Two key flexfield in receivable 1. Location flexfield 2. Territory flexfield I.Location flexfield : sales tax is dependent on the ship to location of the customer so It is MANDATORY flexfield f...

Answer Question  Select Best Answer

What are the different types of accounting entries available in AP?

Vinod

• Oct 5th, 2012

As you know there are three types of items: Inventory Expense Item a) Create Receipt Inventory Receiving A/c Dr Accrual A/c Cr b) Receiving Transaction Expense A/c Dr Inventory Receiving...

Answer Question  Select Best Answer

How to join the tables in PO modules?

CP

• Sep 2nd, 2011

Following should work for standard POs "sql SELECT * FROM po_headers_all pha ,po_lines_all pla ,po_line_locations_all plla ,po_distributions_all pda WHER...

Answer Question  Select Best Answer

What are the types of Fast Formulas available in HRMS Payroll and their details?

Vinoth

• Feb 19th, 2015

Types of Fast Formula frequently used for payroll
1.Oracle Payroll
2. Element input validation
3. Element Skip
4.Payroll run pr-oration

Answer Question  Select Best Answer

If Master Organization doesn’t have any child organizations, this will be stored in
MTL_PARAMETERS or not?

DINESH

• Apr 10th, 2014

Yes.. It will be created as master

Answer Question  Select Best Answer

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