Apps To Fusion

...
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. ( \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 ).

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®ards
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 \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

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

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

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
This e-mail address is being protected from spambots. You need JavaScript enabled to view it

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
This e-mail address is being protected from spambots. You need JavaScript enabled to view it

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

Oracle ADF feture
written by Balaji Goud , April 04, 2008

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.Plz give me answer.
Any difference in between OAF and ADF frameworks.

Thanks & Regards,
Balaji Goud.A

...
written by shaik sheru , April 18, 2008

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

Regards,
Fazlullah Shaik

...
written by vimalraj , April 30, 2008

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

Regards

Vimalraj

Manager- HR
written by Omar Hawsawi , May 16, 2008

thanks for this site

Best Regards
Omar Hawsawi

Usage of rwrun.sh
written by Ashwini , June 04, 2008

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/appldevl/apps/apps_st/appl/pa/12.0.0/repo rts/US/PAXACMPT.rdf userid=hboxrw/devel07 batch=yes mode=character destype=file desname=PAXACMPT.txt desformat=wide

Please help me out.

How to Secure BPEL Process
written by Satya , July 02, 2008

Hello,

I am looking for answers on implementing secured BPEL process.

Requirement: 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(installed 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/external webservice.

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


Thanks,

encumbrance in general ledger
written by bhanuchandra , July 13, 2008

Hi,
i am looking for this mail

iStore and iSupport integration
written by Rameshkumar , July 18, 2008

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
Rameshkumar

technical documents
written by kasi , July 30, 2008

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...
Regards,
kasi

excellent
written by Luis , August 13, 2008

this site is excellent, congratulations.

Sr.Analyst
written by Khalid Mahmood , January 26, 2009

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..Technically and functionally as well..

Long Live apps2fusion..!!

Oracle GL/AP/AR Audit
written by kavi723 , March 04, 2009

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...appriciate your help.

Kavi

Career guidance
written by Shreya - India , August 05, 2009

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/functional/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.
Shreya.

Not able to find Business Group
written by Ashish Puri , August 26, 2009

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

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

Thanks,
Ashish Puri

...
written by murali , September 11, 2009

Hi Anill,

Your explanation is very clear but can you provide videos with some sample report and form customizations in financial modules

Hi Anil
written by DonthireddySunilKumarrReddy , January 07, 2010

Can explain basic setups in P.A module

Restrict users from Receiving schedule 6 drugs "Category H"
written by FourCs , January 13, 2010

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.