In parameter in stored procedure is passing by refrence. OUT parameter is passing by value. If we want to use pass OUT parameter as passing by value then we can use NOCOPY for OUT parameter which will be used as passing by reference.
Senthil
Aug 6th, 2007
IN parameter and IN OUT Parameter are the parameters can be passed by reference or Valur whereas OUT parameters are passed by value.
Inbound interface: We load the data which we got from the legacy systems.Outbound interface : We extract the data for legacy systems.
anil kumar
May 29th, 2007
Inbound Interface: The Data that is being brought in to oracle application from markets?Eg: Purchase Requisitions (From Market-->Oracle)Out Bound Interface: The data that is being sent to markets fro...
a adjustment is some thing that is written off on a invoice.eg a customer short pays a 100$ invoice by 5 $ you write off this 5$ this is an adjustment.while a discount is something a customer gets fro...
reddy
Feb 2nd, 2006
hiif the amt is paid by a customer to supplier after receiving the goods..then after surprisingly discount is given by SUPPLIER or VENDOR ...the amt is adjusted in the nxt invoicereddy
We cannot use ref cursors in the client side (FORMS Libraries ) library. This feature is available only on the server side PLSQL. i.e. Packages which reside in the databse.
HD
Feb 17th, 2006
Could someone please answer why we cannot use REF Cursors in CUSTOM.pll
Value Sets r set of values......There r six Value Sets Availabe in Oracle Apps.1)Independent2)Dependent3)Table4)None5)Special6)Pair.Cheers,Bonthu.
chenna
Nov 30th, 2005
Hi divya, U have forgotten to list out them. Value sets are nothing but a list of values with some validations.There are 8 types of value sets.They are1.None2.Independent3.Dependent4.Table5.Special6.pair7.Translatable Independent8.Translatable Dependent
Can you please tell me, how can i track the API completed in error or completed normal.
vk_appstech
Nov 11th, 2005
hi,i wonder why it didnt work for u.ARP_PROCESS_CHARGEBACK,CREATE _CHARGEBACK IS THE API u need.there are around 42 parameters in which 2 are in params and 2 are inout params.we have done the similar thing once..i am sure it will work procided u have populated the columns properly,,,regardsvijay
Oracle Support should provide you a complete plan of action in case of a patch failure. If they do not provide you complete plan of action ask for it.In case of a patch failure, different patches need different steps to be taken. There is no universal plan of action after a patch has failed.
Devesh Gupta
Jun 7th, 2006
If you have wasted your time in main patch near about 8 to 10hrs.,then you should take backup of FND_INSTALL_PROCESSES,AD_DEFFERED_JOBS and baclup of restart files which extension is .bk9,rf9 nd...
There are many concurrent managers, each monitoring the flow within each apps area.but there are 3 MASTER CONCURRENT MANAGERS:1. Internal Conccurent Manager (ICM): This is the one which monitors all o...
Bonthu Reddy
Feb 10th, 2006
There r quite few concurrent managers available in Apps.1)Concurrent Manager (Standard)2)Interal Monitor.3)Internal Manager.4)Transaction Manager. Thanks n Rgds,Bonthu N Reddy.
RFQ-reques for quotationin purchase module-if company have internal supplier then company will issue rfq,else company will issue rfq,so that supplier can send their quotation.for purchase order
Purchasing formats your purchase orders to be printed on a standardpurchase order form. This section explains how Purchasing prints thepurchase order information. You can use the standard format orcustomize the report to meet your needs.
AR provides the feature such that the customer can directly make the payment for their invoices in the Bank.The Bank would send a datafile in a agreed transmission format which we we i...
I we want to transfer the data from legacy system to oracle we will use the interfaceshere we have two types of interfaces one is inbound interface and other is outbound interfaceinterface is nothing ...
Shruti
Sep 27th, 2006
1- Identification (check if the Open interface exists for loading the data into the base tables)2- Create a staging table( having data colums, conditonal colums)3- Load data into staging table4- Creat...
To call a concurrent program from after report trigger of the report one can not use fnd_request.submit_request deirectly. But one must use the following:1. If this is a custom report then in the "bef...
Silpa
Nov 8th, 2006
Brijesh, Were u able to get the answer for ur question. If so could u please let me know. I have to kick off a shell script from the after report trigger. Thanks in advance.Silpa.
Well explaining about the? AP ModuleAP ----------->GLAP Module consists of the following? steps1)creation of the invoices2)creation of the payments3)transfer it to gl by predefined program.AR ------...
Hi ????? u can do it by setting up the hrms setup in business group where u have an option of manual or automatic for employee no generation.if u employee no generation as automatic and start the sequence with the no which u'r saying may solve u'r problem....
surendra
Feb 12th, 2007
Hi vikky.. how r u.. this is surendra u can try the following syntax to solve the problem create sequence s1 start with 000001 increment by 1;
There is one cycle called P2P(procure-to-pay) contain some module of Oracle Application. PO,AP,GL. Process Flow..... 1) Requisition. once it is approved. 2) Purchase Order.Once it is ap...
sudheer
Dec 4th, 2006
(N) -> Order Management Super User-> Order Returns -> Sales Order Create a Sales Order a. Order Header -> Main Tab B .Order Header -> Others Tab Verify that th...
Ans