What are the different types of profiles options while submitting report through SRS window.

rajeshnrk8

 Profile Answers by rajeshnrk8 Questions by rajeshnrk8

• Mar 25th, 2009

Profiles are nothing but the changable options.While developing the reports we use two user exists i.esrw.user_exist('fnd srwinit');   in before report trigger andsrw.user_exist('fnd srwexit'); in  after report trigger.

Answer Question  Select Best Answer

How to create and generate HMTL file from OracleFor Example : Generate a HTML file with all the rows from a table temp

rajivgupta780184

 Profile Answers by rajivgupta780184 Questions by rajivgupta780184

• Oct 31st, 2008

Set markup HTML on spool c:/temp_table.html select * from temp; spool off set markup HTML off; Thanks & RegardsRAJIV GUPTA(ORACLE CONSULTANT)YOGIK TECHNOLOGIES PVT LTD.

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

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

How to display custom error message in Oracle Report when any run time error occurs?

dinesh upadhyay

• Sep 30th, 2014

Srw.message(Your Custom Message);

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

How to run the GL posting through custom program?

Sarath

• Dec 14th, 2011

In two ways we can post the journals.

Journals> Post function will helps you to post specific journels or we have a request "Program - Automatic Posting", this program will post all the journals.

Answer Question  Select Best Answer

Why we use handlers? What are they?

sktest

 Profile Answers by sktest Questions by sktest

• Jul 11th, 2010

Handlers are group of Package and Procedure which is used in Oracle application to organize the code in PL/SQL form.Handler provide way to centerlize code so that it can easily develop,manage and debu...

Answer Question  Select Best Answer

What is the use of Aging Buckets in AR?

Ravi

• Nov 4th, 2016

Aging buckets are time periods you can use to review and report on your open receivables. For example, the 4-Bucket Aging bucket that Receivables provides consists of four periods: -999 to 0 days past...

Answer Question  Select Best Answer

How to set Org ID?

abhi4apps

 Profile Answers by abhi4apps Questions by abhi4apps

• Dec 3rd, 2010

By using fnd_clinet_info.set_org_contextbeginfnd_client_info.set_org_context(org_id)end

Answer Question  Select Best Answer

What is the Request Set?

alapatisureshbabu

 Profile Answers by alapatisureshbabu Questions by alapatisureshbabu

• May 9th, 2010

To run the number of concurrent programs sequentially or parallely we use request set,in the request set window mention the concurrent programs that you want to execute.

Answer Question  Select Best Answer

What is the utility of P_CONC_REQUEST_ID parameter? For what purpose is P_CONC_REQUEST_ID used?

Praveen Reddy

• Sep 4th, 2014

Hi,

P_conc_request_id capture the concurrent program id in srs window . after run the program successfully completed we will get the output from srs window.

Answer Question  Select Best Answer

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