We can not add new dataload parameter in BIACM console.But if we add in back end tables that will be reflected in BIACM.
We can achieve it from the backend, by inserting into
BIACOMP schema tables. But, please note that Oracle would not support such
customisations as it is beyond the scope of product.
In Our project we had a requirement of micro etl load where we wanted a
parameter to be introduced in BIACM. But there is no option to add from
front end. So, we had tried the below POC.
On same lines, it is possible to add additional parameters and associate
them with JDE source. The below example is with respect to EBS.
Note: Although below solution worked, we did not follow this approach
for implementing micro ETL as it was not recommended by Oracle. So, we had to
come up with alternate approach using custom tables in WH schema.
1.
Introduce new parameter MICRO in BIACM. This is done by manually inserting a
record in C_PARAM, C_PARAM_DW_VAL and C_PARAM_DW_VAL_AUDIT tables in
BIACOMP schema.
2. We
need to associate this parameter with EBS R 12.1.3
3. The
scope should be global
4. Any
load plan created with EBS R 12.1.3 as source will list MICRO as one of the
data load parameters.
5.
This value is editable. Default is set to ‘N’.
6. In
ODI, a new variable IS_MICRO can be created with refresh query as
getcmparam('MICRO','#DATASOURCE_NUM_ID') . This will help in fetching the value
for MICRO from BIACM.
No comments:
Post a Comment