Login
Register

Home

Trainings

Fusion

R12

Blogs

Contact Us

Email Alerts for Our Articles
  • Register

Search Courses

User Rating: 5 / 5

Star ActiveStar ActiveStar ActiveStar ActiveStar Active
 

Dear Friends,

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

Click here to Subscribe to this website via FeedBurner


Thanks,
Anil Passi

Anil Passi

Overall Rating (0)

0 out of 5 stars
  • Hi Anil
    Congratulations for the great job done ..
    rgds

    Short URL:
  • Hi Anil
    Congratulations for the great job done ..
    rgds

    Short URL:
  • 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.

    Short URL:
  • 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

    Short URL:
  • 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

    Short URL:
  • 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

    Short URL:
  • I want to know if i can use xml publisher for the programs like transaction register which is a spawned process.

    Short URL:
  • 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

    Short URL:
  • 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

    Short URL:
  • Guest - Jason

    Thanks

    Short URL:
  • Dear Anil,

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

    thanks in advance
    regards
    uma

    Short URL:
  • hi vijay


    please see the Examples section in www.xslfo.info

    www xslfo info

    Short URL:
  • Hi Anil,

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

    Regards,
    Vijay Srinivas

    Short URL:
  • I want to learn Purchasing module but in this there is not mentioned PO cycle.Plz help me out on this issue

    Short URL:
  • Great site, fantastic resource

    Short URL:
  • Awesome Work!

    Short URL:
  • Awesome Work!

    Short URL:
  • I would like to gather technical knowledge and looks like after lot of search. I will stop here.
    thanks Anil.

    Short URL:
  • I found this site a good resource to know abt Oracle Apps - HRMS.
    Good work, keep it up
    Thanks

    Short URL:
  • 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

    Short URL:
  • Hi,

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

    regards,

    ram

    Short URL:
  • 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

    Short URL:
  • Hi Rashi

    Please use this link for the information required

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

    Thanks
    Anil

    Short URL:
  • 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

    Short URL:
  • hi,
    You are doing a wonderful and thankless job by providing so much information related to Oracle Apps.

    Thank you very much

    Short URL:
  • SID,

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

    thanks
    anil

    Short URL:
  • 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

    Short URL:
  • Hi Anil
    Could you please explain me the concept behind interfaces in Apps ?

    Yours Nakul.V
    9940424744

    Short URL:
  • 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.

    Short URL:
  • 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

    Short URL:
  • 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

    Short URL:
  • good site

    Short URL:
  • This page is sooo great!!!

    Thanks and congratulations!

    Short URL:
  • 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

    Short URL:
  • 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.

    Short URL:
  • 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

    Short URL:
  • Hi Jan

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

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

    Note[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

    Short URL:
  • hi anil,
    i have one one requirement that how to set upemail notifications in iexpenses and oracle time and Labor.


    regards
    ram

    Short URL:
  • 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..

    Short URL:
  • 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

    Short URL:
  • Site is very usefull.Thanks for maintaining it with such a valueable inforamtion

    Short URL:
  • 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

    Short URL:
  • hi
    i want know how to upgrade oracle application from 10.7 version to 11.5.10

    Short URL:
  • 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

    Short URL:
  • 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 !!!

    Short URL:
  • Hi Shireen

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

    Just google for it.


    Cheers
    Anil

    Short URL:
  • 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

    Short URL:
  • 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

    Short URL:
  • 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

    Short URL:
  • 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

    Short URL:
  • Hi,
    Can you send me articles on Manufacturing & OPM pertaining to release 12.
    regards,
    VAS

    Short URL:
  • 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

    Short URL:
  • sir,
    I want to know without doing oracle apps sql based only doing OA Framework java based will be useful in life.

    abhineet

    Short URL:
  • 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.

    Short URL:
  • 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

    Short URL:
  • Sir,
    I have been your ardent admirer from beginning.
    Great Job!!!

    Ramki

    Short URL:
  • 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.

    Short URL:
  • hi anil,
    i want to know the information abt oracle application migration.

    regards,
    kamal

    Short URL:
  • 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

    Short URL:
  • 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

    Short URL:
  • Suha

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

    Thanks
    Anil

    Short URL:
  • Guest - Vivek

    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

    Short URL:
  • 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

    Short URL:
  • 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

    Short URL:
  • I want to subscribe to oracle apps article

    Short URL:
  • Guest - Dammu

    I am new to this world and I find it extremely interesting to read and practice

    Thanks&regards
    Dammu

    Short URL:
  • Guest - farhan

    i want to subscribe oracle apps article at my email id

    Short URL:
  • Guest - Ravneet

    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.

    Short URL:
  • Guest - Martin kimario

    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)

    Short URL:
  • Guest - dawei wang

    Excellent site. Thanks

    Short URL:
  • Guest - ravi chadand

    please send the updates on Oracle HRMS functional to my mail ID ravichadnan.g@rediffmail.con

    Short URL:
  • Guest - Priyanshi Goel

    hi
    this is a very good site to study
    please also send us the practicals of all the things we do in Apps

    Short URL:
  • Guest - Narendra

    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

    Short URL:
  • Guest - Farooque

    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.

    Short URL:
  • Guest - meraj mohammad

    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

    Short URL:
  • Guest - meraj mohammad

    Anil,
    My email address is maverick.abm@gmail.com regarding the Migration Workbench.
    Thanks
    Meraj Mohammad

    Short URL:
  • Guest - radhikaM

    Hi Anil:

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

    Radhika

    Short URL:
  • 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..........................

    Short URL:
  • Guest - achudan-orkut

    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]

    Short URL:
  • Guest - Anand

    Hi Anil,

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

    Thanks .........

    Short URL:
  • Guest - Ravi Saini

    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

    Short URL:
  • Guest - Ashish Bhatt

    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

    Short URL:
  • 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.

    Short URL:
  • Guest - arumalla

    Hi Anil,
    I wolud like to know the sample unix scripts to run the oracle apps package.
    with parametrs.

    Rgds
    Dinesh

    Short URL:
  • Guest - Abddul Rahiman

    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

    Short URL:
  • 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

    Short URL:
  • Guest - Anil Passi

    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

    Short URL:
  • 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

    Short URL:
  • Guest - Anil Passi

    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
    [url]http://www.oracle.com/technology/software/products/publishing/index.html[/url]

    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

    Short URL:
  • Guest - Pankaj Kumar Agarwal

    Really a great work to share and enhance your knowledge.

    Short URL:
  • Guest - s.kumar

    hai all am new to this world of hrms

    Short URL:
  • 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

    Short URL:
  • Guest - Hi

    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.

    Short URL:
  • Guest - Anil Passi

    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
    [img]http://docs.google.com/File?id=dkg3r3j_503dvtqg5gg[/img]

    Thanks,
    Anil Passi

    Short URL:
  • Guest - Parul

    This is great work

    Short URL:
  • Guest - Amrita

    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.

    Short URL:
  • Hi,
    Im new to Oracle apps.. Could you please tell me how to add function to the menu & item to the function..

    Thanks...

    Short URL:
  • Guest - sss

    Hi Anil,
    Could you please write about locks in FORMS?

    Thanks in advance.

    From
    SSS

    Short URL:
  • Pls could you write regarding the B I reports(Discovere)

    Thanks
    Anand

    Short URL:
  • Guest - sushant kumar

    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

    Short URL:
  • 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

    Short URL:
  • Guest - MALLIKA

    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

    Short URL:
  • 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.

    Short URL:
  • Guest - Mai

    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

    Short URL:
  • Guest - amrita

    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

    Short URL:
  • Guest - Anil Passi

    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

    Short URL:
  • Guest - Anil Passi

    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 [url]http://www.google.com/search?q=site:apps2fusion.com+master-detail-screen-in-oa-framework-part-i[/url] dated October 11, 2007

    Thanks,
    Anil Passi

    Short URL:
  • Guest - nitin tugave

    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

    Short URL:
  • Guest - Santosh Gokhale

    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

    Short URL:
  • Guest - karthikv123

    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.

    Short URL:
  • Guest - shailesh

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

    Short URL:
  • 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

    Short URL:
  • Guest - sanjay desai

    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

    Short URL:
  • Guest - Jaykay

    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

    Short URL:
  • Guest - Archanap

    Hi,
    Can any one send me interview questions for supply chain management.
    Thanks
    Archana

    Short URL:
  • Guest - Navin

    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

    Short URL:
  • Guest - Navin

    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

    Short URL:
  • Guest - NAGENDER EGA

    Your Blog is superb and is very helpful.

    Short URL:
  • 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

    Short URL:
  • 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

    Short URL:
  • Guest - Rajiv Grover

    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

    Short URL:
  • Guest - Sachin Tayade

    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.

    Short URL:
  • Guest - Sushant kumar

    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 .

    Short URL:
  • Guest - MBhaskar

    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.

    Short URL:
  • 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

    Short URL:
  • 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 ;D ;D

    Short URL:
  • Guest - Thulasi kumar

    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

    Short URL:
  • Guest - Sanjaya Patro

    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

    Short URL:
  • Guest - Pratap Reddy

    Hi Anil ,

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

    Regards
    Pratap

    Short URL:
  • Guest - Tejas Naveen

    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

    Short URL:
  • Guest - schand

    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

    Short URL:
  • Guest - raghav

    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

    Short URL:
  • 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..!!!

    Short URL:
  • 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

    Short URL:
  • Guest - Tarun Dadhich

    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

    Short URL:
  • Guest - K.Satish

    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.

    [s][/s]

    Short URL:
  • Guest - Raajaa

    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

    Short URL:
  • 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

    Short URL:
  • Guest - shaik sheru

    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

    Short URL:
  • 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

    Short URL:
  • Guest - Omar Hawsawi

    thanks for this site

    Best Regards
    Omar Hawsawi

    Short URL:
  • 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.

    Short URL:
  • Guest - Satya

    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,

    Short URL:
  • Guest - bhanuchandra

    Hi,
    i am looking for this mail

    Short URL:
  • Guest - Rameshkumar

    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

    Short URL:
  • Guest - kasi

    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

    Short URL:
  • Guest - Luis

    this site is excellent, congratulations.

    Short URL:
  • Guest - Khalid Mahmood

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

    Short URL:
  • Guest - kavi723

    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

    Short URL:
  • Guest - Anil Passi

    Hi Kavi

    Just google for
    audit site:apps2fusion.com

    You will find various articles on auditing in eBusiness Suite.

    Thanks
    Anil

    Short URL:
  • Guest - Shreya - India

    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.

    Short URL:
  • Guest - Ashish Puri

    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

    Short URL:
  • Guest - murali

    Hi Anill,

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

    Short URL:
  • Guest - DonthireddySunilKumarrReddy

    Can explain basic setups in P.A module

    Short URL:
  • Guest - FourCs

    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.

    Short URL:
  • Guest - BalaKrishna

    This site is really very useful for person working in Oracle APPS. I got to know about it recently only.

    Thanks for everyone..

    Short URL:
  • Guest - Rajesha

    Currently we are using 11.5.10.2. Since oracle is recommending to apply minimum base line patches to get extended support starting from 01-Dec-2010, we are getting rteady to apply required patches.

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

    Thanks
    Rajesha

    Short URL:
  • Guest - Renganayaki

    Hi Anil,

    I am looking for some good materials with screenshots to start learning Oracle Process Manufacturing.
    Could you please suggest some materials / Books / Blogs?..

    Short URL:
  • Guest - bonbonboy

    Hello! Anil, can you tell me the basic rules for implementation R12 in small industry?

    Short URL:
  • Guest - Dakshesh Patel

    Hi,
    I have made a custom workflow for approval but i am not getting item_key in hr_api_transaction of custom worklfow .
    I want to integrate custom workflow with AME.
    so please help me.

    Regards,
    Dakshesh Patel

    Short URL:
  • Guest - krishnan

    In our company Oracle 12g implementation in progress, without Treasury module

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

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

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

    Regards,

    Krishnan

    Short URL:
  • Guest - Jonna

    I WOULD LIKE TO KNOW MORE ABOUT Order management Functional setups

    Short URL:
  • Guest - va

    Hi,
    I tried to change the record group query for an lov in a standard form through form personalization.

    But it is giving error shown below

    FRM-41826 : cannot replace group ; Columns don't match LOV.

    Short URL:
  • Guest - Purushotham

    hi anil,

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

    Thanks
    Purush

    Short URL:

Search Trainings

Fully verifiable testimonials

Apps2Fusion - Event List

<<  May 2017  >>
 Mon  Tue  Wed  Thu  Fri  Sat  Sun 
  1  2  3  4  5  6  7
  8  9101112
    

Enquire For Training

Fusion Training Packages

Get Email Updates


Powered by Google FeedBurner