Apps To Fusion

.......contents copyright protected by FocusThread UK Ltd

 
  • Increase font size
  • Default font size
  • Decrease font size
We are glad to announce the launch of Forum for Customizations and Extensions. Click here to visit http://apps2fusion.com/forums
Our OA Framework, BPEL Development & Apps DBA Trainings from USD 299 only [on weekends] . Click here for details.
Also see here fully verifiable feedbacks/testimonials

Subscribe to New Oracle Apps Articles on this Website by Email

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
Comments (148)add
...
written by Lalitha , January 19, 2007
Hi Anil
Congratulations for the great job done ..
rgds
report abuse
vote down
vote up
Votes: +0
...
written by Lalitha , January 19, 2007
Hi Anil
Congratulations for the great job done ..
rgds
report abuse
vote down
vote up
Votes: +0
...
written by MB , January 31, 2007
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.
report abuse
vote down
vote up
Votes: +0
...
written by Anil Passi , February 04, 2007
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[business flow], then I can suggest you some options? Please email me

Thanks,
Anil Passi
report abuse
vote down
vote up
Votes: +0
...
written by Milind , February 04, 2007
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
report abuse
vote down
vote up
Votes: +0
...
written by sreedevi u , February 14, 2007
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
report abuse
vote down
vote up
Votes: +0
...
written by bharat , February 19, 2007
I want to know if i can use xml publisher for the programs like transaction register which is a spawned process.
report abuse
vote down
vote up
Votes: +0
...
written by Anil Passi , February 20, 2007
hi bharat,

output 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
report abuse
vote down
vote up
Votes: +0
...
written by Regarding value sets , February 22, 2007
Hi,

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

Regards
Venu
report abuse
vote down
vote up
Votes: +0
...
written by Jason , February 27, 2007
Thanks
report abuse
vote down
vote up
Votes: +0
...
written by uma , February 28, 2007
Dear Anil,

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

thanks in advance
regards
uma
report abuse
vote down
vote up
Votes: +1
...
written by Anil Passi , February 28, 2007
hi vijay


please see the Examples section in www.xslfo.info

www xslfo info
report abuse
vote down
vote up
Votes: -1
...
written by Vijay Srinivas , February 28, 2007
Hi Anil,

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

Regards,
Vijay Srinivas
report abuse
vote down
vote up
Votes: +0
...
written by kishore , March 02, 2007
I want to learn Purchasing module but in this there is not mentioned PO cycle.Plz help me out on this issue
report abuse
vote down
vote up
Votes: +0
...
written by Fred Forsythe , March 06, 2007
Great site, fantastic resource
report abuse
vote down
vote up
Votes: +0
...
written by Ashish , March 08, 2007
Awesome Work!
report abuse
vote down
vote up
Votes: +0
...
written by Ashish , March 08, 2007
Awesome Work!
report abuse
vote down
vote up
Votes: +0
...
written by asit , March 13, 2007
I would like to gather technical knowledge and looks like after lot of search. I will stop here.
thanks Anil.
report abuse
vote down
vote up
Votes: +0
...
written by Kamal , March 13, 2007
I found this site a good resource to know abt Oracle Apps - HRMS.
Good work, keep it up
Thanks
report abuse
vote down
vote up
Votes: +0
...
written by Anil Passi , March 14, 2007
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
report abuse
vote down
vote up
Votes: +0
...
written by ram , March 19, 2007
Hi,

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

regards,

ram
report abuse
vote down
vote up
Votes: +0
...
written by rashi , March 23, 2007
Hi anil,
its really really wonderfull and helping site.i have one question.actually i want to about oracle apps certification.will you please tell me about it.

Thanks and regards,
Rashi
report abuse
vote down
vote up
Votes: +0
...
written by Anil , March 24, 2007
Hi Rashi

Please use this link for the information required

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

Thanks
Anil
report abuse
vote down
vote up
Votes: +0
...
written by venkat reddy duddukunta , March 28, 2007
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
report abuse
vote down
vote up
Votes: +0
...
written by Madhu , March 28, 2007
hi,
You are doing a wonderful and thankless job by providing so much information related to Oracle Apps.

Thank you very much
report abuse
vote down
vote up
Votes: +0
...
written by Anil Passi , March 28, 2007
SID,

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

thanks
anil
report abuse
vote down
vote up
Votes: +0
...
written by sid , March 28, 2007
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
report abuse
vote down
vote up
Votes: +0
...
written by Arun Kumar , March 29, 2007
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.
report abuse
vote down
vote up
Votes: +0
...
written by Nakul Venkataraman , March 29, 2007
Hi Anil
Could you please explain me the concept behind interfaces in Apps ?

Yours Nakul.V
9940424744
report abuse
vote down
vote up
Votes: +0
...
written by Anil Passi , March 31, 2007
Hi Arun,

Interfaces 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.

Thanks,
Anil
report abuse
vote down
vote up
Votes: +0
...
written by navaz , April 02, 2007
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??

Regards
Navaz
report abuse
vote down
vote up
Votes: +0
...
written by raja , April 04, 2007
good site
report abuse
vote down
vote up
Votes: +0
...
written by Ray , April 04, 2007
This page is sooo great!!!

Thanks and congratulations!
report abuse
vote down
vote up
Votes: +0
...
written by Srikanth , April 04, 2007
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
report abuse
vote down
vote up
Votes: +0
...
written by soujanya , April 11, 2007
Hi Anil,

Wonderful 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.

Thanks a lot in advance.
report abuse
vote down
vote up
Votes: +0
...
written by Anil Passi , April 16, 2007
Hi Jan

You will need to extend the Entity Object for Framework. Please have a look at
http://oracle.anilpassi.com/oa-framework-entity-objects-thinking-from-d2k-mindset.html

and also, have a look at http://oracle.anilpassi.com/ip...count.html

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

Bussiness Events
-----------
You can also try subscribing to oracle.apps.per.api.person.update_person
OR
oracle.apps.ar.hz.Person.create
The latter will be fired because HRMS creates a party behnid the scenes.

Thanks,
Anil Passi
report abuse
vote down
vote up
Votes: +0
...
written by Jan Schipper , April 16, 2007
Hello Anil,

How can we include extra server validations in SSHR, for example a check whether the entered email address on /oracle/apps/per/selfservice/personalinformation/webui/NewhirePersonPG does not exists in the database (like the check on employee number)? Thanks in advance

best regards, Jan
report abuse
vote down
vote up
Votes: +0
...
written by Ramkumar , April 23, 2007
hi anil,
i have one one requirement that how to set upemail notifications in iexpenses and oracle time and Labor.


regards
ram
report abuse
vote down
vote up
Votes: +0
...
written by Lalith , April 24, 2007
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..
report abuse
vote down
vote up
Votes: +0
...
written by M.Sattar , April 27, 2007
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
report abuse
vote down
vote up
Votes: +0
...
written by Sateesh Kumar , April 28, 2007
Site is very usefull.Thanks for maintaining it with such a valueable inforamtion
report abuse
vote down
vote up
Votes: +0
...
written by Anil Passi , May 01, 2007
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.

Thanks,
Anil Passi
report abuse
vote down
vote up
Votes: +0
...
written by kamal , May 08, 2007
hi
i want know how to upgrade oracle application from 10.7 version to 11.5.10
report abuse
vote down
vote up
Votes: +1
...
written by Shireen ZM , May 09, 2007
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,
Shireen
report abuse
vote down
vote up
Votes: +0
...
written by Sameer , May 09, 2007
Hi anil,

Registered 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 !!!
report abuse
vote down
vote up
Votes: +0
...
written by Anil Passi , May 09, 2007
Hi Shireen

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

Just google for it.


Cheers
Anil
report abuse
vote down
vote up
Votes: +0
...
written by Anil Passi , May 09, 2007
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
report abuse
vote down
vote up
Votes: +0
...
written by salim , May 10, 2007
Hi Anil,

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

Thanks
Salim
report abuse
vote down
vote up
Votes: +0
...
written by Nimish , May 14, 2007
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.

thanks,
Nimish
report abuse
vote down
vote up
Votes: +0
...
written by Anil Passi , May 14, 2007
Hi Amar

Thats right, the interface line attributes are VARCHAR2, because they store details for other transaction types too, hence could contain characters.Hence it is important that when doing such join, you must also filter on interface_header_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
report abuse
vote down
vote up
Votes: +0
...
written by VAS , May 22, 2007
Hi,
Can you send me articles on Manufacturing & OPM pertaining to release 12.
regards,
VAS
report abuse
vote down
vote up
Votes: +0
...
written by naveen , May 24, 2007
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
report abuse
vote down
vote up
Votes: +0
...
written by abhineet , May 30, 2007
sir,
I want to know without doing oracle apps sql based only doing OA Framework java based will be useful in life.

abhineet
report abuse
vote down
vote up
Votes: +0
...
written by Shankar , June 08, 2007
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
report abuse
vote down
vote up
Votes: +0
...
written by ramakrishna , June 09, 2007
Sir,
I have been your ardent admirer from beginning.
Great Job!!!

Ramki
report abuse
vote down
vote up
Votes: +0
...
written by Kiran , June 12, 2007
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.

Thanks
Kiran.
report abuse
vote down
vote up
Votes: +0
...
written by kamal , June 13, 2007
hi anil,
i want to know the information abt oracle application migration.

regards,
kamal
report abuse
vote down
vote up
Votes: +0
...
written by Anil Passi , June 19, 2007
Hi RK

the syntax is ${global.XX_G_VAR1.value}

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

Thanks,
Anil
report abuse
vote down
vote up
Votes: +0
...
written by suha , June 25, 2007
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...
regards
suha
report abuse
vote down
vote up
Votes: +0
...
written by Anil Passi , June 25, 2007
Suha

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

Thanks
Anil
report abuse
vote down
vote up
Votes: +0
...
written by Vivek , June 27, 2007
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.

Vivek K Bhattu
report abuse
vote down
vote up
Votes: +0
...
written by suri , June 29, 2007
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
report abuse
vote down
vote up
Votes: +0
...
written by pradeep , July 02, 2007
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.

Thanks & regards,
Pradeep.K
report abuse
vote down
vote up
Votes: +0
...
written by poonam , July 02, 2007
I want to subscribe to oracle apps article
report abuse
vote down
vote up
Votes: +0
...
written by Dammu , July 02, 2007
I am new to this world and I find it extremely interesting to read and practice

Thanks®ards
Dammu
report abuse
vote down
vote up
Votes: +0
...
written by farhan , July 08, 2007
i want to subscribe oracle apps article at my email id
report abuse
vote down
vote up
Votes: +0
...
written by Ravneet , July 11, 2007
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.
report abuse
vote down
vote up
Votes: +0
...
written by Martin kimario , July 31, 2007
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)
report abuse
vote down
vote up
Votes: +0
...
written by dawei wang , August 02, 2007
Excellent site. Thanks
report abuse
vote down
vote up
Votes: +0
...
written by Priyanshi Goel , August 07, 2007
hi
this is a very good site to study
please also send us the practicals of all the things we do in Apps
report abuse
vote down
vote up
Votes: +0
...
written by Narendra , August 13, 2007
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
report abuse
vote down
vote up
Votes: +0
...
written by Farooque , August 14, 2007
Excellent Excellent work done by Anil ,Great effort and Knowledge sharing attitude.

Specially 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.
report abuse
vote down
vote up
Votes: +0
...
written by meraj mohammad , August 14, 2007
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.
Regards
Meraj Mohammad

report abuse
vote down
vote up
Votes: +0
...
written by radhikaM , August 16, 2007
Hi Anil:

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

Radhika
report abuse
vote down
vote up
Votes: +0
...
written by madhav , August 20, 2007
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..........................

report abuse
vote down
vote up
Votes: +0
...
written by achudan-orkut , August 20, 2007
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@gmail.. as i cannot access gmail from here.. mail me to my offcial id.. \n This e-mail address is being protected from spambots. You need JavaScript enabled to view it '> This e-mail address is being protected from spambots. You need JavaScript enabled to view it

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

take care

maha alias achudan[orkut]
report abuse
vote down
vote up
Votes: +0
...
written by Anand , August 21, 2007
Hi Anil,

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

Thanks .........

report abuse
vote down
vote up
Votes: +0
...
written by Ravi Saini , August 24, 2007
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
report abuse
vote down
vote up
Votes: +0
...
written by Ashish Bhatt , August 27, 2007
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.

Rgds
Ashish
report abuse
vote down
vote up
Votes: +0
...
written by manjusha konakanchi , August 28, 2007
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.

report abuse
vote down
vote up
Votes: +0
...
written by arumalla , August 31, 2007
Hi Anil,
I wolud like to know the sample unix scripts to run the oracle apps package.
with parametrs.

Rgds
Dinesh
report abuse
vote down
vote up
Votes: +0
...
written by Abddul Rahiman , September 01, 2007
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
Abdul Rahiman

report abuse
vote down
vote up
Votes: +0
...
written by venkat , September 05, 2007
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
report abuse
vote down
vote up
Votes: +0
...
written by Anil Passi , September 05, 2007
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
report abuse
vote down
vote up
Votes: +0
...
written by venkat , September 07, 2007
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

report abuse
vote down
vote up
Votes: +0
...
written by Anil Passi , September 07, 2007
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
http://www.oracle.com/technolo...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

Thanks,
Anil Passi
report abuse
vote down
vote up
Votes: +0
...
written by Pankaj Kumar Agarwal , September 09, 2007
Really a great work to share and enhance your knowledge.
report abuse
vote down
vote up
Votes: +0
...
written by s.kumar , September 14, 2007
hai all am new to this world of hrms

report abuse
vote down
vote up
Votes: +0
...
written by deepthi , September 20, 2007
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

report abuse
vote down
vote up
Votes: +0
...
written by Hi , September 23, 2007
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

Thks in advanced.
report abuse
vote down
vote up
Votes: +0
...
written by Anil Passi , September 24, 2007
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
report abuse
vote down
vote up
Votes: +0
...
written by Parul , September 26, 2007
This is great work
report abuse
vote down
vote up
Votes: +0
...
written by Amrita , September 27, 2007
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.
report abuse
vote down
vote up
Votes: +0
...
written by deepthi , October 01, 2007
Hi,
Im new to Oracle apps.. Could you please tell me how to add function to the menu & item to the function..

Thanks...
report abuse
vote down
vote up
Votes: +0
locks in apps
written by sss , October 01, 2007
Hi Anil,
Could you please write about locks in FORMS?

Thanks in advance.

From
SSS
report abuse
vote down
vote up
Votes: +0
Discovere
written by Anand Rao K , October 04, 2007
Pls could you write regarding the B I reports(Discovere)

Thanks
Anand
report abuse
vote down
vote up
Votes: +0
discoverer
written by sushant kumar , October 08, 2007
Can u explain me regarding custom folder ,how to use function like nvl etc.. in item calculation,join,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
report abuse
vote down
vote up
Votes: +0
Need Advise
written by Saritha , October 10, 2007
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..

Thanks & regards
Saritha
report abuse
vote down
vote up
Votes: +0
LEARNING
written by MALLIKA , October 10, 2007
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.

thank u,
mallika


report abuse
vote down
vote up
Votes: +0
Adding MRP Parameters to the Organisation to enable forecasts to suppliers
written by deepthi , October 10, 2007
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...
Please help me out...Its very urgent.

Thanks
Deepthi.
report abuse
vote down
vote up
Votes: +0
Running quick pay automatically
written by Mai , October 11, 2007
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
report abuse
vote down
vote up
Votes: +0
using of array
written by amrita , October 11, 2007
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
report abuse
vote down
vote up
Votes: +0
...
written by Anil Passi , October 12, 2007
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
report abuse
vote down
vote up
Votes: +0
...
written by Anil Passi , October 12, 2007
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 http://oracle.anilpassi.com/ma...art-i.html dated October 11, 2007

Thanks,
Anil Passi
report abuse
vote down
vote up
Votes: +0
xml publisher
written by nitin tugave , October 12, 2007
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
report abuse
vote down
vote up
Votes: +0
AME: Cost Center Approval
written by Santosh Gokhale , October 19, 2007
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.Account.BC.SLA.Ser.Ind.Loc.Future

Employee submits the expense report containing 2 expense lines with the following expense lines.
Line1: 31.56101.0201.0007.0000.00.00.00
Line2: 31.56101.0301.0008.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
report abuse
vote down
vote up
Votes: +0
Oracle Reports
written by karthikv123 , October 19, 2007
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.
report abuse
vote down
vote up
Votes: +0
regarding alerts
written by shailesh , October 22, 2007
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....

Thanks to Anil....GR8 job....

Shailesh...
report abuse
vote down
vote up
Votes: +0
pick release backorder api
written by venkat , October 23, 2007
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

report abuse
vote down
vote up
Votes: +0
cross validation rule & security rule
written by sanjay desai , October 25, 2007
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


report abuse
vote down
vote up
Votes: +0
Reports conversion
written by Jaykay , November 06, 2007
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
report abuse
vote down
vote up
Votes: +0
Oracle Supply chain management
written by Archanap , November 19, 2007
Hi,
Can any one send me interview questions for supply chain management.
Thanks
Archana
report abuse
vote down
vote up
Votes: +0
...
written by Navin , November 22, 2007
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..

Regards,
Navin

report abuse
vote down
vote up
Votes: +0
...
written by Navin , November 23, 2007
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..

Regards,
Navin
report abuse
vote down
vote up
Votes: +0
NAG
written by NAGENDER EGA , November 24, 2007
Your Blog is superb and is very helpful.
report abuse
vote down
vote up
Votes: +0
inventory set up
written by neetu , December 02, 2007
sir i want you to give some model scenario about inventory (for practice purpose only) in which client requirements/specification about the desired inventory is given so that i can design required set up
report abuse
vote down
vote up
Votes: +0
Pick Slip Report Returns "No Data Found"
written by venkat , December 04, 2007
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?

Regards,
Venkat, Apps technical consultant
report abuse
vote down
vote up
Votes: +0
...
written by Rajiv Grover , December 04, 2007
I was looking for a brief tutorial on BES and found your training article.

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

Regards,

Rajiv
report abuse
vote down
vote up
Votes: +0
Documentation for Personalizing the Self service web pages.
written by Sachin Tayade , December 05, 2007
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.
report abuse
vote down
vote up
Votes: +0
Flexsql
written by Sushant kumar , December 19, 2007
Hi Anil,

can u help in to develop report by using Fnd Flexsql and Fnd flexidval in before report by using srw.user_exit(fnd srwinit).pleses send the whole description .
report abuse
vote down
vote up
Votes: +0
Hi
written by MBhaskar , January 16, 2008
Hi Anil,

i am using process_cust_bank_account() procedure from the API Arp_Bank_Pkg.
This API is not populating Org_id but it is populating when we create a record from the application.presently we are using 11.5.10.2 version.
could you please give me solution.

Thanks & Regards,

Bhaskar.
report abuse
vote down
vote up
Votes: +0
Oracle Sales Order Reservation & Hold conversion
written by piyush gupta , January 21, 2008
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_reservation API we can create reservation, but I am not sure we can use this along with sales order conversion API oe_order_pub.process_order.

If anyone has done reservation conversion, please update me the approach for lot level reservation.
Moreover, 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.
Which is the best way to handle this.
If need more info for clarification, please let me know.

Regards,
Piyush Gupta

report abuse
vote down
vote up
Votes: +0
Nice
written by Madhavi , January 22, 2008
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.
report abuse
vote down
vote up
Votes: +0
Want to make a DFF view Only for a particular responsibility
written by sanjay , February 05, 2008
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_HEADER_BLK.DESC_FLEX) also view Only.

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

Thanks In Advance!!

Thank You,
Sanjay
This e-mail address is being protected from spambots. You need JavaScript enabled to view it