ERPstuff - Oracle EBS Community

try it SELECT papf.person_id, papf.employee_number, papf.full_name, (SELECT user_name FROM fnd_user WHERE user_id = papf.created_by) created_by, papf.last_update_login, paaf.application_id, hla.location_code, papf.effective_start_date, papf.effective_end_date FROM per_all_people_f papf, per_all_assi...

How to Customize Workflow


http://www.erpschools.com/videos/Workflow/workflow.html

basic purpose
you can capture territory wise receivable from this option
you can allocate your sale teams territory wise
you can make pricing schemes territory

You can setup oracle alerts if you have query for that and scheduled it as periodic alert

Make sure that the file asoqueue.sql is present in $ASO_TOP/patch/115/sql directory Make sure that user ?ASO? and ?APPS? have execute rights on SYS.DBMS_AQADM and SYS.DBMS_AQ packages with Grant option Run $ASO_TOP/patch/115/sql/asoqueue.sql in the following manner: sqlplus APPS/<APPS password> @aso...

How to find whether the software is 32 bit or 64bit : * Go to Disk3/stage/Components/oracle.options.odm/9.2.0.4.0/1/DataFiles/ in the installation kit. % cd Disk3/stage/Components/oracle.options.odm/9.2.0.4.0/1/datafiles * Copy lib.1.1.jar file in a new directory, outside the installation kit % cp l...

We all know Linkedin or Plaxo. Now Oracle has it's own network site (beta..)
Check it out and login using your Oracle sso account (otn account)


https://mix.oracle.com/

For internal requisition Order Management is required as all approved internal requisition leads to Internal Sale Order.

You can use Inter- Organization Transfer functionality or Misc. Issue and Receipt Functionality.

Required Operating System patches as per Oracle Applications Installation and Upgrade Notes Release 12 (12.0), are missing/not installed.

<b>WORKAROUND</b>
-------------
Refer to MetaLink Note 427714.1.

1. Source the Applications environment file
2. Run make -f ins_forms.mk install

visit following

http://oracle.anilpassi.com/steps-to-se ... pes-3.html

its for BSA change it to <b>ORDER</b>

need to define new order / line transaction type
set
<b>Negotiation Flow := Negotiation Flow - Generic
Default Transaction Phase :- Negotiation</b>

there must be some problem with price list setup.
check QP Custom Source profile if its on then off and then try it.


secondly create new price list with same item and process it for debugging purpose.

i am using following query in alerts to get higest value cheque bounced. modify it according to your requirement SELECT rc.customer_number, rc.customer_name, COUNT (acra.receipt_number), SUM (acra.amount) INTO &output1, &output2, &output3,&output4 FROM ar_cash_receipts_all acra, ra_c...

Dear Tahir,

i got your point. this link is for assistance not exact solution you need to work on this pattern (use beans and SQL).

try it


http://forms.pjc.bean.over-blog.com/art ... 140-6.html