We are in R12.1.3
We created a custom Integrator to load data into the Project standard interface table - PA_TRANSACTION_INTERFACE_ALL
We have defined a PL/SQL package (as a pre-importer). The input parameters to this package is derived from the data uploaded. We have defined the input parameter as -
data type - varchar2
access - IN
Error Message - Not checked
Default Value - Null
Source - Import
Value - PA_TRANSACTION_INTERFACE_ALL.ORIG_EXP_TXN_REFERENCE1
Lookup - Null
Modifier Clause - Null
We are inserting data into the Column - ORIG_EXP_TXN_REFERENCE1 from the Excel Template
We see that the PL/SQL Package is not executed. However, if we pass a Default Value (a hard coded value), the PL/SQL package is executed.
We request some help here. Is it a known issue. Should i raise an SR as i feel it is a bug.
I had defined a Pre-Importer (with a custom PL/SQL API) and a Importer (with a standard PL/SQL Project Cost Import package - )
My first issue is not resolved yet which is - Passing of the input value to the custom PL/SQL package API PRE-IMPORTER from the Source (Import) and Value (PA_TRANSACTION_INTERFACE_ALL.ORIG_EXP_TXN_REFERENCE1). My Interface is the table - PA_TRANSACTION_INTERFACE_ALL and value is passed into the Column, ORIG_EXP_TXN_REFERNCE1 from the Web ADI Excel. However the value is present for this column from the Interface table.
My second issue of passing input variable to the IMPORTER is resolved. I defined the PA_TRANSACTION_INTERFAE_ALL.TRANSACTION_SOURCE as a Group Variable. The IMPORTER is a standard Project Cost Import Packge. Initially the value from this column was one of the input variable to the IMPORTER standard PL/SQL package and value from this column was not flowing. Post defining it as a Group Variable, values are passed and the package executed successfully.
Do you have any questions
As i mentioned above, PA_TRANSACTION_INTERFACE_ALL.ORIG_EXP_TXN_REFERENCE1 is an input to the Pre-Importer PL/SQL API as Source (Import) and Value from table column.
I defined ORIG_EXP_TXN_REFERENCE1 as a Group Definition attribute which made it appear in the table - BNE_PARAM_LIST_ITEMS.
Post it I ran the Integrator again and it worked fine for me. Now the Pre-Imported PL/SQL API is working fine.
But it is WRONG to define a attribute in Group Definition to enable my Pre-Importer PL/SQL api to work. It is a Oracle issue i thinkl