Below is the function to get current operating unit Timezone. FUNCTION convert_to_ou_tz(p_date DATE, p_org_id NUMBER DEFAULT fnd_global.org_id) RETURN DATE IS l_timezone VARCHAR2(50); l_new_date DATE; BEGIN SELECT attribute8 INTO l_timezone FROM…
Read MoreBelow is the command we can use filler in XML Publisher Data Template. <?xml version=”1.0″ encoding=”UTF-8″?> <xapi:requestset xmlns:xapi=”http://xmlns.oracle.com/oxp/xapi” type=”bursting”> <xapi:request select=”/METADATA/ROWSET/ROW”> <xapi:delivery> <xapi:email server=”XXXXXXX” port=”XX” from=”DoNotReply@XXXXXX.com” reply-to=”DoNotReply@XXXXXX.com”> <xapi:message id=”email1″ to=”${TO_MAIL}”…
Read MoreBelow is the document you can download for IFSC Code. oaf-pesonalization-for-ifsc-code-in-supplier-screen
Read MoreJAD is one of the tool for getting source code the java classes.
Read MoreYou can find correct jdeveloper version using following link. https://support.oracle.com/portal/ Search as Jdev with OA Extension.
Read MoreBy using following tag we can remove entire column in RTF. <?if@column:ORG_ID!=XXX?>Sales Order/Cust PO<?end if?>
Read MoreBelow is the standard API to update sales order deliver to information based on shipment method. Shipment method & deliver to information are maintaining in custom table. oe_order_pub.Process_Order is the…
Read MoreBased on the condition we need to disable message choice in CO. OAMessageChoiceBean DispButtonValue = (OAMessageChoiceBean)webBean.findChildRecursive(“Disposition”); String DispValue = DispButtonValue.getText(pageContext); if (DispValue != null) { DispButtonValue.setDisabled(true); pageContext.writeDiagnostics(DispValue, “DispValue——>!!!!!!> = “,…
Read MoreWhen we do import, sometimes we are facing error as Exception in thread “main” java.lang.NoClassDefFoundError: Then you need to change jpximport.bat and import.bat files as below. Path —> \jdeveloper\jdevbin\oaext\bin You…
Read MoreAs root user in Target Node: Step 1 : /usr/local/avamar/bin/avtar –backups –flagfile=/var/avamar/scripts/my-avtar-flags.txt Make a note of recent Seq in our case it is 124980 . Step 2 : /usr/local/avamar/bin/avtar –list –sequencenumber=124980 –flagfile=/var/avamar/scripts/my-avtar-flags.txt Get the control file name using above command. In our case “11g/PROD/CONTROLFILE.PROD.c-193295451-20170128-00” As Oracle user in Target Node: Step 3 : Step 4 : Create a pfile with db_name=PROD. Step 5 : Start the database in nomount. SQL> startup nomount pfile=’initPROD.ora’; Step 6 : Connect Rman and execute below command RMAN > set DBID=193295451; run{ allocate channel c0 type sbt PARMS=”SBT_LIBRARY=/usr/local/avamar/lib/libobk_avamar64.so” format ‘%d_%U’; send ‘”–prefix=11g/PROD/” “–flagfile=/var/avamar/scripts/my-avtar-flags.txt” “–bindir=/usr/local/avamar/bin” “–sysdir=/usr/local/avamar/etc”‘; restore controlfile from ‘CONTROLFILE.PROD.c-193295451-20170128-00’; } #### Control file taken from step 2. Step 7 : SQL> alter database mount; Step 8: RMAN> list backup; Take recent LOW SCN number. 181267677438…
Read More