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.

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. :)

Order of sub ledgers closing

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

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.

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/