Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Oracle Apex Data Load Table Transformation Rule

Balaji MadhavanDec 12 2018 — edited Dec 12 2018

I have an excel sheet with me and i have a function fn_ex(p_1,p_2) with me this function is used to insert the data into the third column , those 2 parameters are 1st and 2nd column from excel.

If i directly use the column name it is asking me to declare those columns. how can i do this ?? please find my attachment

pastedImage_3.png

pastedImage_4.png

Thanks in advance

Comments

I moved this to the ODI forum....

User_9AGUD

Someone has comment on this. Thanks

Marco Fris

Depends on your definition of 'good' data.
If you can express your criteria in terms of database constraints (uniqueness, referential constraints, check constraints) then ODI's CKMs can help. A CKM verifies incoming data against those constraints and puts records that violate any into an error table. Basic but effective.
They appear to have been omitted in recent documentation, but to my knowledge this older guide is still valid.
Have fun, Marco

User_9AGUD

Thanks Marco. How to implement The rows failing the conditions will be inserted in an error table which are prefixed by E$_? Which IKM can I use? Does IKM exist or not?
Thanks a lot
Loan

Marco Fris

Hi Loan,
It is the CKM that does that. You can select it in the same way you pick you IKM: on the physical tab of your mapping with the target selected.
Did you spot the link to the tutorial? https://docs.oracle.com/cd/E21043_01/integrate.1111/e12641/quality.htm

Have fun, Marco

et4891

Hello Loan,
If you aren't able to find any IKM which I had a hard time finding it so made a post https://community.oracle.com/tech/apps-infra/discussion/4484961/import-create-integration-knowledge-modules
Look at the answer accepted, thanks to @marco-fris3 for helping me out finding where to import

ET

1 - 6

Post Details

Added on Dec 12 2018
9 comments
4,260 views