<-----Google Analytics Code Start----> <-----Google Analytics Code Close---->
Skip to content

Green

color

Default screen resolution  Wide screen resolution  Increase font size  Decrease font size  Default font size  Skip to content Default color Pink color Green color Green color
Home arrow Receive Email for New Articles
This website has now moved to http://apps2fusion.com





Subscribe to My Oracle Apps Articles by Email | Print |  E-mail
Written by Anil Passi   
Friday, 19 January 2007

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 (138)add
...
written by Lalitha , January 19, 2007
Hi Anil
Congratulations for the great job done ..
rgds
...
written by Lalitha , January 19, 2007
Hi Anil
Congratulations for the great job done ..
rgds
...
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.
...
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
...
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
...
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
...
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.
...
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
...
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
...
written by Jason , February 27, 2007
Thanks
...
written by uma , February 28, 2007
Dear Anil,

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

thanks in advance
regards
uma
...
written by Anil Passi , February 28, 2007
hi vijay


please see the Examples section in www.xslfo.info

www xslfo info
...
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
...
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
...
written by Fred Forsythe , March 06, 2007
Great site, fantastic resource
...
written by Ashish , March 08, 2007
Awesome Work!
...
written by Ashish , March 08, 2007
Awesome Work!
...
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.
...
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
...
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
...
written by ram , March 19, 2007
Hi,

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

regards,

ram
...
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
...
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
...
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
...
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
...
written by Anil Passi , March 28, 2007
SID,

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

thanks
anil
...
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
...
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.
...
written by Nakul Venkataraman , March 29, 2007
Hi Anil
Could you please explain me the concept behind interfaces in Apps ?

Yours Nakul.V
9940424744
...
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
...
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
...
written by raja , April 04, 2007
good site
...
written by Ray , April 04, 2007
This page is sooo great!!!

Thanks and congratulations!
...
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
...
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.
...
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
...
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
...
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
...
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..
...
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
...
written by Sateesh Kumar , April 28, 2007
Site is very usefull.Thanks for maintaining it with such a valueable inforamtion
...
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
...
written by kamal , May 08, 2007
hi
i want know how to upgrade oracle application from 10.7 version to 11.5.10
...
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
...
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 !!!
...
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
...
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
...
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
...
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
...
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
...
written by VAS , May 22, 2007
Hi,
Can you send me articles on Manufacturing & OPM pertaining to release 12.
regards,
VAS
...
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
...
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
...
written by teknowledge , May 31, 2007
Hi Anil,

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

Could 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. ( teknowledge21@yahoo.com ).

Many Thanks in Advance.
...
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
...
written by ramakrishna , June 09, 2007
Sir,
I have been your ardent admirer from beginning.
Great Job!!!

Ramki
...
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.
...
written by kamal , June 13, 2007
hi anil,
i want to know the information abt oracle application migration.

regards,
kamal
...
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
...
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
...
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
...
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
...
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
...
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
...
written by poonam , July 02, 2007
I want to subscribe to oracle apps article
...
written by Dammu , July 02, 2007
I am new to this world and I find it extremely interesting to read and practice

Thanks&regards
Dammu
...
written by farhan , July 08, 2007
i want to subscribe oracle apps article at my email id
...
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.
...
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)
...
written by dawei wang , August 02, 2007
Excellent site. Thanks
...
written by ravi chadand , August 07, 2007
please send the updates on Oracle HRMS functional to my mail ID ravichadnan.g@rediffmail.con
...
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
...
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
...
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.
...
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

...
written by meraj mohammad , August 14, 2007
Anil,
My email address is maverick.abm@gmail.com regarding the Migration Workbench.
Thanks
Meraj Mohammad
...
written by radhikaM , August 16, 2007
Hi Anil:

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

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

...
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.. mahalakshmi.m@hcl.in

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

take care

maha alias achudan[orkut]
...
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 .........

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

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

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

...
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
...
written by Pankaj Kumar Agarwal , September 09, 2007
Really a great work to share and enhance your knowledge.
...
written by s.kumar , September 14, 2007
hai all am new to this world of hrms

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

...
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.
...
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
...
written by Parul , September 26, 2007
This is great work
...
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.
...
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...
locks in apps
written by sss , October 01, 2007
Hi Anil,
Could you please write about locks in FORMS?

Thanks in advance.

From
SSS
Discovere
written by Anand Rao K , October 04, 2007
Pls could you write regarding the B I reports(Discovere)

Thanks
Anand
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
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
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


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

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


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
Oracle Supply chain management
written by Archanap , November 19, 2007
Hi,
Can any one send me interview questions for supply chain management.
Thanks
Archana
...
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

...
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
NAG
written by NAGENDER EGA , November 24, 2007
Your Blog is superb and is very helpful.
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
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
...
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
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.
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 .
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.
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

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.
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
Sarangi.sanjay@gmail.com smilies/grin.gif smilies/grin.gif
FEEDBACK FOR YOUR WORK
written by Thulasi kumar , February 13, 2008
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.

Thanks 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
OA Framework - Modifying the extended Self Service HR Page
written by Sanjaya Patro , February 22, 2008
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,
Sanjaya Patro
sanjayapatro@yahoo.co.uk
...
written by Pratap Reddy , February 26, 2008
Hi Anil ,

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

Regards
Pratap
iExpenses workflow timeout
written by Tejas Naveen , February 26, 2008
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,
Tejas
po open receiprs
written by schand , February 28, 2008
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
schand


Customer migration
written by raghav , February 29, 2008
Hi this is raghavendra,

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

thanks and regards
Raghavendra
Self Service Personalization
written by Amit , March 07, 2008
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..!!!
...
written by Amit , March 07, 2008
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
Hi Anil I need a help.
written by Tarun Dadhich , March 09, 2008
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.

Thanks
Tarun
Hi Anil
written by K.Satish , March 13, 2008

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.


Request For Order Management
written by Raajaa , March 14, 2008
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(Tables, API's etc..) in depth concepts.

It would be great help for all viewer's.

Thanks
Dinu
You must be logged in to a comment. Please register if you do not have an account yet.

busy