Dear Friends,
We have now launched a forum.
What is different about this forum
The entries in this forum will be business requirement oriented.
The forum is dedicated to customizations & extensions only.
OA Framework Forum - http://apps2fusion.com/forums/oaf
If you wish to do any extension in OA Framework, then post your requirements in the right section, like iProcuremen, then
apps2fusion team will analyze your requirement and will suggest you a best practice approach and step by step solution.
You can find various samples of how to post your queries.
For example please see below URLs
http://www.apps2fusion.com/forums/viewtopic.php?f=9&t=91
http://www.apps2fusion.com/forums/viewtopic.php?f=10&t=96
PL/SQL API Forum http://apps2fusion.com/forums/
Every consultant keeps their scripts in pocket and re-uses them on different project.
In this forum, as time progresses, we will be posting all our scripts that we have used in the past many years of consulting.
For example, if you wish to write receivables invoice interface, you will be able to see the work of other developers on this forum.
This will be a collaborative effort, I hereby request each of you to share your scripts by posting them on this forum.
You will have to register to access this forum, it takes only 10seconds.
More forums will be added added in future, your suggestions are precious, email us on This email address is being protected from spambots. You need JavaScript enabled to view it.
Finally few humble requests
- Please post entries only within the relevant section
- Explain your problem properly, please don't use short cuts to explain [see samples]
- Please collaborate where you can, every contribution is appreciated
Thanks,
Apps2Fusion Team
Apps2Fusion Articles 
Comments
I was thinking,it might be a good idea to share learning from Project Management experiences,bes t practices for running projects,conver sions & so on.Armoured with this knowledge & apps expertise already,eventua lly it has potential to help consultants on this website to be more able to increase their worth & more value to their client.
Cheers
That is a good idea, I will discuss this further with yourself.
Than ks,
Anil Passi
The idea suggested by Ranu is very good ... Please think of it .
Thanks and Regards
balkris hna
In deed it is, I am working with apps2fusion authors to further enhance this forum.
Thanks,
Anil Passi
I believe, more will keep pouring in from readers & contributors alike with time.
We are using FSG report.After submit the XML report by selecting the template ,it displaying a ERROR MSG as the "template is not exist and contact ypur system admin".
Could you please help me in this issue.please find the below steps
XXX GL Financial controller -> Report manager -> Financial report submission -> report name ¶meters ->template ->storage location ->review->submi t
with regards
suresh
Is there any differences between 11i and R12 for Customer Interface? I developed a BPEL process to upload customer information and used the following tables :
1. RA_CUSTOMERS_IN TERFACE_ALL
2. RA_CUSTOMER_BAN KS_INT_ALL
3. RA_CUSTOMERS_PR OFILES_INT_ALL
4. RA_CUST_PAY_MET HOD_INT_ALL
5. RA_CONTACT_PHON ES_INT_ALL
Is there any change(addition or removal of any tables) in R12? Or can I use my old process for R12 also?
Thanks in advance.
With regards,
Nemai
Do you have any plans on training for Projects Management, Billing, Costing and Manufacturing. Please do let us know.
Thanks,
Shilp a.
Thanks for this query, we are always in pusuit of adding "value for money" trainings to our portfolio.
Howe ver we are not sure if there is enough volume/people seeking the training that you suggested
Than ks,
Anil Passi
I am trying to run FSG in R12 and its erroring out. There is no proper error message displayed.
I am pasting the log file.
Log File:
After recalculating exceptions.
Cur rent date and time: Thu Oct 16 20:09:21 2008
After ranking.
After segment value routine.
XML processing start.
XML processing after xml_page_style.
XML processing after rgrcoh call.
XML processing for content_cnt 1.
XML processing after xml_page_style.
Couldn't find string
Current date and time: Thu Oct 16 20:09:21 2008
Entered sauulc with code 1 from line 908 of file rg/lib/rgrclob. c.
+---------- --------------- --------------- --------------- --------------- -----+
Start of log messages from FND_FILE
+----- --------------- --------------- --------------- --------------- ----------+
+-- --------------- --------------- --------------- --------------- -------------+
End of log messages from FND_FILE
+----- --------------- --------------- --------------- --------------- ----------+
+ --------------- --------------- --------------- --------------- --------------- +
Executing request completion options...
Ou tput is not being printed because:
Progra m failed to set the report print style.
Finish ed executing request completion options.
Progra m exit with Error
+------- --------------- --------------- --------------- --------------- --------+
Concu rrent request completed
Curre nt system time is 16-OCT-2008 20:09:21
----- -----------
Exc ept this i dont see any error message in the log file.
If there any solutions to this please suggest me.
Thanks,
Vijay
Please clarrify
I am a trainee in apps, Can you giver me any useful information about apps.
I very earnestly request you to reply at the earliest possible.
Problem: Existing code is crashing due to memory leak in production environment. I have two questions please:
Question 1: (Connection Pooling Environment)
OADBTransactio n oadbTransaction = getOADBTransact ion();
Statement stmt = oadbTransaction .createStatemen t("statement inside");
I close statements but I do not close oadbTransaction and resultSet.
Does this lead to memory leak?
At one place I forgot to close statement also.
That means statement, resultset and oadbTransaction are not closed here.
Does this lead to memory leak?
------------- --------------- --------------- --------------- --------------- --------------- -------------
- --------------- --------------- --------------- --------------- --------------- --------------- ----------
Ques tion2: (Connection Pooling Environment)
In my framework, I used the following statement:
Connection localConnection = oadbTransaction .getJdbcConnect ion();
I understand now that getJDBCTransact ion() method is not recommended? Why?
I do not close the localConnection but I close the statements.
Does this lead to memory leak?
Does this also lead to out of connections error?
Your prompt response is most appreciated.
Regards,
Fran klin Alagala
9703016412
We have a requirement wherein we need to implement record based security on Customer Standard Form. WE have a DFF Column at Account Level and Site Use LEvel and based on this column value User should be either be allowed to update the record or we need to restrict the update.
Also, based on this value user can either can add sites or cannot add sites.
I need to know what will be the best apporach to achieve this :-
1) OA Framework Extention - can you suggest how to start with this.
2) Virtual Private database
3) Database triggers on base tables.
What do you think will be the best approach. Please do let me know.
Thanks.
We have a requirement wherein we need to implement record based security on Customer Standard Form. WE have a DFF Column at Account Level and Site Use LEvel and based on this column value User should be either be allowed to update the record or we need to restrict the update.
Also, based on this value user can either can add sites or cannot add sites.
I need to know what will be the best apporach to achieve this :-
1) OA Framework Extention - can you suggest how to start with this.
2) Virtual Private database
3) Database triggers on base tables.
What do you think will be the best approach. Please do let me know.
Thanks.
For OA Framework pages, you should use OA Frameowork extension.
You can extend the entity object for method onUpdate() to throw exception when record is being updated mathces your conditions.
If you aren't too comfortable with this, then I suggest you use business event, by creating a subscription less than 99.
This will be similar to database trigger, but business events is a much more elegant approach.
Than ks,
Anil Passi
Please refer to this class in OAF oracle.jbo.serv er.ApplicationM oduleServiceImp l.
Inside methods below:
--> getQNameFromIRe pByJavaType
--& gt; getImplementati onNameFromIRepB yQName
Stateme nts are not closed after use. Does this not lead to memory leak?
If this is true then there is a serious issue with this part of code in OAF.
We are having memory leak issues in our application and JProbe points to memory leak in OAF.
Kindly comment? We eagerly await your reply.
Best Regards,
Frankl in Alagala
Infoys
I am doing a custom form for our client.
I ahve added the libraries including APPDAYPk.pll to the form.
While compiling using frmcmp in linux box it shows CALENDAR.SHOW ,ust be declared.I ahve added calendar.show in key-list-val trigger for an item.
Also it shows the compilation error in CALENDAR datablock triggers which calls calendar.event.
It shows the error as:
CALENDAR.EV ENT must be declared in when-button-pre ssed trigger of CALENDAR Block.
Please help.
I am a beginner in OAF and have a got a custom application.
Th is is an already existing custom application and I need to add some features.
The problem is as below:
I am running the fom directly from JDeveloper and the form opens fine.
I can navigate between pages in the form.
But None of the LOVs in the form open any search page.
when I click on the 'torch' button, the base page refreshes itself and does not pop-up any search page.
pop-up blocker is off.
clicking on date-field-cale ndar icon opens up the calendar.
Ple ase help.
Thanks,
Prakash.
I am new to oracle workflow. i have a workflow issue. whenever an approver approves the PO,
his manager gets the notification of the PO approval. This notification should not be gone as in a day many PO's are approved.
How this functionality can be removed.
The error message will tell the user about the invalid values passed to the Requisition, PO, Supplier Invoice account generators.
Pl ease provide your inputs on how to display errors in Oracle Forms from a workflow.
Than ks & Regards,
mahen dra
At present i am wokring EAM Module. In EAM Stores i need to call one report.
In my OAF Page one button is there("The name of the button is Issue"). After clicking this button i need to fire one report(The name of the report is "Maintenance Picking Slip Issued Report").
Actually the requirement is :
I have a button in the OAF page. On click of that button a new pop up window should open where the report should be displayed. (the report is XML Publisher Report )
I am working on Seeded pages.
Please help me how to call report? I don't have any idea how to proceed for this.please explain clearly.
Than ks in advance..
Than ks,
Somasekhar.
I am trying to call a pl/sql function which is validating the phone number entered in the phones screen. I want to display error message if the phone number is not entered in a proper format. For that i am calling the function from
forms personalization and based on the value returned, i want to display an error message using raise form trigger failure and display some messages using fnd_message.sho w.
But unfortunately, i couldn't use form_trigger_fa ilure and fnd_message in the Builtin type of Excecute a procedure. How to do this??
I can use the built in as Raise formtrigger failure but how to link that to the value returned from the procedure.
Tha nks in advance.
Akhil
We need to extend oracle.apps.per .selfservice.ab sence.server.Ab senceTypeVO View Obect. This object is being used in the page /oracle/apps/pe r/selfservice/a bsence/webui/Ab senceHomePagePG . Query is currently filtering absence types based on a business group. The query should also filer Absence types using the Person_Id who has logged into the self service page. Let us know the steps to be followed.
Than ks in Advance.
Deepak .
I want to attach some SIT functions with the Employee Self Service Menu. could you please tell me what informations need to provide at Create Function screen, to create this SIT function whcih I need to attach at Employee Self Service function.
I used seeded 'Special Information' function, and copied the same HTML call and Parameter for my custom function. when I click on this function from Employee self service Menu, I am geting an error. Error message I am geting is,
Can not access function XXX_PASSPORT. This installation does not manage mode pl/sql. Please contact your System Administrator.
Please suggest what is the issue and how to overcome from this.
Regards
Kartik T
Hi anilpassi and ranu ,
Pl help me on this issue.
Regards ,
Bommudurai
In our company we are upgrading Oracle Apps from 1158 to 12i. Can you tell me the process of converting suppliers from 1158 to 12i.
Thanks,
V amsi
I have to do Expense Report Import interface. Can you explain about how to import expense reports in IExpenses. Can you explain how to populate the interface tables?
After giving the parameter for the request the request will be submitted.
Then I want the FIND REQUEST Form to be displayed automatically as it happens when you submit a request through SRS Screen.
How to do that through FP?
This is the first time i am writing, I need your help.
I need to develop a form
Filed: Item: When user scans any Item (Barcode ) then Item should be populated. in the filed and
in the details block - It should populate the Item,Descriptio n, quantity, Po# and Supplier.
So user i wlll be scanning many items that means all the items with details must be populated in t he details block.
Can you please suggest me how to go ahead.
Please send me a mail to naveen.papineni
Than k you
Naveen
This is the error stack..
oracle .apps.fnd.frame work.OAExceptio n: java.lang.NullP ointerException
at oracle.apps.fnd .framework.OAEx ception.wrapper Exception(OAExc eption.java:888 )
at oracle.apps.fnd .framework.webu i.OAPageErrorHa ndler.prepareEx ception(OAPageE rrorHandler.jav a:1145)
at oracle.apps.fnd .framework.webu i.OAPageErrorHa ndler.processEr rors(OAPageErro rHandler.java:1 408)
at oracle.apps.fnd .framework.webu i.OAPageBean.pr ocessFormReques t(OAPageBean.ja va:2637)
at oracle.apps.fnd .framework.webu i.OAPageBean.pr eparePage(OAPag eBean.java:1659 )
at oracle.apps.fnd .framework.webu i.OAPageBean.pr eparePage(OAPag eBean.java:497)
at oracle.apps.fnd .framework.webu i.OAPageBean.pr eparePage(OAPag eBean.java:418)
at _oa__html._OA._ jspService(_OA. java:88)
at oracle.jsp.runt ime.HttpJsp.ser vice(HttpJsp.ja va:119)
at oracle.jsp.app. JspApplication. dispatchRequest (JspApplication .java:417)
at oracle.jsp.JspS ervlet.doDispat ch(JspServlet.j ava:267)
at oracle.jsp.JspS ervlet.internal Service(JspServ let.java:186)
a t oracle.jsp.JspS ervlet.service( JspServlet.java :156)
at javax.servlet.h ttp.HttpServlet .service(HttpSe rvlet.java:588)
at org.apache.jser v.JServConnecti on.processReque st(JServConnect ion.java:456)
a t org.apache.jser v.JServConnecti on.run(JServCon nection.java:29 4)
at java.lang.Threa d.run(Thread.ja va:534)
## Detail 0 ##
java.lang.NullP ointerException
at vtk.oracle.apps .pos.asn.webui. VtkPosAsnCreate CO.processFormR equest(VtkPosAs nCreateCO.java: 84)
I am not able to find the exact reason.
Even i copied the standard Co class created a new one just changing the path in redirect url for submitt button.
It doesnt even extend any other class still i am getting this error.
Regards
k.kritika
iProc/Purc hasing does have an option where you are restrict requisitions access either to your department, yourself.
I will really appreciate if you can provide some pointer which enable to put a control that users can access there and some specific departments only.
eg-
User A sees requsitions corresponding to Dep C , Dep B , Dept A (His Dept)
User B sees requsitions corresponding to Dep A , Dep C , Dept B (His Dept)
Thanks
A bhishek
phm.put("ParamE mpid",param);
phm.put("xxPara mmainAction",ma inAction);
pageContext.set ForwardURL(
"OA.jsp?page=/o racle/apps/ak/e mployee/webui/M anagePG"
,null //not needed as we are retaining menu context
,OAWebBeanConst ants.KEEP_MENU_ CONTEXT
,null //not needed as we are retaining menu context
//,null
,phm //pass the hashMap that contains values for all of the parameters
,true //retain AM
,OAWebBeanConst ants.ADD_BREAD_ CRUMB_NO
,OAWebBeanConst ants.IGNORE_MES SAGES);
i had created this code and its showing one error..
error is
Error(59,25): method setForwardURL(j ava.lang.String , null, byte, null, java.util.HashM ap, boolean, java.lang.Strin g, byte) not found in interface oracle.apps.fnd .framework.webu i.OAPageContext
I asked in many forum dint get any reply, I have lot of expectation from you.
How Flex plugin work with OAF ?
Thanks,
Amin
Cheers,
Anil Passi
(/*This part is for site level bank*/
SELECT substr(v.NUM_10 99,3,8) RUC,
UPPER(substr(V. VENDOR_NAME,1,3 0)) PROVEEDOR,
ia.INVOICE_NUM FACTURA,
TO_CHAR(ch.chec k_date,'YYYYMMD D') FECHA,
LPAD(TO_CHAR(ip .AMOUNT*100),11 ) IMPORTE,
ieb.bank_accoun t_type FORMA_PAGO,
DECODE(ieb.bank_accoun t_type, '1', '000', '2', '000', cbbv.branch_num ber) CODIGO_OFICINA,
ieb.bank_account_num--substr(ieb.bank_account_num,1,3)||DECODE(ieb.bank_accoun t_type,'1','','2','0','3','0')||substr(ieb.bank_account_num,5,length(ieb.bank_account_num)) CODIGO_CUENTA ,
,' ' FLAG ,
' ' MARCA,
DECODE(v.num_10 99,'20913339',' 20209133394',su bstr(v.num_1099 ,1,11)) NIT
,iep.payee_part y_id
,iep.party_site _id
,iep.supplier_s ite_id
,iep.ext_payee_ id
FROM
/*hz_party_site s hps*/
apps.iby_extern al_payees_all iep
,apps.iby_pmt_i nstr_uses_all ipi
,apps.iby_ext_b ank_accounts ieb
,apps.ce_bank_b ranches_v cbbv
,ap_invoice_pay ments_all ip
,ap_checks_all ch
,ap_invoices_al l ia
,Po_vendors v
,po_vendor_site s_all vs
WHERE
ieb.branch_id =cbbv.branch_pa rty_id
AND ieb.bank_id = cbbv.bank_party _id
AND ieb.ext_bank_ac count_id = ipi.instrument_ id
AND ipi.ext_pmt_par ty_id = iep.ext_payee_i d
/* AND cbbv.branch_par ty_id = hps.party_id (+) */
--AND iep.supplier_si te_id = vs.vendor_site_ id
AND iep.supplier_si te_id=vs.vendor_site_ id
AND iep.payee_party _id = v.party_id
AND ip.CHECK_ID = ch.CHECK_ID
AND ip.INVOICE_ID = ia.INVOICE_ID
AND ch.VENDOR_ID = v.VENDOR_ID
AND ia.VENDOR_ID = vs.VENDOR_ID
AND ia.VENDOR_SITE_ ID = vs.VENDOR_SITE_ ID
AND ch.AMOUNT > 0
AND ch.CHECKRUN_NAM E = '&1'
AND trunc(SYSDATE) BETWEEN nvl(ipi.start_d ate,SYSDATE-1) AND nvl(ipi.end_dat e,SYSDATE+1)
UNION
/*This part is for supplier level bank*/
SELECT substr(v.NUM_10 99,3,8) RUC,
UPPER(substr(V. VENDOR_NAME,1,3 0)) PROVEEDOR,
ia.INVOICE_NUM FACTURA,
TO_CHAR(ch.chec k_date,'YYYYMMD D') FECHA,
LPAD(TO_CHAR(ip .AMOUNT*100),11 ) IMPORTE,
ieb.bank_accoun t_type FORMA_PAGO,
DECODE(ieb.bank_accoun t_type, '1', '000', '2', '000', cbbv.branch_num ber) CODIGO_OFICINA,
substr(ieb.bank_account_num,1,3)||DECODE(ieb.bank_accoun t_type,'1','','2','0','3','0')||substr(ieb.bank_account_num,5,length(ieb.bank_account_num)) CODIGO_CUENTA ,
' ' FLAG ,
' ' MARCA,
DECODE(v.num_10 99,'20913339',' 20209133394',su bstr(v.num_1099 ,1,11)) NIT
,iep.payee_part y_id
,iep.party_site _id
,iep.supplier_s ite_id
,iep.ext_payee_ id
FROM
--hz_party_site s hps
apps.iby_extern al_payees_all iep
,apps.iby_pmt_i nstr_uses_all ipi
,apps.iby_ext_b ank_accounts ieb
,apps.ce_bank_b ranches_v cbbv
,ap_invoice_pay ments_all ip
,ap_checks_all ch
,ap_invoices_al l ia
,Po_vendors v
WHERE
ieb.branch_id =cbbv.branch_pa rty_id
AND ieb.bank_id = cbbv.bank_party _id
AND ieb.ext_bank_ac count_id = ipi.instrument_ id
AND ipi.ext_pmt_par ty_id = iep.ext_payee_i d
--AND cbbv.branch_par ty_id = hps.party_id
AND iep.payee_party _id = v.party_id
AND iep.supplier_si te_id IS null
AND ip.CHECK_ID = ch.CHECK_ID
AND ip.INVOICE_ID = ia.INVOICE_ID
AND ch.VENDOR_ID = v.VENDOR_ID
AND ia.VENDOR_ID = v.VENDOR_ID
AND ch.AMOUNT > 0
AND ch.CHECKRUN_NAM E = '&1'
AND trunc(SYSDATE) BETWEEN nvl(ipi.start_d ate,SYSDATE-1) AND nvl(ipi.end_dat e,SYSDATE+1))
Sorry about the previous thread.....
I have a problem.
Suppose, a supplier has two sites. One of the site is attached to a bank account, where the onther bank account is not attached to none of the site...
So, there are two bank account. One is supplier level another is site level. Now, For a batch payment (In R12 for Payment Process Request), we have a requirement to find out the supplier associated with that batch payment alond with Supplier bank account number.
Now, for Bank account at supplier site level,its not a problem.. Problem occurs for bank account at supplier level. When an invoice is created against that supplier site which is not attached to any bank account, upon payment of that invoice, money should go to default Supplier level bank account.
But, for a bank account at supplier level the corresponding value of column supplier_site_i d will be NULL in table iby_external_pa yees_all table. Now, how could I join an invoice which have a definite vendor_site_id to a Bank account having supplier_site_i d as NULL in table iby_external_pa yees_all.
I am attaching my query herewith.
SELECT substr(v.NUM_10 99,3, ,
UPPER(substr(V .VENDOR_NAME,1, 30)) ,
ia.INVOICE_NUM ,
TO_CHAR(ch.che ck_date,'YYYYMM DD') ,
LPAD(TO_CHAR(i p.AMOUNT*100),1 1) ,
ieb.bank_accou nt_type ,
DECODE(ieb.ban k_account_type, '1', '000', '2', '000', cbbv.branch_num ber),
substr(ieb.ban k_account_num,1 ,3)||DECODE(ieb .bank_account_t ype,'1','','2', '0','3','0')||s ubstr(ieb.bank_ account_num,5,l ength(ieb.bank_ account_num)) ,
' ' FLAG ,
' ' FLAG1,
DECODE(v.num_1 099,'20913339', '20209133394',s ubstr(v.num_109 9,1,11))
FROM
hz_party_sites hps
,apps.iby_external_pa yees_all iep
,apps.iby_pmt_ instr_uses_all ipi
,apps.iby_ext_ bank_accounts ieb
,apps.ce_bank_ branches_v cbbv
,ap_invoice_pa yments_all ip
,ap_checks_all ch
,ap_invoices_a ll ia
,Po_vendors v
,po_vendor_sit es_all vs
WHERE
ieb.branch_id =cbbv.branch_pa rty_id
AND ieb.bank_id = cbbv.bank_party _id
AND ieb.ext_bank_ac count_id = ipi.instrument_ id
AND ipi.ext_pmt_par ty_id = iep.ext_payee_i d
AND cbbv.branch_par ty_id = hps.party_id (+)
--AND iep.supplier_site_i d = vs.vendor_site_ id
AND iep.supplier_site_i d vs.vendor_site_ id
AND iep.supplier_site_i d IS NULL
AND iep.payee_party _id = v.party_id
AND ip.CHECK_ID = ch.CHECK_ID
AND ip.INVOICE_ID = ia.INVOICE_ID
AND ch.VENDOR_ID = v.VENDOR_ID
AND ia.VENDOR_ID = vs.VENDOR_ID
AND ia.VENDOR_SITE_ ID = vs.VENDOR_SITE_ ID
AND ch.AMOUNT > 0
AND ch.CHECKRUN_NAM E = '&1'
AND trunc(SYSDATE) BETWEEN nvl(ipi.start_d ate,SYSDATE-1) AND nvl(ipi.end_dat e,SYSDATE+1)
Th anx in advance
I have one quick question, Like i want to use BAM in my current project to generate reports.
So May i know in detail like: How to install BAM, what are the basic steps we need to follow before install.
Than ks
Uma
I have seen lot of your post, your ideas and solutions are impeccable. I am in need of your help. We have a requirement in which an existing OAF page need to be customized. An additional feature for downloading a file need to be introduced.My question is , whether we need to extend AM,VO for this or simple modification of page ie enough, expecting your reply :)
First i want to thank you for the information and help that you have provided.
Now i have a query.We are using Oracle E Business suite's Product Life Cycle Management application.
I need to extend the controller so that i can validate a attribute in one attribute group based on a attribute in another attribute group.
Now i used the following code,
OAApplicationMo dule oaapplicationmo dule1 = oapagecontext.g etRootApplicati onModule();
OAApplicationMo dule oaapplicationmo dule2 = EgoExtFwkUtil.findNestedAM(oaapplicationmo dule1, "EgoExtFwkAM");
OAViewObjectImp l vo = (OAViewObjectImp l)oaapplicationmo dule2.findViewObject("EGO_ITEMMGMT_GROUP431ATTRNAME");
Row row = vo.first();
System.out.prin tln("Value - " + row.getAttribut e("CExtAttr1")) ;
This code prints the value which is available while rendering the page and not the value modified before submitting the page.
Please suggest the VO to get the new or modified values.
Thanks .
please help me how to upload customer data in oracle apps r12 wiht the help of interface and which data fillup in the below table colums .my mail id:- de.sanjit
1>RA_CUSTOMER S_INTERFACE_ALL (ORIG_SYSTEM_CU STOMER_REF,SITE _USE_CODE ,CUSTOMER_NUMBE R ,CUSTOMER_NAME ,CUSTOMER_STATU S,INSERT_UPDATE _FLAG ,ORIG_SYSTEM_AD DRESS_REF,PRIMA RY_SITE_USE_FLA G,ADDRESS1,COUN TRY ,LOCATION)
2>RA _CUSTOMER_PROFI LES_INT_ALL(CUS TOMER_PROFILE_C LASS_NAME,ORIG_ SYSTEM_CUSTOMER _REF,NSERT_UPDA TE_FLAG,CREDIT_ HOLD,ORIG_SYSTE M_ADDRESS_REF)
3>RA_CONTACT_PH ONES_INT_ALL (ORIG_SYSTEM_CU STOMER_REF,ORIG _SYSTEM_TELEPHO NE_REF,TELEPHON E,TELEPHONE_TYP E,INSERT_UPDATE _FLAG,ORIG_SYST EM_ADDRESS_REF, ORIG_SYSTEM_CON TACT_REF,CONTAC T_LAST_NAME)
4> RA_CUSTOMER_BAN KS_INT_ALL(ORIG _SYSTEM_CUSTOME R_REF,PRIMARY_F LAG,START_DATE, BANK_ACCOUNT_NA ME,BANK_ACCOUNT _CURRENCY_CODE, BANK_ACCOUNT_NU M,BANK_BRANCH_N AME,ORIG_SYSTEM _ADDRESS_REF)
5 >RA_CUST_PAY_ME THOD_INT_ALL(OR IG_SYSTEM_CUSTO MER_REF,START_D ATE,ORIG_SYSTEM _ADDRESS_REF,PR IMARY_FLAG,PAYM ENT_METHOD_NAME )
We are R12.0.6 - and our users love using spaces (trailing & leading) in the invoice numbers. Would it be possible to add personalization that would either clear the spaces or prevent them from being captured?
i am new to apps pls forward some material about modules in technical consultant point of u
first thanks for helping....
I am a trainee in oracle.i have started from D2K part.i hace completed my PL/SQL part.now i am moving on report builder.Could you please tell from where can read good report article and start on it
Thanks with Regards
Jitende r Kumar
general expenses
sellin g and distributions
m arketing expenses
staff cost
financial expenses
depric iation
others
p lease send me to my mail-binayb30
we are upgraded the 11.5.10.2 to R12, in our 11i custom self service report(payslip) its working fine using SSWA jsp function and oracleOasis.jsp function..
but the same report in R12 its not working, If I click the report, 'page cannot be displayed' ,,please help to me..
trigger fires exactly on the event but the message i am expecting isn't there. it gives me something like this ..
Error Page
You have encountered an unexpected error. Please contact the System Administrator for assistance.
Cli ck here for exception details.
so i want to know why i m not getting the expected error ?
i am new to apps pls forward some material about modules in technical consultant point of u
i have a problem in oracle EBS in calling a stored procedure in a form personnalizatio n
this is the call:
='DECLARE
X varchar2(50);
BEGIN
topnet_send_mai l('''||${item.c c_entries.subin ventory.value}| |''',
''f.topnet
''Comptages inventaire tournant.'',
''Le comptage a été effectué avec succès.'',
''smtp.topnet.t n'');
END' it works but the problem in the place of ''Le comptage a été effectué avec succès" in the call of the procedure i should concatinate a field recuperated and a text like this: '' inventaire'''|| ${item.cc_heade r2.cycle_count_ header_name.val ue}||''' please how can i concatinate them ?
I'm kinda paranoid about losing everything I've worked hard on. Any tips?
shout out and say I truly enjoy reading your blog posts. Can you recommend any other blogs/websites/ forums that go over
the same subjects? Many thanks!
get in fact loved account your blog posts. Anyway I will
be subscribing in your feeds or even I success you access persistently quickly.
I needs to spend some time learning much more or understanding more.
Thanks for fantastic info I was looking for this info
for my mission.
was wondering if you knew where I could find a captcha plugin for my comment form?
I'm using the same blog platform as yours
and I'm having problems finding one? Thanks a lot!
for a blog site? The account aided me a acceptable deal.
I had been a little bit acquainted of this your broadcast provided bright
clear concept
out your blog on my iphone during lunch break. I enjoy the info
you present here and can't wait to take a look when I get home.
I'm surprised at how fast your blog loaded on my phone ..
I'm not even using WIFI, just 3G .. Anyways,
very good blog!
but this web site gives quality based posts.
subject and didn't know who to ask.
after looking at many of the posts I realized it's new to me.
Nonetheless, I'm definitely happy I came across it and I'll be book-marking it and checking back regularly!
as I provide credit and sources back to your webpage?
My website is in the very same niche as yours and my visitors
would genuinely benefit from some of the information you present here.
Please let me know if this ok with you. Thank you!
pay a visit this web page and be up to date everyday.
Keep up the good work! You understand, a lot of people are looking around for this information, you can aid them greatly.
Thanks
a la persona. Gracias a los teléfonos móviles podemos hacer fotos en cualquier
momento y por supuesto tener guardados esos recuerdos en nuestro bolsillo.
Es un sistema en el cual se imprimen directamente la imagen sobre el Aluminio Dibond,
con un acabado casi tan bueno como el fotográfico gracias a la evolución de las máquinas de impresión UV con las que se consigue cada vez
mejores efectos y la mejor calidad, mediante este método
podemos ofrecer un excelente producto a un coste muy competitivo pues requiere menos
tiempo en su preparación y nos ahorra imprimir la fotografía y posteriormente adhesivarla.
Las ideas originales para regalar de nuestra web cuentan con una amplia variedad de precios, desde las ideas más baratas a regalos informáticos o electrónicos como impresoras 3d de precios más
elevados, el gasto dependerá de ti y lo que desees comprar.
Hay tantos detalles y regalos que puedes encontrar en nuestra web que no vas
a saber por dónde empezar. Busca entre nuestras secciones
para encontrar lo que necesitas, en cuanto entres en la sección adecuada verás que
tenemos los regalos baratos para regalar a esa persona.
además de siete colores LED con control manual y automático.
Este estuche de Viña Arnáiz está formado por tres botellas con D.O.
Ribera del Duero -Reserva, Crianza y Roble- presentadas en un estuche de madera.
Son perfectos para la habitación del bebé, un regalo original
totalmente personalizado. Los altavoces que llevan son acolchados, planos y se conectan por bluetooth.
Desde tazas originales y divertidas a cafeteras
o lavadoras portátiles que podemos llevar de viajes.
Podemos usarla tanto para ir al gimnasio o hacer deporte, con un look informal
o para estar en casa y teletrabajar. Si no paras de darle
vueltas porque no sabes que regalar a tu pareja, también podemos ayudarte,
contamos con una selección de regalos para novio y regalos originales para mujer que harán las delicias de los sorprendidos.
En cuanto a su longitud, viene precortada en dos tiras de 50 centímetros y dos de 60 centímetros, que son las dimensiones
que vas a necesitar para colocarlas en la
parte trasera de tu televisión o monitor. Cada vez más gente las utiliza para llenar de luz
sus terrazas, crear atmósferas acogedoras en su salón o incluso retroiluminar la televisión para reducir la
fatiga visual en los largos maratones de series y películas que están propiciando los
confinamientos.
Thanks a lot and I am having a look ahead to contact you.
Will you kindly drop me a e-mail?
long) so I guess I'll just sum it up what
I had written and say, I'm thoroughly enjoying your blog.
I as well am an aspiring blog writer but I'm still new to the whole thing.
Do you have any tips for novice blog writers? I'd certainly
appreciate it.
knew where I could locate a captcha plugin for my comment form?
I'm using the same blog platform as yours and I'm having
difficulty finding one? Thanks a lot!
text in your article seem to be running off the screen in Safari.
I'm not sure if this is a format issue or something to do
with web browser compatibility but I thought I'd post to let you know.
The layout look great though! Hope you get the problem fixed
soon. Many thanks
posts. Anyway I will be subscribing for your feeds and even I fulfillment you get entry to consistently rapidly.
I am sending it to some buddies ans additionally sharing in delicious.
And certainly, thanks to your effort!
a aplica la dispozitie canale romanesti HD, Full HD si
4K. Totodata posibilitatea testarii gratuite pana la 24 de ore.
Acesta este cel mai mare număr de canale HD oferit de un operator TV pe
piața din România. Program Tv azi, posturi TV: platformă tv România TV.
Poţi viziona posturi care nu se regăsesc decât în grila unor anumiţi furnizori (precum GSP TV
sau Eurosport 2) ori poţi viziona HBO, orar pentru care în mod
normal trebuie să plăteşti suplimentar. Pentru a viziona un platformă tv online surpriză
pe site selectati categoria careia ii apartine si faceti
click pe numele postului tv onlinePot exista perioade de etate cand anumite programe tv online sa nu emita live pe internet.
După ce ați făcut acest lucru, accesați
fila TV a TV Wave, dați click pe select an option și alegeți din listă opțiunea load custom list.
Nu este nevoie să încărcați lista posturilor TV de fiecare dată când porniți programul, canalele din lista custom va fi adăugată în mod automat în lista celor preferate.
Motorul HH va răsuci automat antena pe satelitul selecţionat din telecomanda receptorului.
y hawaiana de este tipo de casamientos; los contrayentes depositaron lentamente sus respectivas arenas rosa para Maricruz y azul para Jesús, a los
acordes de los "Recuerdos de la Alhambra" fundidos con unas palabras del
oficiante escritas expresamente para ese momento. De allí que se representaran figuras formadas por los fuegos artificiales del ferrocarril Qinghai-Tíbet y la
nave espacial Shenzhou. La tarde del lunes se celebró una
misa de cuerpo presente que estuvo acompañada de
Mariachi. También se usaron palabras del bioquímico francés y Premio Nobel Jacques Monod y del astrofísico Stephen Hawking, y siendo leonesa la novia no faltaron algunas estrofas de su
paisano Amancio Prada. Aunque puede hacerlo en silencio, o durante una lectura o una canción, considere que su oficiante diga algunas palabras.
Todos iban a una boda civil dispuestos a encontrarse con lo de siempre.
Cada vez es más habitual ver la ceremonia de la arena en la renovación de votos matrimoniales
o en aniversarios de boda. Ésta ceremonia tiene dos significados, uno filosófico y otro simbólico, y es tan antigua, que
se han encontrado recipientes de más de cinco mil años de antigüedad,
con la arena de dos lugares distantes a más de 500 kilómetros, y simbolizaban la unión de una pareja, cuyos
novios provenían de reinos o tribus lejanas, que se unían en matrimonio, e iniciaban una
nueva y fecunda relación como un sólo pueblo, más
grande, con mayores recursos, territorios y cosechas.
now each time a comment is added I recieve four emails with the exact same comment.
Is there a means you are able to remove me from that service?
Many thanks!
topic of from this article.
and post is in fact fruitful for me, keep up posting such articles or reviews.
had been conducting a little homework on this. And he actually ordered me dinner due to the fact that I discovered it for
him... lol. So allow me to reword this.... Thank YOU for the meal!!
But yeah, thanx for spending the time to discuss this subject here on your blog.
the blogger lovers but this post is genuinely a fastidious post,
keep it up.
is really a nice post, keep it up.
Did you make this amazing site yourself? Please reply back as I'm wanting to create my very own blog and would love to know where you got this from or exactly what the theme is called.
Many thanks!
vizionarea TV, funcționează printru intermediul listelor de canale
în format m3u, un fișier care va oferi utilizatorilor indicații pentru transmisiile în direct.
WisePlay este un player video capabil de citească listele m3U, pentru a-l uza
trebuie doar şi copiați o adresă URL și şi o lipiți pentru a afișa lista de canale.
Germania și despre preschimbarea acestuia cu un permis german. Utilizând suplimentele
veți a îngriji canale gratuite și cu plată în orice
moment în terminalul dvs. și la rândul lui, din acesta.
Decizia va învinge în vigoare până când Rusia va înceta războiul în Ucraina
şi se va scoate de pe teritoriul ucrainean, inclusiv din Crimeea.
Astăzi vă prezentăm cele mai bune aplicații pentru a viziona canale
cu plată 100% gratuite cu care de poți a se socoti orice specie de conținut,
inclusiv oareşicine dintre lucrurile care se consumă astăzi, care este
sportul în general. A devenit de mult durată un centru multimedia perfect atunci când
vine vorba de redarea oricărui soi de conținut,
inclusiv liste de descriere externe.
Exploring in Yahoo I finally stumbled upon this web site.
Studying this info So i am satisfied to express that
I have an incredibly just right uncanny feeling I discovered just what I needed.
I so much definitely will make certain to don?t forget this site and give it a glance on a constant basis.
The clarity on your submit is simply nice and that
i can think you are knowledgeable in this subject. Well with your permission allow
me to grab your RSS feed to keep updated with drawing close post.
Thank you one million and please keep up the gratifying work.
you by mistake, while I was researching on Digg for something else, Anyhow I am here now and would just like to
say thanks for a fantastic post and a all round entertaining blog (I also love the theme/design),
I don’t have time to go through it all at the minute but
I have saved it and also added your RSS feeds, so when I have time I will be back to read more, Please do keep up the superb work.
days, but I by no means found any attention-grabb ing article like
yours. It is beautiful price sufficient for me. In my opinion, if all web owners and bloggers made good content as you probably did, the web shall be much more useful than ever before.
friends. I'm confident they'll be benefited from this web site.
my presentation topic, which i am going to deliver in institution of higher education.
and in accession capital to say that I get actually loved
account your weblog posts. Any way I will be subscribing for your augment and even I achievement you get right of entry to constantly rapidly.
Look advanced to more added agreeable from you!
However, how can we communicate?
RSS feed for comments to this post