How to develop Matrix Report in XML Publisher?

hegize

• Oct 23rd, 2014

Insert ---------pivot table

Answer Question  Select Best Answer

How to register table in Oracle Apps?

astaputra

 Profile Answers by astaputra Questions by astaputra

• Jul 7th, 2008

you have to use AD_DD package for registering your tables and columns.Here is the codeAD_DD.register_table(p_appl_short_name => ,p_tab_name => ,p_tab_type => )AD_DD.register_column(p_appl_sho...

Answer Question  Select Best Answer

Explian What are Profie Options and User Exits

babind

 Profile Answers by babind Questions by babind

• Aug 15th, 2008

Profile options is a collection of changeble option this option you can?steup then your way of application is running is change.? The porfile option are 4 types they are given below?1=>? user leve...

Answer Question  Select Best Answer

What is O2C Cycle? Explain the process.

patitapan

 Profile Answers by patitapan Questions by patitapan

• Jul 4th, 2008

O2C REFFERS TO "Order To Remittance".This means for any sale or distribution done in the Order Management, Oracle Receivables is responsible for the remittance of amount sold.So the total process of r...

Answer Question  Select Best Answer

Hi Everybody..... 1) My query is like i have a form by name employeetest 2) I a form i have two canvases 3) There are many test_fields and list_items in the canvas 4) What my query is like..... 4a) If i don't fill any of the item or text_filed i need...

rajivgupta780184

 Profile Answers by rajivgupta780184 Questions by rajivgupta780184

• Aug 11th, 2008

You can do this validation in two ways 1> You can select all the feild at a time and click F4 or go to the properties of that and make the required feild(required property) =YES2>You can also do it th...

Answer Question  Select Best Answer

How we will receive the flat files from the Client?

rajivgupta780184

 Profile Answers by rajivgupta780184 Questions by rajivgupta780184

• Aug 18th, 2008

It is possible in oracle forms 10G Oracle provide an inbuilt facility "webutil".From that you can upload you flat file from? client.But for that you have to conigure certain parameters in configuration files.THANKSRAJIV GUPTAYOGIK TECHNOLOGIES PVT. LTD.

Answer Question  Select Best Answer

How to use the Lexical Parameter in the Oracle 10g report?

sanjay

 Profile Answers by sanjay Questions by sanjay

• Oct 15th, 2008

Lexical parameter can be used in report for chaning column in query. These has to be defined in parameter with same name.

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

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