Add data into both the Master and Detail tables in as single submit?

Should be do-able in a 2-step process.

1. Automatic DML returns PO_ID to a hidden Item.
2. IG DML process takes in that hidden item also

MK

For the first process:  Just fill out the Process as like the image (with appropriate name changes)

You should then be able to use the value in the item (P3_EMPNO in example) within your IG DML process step.

MK

OBIEE-N-Co,

First you will create the order master then return the order master id place into another item then the details  will need to created by the order master......

As like.....

insert into TRD_ORDER ( 

        PID_CLIENT_REG,

        ORDER_DATE,

        DELIVERY_DATE,

        ORDER_ID,

        ORDER_TYPE,

        REF_NO,

        PID_BRANCH,

        PID_PROJECT,

        PID_EMPLOYEE_RESPONSIBLE,

        PID_EMP_ENTRY_BY,      

        PID_ORG

        )

        values (

        :P413_PID_CLIENT_REG,

        to_date(:P413_TRANSACTION_DATE,'dd/mm/yyyy hh24:mi'),

        to_date(:P413_DELIVERY_DATE,'dd/mm/yyyy hh24:mi'),

        (select nvl(max(TRANSACTION_ID),0)+1 from TRD_TRANSACTION_MASTER ),

        :P413_TRANSACTION_TYPE,

        :P413_PHYSICAL_REF_NO,

        :P413_PID_BRANCH,

        :P413_PID_PROJECT,

        (select PID_EMPLOYEE from TRD_CLIENT_REG_INFO where pid=:P413_PID_CLIENT_REG),

        :G_PID_EMPLOYEE,    

        :G_PID_ORG)

        returning pid into v_pid_master;

        :P413_PID := v_pid_master;

    end;

Sanjay Sikder

There is a 99.55% chance that those last few lines (WHEN OTHERS THEN NULL) are a bug in your code.

Please edit them out or please add detailed comments why it is logically valid for your example code to ignore ORA-600,ORA-1653, etc. when they come up.

MK