Thursday, July 23, 2015

Deployment changes from 12.2 onwards

Please refer to:
1.Oracle® E-Business Suite Developer's Guide Release 12.2 (Part No. E22961-09)
2.Deploying Customizations in Oracle E-Business Suite Release 12.2 (MOS Doc ID 1577661.1)
3.Using the Online Patching Readiness Report in Oracle E-Business Suite Release 12.2 (MOS Doc ID 1531121.1)
4.Oracle E-Business Suite Release 12.2: Online Patching FAQ (MOS Doc ID 1583902.1)

Edition based Redefination ( EBR) - Run Edition and Patch Edition

EBR in DB: Editionable objects are synonym, views and all plsql objects.
In Linux:
echo $FILE_EDITION
 In DB:
select ad_zd.GET_EDITION_TYPE,
ad_zd.GET_EDITION
from dual;

How to set your Edition?
OS:
source /oracle/ebs122/EBSapps.env run or
source /oracle/ebs122/EBSapps.env patch
echo $RUN_BASE - the run filesystem
echo $PATCH_BASE - the patch filesystem
DB:
ad_zd.SET_EDITION(‘RUN’)
or
ad_zd.SET_EDITION(‘PATCH’)

Check Edition Status:
•How to check the status of patching
•In the OS:
adop –status
•From the DB:
sqlplus apps @ADZDSHOWED.sql

EBR and Data:
•Table Data is maintained through triggers
•Seed Data is handled by striping it with an Edition column









Oracle MAF (Mobile Application Framework)

Need to install Jdeveloper 12c.

http://multikoop.blogspot.in/2014/07/adf-mobile-rebrands-to-oracle-maf.html
http://www.oracle.com/technetwork/developer-tools/maf/overview/index.html
http://download.oracle.com/otn_hosted_doc/maf/academy/DevelopingApplicationsWithMAF/presentation.html


Develop your own free IM(Instant Messaging) tool for your website or organization

Openfire server --> Install this at linux server. This is open source and written in java. This uses XMPP (Extensible Messaging and Presence Protocal)

Spark client --> Clients should install this at their local machines

http://www.tecmint.com/create-your-own-instant-messagingchat-server-using-openfire-in-linux/

We can also integrate IM(XMPP) with Oracle Apex. Please check below

https://technology.amis.nl/2012/10/01/how-to-build-an-im-xmpp-solution-with-oracle-apex-and-websockets/

Wednesday, May 27, 2015

Useful scripts

--Script to reset password of application user with APPS password
declare
v_user_name varchar2(30):=upper('&Enter_User_Name');
v_new_password varchar2(30):='&Enter_New_Password';
v_status boolean;
begin
v_status:= fnd_user_pkg.ChangePassword (
    username => v_user_name,
    newpassword => v_new_password
);
if v_status =true then
dbms_output.put_line ('The password reset successfully for the User:'||v_user_name);
commit;
else
DBMS_OUTPUT.put_line ('Unable to reset password due to'||SQLCODE||' '||SUBSTR(SQLERRM, 1, 100));
rollback;
END if;
end;
 List of responsibilities a application user has
------------------------------------------------------------------ ------------------------------------------------------------------
SELECT frt.RESPONSIBILITY_NAME, furg.end_date
FROM
fnd_user_resp_groups fur,
FND_RESPONSIBILITY fr,
fnd_responsibility_tl frt,
fnd_user fu
WHERE fu.user_name = '&username'
AND fu.user_id = fur.user_id
AND furg.responsibility_id = fr.RESPONSIBILITY_ID
AND frt.responsibility_id = fr.RESPONSIBILITY_ID
ORDER BY 1

 How to activate user by setting end_date as Null

 ----------------------------------------------------------------- ------------------------------------------------------------------

DECLARE
   CURSOR usercur
   IS
      SELECT fu.user_name
        FROM apps.fnd_user fu
       WHERE user_name = 'TEST_ACCOUNT';
BEGIN

   FOR myuser IN usercur
   LOOP
      fnd_user_pkg.updateuser(
         x_user_name      => myuser.user_name
       , x_owner          => 'CUST'

        ---- This is 1/2/4712. Oracle keeps end date as null
        , x_end_date       =>  to_date('2', 'J')
      );
   END LOOP;

END;

Saturday, January 10, 2015

How to resolve ORA-22288 ORA-06512 File or LOB operation GETLENGTH failed

ORA-22288: file or LOB operation GETLENGTH failed
No such file or directory
ORA-06512: at "SYS.DBMS_LOB", line 850
ORA-06512: at line 99
22288. 00000 -  "file or LOB operation %s failed\n%s"
*Cause:    The operation attempted on the file or LOB failed.
*Action:   See the next error message in the error stack for more detailed
           information.  Also, verify that the file or LOB exists and that
           the necessary privileges are set for the specified operation. If
           the error still persists, report the error to the DBA.

Solution: Make sure you uploaded file into proper DB Server.

Thursday, December 4, 2014

How to remove Oracle OAF VO Substitution

Oracle OAF Substitution basically creates personalization for example if I do VO substitution on oracle.apps.pos.request.server.SupplierRequestsVO with xxus.oracle.apps.pos.request.server.xxSupplierRequestsVO

After I do jpx import, it creates below personalization
     /oracle/apps/pos/request/server/customizations/site/0/xxSupplierRequestsVO

So If you want to remove VO Substitution, we have to remove above personalization either using 'Functional Administrator' or using below

begin
   jdr_utils.deletedocument('/oracle/apps/pos/request/server/customizations/site/0/xxSupplierRequestsVO');
   commit;//this is important :)
end;

Happy Substitution. :)

Thursday, November 6, 2014

Order of sub ledgers closing

It must be Payables, Purchasing, Inventory, Receivables and then Fixed assets

Wednesday, October 29, 2014

Switzerland Tax Registration number logic from Jan 1st 2014

SELECT  DECODE(
        ceil(((REGEXP_SUBSTR(num,'[0-9]',1,1))*5+
                         (REGEXP_SUBSTR(num,'[0-9]',1,2))*4+
                         (REGEXP_SUBSTR(num,'[0-9]',1,3))*3+
                         (REGEXP_SUBSTR(num,'[0-9]',1,4))*2+
                         (REGEXP_SUBSTR(num,'[0-9]',1,5))*7+
                         (REGEXP_SUBSTR(num,'[0-9]',1,6))*6+
                         (REGEXP_SUBSTR(num,'[0-9]',1,7))*5+
                         (REGEXP_SUBSTR(num,'[0-9]',1,8))*4
                        )/11) * 11 -
                   ((REGEXP_SUBSTR(num,'[0-9]',1,1))*5+
                    (REGEXP_SUBSTR(num,'[0-9]',1,2))*4+
                    (REGEXP_SUBSTR(num,'[0-9]',1,3))*3+
                    (REGEXP_SUBSTR(num,'[0-9]',1,4))*2+
                    (REGEXP_SUBSTR(num,'[0-9]',1,5))*7+
                    (REGEXP_SUBSTR(num,'[0-9]',1,6))*6+
                    (REGEXP_SUBSTR(num,'[0-9]',1,7))*5+
                    (REGEXP_SUBSTR(num,'[0-9]',1,8))*4),
                   10,'INVALID',
                   (REGEXP_SUBSTR(num,'[0-9]',1,9)),'VALID',
                   'INVALID'
                   ) FINAL_RESULT
    --INTO l_result
    FROM (SELECT
            REGEXP_SUBSTR(REPLACE(REGEXP_SUBSTR(:p_trn_value,'^(CHE-[0-9]{3}.[0-9]{3}.[0-9]{3}) (MWST|TVA|IVA)$'),'.',''),'[0-9]+') NUM
          FROM DUAL
         );

Sample value is CHE-456.456.791 MWST 

In words, the ninth digit should be equal to  upper round(digit1*5+digit2*4+digit3*3+digit4*2+digit5*7+digit6*6+digit7*5+digit8*4)/11*11-(digit1*5+digit2*4+digit3*3+digit4*2+digit5*7+digit6*6+digit7*5+digit8*4)

That's it. Nice logic right :). It will be different for different countries.

Wednesday, October 15, 2014

Oracle Fusion Applications

Hardware requirements



http://www.oratraining.com/blog/2013/09/fusion-applications-financials-virtual-machine-available-now/





Install steps below

http://www.oratraining.com/blog/2014/04/oracle-fusion-applications-installation-step-by-step-guide-11-1-8/