-
Can any one solve this, let me know the process steps?In HRMS Module i terminated one employee on 4-May-2006 with the Settlement date of 31-May-2006 and the Actual date is 5-May-2006, In this case on which date is going see the 'Person Type as: Ex.Employee' and What date we are going to see in effective date?
rashve
- Apr 14th, 2008
The settlement date is of no importance.The user has added the termination of the employee on 04-may-2006 for the 05-May-2006.This means that the last working of the employee will be 05-May-2006 , so ...
rahul.gatade
- Apr 12th, 2008
Why the employee type ex_employee is upto 31-dec-4712...I mean why upto the year 4712....
-
What r the changes that we will make to a report when we r installing it as a concurrent program?
azamtulla
- Apr 22nd, 2008
Apart from general emplementation of oracle repots we do the following thing: --> create prameter P_CONC_REQUEST_ID as number--> add following user exits: ...
-
How to run a report in a multi org environment for all orgs at one stroke Typically, to run for a single org, in the before report trigger, user_exit FND GETPROFILE is used. What if the report at a single run has to generate data for all offices.
vipulgosai
- Apr 25th, 2008
Hi,Use Base table instead of multi-org table. Mean to say...use AP_INVOICEs_All instead of AP_INVOICE(view) as AP_INVOICE is multi-org view and it fetch rows based on org_id.
PREM
- Oct 30th, 2006
IN THE CONCURRENT PROGRAMM FORM OR WINDOW U HAVE "COPY TO' OPTION AT THE BOTTOM LEFT. CLICK THAT OPTION AND THE SAME REPORT CAN ATTACH TO OTHER ORGANIZATIONS REPEAT IT FOR MULTI ORGANIZATIONS.
-
What is FlexField?
Oracle Application uses Flexfield to capture information about Your organization. Flexfield have flexible structure for storing key information. Like Company, Cost Center, and Account. They also give u highly adaptable Structure for storing customized information in oracle Applications.
shrikantgarud
- Apr 25th, 2008
Simple way to descriptive flexfield are the flexible data fields designed and customised according to business needs. Types1. kff- key flexfeilds 2. dff- descriptive flex fieldsThe basic steps in de...
Dawson
- Apr 20th, 2007
KFF - DFFWrong. Please follow GL Module document. in OTN
-
What is R2R Cycle in Apps?
vsn0208
- May 6th, 2008
R2R stands for Record 2 Report i.e. Record Jounal entries in the General Ledger and Report to the Financial Managers using reporting tools such as hyperion. Below modules come under R2R cycle1) Genera...
-
What is a template?What is a token?
kader_bathusha
- May 14th, 2008
Template is predefine , future purpose like expenses template,or quick codes ,Token is unique no every user entering orcle gateway used owen token same thing any problam or issuse share probalm ...
knarender
- Jun 27th, 2007
Template.fmb is a predefined standard form ,which is having 21 libraries to support oracle application structureToken is a field in the parameter window of a concurrent program which is used to map concurrent program parameter with the report builder bindvariable.
-
Hi to all, iam very new to oracle apps.when did order closes on header level in order management module?
mallikarjunekmn
- May 16th, 2008
Hi,As per my Knowledge as per ERP ProcessSteps:1. Purchase Order will be in Fresh Status when it is created.2. It will be in Approved Status after it is approved by Purchase Dep Head or correspon...
AYAN BASU
- Sep 29th, 2006
Please consider two situtions:1. An order with a single line2. An order with a multiple lineIn a single line order , when the entire quantity is fullfilled i.e shipped and AR interface being run the l...
-
What are the standard programs for Oracle GL,AP,PO modules open interfaces?
-
Display "No Records Found" In Report Output
In a report output, How to display "no records found", if no records have been retrieved?
Rampraas
- Jun 8th, 2008
Dear anishajain,Define a Summary Column in Data Model with source of any driving column. Add a boilerplate text with "NO Records Found".Defin code in Format trigger for the same as followsfu...
-
What is the difference between D2K Reports and Oracle Apps Reports?
raman av
- Jun 12th, 2008
Differences between D2k Report and Apps Report(1) in D2k Report there is no fecility to schedule the program where as in Apps report we have that fecility(2) in D2k Report we can't use User-Exits ...
AMIT SONI
- Aug 15th, 2007
D2K reports and Oracle Reports basically have no difference the main difference between them is only that simple D2k report run in any environment and we always use Tables if we want to run a repo...
-
O2C Cycle Process
What is O2C Cycle? Explain the process.
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...
-
Register Table
How to register table in Oracle Apps?
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...
-
Steps for loading data from excel file in cash management using data loader?
rajivgupta780184
- Aug 11th, 2008
Firstly, you have to arrange the excel file in same manner as was the table.i.e., first column data in excel file should be of first column in the table and also remember the data in Excelfile shoul...
-
Show report output reocrds in Blue and Black color alternatively
In a report output, How to show reocrds in blue and black color alternatively.
rajivgupta780184
- Aug 11th, 2008
By using conditional formatting in Oracle reports. You can get conditional formatting in reports properties, try it out.
bye Rajiv Gupta -
How can we call one report from another report in Oracle Apps Reports?
rajivgupta780184
- Aug 11th, 2008
By Using run_product('reportname')? in-built feature? you can call one report from another.
-
How to pass lexical paramater for example &where_clause from forms 10g to report 10g using web
rajivgupta780184
- Aug 11th, 2008
Lexical parameters are used to substitute multiple values at runtime. It can be used in FROM TABLE NAME and in WHERE clause. Usually the lexical parameters are defined in After Parameter Report or in ...
-
Where does the customer information is stored in Oracle Apps tables
When they ask where does the customer information is stored in tables should we say hz_parties or ra_cust
rajivgupta780184
- Aug 11th, 2008
You can enhance processing time by formatting the code in right order.
Use less of cursor if possible
Avoid using conditions and loops as much as possible etc...ThanksRajiv Gupta -
Oracle Forms Validations
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
- 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...
-
How to add company logo to a report?
rajivgupta780184
- Aug 12th, 2008
Go to file option in menu barclick on import->image window will appear then browse the logoselect the picture quality and press ok
mrutyunjay
- Dec 26th, 2006
If the report is not a text report then,we can add a logo.the navigation path isfile->import->picture
-
Profie Options and User Exits
Explian What are Profie Options and User Exits
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...
Oracle Apps Technical Interview Questions
Ans