Workflow PO Approval Error : Notify Preparer of No Approver Found

Workflow PO Approval Error: Notify Preparer of No Approver Found

Step 1: Create PO with following details.

 

Step 2: Add Shipment Information.

Step 3: save the transaction. Now PO Number generated.

 

Step 4: Click on the Approve button to Approve the PO.

Step 5: Login with Sysadmin user for Approve the PO.

                Navigation: Workflow Administrator Responsibility >  Administrator Workflow > Status Monitor

 

Step 6: Workflow seeded error

Error 1: Return PO to submitter

Error 2: Notify Preparer of No Approver Found

 

Step 7: Check PO Summary status for the same PO. Its Incomplete status because of Buyer is not listed in the Approval Group.

 

Step 8: Check the Buyer Position from HRMS responsibility.

 

Go to the Assignment tab by click on the Assignment button.

  

Step 9: Go to purchasing responsibility and check against this position Purchase Approval document type assigned or not.

Against this buyer Position no Document type for Purchase Order Approver available.

Step 10: Assign ‘Approve Standard Purchase Orders’ Document type against this position.

 

Step 11: Now Create new PO with same details, It will successfully complet with Approved status.

    

How to Assign Modified Oracle Custom Report (Data Model & RTF) to Seeded Report Request - Oracle Fusion

How to Assign Modified Oracle Custom Report (Data Model & RTF) to Seeded Report Request

Requirement: Required to assign modified ‘Pick Slip Report’ to Seeded pick slip request.

1  Step 1: Login to Oracle Fusion > Navigator > Reports and Analytics

    Step 2: Navigate to :  All Folders > Shared Folders > Supply Chain Management > Warehouse Operations > Pick Slips > Pick Slip Report

    Step 3: Click on the Report and Click Edit. A new Window opens. Attach the new custom Data Model.

    Step 4: Click on edit again and it will download the RTF or we can add a new layout and make it default layout.

    Step 5: Make new RTF as the default layout                

    Step 6: Make the necessary changes to the RTF and upload it to the same report.

   

    Step 7: Now you can able to use modified report by using seeded request.

How to enable key flex field (GL Code Combination) in Oracle Custom Form level

Enable Key Flex Field (GL Code Combination) in Oracle Custom Form level

Requirement: Required to enable Accounting Key Flex Field in From Acct and To Acct fields in below custom form.

Custom Form:

Step 1: Find Accounting Key Flex Field Structure Number which you want to enable in custom form level

Accounting Flex Field Structure Code: MWANI_QATAR_COA

Find Flex Field Structure Number using below sql query

select ID_FLEX_NUM from FND_ID_FLEX_STRUCTURES where id_flex_code='GL#'

and Application_id=101

and ID_FLEX_STRUCTURE_CODE='MWANI_QATAR_COA'; -- for GL

Step 2: Add Following Code in WHEN-NEW-FORM-INSTANCE Form level trigger.

-----From Account-----

FND_KEY_FLEX.DEFINE(

block => 'BUDGET_HDR_BLOCK',

Field => 'FROM_ACCT',

Description =>  'FROM_ACCT_DESC',

ID => 'FROM_ACCT_ID',

Appl_short_name => 'SQLGL',

Code => 'GL#',

Num => '50428',

--VRULE => 'GL_GLOBAL\nDETAIL_POSTING_ALLOWED \nE\nAPPL=''SQLGL'';

VRULE=>'\\nSUMMARY_FLAG\\nI\\nAPPL=SQLGL;NAME=GL_NO_PARENT_SEGMENT_ALLOWED\\nN', where_clause => 'summary_flag != ''Y''', QUERY_SECURITY =>'Y'

);

-----To Account-------

FND_KEY_FLEX.DEFINE(

block => 'BUDGET_HDR_BLOCK',

Field => 'TO_ACCT',

Description =>  'TO_ACCT_DESC',

ID => 'TO_ACCT_ID',

Appl_short_name => 'SQLGL',

Code => 'GL#',

Num => '50428',

--VRULE => 'GL_GLOBAL\nDETAIL_POSTING_ALLOWED \nE\nAPPL=''SQLGL'';

VRULE=>'\\nSUMMARY_FLAG\\nI\\nAPPL=SQLGL;NAME=GL_NO_PARENT_SEGMENT_ALLOWED\\nN', where_clause => 'summary_flag != ''Y''', QUERY_SECURITY =>'Y'

);

Step 3: Add WHEN-NEW-ITEM-INSTANCE trigger at field level (field : FROM_ACCT & TO_ACCT)

FND_FLEX.EVENT('WHEN-NEW-ITEM-INSTANCE');

Step 4: Add KEY-EDIT trigger at field level (field : FROM_ACCT & TO_ACCT)

                                FND_FLEX.EVENT('KEY-EDIT');

Step 5: Add WHEN-VALIDATE-ITEM trigger at field level (field : FROM_ACCT & TO_ACCT)

FROM_ACCT Trigger:

FND_FLEX.EVENT('WHEN-VALIDATE-ITEM');

IF :BUDGET_HDR_BLOCK.FROM_ACCT_ID = -1 THEN

FND_MESSAGE.SET_STRING('You Have Selected An Undefined Code Combination !');

FND_MESSAGE.SHOW;

RAISE FORM_TRIGGER_FAILURE;

END IF;

TO_ACCT Trigger:

                FND_FLEX.EVENT('WHEN-VALIDATE-ITEM');

IF :BUDGET_HDR_BLOCK.TO_ACCT_ID = -1 THEN

FND_MESSAGE.SET_STRING('You Have Selected An Undefined Code Combination !');

FND_MESSAGE.SHOW;

RAISE FORM_TRIGGER_FAILURE;

END IF;

Step 6: Set Filed property palette (FROM_ACCT & TO_ACCT)

FROM_ACCT

TO_ACCT

Step 7: Compile the Form and upload it on server.

Step 8: Key Flex field enabled on both field.

FROM_ACCT

TO_ACCT