Login
Register

Home

Trainings

Fusion Blog

EBS Blog

Authors

CONTACT US

Miscellaneous
  • Register

Oracle Gold Partners, our very popular training packages, training schedule is listed here
Designed by Five Star Rated Oracle Press Authors & Oracle ACE's.

webinar new

Search Courses

Dear Friends,

You may decide to subscribe to the articles on this website. This will facilitate you to receive emails when I publish new articles on this Website.
This functionality is being made available via FeedBurner.

Click here to Subscribe to this website via FeedBurner


Thanks,
Anil Passi

Anil Passi

Comments   

0 #1 Lalitha 2007-01-19 00:00
Hi Anil
Congratul ations for the great job done ..
rgds
Quote
0 #2 Lalitha 2007-01-19 00:00
Hi Anil
Congratul ations for the great job done ..
rgds
Quote
0 #3 MB 2007-01-31 00:00
Dear Anil,
Thanks a lot for this really helpful and inforamtive site. Perhaps you can also make sections grouped by experience: junior levels, 4-5 years, etc...But its all up to you, if it seems relevant.
Quote
0 #4 Anil Passi 2007-02-04 00:00
My recent experience in iExpenses taught me that standard functionality of Oracle allows one to setup Signon limit per cost centre against each individual. Although very rarely do you see two clients having similar set of requirements for approval, unless of course they decide to use vanilla functionality. I suggest you read a white paper on AME on Metalink. As per the matrix, usually clients translate the approval flow of their paper invoices into the ERP system. If you tell me your current approval process[busines s flow], then I can suggest you some options? Please email me

Thanks,
Anil Passi
Quote
0 #5 Milind 2007-02-04 00:00
I am a new non technical user. I want to build rules for the approval of vendor invoices. The rules should cause an invoice to automatically be routed to the correct approver and move along the chain of approvers, based on certain criteria like amount etc.
Can you tell me how to get ideas on the kind of approval matrix that is available in Oracle.
Can I see samples of the matrix built by others?
Thanks
Milind
Quote
0 #6 sreedevi u 2007-02-14 00:00
Hi ,
Anyone worked on CRM conversions as Install base and service contracts conversion from legacy.
pls send me the scripts for the same.

rgds
sreedevi
Quote
0 #7 bharat 2007-02-19 00:00
I want to know if i can use xml publisher for the programs like transaction register which is a spawned process.
Quote
0 #8 Anil Passi 2007-02-20 00:00
hi bharat,

outp ut must be XML, hence try to set the output of spawned concurrent program to be XML. i have reservations against this to work. but good luck anyway

anil
Quote
0 #9 Regarding value sets 2007-02-22 00:00
Hi,

Can you please provide any training material
for translatable dependent and translatable independent value sets.Also for special and pair value sets.

Regard s
Venu
Quote
0 #10 Jason 2007-02-27 00:00
Thanks
Quote
+1 #11 uma 2007-02-28 00:00
Dear Anil,

Can u pl provide material for HRMS Budgeting and collective agreement?

t hanks in advance
regard s
uma
Quote
-1 #12 Anil Passi 2007-02-28 00:00
hi vijay


plea se see the Examples section in www.xslfo.info

www xslfo info
Quote
0 #13 Vijay Srinivas 2007-02-28 00:00
Hi Anil,

Can we get any stuff related to XSLFO reports.
ABout the coding standards for XSLFO

Regard s,
Vijay Srinivas
Quote
0 #14 kishore 2007-03-02 00:00
I want to learn Purchasing module but in this there is not mentioned PO cycle.Plz help me out on this issue
Quote
0 #15 Fred Forsythe 2007-03-06 00:00
Great site, fantastic resource
Quote
0 #16 Ashish 2007-03-08 00:00
Awesome Work!
Quote
0 #17 Ashish 2007-03-08 00:00
Awesome Work!
Quote
+1 #18 asit 2007-03-13 00:00
I would like to gather technical knowledge and looks like after lot of search. I will stop here.
thanks Anil.
Quote
0 #19 Kamal 2007-03-13 00:00
I found this site a good resource to know abt Oracle Apps - HRMS.
Good work, keep it up
Thanks
Quote
0 #20 Anil Passi 2007-03-14 00:00
Hi Asit,

That was a lovely comment from you.
But I suggest you must not stop here or at any other single place. There is unlimited knowledge out there on the web.

Thanks
anil
Quote
0 #21 ram 2007-03-19 00:00
Hi,

Please let me know what are the basic set ups required for doing Training Budget.

rega rds,

ram
Quote
0 #22 rashi 2007-03-23 00:00
Hi anil,
its really really wonderfull and helping site.i have one question.actual ly i want to about oracle apps certification.w ill you please tell me about it.

Thanks and regards,
Rashi
Quote
0 #23 Anil 2007-03-24 00:00
Hi Rashi

Please use this link for the information required

http://www.oracle.com/global/us/education/certification/ebusiness_index.html

Thanks
Anil
Quote
0 #24 venkat reddy duddukunta 2007-03-28 00:00
Hi Anil, I am having one issue with parameters in oracle application, The issue is I am having 4 parameters, the 1st parameter is optional and rest of the parameters are mandatory. If I select any value in 1st parameter the rest of the parameters need to disabled. Please assist me how to do this.. Thanks and regards Venkat
Quote
0 #25 Madhu 2007-03-28 00:00
hi,
You are doing a wonderful and thankless job by providing so much information related to Oracle Apps.

Thank you very much
Quote
0 #26 Anil Passi 2007-03-28 00:00
SID,

you should use business events or workflows in preference to alerts.

than ks
anil
Quote
+1 #27 sid 2007-03-28 00:00
hi ,
Anil i have gone through maximum artial of ur.
Why do not u write some artical on Oracle apps Alert.
Give some funda mental idea to us
Quote
0 #28 Arun Kumar 2007-03-29 00:00
I am a novice to Oracle Apps. This site was suggested by one of my collegue. This is simply a superb site with no non sense. Thanks a lot to Mr.Anil Passi. Your site is making life easier for lot many people in this world. Never close this site please.
Quote
-1 #29 Nakul Venkataraman 2007-03-29 00:00
Hi Anil
Could you please explain me the concept behind interfaces in Apps ?

Yours Nakul.V
994042 4744
Quote
+1 #30 Anil Passi 2007-03-31 00:00
Hi Arun,

Interf aces are used to integrate Oracle Applications with other systems. A big enterprise usually does not run all its business applications on one single system, hence integration of sorts is required between those systems to avoid duplicate data entry efforts.

Tha nks,
Anil
Quote
0 #31 navaz 2007-04-02 00:00
Hi Anil
I want my Oracle Report AR Aging 4 Buckets Output to be stored into Excel format
Can anyone help me with any ideas or approach??

R egards
Navaz
Quote
0 #32 raja 2007-04-04 00:00
good site
Quote
0 #33 Ray 2007-04-04 00:00
This page is sooo great!!!

Tha nks and congratulations !
Quote
0 #34 Srikanth 2007-04-04 00:00
Anil,,
Great job...
Keep posting and I would like to see more people posting and offering ideas so this would be an Oracle apps repository.

Well done, Anil
Quote
+1 #35 soujanya 2007-04-11 00:00
Hi Anil,

Wonder ful site to learn. As I am new to Oracle apps project, Could you please help me in reading your Oracle Apps basics articles as blogs are blocked in our company.

Tha nks a lot in advance.
Quote
0 #36 Anil Passi 2007-04-16 00:00
Hi Jan

You will need to extend the Entity Object for Framework. Please have a look at
http://www.google.com/search?q=site:apps2fusion.com+oa-framework-entity-objects-thinking-from-d2k-mindset

and also, have a look at http://www.google.com/search?q=site:apps2fusion.com+iprocurement-11.5.10-rebuild-charge-account

Note[Altern atives to Fwk]:-
API Hooks
-------- -
You may also quickly investigate API hooks in HRMS to see if validation can be entered there.

Bussi ness Events
------- ----
You can also try subscribing to oracle.apps.per .api.person.upd ate_person
OR
oracle.apps.ar .hz.Person.crea te
The latter will be fired because HRMS creates a party behnid the scenes.

Than ks,
Anil Passi
Quote
0 #37 Jan Schipper 2007-04-16 00:00
Hello Anil,

How can we include extra server validations in SSHR, for example a check whether the entered email address on /oracle/apps/pe r/selfservice/p ersonalinformat ion/webui/Newhi rePersonPG does not exists in the database (like the check on employee number)? Thanks in advance

best regards, Jan
Quote
0 #38 Ramkumar 2007-04-23 00:00
hi anil,
i have one one requirement that how to set upemail notifications in iexpenses and oracle time and Labor.


reg ards
ram
Quote
0 #39 Lalith 2007-04-24 00:00
Hi Anil

I have setup proration for mid month grade changes using standard event group functionality.. after changing an employees grade midmonth.. i have run quick pay.. the event group is trigering perfectly fine for the particular element and it is giving correct prorated values.. but in this process the basic salary element which is linked to salary basis is getting processed twice.. lets say the initial value is 1000 , after updating grade and when run quick pay, along with the effected allowance , basic salary element is also getting processed and its giving an output on 2000... kindly advise..
Quote
0 #40 M.Sattar 2007-04-27 00:00
Hi,

Anil,You are doing excellent job .I cant express in words that how much thnakful to you .Thank you very very very very very much

Regards ,
Sattar
Quote
0 #41 Sateesh Kumar 2007-04-28 00:00
Site is very usefull.Thanks for maintaining it with such a valueable inforamtion
Quote
-1 #42 Anil Passi 2007-05-01 00:00
Hi Triv

The easiest way is to enable the Trace in Professional Forms Session, preferably with bind variables, and then read through the Trace file to see if any workflow is being executed.

Th anks,
Anil Passi
Quote
-1 #43 kamal 2007-05-08 00:00
hi
i want know how to upgrade oracle application from 10.7 version to 11.5.10
Quote
0 #44 Shireen ZM 2007-05-09 00:00
Hi Anil,
Really impressed by the brilliant work done by you. I would like to know if you have a free oracle apps instance link and access through which we can practice the setups. Your help is highly appreciated.

Thanks and Regards,
Shire en
Quote
0 #45 Sameer 2007-05-09 00:00
Hi anil,

Regist ered successfully on your site and got message that I would receive a confirmation e-mail. But I havent yet receive any e-mail and it wont let me sign in. Please help !! cheers !! Keep doing Good work !!!
Quote
0 #46 Anil Passi 2007-05-09 00:00
Hi Shireen

You can try solution beacon website, as they have hosted R12 instance.

Ju st google for it.


Cheers
Anil
Quote
0 #47 Anil Passi 2007-05-09 00:00
It might have gone into your spam/junk mail folder.

Note : You do not need to register on this site, all the information is open
Quote
0 #48 salim 2007-05-10 00:00
Hi Anil,

your article are very helpfull for me, can u plz tell what are the changes in R12 with respect to HRMS module.

Than ks
Salim
Quote
0 #49 Nimish 2007-05-14 00:00
Thanks very much Anil.

No I am not making any changes to the form, I wanted to know the tables as I needed to modify the customised reports.

tha nks,
Nimish
Quote
0 #50 Anil Passi 2007-05-14 00:00
Hi Amar

Thats right, the interface line attributes are VARCHAR2, because they store details for other transaction types too, hence could contain characters.Henc e it is important that when doing such join, you must also filter on interface_heade r_context or the interface_line_ context.

On such joins, ora exception of invalid number could be raised. so include the filter on context field prior to this join.

Thanks ,
Anil
Quote
0 #51 VAS 2007-05-22 00:00
Hi,
Can you send me articles on Manufacturing & OPM pertaining to release 12.
regards,
VAS
Quote
0 #52 naveen 2007-05-24 00:00
Hi
I want to know can we can build Graphs which are not defined in 10g Report builder.
For example if I want to start my y-axis in Percent line graph from 60%.
and also can I get vertical lines in line Graph based on y-axis.
Thanks
Naveen
Quote
0 #53 abhineet 2007-05-30 00:00
sir,
I want to know without doing oracle apps sql based only doing OA Framework java based will be useful in life.

abhineet
Quote
0 #54 teknowledge 2007-05-31 00:00
Hi Anil,

I sincerely appreciate your time and efforts for sharing the knowledge.

C ould you also pls give us in depth process of a typical conversion (end-to-end) including some transaltions also from legacy system to Oracle Apps system.

Will appreciate if you can send the reply directly to my email ID i.e. ( ).

Many Thanks in Advance.
Quote
0 #55 Shankar 2007-06-08 00:00
I had posted a query recently, how and when do I know if it has been answered on the website. Do I get an email confirmation ?
Thanks
Quote
0 #56 ramakrishna 2007-06-09 00:00
Sir,
I have been your ardent admirer from beginning.
Gre at Job!!!

Ramki
Quote
0 #57 Kiran 2007-06-12 00:00
Hi Anil I just started working on projects .This is my first project on PROJECTS.Do u have any training articles or any documents?If so it would be grateful.

Th anks
Kiran.
Quote
0 #58 kamal 2007-06-13 00:00
hi anil,
i want to know the information abt oracle application migration.

r egards,
kamal
Quote
0 #59 Anil Passi 2007-06-19 00:00
Hi RK

the syntax is ${global.XX_G_V AR1.value}

S imilarly for :block.item.val ue, you can not use bind variable value
Hence use the SPEL syntax to refer to field/global variable values when executing a stored procedure

Th anks,
Anil
Quote
0 #60 suha 2007-06-25 00:00
hi anil,
iam facing some problems at the time of validations,for example iam doing ap invoice attach document interface,what is the interface table for this interface...
r egards
suha
Quote
+1 #61 Anil Passi 2007-06-25 00:00
Suha

Please paste the exact error message.
The attached documents are mostly stored in FND tables.

Than ks
Anil
Quote
0 #62 Vivek 2007-06-27 00:00
Hello Anil,
Very thanks for ur suggestion, and by this site , u realy doing great, it will definitely helpful for me to make career in oracle apps. many thanks.

Vive k K Bhattu
Quote
0 #63 suri 2007-06-29 00:00
Hai Anil,
I am new user ,as i have seen all the solutions so good,and good site for me to interact with u, so i got a task ,that task is as the output of rdf should be in excel format, i have been through mime setup but there specified navigation steps are not there in my system how to solve this ,if have doc or flow send me
thanks
suri
Quote
0 #64 pradeep 2007-07-02 00:00
Hi Anil,
I feel comfortable if you add a search engine for your article and regarding hot topics,so that the users will get their resource by giving the search string.

Than ks & regards,
Prade ep.K
Quote
0 #65 poonam 2007-07-02 00:00
I want to subscribe to oracle apps article
Quote
+1 #66 Dammu 2007-07-02 12:30
I am new to this world and I find it extremely interesting to read and practice

Thank s®ards
Dammu
Quote
0 #67 farhan 2007-07-08 14:59
i want to subscribe oracle apps article at my email id
Quote
+1 #68 Ravneet 2007-07-11 09:41
this is the best site for people like us,who are is search of knowledge.
I wd b glad to be a subscriber for this site.Thanks a lot Anil for ur support.
Quote
0 #69 Martin kimario 2007-07-31 13:25
Hi Anl,
I am new in oracle world and I find this site more than helpfull,thus I would like to convey my sincerely gogratulation for the effort you always put to make me proffessional.
kindly Regard,
martin( Lenduli)
Quote
0 #70 dawei wang 2007-08-02 18:20
Excellent site. Thanks
Quote
-1 #71 ravi chadand 2007-08-07 09:08
please send the updates on Oracle HRMS functional to my mail ID
Quote
0 #72 Priyanshi Goel 2007-08-07 11:26
hi
this is a very good site to study
please also send us the practicals of all the things we do in Apps
Quote
0 #73 Narendra 2007-08-13 19:57
Hi Anil,

I was asked in an interview what is the difference in Oracle Applications Forms Development and Forms Extension. I tried to explain like extension is adding functionality to seeded form and development is write new form. Was I correct ??

Regarding development I talked about the APPSTAND base form and adding DB blocks and columns based on busniess requirement business requirement for a new form. Extension would be adding new columns logic to capture additional information or something like that.

REquest if can you throw some light on this. In this is something new then would like to know abt it.
Regards
Quote
0 #74 Farooque 2007-08-14 06:41
Excellent Excellent work done by Anil ,Great effort and Knowledge sharing attitude.

Spec ially for Oracle HRMS consultants , this site is really helpful for them even for experienced consultants it will serve like a revision or quick reference guide.

Keep it up Dear Anil.
Quote
0 #75 meraj mohammad 2007-08-14 20:51
Anil,
Can you explain the process of migration Sql Server database to Oracle 10G. The client here wants to do the same. I guess we can use Migration Workbench but since I have never used it , its taking a while for me to figure out. The client is in a hurry. Can you help us out here by providing documentation or your scripts for examples and some tips as to how we can achieve the mentioned task. Appreciate your help.
Thanks in advance.
Regard s
Meraj Mohammad
Quote
0 #76 meraj mohammad 2007-08-14 20:52
Anil,
My email address is regarding the Migration Workbench.
Than ks
Meraj Mohammad
Quote
0 #77 radhikaM 2007-08-16 17:17
Hi Anil:

Thanks for sharing this great information ..... and please do keep up your good work!!!

Radhika
Quote
-1 #78 madhav 2007-08-20 09:43
Hiii Anil
I am new to OA Framework...
Actually i want open new page depending on the value passed by the button, but unfortunatly i can't get the required result. Instead it gives the blank page only......
I have written initQuery & initDetails methods & also the code for button in CO....
Please help me by giving some suggestions or the code.
Thanks... ............... ........
Quote
0 #79 achudan-orkut 2007-08-20 11:03
hi anil, how ar eu. rememebr me achudan.. i joined in hcl..how are u.. i need a help from you.. i ned stetup steps for compensation workbench, atleast for workplans and budget allocation.. i need one more help its like.. my clien company wants customisation like all the plans like they have three plans should be visioble in one worksheet for an employee.. i need some tech help.. you are the tech and cuntional guru naa.. pls help me.. well dont mail me to maha.suji2007@g mail.. as i cannot access gmail from here.. mail me to my offcial id..

pls.. i will be waiting for your reply.. for sure.. pls do the need ful gurujee..

take care

maha alias achudan[orkut]
Quote
0 #80 Anand 2007-08-21 11:10
Hi Anil,

Great Anil, you did good job.I required details about TCA and Auto Lock Box in AR.

Thanks .........
Quote
0 #81 Ravi Saini 2007-08-24 07:59
hi anil
i am working as a apps technical conslulant, i want to work on xml, fusion, and discovrer please tell me the step that i can learn these technologies soon with sysmatic way. want to do something unique in field of apps help me i can do hard labour but i don't know the way......Ravi Saini
Quote
0 #82 Ashish Bhatt 2007-08-27 05:30
Dear Anil,
Thank you Very much for providing such a great help online for
Techno Functional Support.
Its a great initiative and we appreaciate your contribution in Spreading Knowledge.

Rgd s
Ashish
Quote
0 #83 Prasanna 2007-08-28 17:32
Hi Anil,

Can u tell me what are the real time challenges that an oracle financial functional consultant is going to face and also some of the gaps we find in the real time.a reply to this will be a great help to me.(I dont wether this is the right palce to post).is i am wrong i am sorry about that.
Quote
-1 #84 arumalla 2007-08-31 15:58
Hi Anil,
I wolud like to know the sample unix scripts to run the oracle apps package.
with parametrs.

Rgd s
Dinesh
Quote
-1 #85 Abddul Rahiman 2007-09-01 05:16
Hi Anil,

This is a very good site to study.I want flow of Order Management step by step
front end setups could you provide me
Regards
Abdu l Rahiman
Quote
0 #86 charchumallrohini 2007-09-05 10:16
Hi Anil,

How I want to display the images in report from oracle applications. I got the images in the oracle report but not running in apps. Should i change the report type as XML type in conc pgm. pls clarrify my doubt.

The image which i took it from the database table.

regrads ,
venkat
Quote
0 #87 Anil Passi 2007-09-05 21:54
Hi Venkat

You haven't mentioned what you did to display the reports from PC.

As for XMLP, if the RTF contains an image, that should be parsed by XMLP and hence that should appear in the final output

Thanks
Anil
Quote
0 #88 charchumallrohini 2007-09-07 05:50
Hi Anil,

I mean that i have the requirement to display the photo of individual employee in apps report which comes from core HRMS module. The images stores in PER_IMAGES table as LongRAW datatype. Iam getting the photo when i execute the querry in the report builder but not getting in apps when i running the concurrent progrm.

Even though i 've changed the output type as XML and save into XML format but iam getting the source file(xml file).

Hope i ellaborate the requirement and expecting the solution from u asap.

Thanks & Regards,
venkat
Quote
0 #89 Anil Passi 2007-09-07 10:30
Hi Venkat


I spoke to a friend in Oracle, and he says this should work on R12, provided you upgrade BI Publisher to version Oracle BI Publisher (10.1.3.3)
This can be downloaded from
www.oracle.com/technology/software/products/publishing/index.html

I am afraid, if you are on 11.5.10, then this wouldn't work on XMLP.
A workaround could be to build a OA Framework page with search fields matching the report parameters

Tha nks,
Anil Passi
Quote
0 #90 Pankaj Kumar Agarwal 2007-09-09 09:15
Really a great work to share and enhance your knowledge.
Quote
0 #91 s.kumar 2007-09-14 13:29
hai all am new to this world of hrms
Quote
0 #92 Raj K 2007-09-20 13:05
Hi,
Im new to Oracle apps. Could you please let me know how to add function menu to the existing responsibility & add a new item to the existing function menu.

Thanks
Quote
0 #93 Hi 2007-09-23 19:32
Anil,

quick question, is there a way to default a value in a DFF from OM order header to the line item. If so. please provide the steps, have urgent requirement

Th ks in advanced.
Quote
0 #94 Anil Passi 2007-09-24 05:57
Hello Hi

Please use the default property of DFF as shown below.
You will use default type of Field, and default value of :ORDER_HEADER_BLOCK.ATTRIBUTEn


Thanks,
Anil Passi
Quote
-1 #95 Parul 2007-09-26 07:07
This is great work
Quote
0 #96 Amrita 2007-09-27 05:06
Hi,
I like all the Oracle HRMS/Payroll articles published here.
When creating a deduction element for "401k Roth plan", do I need to classify it as 'Pre-Tax element' or 'Voluntary element'? Please provide me the answer.

Thanks in advance.
Quote
0 #97 Raj K 2007-10-01 12:48
Hi,
Im new to Oracle apps.. Could you please tell me how to add function to the menu & item to the function..

Tha nks...
Quote
0 #98 sss 2007-10-01 13:39
Hi Anil,
Could you please write about locks in FORMS?

Thanks in advance.

From
SSS
Quote
+1 #99 Shouvik 2007-10-04 11:28
Pls could you write regarding the B I reports(Discove re)

Thanks
Anand
Quote
0 #100 sushant kumar 2007-10-08 15:04
Can u explain me regarding custom folder ,how to use function like nvl etc.. in item calculation,joi n,how to create summary folder and how to save Sql query in summary folder and use later when required.how to create function in pl/sql and how it's using in item.

Thanks
sushant kumar
Quote
0 #101 Saurabh Jethi 2007-10-10 05:24
Hi Mr.Anil,

This is Saritha, having 8 years experience in Domain HR and recently i finished Oracle HRMS course..now i'm searching for a job in Oracle HRMS..could you please advise me how to approach and if possible..can you provide some realtime scenarios..

Th anks & regards
Saritha
Quote
0 #102 MALLIKA 2007-10-10 07:16
hi Mr.Anil,

I am very new to oracle apps.I just want to learn oracle fusion technologies like BPEL,
ADF and OA frameworks.Can u suggest how to learn this topics?I am very glad if u reply as soon as possible.

than k u,
mallika
Quote
0 #103 Raj K 2007-10-10 12:41
Hi Anil,
I have got a question. please help me out.
When creating a Organisation, mrp parameters didn't get created.Without these parameters setup, forecast cannot be entered.How can I do it.
Will this effect the report...
Pleas e help me out...Its very urgent.

Thanks
Deepthi.
Quote
0 #104 Mai 2007-10-11 08:33
Hi

can i run quick pay automatically, from self service or from package. The case I have is that I must pay for the employee after he/she apply to a training course, all steps from applying to the course and get approval and pay for employee will be done using self service, workflows ….. . the only missing step is : how to pay him without manually running the quick pay.

Thank for your help
Mai
Quote
0 #105 amrita 2007-10-11 12:47
Hi,

I have a sql which selects 8 columns. Out of that one of the column values has to be stored in an array. how do i do that?

Thanks in advance
Amrita
Quote
0 #106 Anil Passi 2007-10-12 08:32
Hi Mai

Its been a while since I worked on Oracle Payroll. I believe you can run the payroll concurrent program for an Element Set, as that is a parameter for Payroll Run Concurrent Program.

Hence you can create an Element Set that includes training related elements, and then schedule the process on daily basis

Thanks,
Anil Passi
Quote
0 #107 Anil Passi 2007-10-12 08:35
Hi Amrtia

Not sure I have understood your requirement properly.
If you want to return an array of columns as a single record in SQL, with data collated from different records/tables, then use the approach I have described in comment section of URL www.google.com/search?q=site:apps2fusion.com+master-detail-screen-in-oa-framework-part-i dated October 11, 2007

Thanks,
A nil Passi
Quote
0 #108 nitin tugave 2007-10-12 10:43
In xml publishere i am getting error afte creating data definition and template and attached the rtf to template here i gave data defination code name same as short name of executable and same name to tempalte . But when i run it i mean submit it thro apps it is not changing the layout which genaralyy happens and out what i am getting is xml output and not the template (rtf) which i have created can u suggest me what will be the reason

thanks
Quote
0 #109 Santosh Gokhale 2007-10-19 07:24
AME: Cost Center Approval

We are in the process of implementing iExpense along with AME. We would like to route the approval on the basis of 2 of our segments. Out of the 2 segments one is the cost center segment.

Following is the case study: The COA contains the following 8 segments. Out of whic the BC is qualified as cost center.

company.Accou nt.BC.SLA.Ser.I nd.Loc.Future

Employee submits the expense report containing 2 expense lines with the following expense lines.
Line1: 31.56101.0201.0 007.0000.00.00. 00
Line2: 31.56101.0301.0 008.0000.00.00. 00

Using AME we would like the expense report routed to different approvers based on the BC-SLA combination in the expense report. In the current situation the Expense report should be routed to the respective owners of 0201-0007 and 0301-0008.

Is this possible

Regards
Santosh
Quote
0 #110 karthikv123 2007-10-19 10:27
hi
Im new to Oracle apps and can anyone please assist me in the exercise below:

i want to display the output of the oracle apps reports in excel format(when the user makes a request in apps).I may not be correct with the question but please do help.


thank you,
karthik.
Quote
0 #111 shailesh 2007-10-22 07:29
Hi....

I am very happy about this blog i got various things from this site.....
these stuffs are used in my work....
one more thing i want to add here...
please upload more documents on Alerts in HRMs....

Thank s to Anil....GR8 job....

Shaile sh...
Quote
-1 #112 charchumallrohini 2007-10-23 10:27
Hi Anil,

hope u do well.
My questions is in inventory module, i dnt know which api is called when we do transact move order and also i want to know which api is used when i do backorder quantity in pick confirm that means there is difference between the picked qty and confirmed qty.

Immediate response can favour me a lot

Thanks & Regards,
venkat
Quote
0 #113 sanjay desai 2007-10-25 10:56
Hi Anil
You are doing a great job .. God bless you.

I am a novice in Ora.Apps.

I want to understand the cross validation rule & security rule topics with screen shots.
If psb, pl.publish the same at earliest. This will help the novice like me

Thanks in advance........
Sanjay
Quote
0 #114 Jaykay 2007-11-06 07:09
Hi,

I am trying to find a method to convert the Report output in the Apps to excel, could you help me with this.

Thanks,
Jay
Quote
0 #115 Archanap 2007-11-19 13:26
Hi,
Can any one send me interview questions for supply chain management.
Tha nks
Archana
Quote
0 #116 Navin 2007-11-22 11:09
Hi,

I have an issue of Scheduling a couple of Alerts using Script.I'm not able to find any API for that,is there a API available to schedule a Alert or any other way available..

Re gards,
Navin
Quote
0 #117 Navin 2007-11-23 04:25
Hi,

I have an issue of Scheduling a couple of Alerts using Script.I'm not able to find any API for that,is there a API available to schedule a Alert or any other way available..

Re gards,
Navin
Quote
0 #118 NAGENDER EGA 2007-11-24 10:55
Your Blog is superb and is very helpful.
Quote
0 #119 neetu 2007-12-02 16:01
sir i want you to give some model scenario about inventory (for practice purpose only) in which client requirements/sp ecification about the desired inventory is given so that i can design required set up
Quote
-1 #120 charchumallrohini 2007-12-04 11:11
Hi Anil,

You are doing the great job in oracle application field. We cannot get the pick slip report even we have double checked the available qty, after pick release the sales order the concurrent has been submitted, then when we open the pick slip report it shows error message.

Can you please revert back with the solution for this kind of problem?

Regar ds,
Venkat, Apps technical consultant
Quote
0 #121 Rajiv Grover 2007-12-04 20:07
I was looking for a brief tutorial on BES and found your training article.

Thank s for putting it out there, saved me a lot of time reading through Oracle manuals.

Regar ds,

Rajiv
Quote
0 #122 Sachin Tayade 2007-12-05 08:27
Hi Anil Sir,

Can you please tell me,is there any documentation available for Personalizing the Self service web pages.
Actually i am a beginner for this, i know form peronalization little bit, i can do little peronalization there , not very complex, but i not getting any thing in self service web pages.

If you have any documentation for this, it will be higly appreaciated.

Thank You.
Sachin Tayade.
Quote
0 #123 Sushant kumar 2007-12-19 11:13
Hi Anil,

can u help in to develop report by using Fnd Flexsql and Fnd flexidval in before report by using srw.user_exit(f nd srwinit).pleses send the whole description .
Quote
0 #124 MBhaskar 2008-01-16 06:07
Hi Anil,

i am using process_cust_ba nk_account() procedure from the API Arp_Bank_Pkg.
T his API is not populating Org_id but it is populating when we create a record from the application.pre sently we are using 11.5.10.2 version.
could you please give me solution.

Than ks & Regards,

Bhask ar.
Quote
0 #125 Alhassan 2008-01-21 11:42
Hi,

I am doing sales order conversion.
I want to convert reservation details from legacy to Oracle ERP with lot, subinv, item details.
I found that using inv_reservation _pub.create_res ervation API we can create reservation, but I am not sure we can use this along with sales order conversion API oe_order_pub.pr ocess_order.

I f anyone has done reservation conversion, please update me the approach for lot level reservation.
Mo reover, I want to do the convert hold information for sales order.
Please update me the approach for the same and also the API.

I am confuse that we should use API or Interface for reservation and Hold conversion.
Whi ch is the best way to handle this.
If need more info for clarification, please let me know.

Regards,
Piyush Gupta
Quote
0 #126 Ishwar Suthar 2008-01-22 17:33
Thanks a lot for this helpful site.I am new to Oracle Apps and i want to learn the HRMS module.Can you suggest me any good site or any good source which can give me the online training for that? and also I would like to know that which are the topics included in HRMS Module and can you plz write the article for HRMS functional from the scrach?Because I am going to learn the HRMS functional module and I don't have the detail knowledge about that.
Quote
0 #127 Ramesh 2008-02-05 11:09
Hi All,
I have a requirement to make a DFF View Only for a particular responsibility.

Requirement:-
For a particular responsibility i need to make the Move orders form view only.The form is made view only by using the function "Move Orders Inq".But the DFF present in the form is not made View only.I can make changes in the DFF.The SAVE Button in the Tool bar is disabled but I can save the record by using CTL S .Please suggest me to make this DFF (TOMAI_MAIN_HEA DER_BLK.DESC_FL EX) also view Only.

Guys plz help me on this. Can it be done with Form Personalization ?

Thanks In Advance!!

Thank You,
Sanjay
;D ;D
Quote
0 #128 Thulasi kumar 2008-02-13 08:24
Hi Anil,
i can only say just thanks you for your work.
the way you put your effort on this site with your great experience and extordinary knowlodge shows your character.

Tha nks alot.
I WISH YOU ALL THE SUCESS FOR EVERY STEP IN YOUR LIFE.

Take care as persons like you are more needed for APPS world.

bye
Quote
0 #129 Sanjaya Patro 2008-02-22 13:44
Hi Anil,
I'm very new to OA Framework development. Basically i want to modify the extended pages in Self Service HR module for Enter Overtime function which is a JSPage. I can locate the page patch. Do I need to bring up other components into jDeveloper or just that Enter Overtime function page only. Function has been deployed at responsibility level. I need you suggestions, where to start and what?

Regards,
Sanj aya Patro
Quote
0 #130 Pratap Reddy 2008-02-26 08:40
Hi Anil ,

This is wonderful site for Oracle Application.
My heartful thanks to you for providing the solutions.

Reg ards
Pratap
Quote
0 #131 Tejas Naveen 2008-02-26 19:54
Hi Anil,
I have setup different iExpenses approval rules using AME(version B). These rules are working fine and the notifications are routed correctly. Only issue I am facing is with the timeouts. If an Expense Report is not approved by the manager within 5 days(as per the setup), preparer must be notified about manager not approving his Expense Report. This works if AME is not used.Do you have any idea of how to setup timeouts using AME?
Thanks,
Te jas
Quote
0 #132 schand 2008-02-28 17:15
hi anil,

i have one requirement to make a data 11.0.3 to 11.5.9.
11.0.3 data vl be insert into 11.5.9 interface tables.
after that whatever the data inserted into 11.5.9 interface tables
those data vl appeared on the base tables(11.5.9) also.
can u plz send me the code.

Thanks
s chand
Quote
0 #133 raghav 2008-02-29 08:44
Hi this is raghavendra,

I am working on customer migration from 11.0.3 to 11.5.9 please send me related information

th anks and regards
Raghave ndra
Quote
+3 #134 Venu 2008-03-07 11:05
Hi Anil,

I'm a new member of this great site.

Can I get some material on Self Service Personalization (in HRMS), so that we can personalize the OA Framework Page?

Waiting for a positive response..!!!
Quote
0 #135 Venu 2008-03-07 11:05
Hi Anil,

I'm a new member of this great site.

Can I get some material on Self Service Personalization (in HRMS), so that we can personalize the OA Framework Page?

Waiting for a positive response..!!!

Thanks & Regards,
Amit Singhal
Quote
0 #136 Tarun Dadhich 2008-03-09 08:41
Hi Anil,

I am very happy to get this blog ...could u please help me out regarding OAF.
How can we set dynamically key flexfield's "Name" property to the code of the key flexfield.
As I have to update the key felx field via OAF page. I done aal the things but when I go to update a keyflexfield it throws a error due to mismatch of flex NAME.
Please provide me the solution.

Than ks
Tarun
Quote
0 #137 K.Satish 2008-03-13 15:45
I am new member to this site. And i have seen all your training session and interview questions. And i need your help to solve a issue in the FA Account Generator workflow builder. And also i am new to the workflow builder.

My issue is :

The issue is xyz have changed the proceeds of sale clearing account from 86502 to 13520 in the setup screen as under for both XXX CORP and CORP DEV books. The user has retired an asset on 29th Feb-08 and the asset number is 434513. But the account generator has still picked up the old value 86502 instead of 13520 for clearing account. This situation is only available in Prod. I think you would have got the prod. back end access.

The possible solutions were

(i) the user has retired the asset before changing the value to 13520. pl. check the retirement was happened only after changing the clearing account value.

(ii) due to customization of account generator which is still picking up the old value instead of new value. (work with tech. team for resolution.)


So, please help me.

Quote
0 #138 Raajaa 2008-03-14 02:33
Hi Anil,
I have been a regular visitor to your site and I have aquired a lot of knowledge. When I forget or have any issue I immediately log in to our web site for a solution. However, I have a request for you. I did come across couple topics related to Order Management. One is the Order To Cash and Period End Closing. These are the only two topics you coverer in Order Management.

I f you don't mind please can you give us some brief Technical and Functional approach in Order Management. The whole Life Cycle of Order Management. The modules that interact with Order Management and Technically what are the steps need to be followed and the Tables that influen or to be more focussed. For Example Let's say there is fresh start of OM in a company, what would be the approach from the Functional perspective and for a Technical person what would be the approach. What are the functional set up steps to be implemented. What are the Technical(Table s, API's etc..) in depth concepts.

It would be great help for all viewer's.

Thanks
Dinu
Quote
0 #139 AREZQI Rachid 2008-04-04 06:19
Hi Mr.Anil,
I am working as a softwere developer in one of the big MNC.
Now I am changed my technologies are Oracle ADF and BC4J with JAVA/J2EE.How is the feature in these technoligies.I am thinking somuch for this technologies.Pl z give me answer.
Any difference in between OAF and ADF frameworks.

Thanks & Regards,
Balaji Goud.A
Quote
0 #140 shaik sheru 2008-04-18 06:37
Dear Anil,

We implemented Oracle iRecruitment and land up with one issue. The issue goes like this
Client have two groups at India and England both have different websites login to the Oracle iRecruitment.Th e issue comes here when they login from England web sites they want to view company logo and when login through India website they don’t want to see the logo.

Let me sum of the issue with example:

We have to web sites one is ABCD.COM and 1234.COM and one Oracle iRecruitment home page.

Case 1:

When they login from ABCD.COM can view company LOGO and

When they login from 1234.COM cannot view company LOGO.

Please let me is it possible.

Rega rds,
Fazlullah Shaik
Quote
0 #141 vimalraj 2008-04-30 09:09
I need you help in solving cheque printing ,. Business need single cheque for a vendor and its sites. ( ie. If a vendor is having
5 sites and oracle prints 5 cheques for each site. But we need to print 1 cheque for all 5 sites.)

Regard s

Vimalraj
Quote
0 #142 Omar Hawsawi 2008-05-16 08:31
thanks for this site

Best Regards
Omar Hawsawi
Quote
+1 #143 Ashwini 2008-06-04 13:01
Please let me know the usage of rwrun.sh command from UNIX prompt.

I need to run the rdf PAXACMPT.rdf from the command line using rwrun.sh

PAXACMPT has 4 mandatory parameters. Please let me know the usage of rwrun.sh

I tried using the following syntax: rwrun.sh report= /ebsdevl/applde vl/apps/apps_st /appl/pa/12.0.0 /repo rts/US/PAXACMPT .rdf userid=hboxrw/d evel07 batch=yes mode=character destype=file desname=PAXACMP T.txt desformat=wide

Please help me out.
Quote
+1 #144 Satya 2008-07-02 22:17
Hello,

I am looking for answers on implementing secured BPEL process.

Requi rement: How to secure a BPEL process?

I have designed a BPEL process(for the simplicity of understanding, lets say HelloWorld process) using Oracle JDEV and deployed it on SOA suite server(installe d locally on the same laptop), so it is not public webservice; but whosoever knows the WSDL url for my BPEL process within the intranet would be able to invoke it.

Hence I wanted to secure the BPEL process from rest of the world except authorized requestors. Ultimately my BPEL process will be called from other external webservices and there I need security mechanism in place to validate the authentication of requestor/exter nal webservice.

Please let me know if you need any additional information for more information see appended mail.


Thanks,
Quote
0 #145 bhanuchandra 2008-07-13 23:44
Hi,
i am looking for this mail
Quote
-1 #146 Rameshkumar 2008-07-18 03:04
Hi Anil,
I am working on iStore and iSupport integration.
I have done all cofigration setup for istore and isupport integration, but not display quick menu in istore home page.
please give any idea.

Thanks
R ameshkumar
Quote
0 #147 kasi 2008-07-30 06:00
hi,
This is a great job done by you all and i have been viewing this site from past 1 year
and i have an idea as it would help us alot if u can provide both the
procure to pay and order to cash cycle with a technical perspective.
as showing the tables and the change in their status depnding on the flow.
wud it be great...
Regard s,
kasi
Quote
0 #148 Luis 2008-08-13 17:24
this site is excellent, congratulations .
Quote
0 #149 Khalid Mahmood 2009-01-26 08:41
Hi Anil..

Can you provide few doc's, training stuff on Property Manager module, i joined a new organization apart from fin/HR/Pur they have PM in which am newbie, i was searching for few basics things to startup learing process, then i thought lets ask Mr.Apps Guru, one and only Anil Sir..!! I'll be obliged if u can help in getin a kick start in Property Manager module..Technic ally and functionally as well..

Long Live apps2fusion..!!
Quote
0 #150 kavi723 2009-03-04 07:47
Anil,

Would you be able to give me system audit presentation for 11i GL/AP/AR modules. Basically for an IT auditor what is pre-requistie and if any specific documents available which talks about GL auditing and how auditing can be accomplished by auditor will be great help...I have basic knowledge of Oracle apps framework and understand Oracle financials...ap priciate your help.

Kavi
Quote
0 #151 Anil Passi 2009-04-27 15:40
Hi Kavi

Just google for
audit site:apps2fusio n.com

You will find various articles on auditing in eBusiness Suite.

Thanks
Anil
Quote
0 #152 Shreya - India 2009-08-05 19:17
Hi Anil
I am working in oracle application as developer from last 2 years.
But somehow coding finds difficult for me. thinking to change the strem in oracle apps itself.
But in confusion ..whether to select DBA strem/functiona l/testing.
Your opinion will be of strong help. Does DBA stream requires coding ? will it be easy than development ? Is there any tetsing course in Orace apps ? Will finctional strem will be fine for me as I have got some functional experience while working as developer ?
Please help.
Regards.
Shrey a.
Quote
0 #153 Ashish Puri 2009-08-26 05:02
Hi Anil,

I have created one Business Group in HRMS in R12. Further I have set the profile Option : "Enable Security Group to Yes"...However the problem is when I try to define Job Group (HRMS->Work Structures->Job ->Job Group), I dont find my Business Group in the LOV rather it shows the default..

Coul d you please let me how should i get the one I defined..

Than ks,
Ashish Puri
Quote
0 #154 murali 2009-09-11 07:03
Hi Anill,

Your explanation is very clear but can you provide videos with some sample report and form customizations in financial modules
Quote
0 #155 DonthireddySunilKumarrReddy 2010-01-07 09:54
Can explain basic setups in P.A module
Quote
+1 #156 FourCs 2010-01-13 06:54
Hi,

I am new in Oracle WMS ,Our client want us to :
1.When Receiving Items Schedule 6 drugs -- This drugs must be only Received by Pharmacist
2.When Log in on the scanner if u don't have access to receive this drugs the system must deny access to this user.

Where can I start doing my customization for this requirement .
Your help will be much appreciated.
Quote
0 #157 BalaKrishna 2010-06-02 20:33
This site is really very useful for person working in Oracle APPS. I got to know about it recently only.

Thanks for everyone..
Quote
0 #158 Rajesha 2010-09-12 01:28
Currently we are using 11.5.10.2. Since oracle is recommending to apply minimum base line patches to get extended support starting from 01-Dec-2010, we are getting rteady to apply required patches.

1) I am following the documents in metalink.. I want to know how to decide what product specific patches needs to applied... there are customoization in the current environment... (I don't know the complete customization as i am new to the organization). I am concerned to apply all recomennded patches incase the patches removes all customization.. .
Your expereince , analysis that must be completed will be a great help

Thanks
Ra jesha
Quote
-1 #159 Renganayaki 2010-11-20 10:17
Hi Anil,

I am looking for some good materials with screenshots to start learning Oracle Process Manufacturing.
Could you please suggest some materials / Books / Blogs?..
Quote
0 #160 bonbonboy 2011-01-25 12:57
Hello! Anil, can you tell me the basic rules for implementation R12 in small industry?
Quote
0 #161 Dakshesh Patel 2011-05-11 02:10
Hi,
I have made a custom workflow for approval but i am not getting item_key in hr_api_transact ion of custom worklfow .
I want to integrate custom workflow with AME.
so please help me.

Regards,
D akshesh Patel
Quote
0 #162 krishnan 2011-11-04 09:27
In our company Oracle 12g implementation in progress, without Treasury module

We have n number of Fixed Assets in deifferent currencies with different maturity periods.

We need to maintain the number of FDs earned interest during a particular period and which one is maturing in the current
period? and so on,

Can u suggest this can be maintained in GL, with customised reports?

Regar ds,

Krishnan
Quote
-1 #163 Jonna 2011-12-06 04:51
I WOULD LIKE TO KNOW MORE ABOUT Order management Functional setups
Quote
0 #164 va 2012-02-06 00:55
Hi,
I tried to change the record group query for an lov in a standard form through form personalization .

But it is giving error shown below

FRM-4182 6 : cannot replace group ; Columns don't match LOV.
Quote
0 #165 Purushotham 2012-03-25 14:08
hi anil,

You are doing great job...
Please reply me " How can dynamically change the company logo on the reports"

Thanks
Purush
Quote

Add comment


Security code
Refresh

Search Trainings

Fully verifiable testimonials

Apps2Fusion - Event List

<<  Apr 2024  >>
 Mon  Tue  Wed  Thu  Fri  Sat  Sun 
  1  2  3  4  5  6  7
  8  91011121314
15161718192021
22232425262728
2930     

Enquire For Training

Fusion Training Packages

Get Email Updates


Powered by Google FeedBurner