Hi Anil:
You have a great blog!
I have started writing a blog on EBS OCP certification. Please let me know some tips how to improve it.
Thanks,
M ohan

hi anil
U R blog is really cool.
can u tell me where can i find the basic concepts of OA frame work and wat r the thing an appsdba has to deal with OA frame work..
Thanx
Leenus

hi anil
U R blog is really cool.
can u tell me where can i find the basic concepts of OA frame work and wat r the thing an appsdba has to deal with OA frame work..
Thanx
Leenus

Hi Anil,

Can you please explain the hierarchy/prece dence of profiles user-responsibi lity-applicatio n-site.But in addition to the above profile levels,11i have something called as organization and server.where these two will fit.

Thanks,
YJ

Hi YJ, I will definitely write up an article on interfaces tonight, which shall answer your remainder questions.
Pro file article will be ready in next couple days.

Thanks ,
Anil passi

hi anil,

What is the difference between interface,conve rsion and migration?

T hanks,
YJ

Anil,
Can u please provide the setup details for core HR and if possible the potential interview questions.
I request you for an overview of HR inteeligence.

As requested, please find the two articles

Hierarchy Profile Options http://www.google.com/search?q=site:apps2fusion.com+hierarchy-profile-options

Also, another article that explains difference between migration/conve rsion & interface practices in Apps
http://www.google.com/search?q=site:apps2fusion.com+open-interfaces-in-apps-ebs-best-practices

Next coming is building Interface using Java Concurrent Programs...

Thanks
Anil Passi

Anil,
Can u please provide the setup details for core HR and if possible the potential interview questions.
I request you for an overview of HR inteeligence.

As requested, please find the two articles

Hierarchy Profile Options http://www.google.com/search?q=site:apps2fusion.com+hierarchy-profile-options

Also, another article that explains difference between migration/conve rsion & interface practices in Apps
http://www.google.com/search?q=site:apps2fusion.com+open-interfaces-in-apps-ebs-best-practices

Next coming is building Interface using Java Concurrent Programs...

Thanks
Anil Passi

Thank you so much. Great blog will visit over and over. Want to see you java concurent program.
Have a great day.

Hi Ripal,

I am afraid, I do not have any setup docs on Enterprise asset managerEAM.

Thanks,
Anil

Hi Anil,
You are doing a great job.
My heartiest congratulations to you.
Do you have any EAM set up?
Regards
R ipal

Hi Ripal,

I am afraid, I do not have any setup docs on Enterprise asset managerEAM.

Thanks,
Anil

Hi Anil,
You are doing a great job.
My heartiest congratulations to you.
Do you have any EAM set up?
Regards
R ipal

Hi Anil, Please let me know how to default/replace the Item Master Rates from the latest PO Item rate.

Thanks

raju

Hi Anil,
Your blog is very informative. Thanks for all the useful articles.
I am going to ask you a very basic question. I wanted to know if there is a way to get the source code for self-service forms. There is a Wokflow related form Navigation from System Administrator Reponsibility -> Workflow>>Admin istrator Workflow >>Notifications form. I am trying to find the source code for this form.
Thanks, MP

System Administrator Reponsibility -> Workflow>>Admin istrator Workflow >>Notifications form


The form function name is WF_ADMIN_NOTIFI CATIONS

howe ver, to know the MDS document, you can click on Personalize to get the path

Scope Page: /oracle/apps/fn d/wf/worklist/w ebui/AdminNotif icationsPG
Do cument Name /oracle/ap ps/fnd/wf/workl ist/webui/Admin NotificationsPG





vi $FND_TOP/mds/wf /worklist/webui /AdminNotificat ionsPG.xml

H ere you will see that
^M

Now , you need to go to Java Top to find your classes & XML in below locations

Yo ur Application Module is in
$JAVA_TOP/ora cle/apps/fnd/wf /worklist/serve r/Notifications AM.xml

Your controller class is
$JAVA_TOP/ora cle/apps/fnd/wf /worklist/webui /NotificationsP ageCO.class

You should extend and not customize your OA Framework.
You should be able to FTP all these OAF files to jDev and work directly from jDev


Thank s
Anil Passi

Hi Anil,

Keep the good work going.......

I am a Functional person, please give me some functional knowledge in GL & AP as i want master them.

Please provide me some related sites as well.

Thanks n Regards,
Santo sh

Hi Santosh,

Cur rently I am writing up things for Oracle HRMS and Payroll.

Ple ase let me know the information you are after, I will try writing something up to that effect.

Than ks
Anil Passi

Hi Anil,

Keep the good work going.......

I am a Functional person, please give me some functional knowledge in GL & AP as i want master them.

Please provide me some related sites as well.

Thanks n Regards,
Santo sh

hi anil

please can u write interview question for oracle hrms functional role .please here u have covered more techinical stuff.please i am waiting for urs reply.
thanks
bye

hi ,looking at the steps for oracle workflow i want to learn that .
Please let me know from where can I download workflow builder. Is that the same which is avilable on oracle website (OTN)and named as oracle workflow client?
send me email for the details
thank you
Anuj

hi anil

please can u write interview question for oracle hrms functional role .please here u have covered more techinical stuff.please i am waiting for urs reply.
thanks
bye

hi ,looking at the steps for oracle workflow i want to learn that .
Please let me know from where can I download workflow builder. Is that the same which is avilable on oracle website (OTN)and named as oracle workflow client?
send me email for the details
thank you
Anuj

Dear Anil,
You are doing a great job great !!!!!!!
I am now going to make my career in ORACLE HRMS & your blog is a great!!!!!!This is a excellent effort from you ANIL.
PLZ HELP ME ON THIS :
What steps involve in creating BG?
what is full life cycle implementation?
How can we define payroll?

.


Hi Ram,

I am glad that this website helped you learn a few things.

With reference to Java Concurrent Program, please follow the article by clicking on this link http://www.google.com/search?q=site:apps2fusion.com+java-concurrent-programs-in-oracle

Thanks
Ani l Passi


.

.


Hi Ram,

I am glad that this website helped you learn a few things.

With reference to Java Concurrent Program, please follow the article by clicking on this link http://www.google.com/search?q=site:apps2fusion.com+java-concurrent-programs-in-oracle

Thanks
Ani l Passi


.

Hi Anil
ur blog is good very clear.

can u post an example of how to create a new LOV and put it in the iexpense ExpenseDetails page. I need the steps fot it.

it will be very helpful

Than ks

hiAnil,
I am glad that this website helped you learn a few things.

Plz provide some screen shots and explation in Po and INN in Functional side

.
.
.
.

H i Sri,

Indeed there is no Key Flex on po_headers.
Th ere is no reason that I am aware of I am afraid.

I think this is legacy, during very earlier versions of Oracle Financials, they might have decided to allow KeyFlexfield, to capture Organization Name, PO Type etc as a part of PO-Number itself. Thereafter, Oracle created Composite Unique index on Segment1[po-num ber],org_id & type_lookup_cod e. Hence they decided to backtrack from a KFF on PO-Number....

Above is not a statement of facts, but merely my understanding.

THanks,
Ani l Passi
.
.
.
.

.
.
.
.
Hi Santhos

Inde ed you can, but not all reports will work out of the box when switched to XML Publisher.
I think format triggers do not get executed when concurrent manager runs a rdf file for XML output. Understandably oracle expects you to define your formatting inside XML Publisher itself.
.
.
.
Thanks,
Ani l Passi

Hi Anil,
Your blog is very informative. Thanks for all the useful articles.I am going to ask you a very basic question about XML Publisher.Is that possible to convert/change the existing reports to XML as it can provide multiple outputs?

Reg ards
Santhosh.

.
.
.
.
Hi Santhos

Inde ed you can, but not all reports will work out of the box when switched to XML Publisher.
I think format triggers do not get executed when concurrent manager runs a rdf file for XML output. Understandably oracle expects you to define your formatting inside XML Publisher itself.
.
.
.
Thanks,
Ani l Passi

Hi Anil,
Your blog is very informative. Thanks for all the useful articles.I am going to ask you a very basic question about XML Publisher.Is that possible to convert/change the existing reports to XML as it can provide multiple outputs?

Reg ards
Santhosh.

Hi Santosh,
This is listed in interview questions.
Tha nks
Anil Passi

Hi Anil,

I have a doubt in Oracle Reports?
I am using Reports 6i.
I am working on Invoice Report. My requirment is if the output is within a page then there is no need to print the page number or else need to print it. How can we achieve this?

I tried using the Total Physical pages, but i could not refer in conditional format trigger. Could you please help me in achieving this?

Regard s
Santhosh.

.
.
.
Hi Santosh,

I vaguely remember that you will need to create a summary column for page number, reset at appropriate level, and then use format trigger to hid/display.

Its been six year since I did any professional work on developing reports. Hence my statement may not be accurate.

TH anks
Anil Passi

HI Anil ,
I am working in Oracle HRMS , i am not clear with organization classifications and Key Concepts for Representing Enterprises , could you please help me out in this.

Hi,

Is it possible to pass the bad file name and the discard file name to the SQL Loader type concurrent program in apps ? I am passing the data file name(and path) and bad file name (and path) as parameters ,but it is using its own bad file name and path.

Anil,

Great work. Do you have a set of interview questions for oracle crm.

Thanks.

Hi Anil,

If possible, can you plese explain the basic fundamentals about apps tables and busines. For example, consider from customer placing an order, and finally ending with collecting the payements, receipts,invoic e etc.,...Also, what kind of information is stored in what tables and what columns. What are the mostl frequently used tables and columns that are being used. If you can explain with a real time scenario, that would be very useful.

Than k You!

Great blog...keep it up !

Was wondering if all the above information is on some PDF or word file?

sajeedmujawargmail.com

Regards, Sajeed

Anil,
I am an techie,and more inclined towards HR functional track.can you please let me know your opinion.I mean about the scope for HR functional consultant.

Thanks,
YJ

Hi Anil,
I want to make a request that plz make a set of some real time question about pl sql(trigger,cur sor,package,pro cedure),report 6i,and oracle apps tech which journelly a fresher dont know and which atleast give some positive impact in interview.
so this ismy humble request plz make a set of such questions plzzz
thanks

.
.
.
Hi Shell,

You need to become a good Oracle Apps consultant, regardless of TEchnical or Functional Consultant.

I suggest, you pick up a module of your choice, and try to run end to end process. For example from Payables invoice, to invoice payment batches, Accounting, transfer to GL, posting to GL, and seeing those entries in GL balances.

Th is is just an example. Next you can expand the scope of your steps, and start from purchasing requisition, to approval, to Purchase Order to its receipt and then transferring all to GL. Next you can create an invoice and match the same to Purchasing.

I am trying to say, first step, UNDERSTAND HOW THE ORACLE APPS SYSTEM WORKS.

Once you have done so, then you can take the next step by setting up a new GL Set of Book, new Multi Org Organizations, new responsibility, new setup for that Org and GL SOB. And then setup module specific entities. Once you have done your own setup, try running end to end process again on your config data.

All this is hard work, but so goes life.

Thanks ,
Anil Passi

Hi Anil,

First of all...Many Many thanks for sharing knowledge through this blog..Its really a wonderful one. Hope that we all utilize this and clarify all our doubts and queries from here.

Best Regards,
Dwai

Hi Anil;
I was wondering if you can help me out with our Logon Securities predicament: We have set up some generic apps ids that are only known to a handful of users. Regular but unauthorized users are trying to sign-on using these generic ids by guessing the password and end up locking them when they exceed sign-on attempts. Is it possible to trace these unauthorized users? (via ip address or terminal id?) (We are on 11.5.8)

Thanks, Al

.
.
Hi Madhu

Have a look at the comment section of link http://getappstraining.blogspot.com/2006/10/orgid-and-multi-org-in-oracle-apps.html

The answer to your question has been discussed there.

Thank s,
Anil Passi

Great work Anil with your amazing experience and skill. I planned to take ocp-ebs - SCM track. Can I have some sample questions.

hi anil,
your blog is really very helpful for people you need help for oracle applications.
with regards
murthy

Hi Venkat,

I am yet to experiment with Mobile apps.
Is there nothing on Metalink ?

Cheers
Ani l Passi

hi anil,
i need an advice regarding apps. I am new to apps
and u r site is ver helpful to me.i want to know which module will be fetching for me for getting job as my btech is on nonit.is it necessary to learn java too.please help me regarding this.i already completed my training in apps 11i.

Hi AY

The best way to approach the market is to be prepared for most possible skillsets, that which are commonly used in most projects.

Ex amples are:-
1. Interfaces using API and interface tables
2. Concurrent programs of type pl/sql to create processes
3. Workflow modifications and creating Workflows from scratch
4. CUSTOM.pll
5. Forms Personalization s
6. Self Service personalization s and framework concepts
7. some data migration examples
8. workflow business events

If you can try couple of in each of the categories, then I can say you are prepared for it. It might take you long time to get the job, but then it also means you get long time to learn and experiment these things.

also , look at forums.oracle.c om and see the kind of questions people are raising there, its a nice place to learn about practical problems that people face and also their resolution. so do as much reading as possible on the forum

good luck
anil

in concurrent programe if the executable is PL/SQL
in that case when i pass a parameter that is attache with a value set in that case what shoub be the value set because I wrtie the proceduer and table and register all in my application table which value I have to pass.

Hi Anil, You have done an excellent work in most of the area. I would request you to put in a basic setup steps for Oracle Advance Pricing along with modifiers and qualifiers and formulae as it is 1 module which generally no one gets into the details. Thanks in advance

Hi Anil,
I have a requirement described below. Could you please give me any suggestion regarding this.

I need to create a discoverer report, which will display all the details of the user, who is currently executing this discoverer report.
The details should include:
1) Apps user id, through which he loggeged in the discoverer desktop edition.
2) Any other details attached to the user id, such as Employee ID, Name etc etc..

Lookin g for your quick reply.

Thank s,
Nemai

Hi Nemai

If APPS login option is being used, then fnd_global package has the functions that you need

thanks
anil

Hi Manish

See if think link gives you required info
http://www.oracle.com/global/us/education/certification/ebus11i_appteccourses.html

Thanks,
Anil

Anil,
SQL n PLSQL can be practiced using database. What about D2K, is it JDeveloper?

Hi,
I am a functional person. Just changed my field and into Oracle Apps, after 10 years of hardcore process manufacturing experience. I have started with learning basic modules, Purchasing, GL,AP,INV. My focus is to master the process manufacturing module. Can u pl. tell me what is the first step in learning oracle. There are so many things out there that i got confused, PL. HELP.

Hi Keyur

Before you learn Oracle Financials, try to navigate through the various screens/busines s processes to get familiar with the Architecture.

Make a start with GL module, and then Payables integrating to GL.

Solution Beacon website has hosted R12 instance, on which you can play around.

Than ks
Anil

hi,
please explain interfaces, gl, ap,ar in detail. thanks this site is really helpful.

Hi Sheeba

Pleas e let me know which area of workflow are you interested in?

THanks
Anil

Hi keyur

You can download the diagrams from http://etrm.oracle.com

Thanks,
An il Passi

Hello Anil,
I have just started Inventory module. Which i am going to learn in detail, because this the base for any manufacturing application. I am trying to understand the hierarchy and relationships of Items templates,Item categories, categorysets. Could you please throw some light on these topic. Shall be better if any short article which can help. Can I use different category KFF for different items, in the same Organization?

Thanks Anil

Hi Anil,

I am a Oracle & D2K developer.I want to move on to Oracle Apps Technical and I prefer financials.Can u pls suggest the topics that I need to learn from a technical point of view.

Kind Regards
Shiva

hi ani
what are the basetables,inte rface tables,standard conc prog for approved supplter list conversion.

Hi Anil,
I am here once again with a question whose answer I have not got till now .
Can you help me with a site where I can get implementation knowledge of oracle application modules(manufac turing and Finance) . Also I am desperately looking for FAQs from functional point of view .
Can you help me out . I accept that it is very hard to post such a doc that can give what I require in a nutshell . Still is there any approx solution to what I am looking for ?

Thanks & Regards

Saro j

Hi,

Can you please let me know where i can information about Item Master. Also please let me know, if I need to know any prerequesites to know item master.

Than ks!

hi Anil,

I am into oracle Apps for 3 yrs and wants to pursue the functional stream.My interest is towards HR and CRM.Can you please give me a rough scope about these two.which would has the more viable scope.

Hi Anil,

How to view EXCEL output of a concurrent program using XML Publisher.

I tried but it is giving error it is showing the output as html.

hi
Anil
Can u provide India Localization related stuff
Regards
Mohan.Katepalli

Would like to put job opportunity for Oracle Apps functional on this site, will it be possible?

Ma y update the process and detail?

Do I have to pay for that?

Regard s,
Ashok

No problems Ashok.

And, you do not have to pay for that either.

Hi Bhaskar

All you need to do is to create a hyperlink to AppsLocalLogin. jsp
If you are currently in oa_html/bbrr/xx .jsp
Then your URL will be ../AppsLocalLog in.jsp

Thank s
Anil

Sorry Anil for being so vague, I have seen word “USAGESâ € used on the data entry screen and in some of the Table/ view names (e.g. PER_PERSON_TYPE _USAGES_F). So is there any significance of word Usage?

Hope this time I am bit more clear in my question.

Than ks!

Hey Ajay

Good luck with your job.

Thanks,
A nil Passi

Hi Mandev

Costs depends on your implementation strategy.
Costs can be kept down by involving as much of your permanent staff as possible in the Business Analysis roles. In your location, you should compare the hourly wage for SAP and Oracle consultants. That will give you a fair idea of which ERP implementation will be cheaper.

Keepi ng money aside, Oracle is pushing for open standards. Oracle's BPEL is much more powerful that SAP's netweaver.

FMW [FUsion middleware] will provide your organization scalability both within and outwards[integr ation with trading partners], as the company grows.

Having open standard technologies will keep the technical costs lowers in the longer run.
Hence Oracle is my choice

Thanks,
Anil

Hi Tony

For performance reasons Oracle does not use Foreign Keys in EBS.
Hence there isn't a need for primary keys either.

The net effect of Unique Key and Primary Key is the same.

Thanks,
Anil

hi
can u tell me how can i add multiple assignments by using fa_mass_additio ns

Hi Subb,

There are two ways by which you can debug a report in APPS[assuming its deployed on server].
1. run trace. you can turn the tracing on in concurrent program definition.
aft er the tracing has been turned on, you can simply check the trace file to see the sql
2. pur srw2.message, these will be visible in the log file of the report

In order to debug report on PC, using D2k, simply use the D2k debugger.

Than ks
Anil

Hi,
I would be pleased to know if there is any place to know Order Management. Not the pdfs that are provided by oracle, expecting something in anil passi style. Would be glad, if someone helps in this regard.

Thanks !

Hi Anil
I have some issues while adding code in CUSTOM.pll
Plea se refer to the explanation below:
Sub:Deselectin g a line on Autocreate Form through CUSTOM.pll

I have written code to customize the Autocreate form. In this form only the valid lines (validity is checked based on certain conditions) should get selected when I check the checkbox corresponding the requisition line.

For deselecting the line I have written the code:

if (invalidity_con dition is TRUE for a line) then
copy('N', 'REQ_LINES.SELE CT_LINE');
end if;

But through this code only the checkbox is deselected and not the lines.
The lines remains selected because it remains highlighted in yellow color. Also when I press Autocreate button these lines appear on Purchase Order form.

Please guide me how to do this ..as I am a fresher in Oracle Apps/CUSTOM.pll
Plea se reply to this asap..

Regards
Shweta

Hi Vivek

I am sorry if I have ever unknowingly advised against taking up functional role.

In fact one of my friends from Tech background[from REC] is one of the highest paid Functional consultants in Europe.

Payrol l functional role will also involve some mathematics, when you design your Fast Formulaes.

It is a good opportunity, I would have taken this role if I were to be in your position.

Than ks,
Anil Passi

Hi Anil,

I am new to Oracle Apps and would like to know about Oracle Process Manufacturing

I have an interview on OPM

PLease let me know if you have any notes on OPM

thanks

Ja yaKrishna.

Hi Anil,

I am tryng to compile a Form in R12,
But it is showing below error


[applmg r@apps US]$ frmcmp_batch.sh module=XXDARXTW MAI.fmb userid=apps/app s@VIS Module_Type=FOR M
Forms 10.1 (Form Compiler) Version 10.1.2.0.2 (Production)

F orms 10.1 (Form Compiler): Release - Production

Cop yright (c) 1982, 2005, Oracle. All rights reserved.

PL/S QL Version 10.1.0.5.0 (Production)
Or acle Procedure Builder V10.1.2.0.2 - Production
Orac le Virtual Graphics System Version 10.1.2.0.0 (Production)
Or acle Multimedia Version 10.1.2.0.2 (Production)
Or acle Tools Integration Version 10.1.2.0.2 (Production)
Or acle Tools Common Area Version 10.1.2.0.2
Orac le CORE 10.1.0.5.0 Production
ORA- 12154: TNS:could not resolve the connect identifier specified

Form not created


can u please suggest any thing on this one.

Thanx

La kshmi Narasaiah

Dear Mr. Anil

I hav some working knowledge in Oracle Applications 11 i. hence i wish to explore more about Oracle Apps (Starting from the basics).Can u plz suggest me some useful documentations/ steps that helps me

Thanks & regards
padmaja

Dear Anil, What is the exact difference between following profile options:
1) HR: Security Profile
2) HR: Business Group

If we attach the HR:security profile option to responsibilitie s then It is automaticallt attached to HR:Business Group but what exactly is the need of having two different profile options, can't we manage with a single profile option
Regards,
Jaspal

Hi Amarnath,

Than ks for your kind words.

Please use the SQL below

SELECT initcap((to_cha r(to_date(&ente r_your_amount, 'j'), 'jsp')))
FROM dual
/

Thanks,
Anil Passi

Amazing Blog !!!

Really Useful.....

Th anks,
Meera

Dear Anil,
Could u please guide the steps on How to make Attachments as mandatory in Oracle Purchase Requisition Form Header section.
Thanks & regards
P Ahuja

Hi

Do you have anything on RICE components??

R egards,
Nidhi

Job title : Oracle Techno functional.
Loc ation : Coimbatore, India
Duration : Very Long term
Salary : Negotiable

Job description : Candidate should have solid experience with Oracle Financials preferably in AP and AR.
Should have realtime experience with Oracle 10.0 and 11.03 (Mandatory)

Pl ease call me at 0422-3294524 or email me at pradeep.prabhakaralliedgroups.com

Best regards,

Prade ep Prabhakaran
Res ource Analyst
Allied Solutions Group inc.
440-397-05 50 x 111
offshore : 0422-3294524
www.alliedgroups.com

Hi Anil,
Please read the following scenario and advise accordingly:

While implementing the HRMS in Oracle 11i, for the Company X that contains two offices: Office Y and Office Z, both are based in the the same set of countries and they have the same structure.

How would they be classified, in order to secure data of each one and make them partitioned. Is this done by classifying them as two legal entities? Or two business groups?

Hi,

Are the OCP developer exams worth gaining?

thank s

Hi John

I haven't got any certifications within any of the streams with Oracle.
Hope that answers your question.

Than ks,
Anil Passi

Hi Anil,
how to find the form names, for the jsp pages as we find for applet screens?

Please also give me the table name which holds that info.

Thanks Anil.

->Jana

i am mca background fresher. i want to learn oracle apps finance plz give me any suggestion is it best for me or not.

thanking you,
pavan

Hi Anil,
Would like to know abt the Future of Oracle CRM (sales. mktg and service modules) in the fusion release. jst finished implementing on 10.2 version. In fusion Is it gonna be replaced by Siebel CRM features. any info on this would of great help.
Anil also, can you pls suggest me any URL which has a huge resource of oracle CRM related info. ..sumwhat similar to your blog.

Well Hats Off to your blog..Chak de
God bless u
MKB

Hi Anil,
I'm facing problem in defining the Event Alert on Custom Table. I'm able to define the periodic alert on Custom Table. I registered the table in Apps for my custom Application and define the event alert on after update but I didnt receive any mails even i updated my table. Could you please help me regarding this and I need this very urgent.

Regards,
Amit ha.

I am getting a very good knowledge about oracle apps

hi Vinay,
you can use the API, PO_CHANGE_API1_ S.update_po for updating the quantity and price alone.

And for cancelling the PO, you can use PO_Document_Con trol_PUB.contro l_document

->Jana

Hi Anil,
Ur Blogs look very helpful.Good work.I'm basically an Oracle DBA (8,8i,10g) joining a company having 11i Apps and 10g database . Pls suggest where I've to startfrom to become an expert Apps DBA (I know basics of 3-tier architechtures) . Oracle is my pet product and I'm yearing to master Apps stuff also.

anil,
i am unable to open lot of links,i want to read those thinkgs.let me know reason to that
i am giving some of links below
1)what-happens -when-you-login -to-apps
2)why-call-it- apps-and-not-or acle-erp
3)what-are-pro file-options-in -oracle ...ETC

Hi Anil,


I have come across so many books in my life, i think your way of explaining things is the best of them all . one can never have problems in understanding any topic.
Could you give me a real life example how to create a business group ???

regards,
f arha

Hi Anil,
thanks for providing useful materials.
i developed a form, o/p shd display empno,ename.
empno having lov.

first i have created record grp manually as below:
ITEM:Emp no
TRIGGER:When -New-Item-Insta nce

declare
rg_name varchar2(30):=' XRECGRP';
rg_id recordgroup;
er rcode number;
begin
rg_id:=find_gro up(rg_name);
if id_null(rg_id) then
rg_id:=create_g roup_from_query (rg_name,'selec t empno from emp');
end if;
ERRCODE:=PO PULATE_GROUP (RG_ID);
end;


next i created lov at design time(option:man ually)name:lov8 .
(i didn't change any property)becous e i'm setting recgrp to lov using set_lov_propert y

in same above code i changed as
declare
lov_result boolean;
rg_name varchar2(30):=' XRECGRP';
rg_id recordgroup;
errcode number;
begin
rg_id:=find_gro up(rg_name);
if id_null(rg_id) then
rg_id:=create_g roup_from_query(rg_name,'selec t empno from emp');
end if;
ERRCODE:=POPULA TE_GROUP(RG_ID) ;
set_lov_propert y ('lov',GROUP_NA ME,'XRECGRP');
lov_result:=sho w_lov('lov8');
end;

it showing errror as:
FRM-30048: Unable to find record group .
LOV LOV8
Form: XFORM_RGRP_LOV
FRM-30085: Unable to adjust form for output.

In Code i have attach record grp to lov(using set_lov_propert y) why its not taking.

if that lov already consists another record grp then it is setting rec grp used in set_lov_propert y.i don't want like that.plz ans me.
and is there any way to create lov manually(using code) or we have create at design time only(using create button)

Hi Anil,

This example suggests what my actual doubt is.

While pick Releasing Sales Orders, a single move order header number is assigned for the lines belongs to different Sales Orders.

My Requirement is to get a distinct move order numbers for the lines belongs to different Sales Orders.

Please suggest me if this is possible or not.

Thank You,
Murali.

Hi Anil,

I am working on upgradation from 11 to R12 on GL module.Could you help me in finding TOIs(Technical Functional).I am not able find TOIs information on metalink.Please see the document note for your reference-

Upgrading to Release 12: 414710.1

Oracle General Ledger Documentation Resources, Release 12

Doc ID: Note:396911.1 Type: REFERENCE
Last Revision Date: 16-FEB-2007
Status: PUBLISHED

Transfer of Information (TOI) Online Training

*First-time TOI users: follow these setup instructions
Functional TOIs

Provides information for users on how to set up and use the new features included in base Release 12.
Includes:
Benefits of new features from a business perspective
Details on product dependencies and interactions
Links to additional resources

Technical TOIs

Contains information about changes made to existing Release 11i features in base Release 12.
Describes the changes made to database objects, profile options, forms, reports, programs, workflows, lookups, and seed data.
Please upload some R12 docs on your portal in this regard especially techical.

Rega rds,

Greesh

Hell Anil,

Can you fix the link for the below as I am looking for an example for interface.

Des ign and Development of Open Interfaces in Oracle Apps

Thanks
Ki shore

Hi Anil,

I want to delete element which has run results.

I deleted the element entry using hr_entry_api corresponding to element entry id.but run result exist for that element entry id .

I tried to rollback quick pay and prepayments if any,but i culdn't.
also i deleted element entries from element entry scrren.

kindly suggest me how to delete element in this case.

Thanks and Regards
Vignesh

Hi Anil,

Can you please give me step by step process of how to track the data using FND_STANDARD.SE T_WHO API.
I want this to track from Form and concurrent program both.
(In my custom table i have added the WHO columns,
now,wh enever user will enter any data to Custom form(Wich i have developed) or changes any data then i want to track the change made and fill this WHO column.)

I was working on some other technology and new this one.
So please elaborate all the needfull.

Hi Anil,
I am following your Apps material.Thank you vey much for the service you are doing towards your flat form members.
I am here becoz, recently our client asked us,they want to enter comments that which they have to found them in Auot Invoices.I saw a Comment Field in sales Order.I enbled it by personalization and gave the data.
After booking the order I find that Comment column to be empty.I also reopened through Organization(B) .But there I find the comment field in the disabled mode and didn't find the data which I typed.Please gind me a solution.I searched in metalink also.There they are also not clear about the issue.

Hi Anil,
Can You please provide step by step information of OPM Module,i am new in this module.
I have to learn this module of R12.

anuj

Hi Anil,

Can you fix the link for the below as I am looking for an example for interface.

Des ign and Development of Open Interfaces in Oracle Apps

Thanks
Sh aik

I have one problem. That is based on 2 discoverer reports i need to create one discoverer report by gathering some columns in both reports. Can u please send me the step by step process to generate this report.I am very greatfull to u, if u send screen shots also.

Hi Anil,

I need to cancel the POs using API. When I am using:

DECLARE
l_return_statu s VARCHAR2(1);
BE GIN
--FND_GLOBA L.apps_initiali ze ('48816','50104 ','20043');
--c all the Cancel API
PO_Document _Control_PUB.co ntrol_document (
1.0, -- p_api_version
F ND_API.G_TRUE, -- p_init_msg_list
FND_API.G_TRUE , -- p_commit
l_retu rn_status,-- x_return_status
'PO', -- p_doc_type
'STA NDARD', -- p_doc_subtype
n ull, -- p_doc_id
'12099 1273', -- p_doc_num
null, -- p_release_id
nu ll, -- p_release_num
n ull, -- p_doc_line_id
n ull, -- p_doc_line_num
null, -- p_doc_line_loc_ id
null, -- p_doc_shipment_ num
'CANCEL', -- p_action
SYSDAT E, -- p_action_date
n ull, -- p_cancel_reason
'N', -- p_cancel_reqs_f lag
null, -- p_print_flag
nu ll, -- p_note_to_vendo r
null); --p_use_gldate
-- Get any messages returned by the Cancel API
FOR i IN 1..FND_MSG_PUB. count_msg
LOOP
DBMS_OUTPUT.put _line(FND_MSG_P UB.Get(p_msg_in dex => i,
p_encoded => 'F'));
END LOOP;
END;


I am getting errors:
l_retur n_status :E
You do not have sufficient authority to control the status of this document

Thx Anil, I got it.........:)

Hi Anil

I need your help on writing host programs. following is my requirement.

N eed to create a directory, the dirrectory named will be passed as a parameter. Need to register this program as a concurrent program. Need to capture the concurrent status also. If program error out I need to capture the status.

what are the basic requirements to register host program. I really appriciate your help on this.

Thanks
S rini

Hi All,

I am working with an interface, in which i need to generate/retrie ve the Code Combination id on the fly with segment values. I have retrieved all the segment values. Now how could i insert the values in GL_Code_combina tions?. Is there any API or can we insert directly into the table?

I heard that there is an API named "FND_FLEX_EXT.G ET_COMBINATION_ ID" .
How to use it? I am new to API's?
Could anyone please help me in this regard?


Regar ds
Santhosh

Hi Anil



I have one problem in inventory module

How to calculate the ageing days of items in inventory as on sysdate

For e.g

Like today sysdate is 20-mar-2008

on e item BM001 HAS PO RECEIPT 19-mar-2007 with 200 qty.

receipt 15-jul-2007 with 15 qty

receipt 20-jul-2007 with 30 qty



issue 25-mar-2007 with 15 qty

issue 14-jul-2007 with 1 qty

issue 20-aug-2007 with 10 qty

issue 20 -sep-2007 with 5 qty

issue 20-oct-207 with 25 qty

issue 20-dec-2007 with 22 qty





Kindly help me to calculate the no .aging days of that invemtory in system as on sysdate



Than ks and Regards

ajay

Hi Anil,

I want to delete around 1000 service contracts. I want to write a Procedure .Waht is the perfect API in SCM.Please tell me API name.

Thanks
S hankar

Hi Anil,

Your blog is too much worthy.......
Can you help me building reports through Oracle Discoverer....

Thanks......

Hi Sushil

These are Key Flexfields.
For a Key Flexfield, if Dynamic Insertion is not allowed[as per KFF setup], then you must create a combination before using it.

Hence in this case, you need to go to Position Screen and create your Position combination

Th anks
Anil Passi

Hi Anil,

I am a great admirer of the great job that you are doing especially for the newbies.

I was trying to collect some info on APIs.I am right now trying to run an Order managemet Shipping Execution Public API , WSH_TRIPS_PUB.C reate_Update_Tr ip. The manuals, just specify the parameters, but I wonder how to put that into Pl/sql code, as I am a new to this.

I would be grateful if you could direct me on how to run this API,(specifical ly on how to pass the parameters for this API including the record type variable) with a sample code.

Thanks in advance,
Begins

Hi Anil,
Your effort is appreciable. I learnt a lot from ur article.
great job.
cheers...

I am a java developer looking to dive into oracle apps, I am hearing different kinds of stories about java and oracle apps prospects.
Particularly, I am fascinated to work in both areas. Can I find any jobs like that??

Is there any added advantage if an apps developer has java back ground ?

Is there any work that can be done only by an expert in both the fields, etc?

I dont know any thing about apps, your answer will be appreciated.

Thanks for spreading your knowledge.

Hi Anil,
I need to cancel requisition lines that are not made to PO. I need to get the complete list of requisitions lines first before I do cancel.
How do i get the list first and do cancel.
Please help

I'm trying to chang the lov(supplier name) on the form APXVDMVD (N)Purchasing super user-->suppl ybase-->supp lier-->find supplier form.
The lov on supplier name field (QF_VENDORS_BY_ NAME) currently has 4 columns(supplie r name, number, taxpayerId and tax registration number)
I want to add a new column Inactive on Date.
I tried to doing the following
1.Cre ate record group from query
select vendor_name,seg ment1,num_1099, vat_registratio n_num,vendor_id , end_active_date from po_vendors order by upper(vendor_na me)
2.Attached new record group to LOV
Now I get an error FRM-41826: cannot replace group; columns don’t match lov.
I modified the query and followed the same steps
1.Create record group from query
select vendor_name,seg ment1,num_1099, to_char(end_dat e_active, 'DD-MON-YYYY') vat_registratio n_num,vendor_id , from po_vendors order by upper(vendor_na me)
2.Attached new record group to LOV
Now the LOV looks like this
Supplier NameNumberTaxpa yerIDTaxRegistr ationNum
Abc123 45612-Apr-2005
Xyz88755621-Dec -2002

Question s:
Is there any way I can add an extra column to the LOV using FP?
Is there any way I can change the heading of the existing column (in this case TaxRegistration Num to InactiveOn)?

T hank you,
Venkat.

Hi Anil,
Your blog is extremely useful. I recently purchased hp laptop which has windows vista OS. I can’t switch back to XP. Can I install Oracle E-Business suite in Vista. Kindly reply to me.
Best regards,
Pravee na

Hello Anil,

I am posting to this section since I can not post to the appropriate blog. My apologies.

Hop efully, you can help me come up with a solution for a problem I'm having. I am trying to create a menu item that 'refreshes' NOTE_BALI.NOTE_ BST, the grid under the Note tab on the eBusiness Center form (ASTRCALL). I thought that JTF_GRID.REFRES H('NOTE_BALI.NO TE_BST') would be the appropriate BuiltIn (built in Type Call Custom Library) to use for the menu. I put the "JTF..." procedure as the argument, and this does not work. I also tried using 'Execute a Procedure' instead, but this also did not work.

After failing with using BuiltIn, I tried using the Property type instead of BuiltIn type. My plan was to use two steps: first clear the grid, and then repopulate it. I wanted to see if there was a way I could just set the value of NOTE_BALI.NOTE_ BST to NULL, but this did not clear the grid.

This is proving to be very difficult for me, and any advice on this would be appreciated.

So here's what I ended up doing:

First thing to know - the requirement was to toggle a filter on NOTE_BALI.NOTE_ BST. The filter displays only one type of Note. So, I was never supposed to clear this grid. Without looking at the details of the JTF_GRID package, I would imagine there is a simple function there that would do this should you require it.

Elements:

1) 2 menu items that get created on the WHEN-NEW-FORM-I NSTANCE trigger. "Show -specific- notes only" and "Clear -specific- notes filter". I set up two lines in the personalization for these menu items. Each used an Action type of Menu. I used menu entries Special12 and Special14. This was the "shell" of the solution, and the easy part.

2) Here was the tricky part: I edited CUSTOM.pll, adding these two IF statements within the humongous "event" procedure:

-- show specific notes only
IF event_name = 'SPECIAL12' AND form_name = 'ASTRCALL' THEN

-- set values for start and end dates (assumed that you add these variables at the top of the file)
l_start := name_in('NOTE_B ALI_DATES.START _DATE');
l_end := name_in('NOTE_B ALI_DATES.END_D ATE');

-- created a WHERE clause string here (assumed that this variable is declared)
l_where := (here, you include NOTE_TYPE_MEANI NG, OBJECT_ID, and ENTERED_DATE in the range between l_start and l_end)

-- grid init
jtf_grid.init(' NOTE_BALI.NOTE_ BST','AST_NOTES _GRID');

-- finally, apply the filter
jtf_grid.setCha rProperty('NOTE _BALI.NOTE_BST' , jtf_grid_proper ty.WHERE_CLAUSE , l_where);

END IF;

-- remove the specific notes filter
IF event_name = 'SPECIAL14' AND form_name = 'ASTRCALL' THEN

-- set values for start and end dates (assumed that you add these variables at the top of the file)
l_start := name_in('NOTE_B ALI_DATES.START _DATE');
l_end := name_in('NOTE_B ALI_DATES.END_D ATE');

-- HERE is the MAJOR difference....
l_where := (its the same as before, except you DO NOT include NOTE_TYPE_MEANI NG)

-- grid init
jtf_grid.init(' NOTE_BALI.NOTE_ BST','AST_NOTES _GRID');

-- finally, apply the filter
jtf_grid.setCha rProperty('NOTE _BALI.NOTE_BST' , jtf_grid_proper ty.WHERE_CLAUSE , l_where);

END IF;

Hi,
I am trying to print a footer and header from plus and export it into excel, but once its exported into excel, the header and footer do not show. They show if exported into PDF. How can I make it appear in excel?
Any ideas will be greatly appreciated

Th anks
Sheena

Hi Anil,

The material which u have are really amazing and very useful to many oracle guys.
I have an issue.
We designed many custom forms and in that when two users try to update a single record the screen gets locked for the second user and the system just hangs.
I have not noticed this kind of a behaviour in any of the apps standard forms.
I am creating the block based on the table.But I have seen in standard forms the blocks are based on views.
Will this problem go away if the datablock is created based on a view.
Please advice.

Thanks
Kirubanandh

Hi Anil,

I am using the FNDLOAD program in apps to download a value set .
I have actually created a pl/sql program and submitted the fndload program using fnd_request.sub mit_request.
Th e program completes successfully and the log file says the ldt file has been created,
But I have checked for the file in the corresponding location the file is not present.
I tried to create the ldt file using the standard method from unix box(ie from Putty) it is getting created .
It would be of a great help if you can suggest something on troubleshooting on this problem.
I have given the log file detail below.

FNDLOAD module: Generic Loader
+------- --------------- --------------- --------------- --------------- --------+

Curr ent system time is 18-FEB-2009 01:53:56

+---- --------------- --------------- --------------- --------------- -----------+

D ownloading VALUE_SET to the data file /o6_u11/home/ap plmgr/osp6appl/ fnd/11.5.0/patc h/115/import/TE ST13FEB0902.ldt
Downloaded VALUE_SET TEST13FEB09
+------------- --------------- --------------- --------------- --------------- --+
Start of log messages from FND_FILE
+----- --------------- --------------- --------------- --------------- ----------+
+-- --------------- --------------- --------------- --------------- -------------+
End of log messages from FND_FILE
+----- --------------- --------------- --------------- --------------- ----------+


T hanks and Regards
Kiruban andh

Dear Anil,

I am trying to customize the LOV of PAyments Window in Oracle Payables.

I have personalized this form by first using a built-in "Create Record Group from Query"
and then I have attached my Custom Record Group (XXCS_OBJECT_CO DE_RG) to the standard LOV.
When I click "Apply Now" I receive the error:
"FRM-418 26: Cannot replace group, columns don;t match LOV"

Initially I was using standard Record Group Query and put a condition in the end but it was also not running and
generating the error:
"FRM-40502: Unable to read list of Values"

Later on I decided to write my own custom query. Now I am getting the above mentioned error.

Please help.
This is my custom query:

SELECT
V.INVOICE_NUM,
V.INVOICE_ID,
V.INVOICE_TYPE_ LOOKUP_CODE AS INVOICE_TYPE,
N ULL AS PAY_ALONE,
V.EX CLUSIVE_PAYMENT _FLAG,
NULL AS PAYMENT_NUM,
NV L(V.INVOICE_AMO UNT,0) - NVL(V.AMOUNT_PA ID,0) AS AMOUNT_REMAININ G,
NULL AS CHAR_AMOUNT_REM AINING,
0 AS DISCOUNT_AVAILA BLE,
NULL AS CHAR_DISCOUNT_A VAILABLE,
SYSDA TE AS DISC_DATE,
NULL AS ALWAYS_TAKE_DIS C_FLAG,
0 AS DISCOUNT_AMOUNT _AVAILABLE,
SYS DATE AS DISCOUNT_DATE,
SYSDATE AS SECOND_DISCOUNT _DATE,
0 AS SECOND_DISC_AMT _AVAILABLE,
SYS DATE AS THIRD_DISCOUNT_ DATE,
0 AS THIRD_DISC_AMT_ AVAILABLE,
V.IN VOICE_AMOUNT AS GROSS_AMOUNT,
V .DESCRIPTION,
V .ACCTS_PAY_CODE _COMBINATION_ID AS ACCTS_PAY_CODE_ COMBI_ID,
V.TER MS_DATE AS DUE_DATE,
NULL AS REMIT_TO_SUPPLI ER_NAME,
NULL AS REMIT_TO_SUPPLI ER_ID,
NULL AS REMIT_TO_SUPPLI ER_SITE,
NULL AS REMIT_TO_SUPPLI ER_SITE_ID,
V.R ELATIONSHIP_ID,
V.EXTERNAL_BAN K_ACCOUN_ID,
NU LL AS EXTERNAL_BANK_A CCOUNT_NUM,
NUL L AS EXTERNAL_BANK_A CCOUNT_NAM
FROM AP_INVOICES_ALL V
WHERE V.ORG_ID = 82

and this is the standard LOV query,

select v.invoice_num,v .invoice_id,v.i nvoice_type, v.pay_alone, v.exclusive_pay ment_flag, v.payment_num, v.amount_remain ing,to_char(v.a mount_remaining ,fnd_currency.g et_format_mask( v.currency_code ,42)) char_amount_rem aining,ap_payme nt_schedules_pk g.get_discount_ available(v.inv oice_id, v.payment_num,: pay_sum_folder. check_date,:pay _sum_folder.cur rency_code) discount_availa ble,to_char(ap_ payment_schedul es_pkg.get_disc ount_available( v.invoice_id,v. payment_num, :pay_sum_folder .check_date,:pa y_sum_folder.cu rrency_code),fn d_currency.get_ format_mask(v.c urrency_code,42 )) char_discount_a vailable, ap_payment_sche dules_pkg.get_d iscount_date(v. invoice_id, v.payment_num, :pay_sum_folder .check_date) disc_date,v.alw ays_take_disc_f lag, v.discount_amou nt_available,v. discount_date,v .second_discoun t_date,v.second _disc_amt_avail able, v.third_discoun t_date,v.third_ disc_amt_availa ble,v.gross_amo unt,v.descripti on, v.accts_pay_cod e_combi_id,v.du e_date,v.REMIT_ TO_SUPPLIER_NAM E, v.REMIT_TO_SUPP LIER_ID, v.REMIT_TO_SUPP LIER_SITE, v.REMIT_TO_SUPP LIER_SITE_ID, v.RELATIONSHIP_ ID,v.external_b ank_account_id, apbk.bank_accou nt_num external_bank_a ccount_num,apbk .bank_account_n ame external_bank_a ccount_name from ap_invoices_rea dy_to_pay_v v, ap_bank_account s_all apbk where v.party_id = :pay_sum_folder .party_id and v.invoice_num like :adj_inv_pay.in voice_num||'%' and ((:pay_sum_fold er.payment_type _flag = 'M') or (:pay_sum_folde r.payment_type_ flag = 'R' and v.invoice_type in ('CREDIT','STAN DARD', 'DEBIT','EXPENS E REPORT','MIXED' ,'AWT')) or /*Bug5948003, Bug6069211*/ (:pay_sum_folde r.payment_type_ flag = 'Q' and (v.vendor_site_ id = :pay_sum_folder .vendor_site_id or v.invoice_type = 'PAYMENT REQUEST') and ((:system.last_ record = 'TRUE' and :system.cursor_ record = '1') or (NVL(v.exclusive_pay ment_flag,'N') = 'N' and nvl(:parameter. pay_alone, 'N') = 'N')))) and v.currency_code = :pay_sum_folder .currency_code and v.payment_metho d_code = :pay_sum_folder .payment_method _code and nvl(v.payment_f unction, 'PAYABLES_DISB' ) = nvl(:pay_sum_fo lder.payment_fu nction, 'PAYABLES_DISB' ) and v.set_of_books_ id = :pay_sum_folder .set_of_books_i d and nvl(v.future_da ted_payment_cci d, -1) = DECODE(:paramet er.manual_fdp_s ite_acct_src_fl ag,'Y',nvl(:par ameter.site_fdp _account_ccid,- 1), nvl(v.future_da ted_payment_cci d,-1)) and v.external_bank _account_id = apbk.bank_accou nt_id(+) order by upper(invoice_n um)