ORG_ID NUMBER(15) DEFAULT TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1),' ',NULL,SUBSTRB(USER

 Hello,

We are upgrading the applications from 11.5.10 to R12(12.1.3) and in many tables the org_id is extracted based on the user environment variable CLIENT_INFO  as shown below

CREATE TABLE XX_ORDER_DETAILS(
ORDER_NUMBER        NUMBER,
CUSTOMER_ID            NUMBER,
ADDRESS1                 VARCHAR2(100),
ADDRESS2                 VARCHAR2(100),
POSTAL_CODE          VARCHAR2(100),
COUNTRY                  VARCHAR2(100),
ORG_ID                      NUMBER(15)   DEFAULT TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1),' ',NULL,SUBSTRB(USERENV('CLIENT_INFO'),1,10)))
)

In R12, how to extract the value for CLIENT_INFO value or what can be done to the above table.

In anyone has encountered this scenario, could you please share.

Best  Regards
Syed Hussain