Follow us: Connect on YouTube Connect on YouTube Connect on YouTube

Pages

Tuesday, 10 May 2016

Query to To check if multi-org is setup

The relevant query is as follows:

Select multi_org_flag from FND_PRODUCT_GROUPS;
Share this article :

3 comments:

  1. Hello There,


    Your writing shines! There is no room for gibberish here clearly you have explained about Query to To check if multi-org is setup. Keep writing!

    My name is Donal and I'm new to the site so just wanted to introduce myself and say hi and post my first question so let me know if I am making any stupid mistakes as I may be a bit green on how this works!

    Basically I have data stored in a 2 fields as follows:
    Org_ Parent
    Org_child
    The Org_Parent field is repeated with the same value 3 times but the org_child has 3 separate values. I need a query that will represent the data in a flat format .i.e. in 4 separate fields as follows:

    cost centre(org_parent field):
    Sub-Division(first value in org_child field): will always start with a 6 digit number
    Division(second value in org_child field): will always start with a 4 digit number ending with 2 zeros
    Branch(third value in org_child field): will always start with a 4 digit number ending with 3 zeros

    See attached excel spread sheet for how data currently looks and how it should look after the query

    Follow my new blog if you interested in just tag along me in any social media platforms!


    Best Regards,
    Renina

    ReplyDelete
  2. Halo,


    Fully agree on #topic. We’re seeing a lot of projects tackle big complex problems but few seem to have taken into consideration and in particular reasons to adopt.

    My table column type is clob. Field value contain double quotes

    id,text_clob,date

    1,"\"data1\",0,1,1,1,\"data2\"","2018-03-03 09:08:45"

    can you kindly help loader query. i cant use replace in clob field.

    It was cool to see your article pop up in my google search for the process yesterday. Great Guide.
    Keep up the good work!



    Thank you,

    morgan

    ReplyDelete

  3. Hi There,

    Thanks for highlighting this and indicating about Query to To check if multi-org is setup where more study and thought is necessary.

    I have some statements that I need to schedule in a procedure.

    Drop Table u_system.emp_load;
    CREATE TABLE u_system.emp_load
    (employee_number CHAR(5),
    employee_atten_time TIMESTAMP,
    machine_number CHAR(3),
    in_out CHAR(2)
    )
    ORGANIZATION EXTERNAL
    (TYPE ORACLE_LOADER
    DEFAULT DIRECTORY user_dir
    ACCESS PARAMETERS
    (RECORDS DELIMITED BY NEWLINE
    FIELDS (employee_number CHAR(4),
    employee_atten_time CHAR(20) date_format TIMESTAMP mask "dd/mm/yyyy hh24:mi:ss",
    machine_number CHAR(4),
    in_out CHAR(1)
    )
    )
    LOCATION ('emp2.dat')
    );
    insert into u_system.emp_attend(employee_number,employee_atten_time,machine_number,in_out)
    select * from u_system.emp_load;

    Follow my new blog if you interested in just tag along me in any social media platforms!

    Thanks,
    Preethi

    ReplyDelete