Web ADI Error: An error has occurred while running an API import. No return type specified in PL/SQL parameter list 222:MWANIFARET6_PLS attribute 3

Web ADI Error:

·         Out of he 1row(s) successfully uploaded to the staging tables, 1 row(s) failed validation.

·         An error has occurred while running an API import. No return type specified in PL/SQL parameter list 222:MWANIFARET6_PLS attribute 3

\

Please check you defined integrator definition by using this script.

Script:

select *from BNE_ATTRIBUTES where ATTRIBUTE_CODE like '%MWANIFARET6_XA1%';

If you check Attrubite1=’Function’ , In our package we have defined procedure not function.

Required to update the Attribute1='PROCEDURE' and Attribute4=NULL

Script:

update BNE_ATTRIBUTES

set attribute1 = 'PROCEDURE', attribute4 = null 

where application_id = 222 and attribute_code like 'MWANIFARET6_XA1';

Now restart the system and use Web ADI template again. Issue will be Resolved.

Workflow Mailer Notification Issue Solution - Specific user not getting a workflow notification in system or email for any transaction.

Subject: Specific user not getting a workflow notification in system or email for any transaction.

Solution:

Step 1: Run following query for specific username.

Sql Query:

select name, notification_preference

from apps.wf_users

where notification_preference = 'DISABLED'

and status = 'ACTIVE'

and name='2346';

-          Current user account notification preference is disabled required to enable.

Step2: Required to enable User account notification preference.

Step3: Login with Specific User Account.

Step4: Click on Preference link.

Step5: The bottom part of the window ensure that their notification preference is set appropriately.

Step6: Required to set Email Style= ‘HTML mail with Attachments’ and click on the Apply button. 

-          Now in future this user will get notification & attachment after enable those preference settings.

-          If you check this user details using the same query, now it will not found in the query list.

How to enable Oracle fusion report GL Level User Security Profile

Requirement: Oracle Report will give output for specific code combination only which is based on User Security profile option.

Step1: Required to create a parameter

Step2: Create Flexfield with following details. 

- Now when you run the report it will give output for only those account which is enabled at User Security profile for that user.

Note:

1.       we have to use the table GL_CODE_COMBINATION_KFVS main Dataset table alias name in Code Combination Table Alias  name in configuration

2.       We can enable User Security profile on Dataset level only not on Parameter level using this process.