The macro cannot be found or has been disabled (BI Publisher and Office 2010)

Recently I have upgraded MS Office from 2007 to 2010. As I work on some BI projects, part of mine set of oracle programs is oracle BI Publisher Desktop, which use Word as report template designer. When I run BI Publisher macros in Word 2010 I got following error:
The macro cannot be found or has been disabled because of your macro security settings

The solution

The solution shown here really works (tested on several computers), so I'm writing this down to be more like documentation for future reference to anyone stack on this case. Idea is to remove old *.EXD files from any location in %USERPROFILE% folders that might exists.
Because mine praxis is to have separate %USERPROFILE% folder location then where are OS files (different then partition then C:), exd file was found as shown. In mine case it was only in one folder:

D:\Users\Sandip\Application Data\Microsoft\Forms>dir

Volume in drive D is Data

Volume Serial Number is 505E-794F

Directory of D:\Users\Sandip\Application Data\Microsoft\Forms

01.02.2011  11:45    <DIR>          .

01.02.2011  11:45    <DIR>          ..

12.03.2009  15:17           165.808 MSComctlLib.exd

31.08.2010  10:34            11.776 WINPROJ.box

01.02.2011  11:19             7.168 WINWORD.box

3 File(s)        184.752 bytes

2 Dir(s)  51.699.859.456 bytes free

D:\Users\Sandip\Application Data\Microsoft\Forms>

So all you have to do is:

1. Rename existing "MSComctlLib.exd" file to "MSComctlLib.exd_bak"
2. Install BI Publisher again.

It should work....

Cherrrrrrrssssssssss...

Reference :- http://damir-vadas.blogspot.com/2011/02/macro-cannot-be-found-or-has-been.html?showComment=1303225868321#c4865170160256515104

Education and Qualification and Other Professional Qualifications Approval in SSHR

Education and Qualification and Other Professional Qualifications Approval in SSHR:

Process Name for Education and Qualification workflow - HR_QUALIFICATION_JSP_PRC

And Process Name for Other Professional Qualifications workflow - HR_AWARD_JSP_PRC

First Responder wins Approval in Oracle SSHR AME

First Responder wins Approval in Oracle SSHR AME:

Requirement - My client requirement is once personal details are updated through self-service page, it should go to HR for approval. As of now I am able to send notification to one person in HR dept. Now I want notification should go to many HR people and one first person approves it, request should get approved. If no one is taking action within three working days then it should get rejected. Please let me know how this can be achieved. Steps:

1.       Login by SYSADMIN

2.       Go to Approval Manager Administrator -> Configuration Variables -> Select Transaction Type - Oracle Self Service Human Resources -> Allow All Approver Type Set to Yes  Both Default and Transaction Type

3.       Go to Approver Type Quick Link and Add PQH_ROLE there i.e. Position Control Roles

4.        Define Roles: Using HRMS Manager Responsibility define roles and assign the Person names to the roles that are part of an approver group. For each approver group for which parallel notification is required, define a corresponding role in the Maintain Roles form with the same members assigned to the role as in the approver group.

Navigation: HRMS Manager responsibility -> Transaction Maintenance ->Roles -> Maintain

Roles -> Users

5.       Approver Group set up:

Using Approvals Management Business Analyst responsibility within AME, select the

Transaction Type and define attributes/conditions as required for the business case. Define the Approver group with Voting regime ‘first-responder-wins and add the Roles defined in Step 1

6.       Approver group members with Approver Type ‘Position Control Roles’. Add those roles to which the corresponding group members were assigned whom we want to be the members of the approver group. Give order number for the roles so that if we are using multiple roles/groups for approval, the members of each of role will be notified based on the order number assigned to the roles. Define Approval Rule with action type set to require approval from the approver groups. Navigation: Approvals Management Business Analyst responsibility -> Business Analyst Dashboard -> Select Transaction Type -> Define Attributes -> Conditions ->Define Approver Groups -> Add Group Members (Roles) ->Define Rule
 7.     In Action Type – Ordering Mode – Parallel and Voting Method -> First Responder Wins

Reference - http://www.scribd.com/doc/38609690/Whitepaper-Parallel-Approvers-Notification

How to create Leave Approval workflow using AME

Requirement : Once leave is submitted, notification should go to first supervisor and then to HR Staff for approval.

1. Create new condition - WORKFLOW_PROCESS_NAME in (HR_GENERIC_APPROVAL_PRC)
2. Create Approval Group - Name - HR Approver
                                            Description - HR Approver
                                            Order Number - 1
                                            Voting Method - Serial
                                            Usage Type - Static
                                            Approver - Name of HR People
3. Create new Action Type - Approval Group Chain of Authority
4. Remove HR_GENERIC_APPROVAL_PRC  from existing WORKFLOW_PROCESS_NAME condition. Do not remove HR_LOA_JSP_PRC
5. Create New Rule - Name - XXXX
                                  Type - List Creation
                                  Item Class - Header
                                  Start Date - Date
                                  End Date - Date
6. Add new created condition
7. Add Two Action Types
     1. supervisory level
      2. approval-group chain of authority
8. Create the rule.
9. Clear the cache
10. No change is required in the Workflow.
11. Absence Management function parameter should be -
OAFunc=HR_LOA_SS&pAMETranType=SSHRMS&pAMEAppId=800&pProcessName=
HR_GENERIC_APPROVAL_PRC&pItemType=HRSSA
&pCalledFrom=HR_LOA_SS&pApprovalReqd=YD&pNtfSubMsg=HR_ABS_NTF_SUB_MSG
&pConcAction=N
12. Test the approval. It should go properly.


Cheerrrrrrrrrssssssssssssssss.....

AP Invoice Interface

AP Invoice Interface:

select lookup_code

from ap_lookup_codes

where lookup_type='SOURCE'

INSERT

INTO ap_invoices_interface

(

invoice_id,

INVOICE_NUM,

DESCRIPTION,

invoice_type_lookup_code,

invoice_date,

vendor_id,

vendor_site_id,

invoice_amount,

INVOICE_CURRENCY_CODE,

source,

payment_method_code,

taxation_country

org_id

)

VALUES

(

AP_INVOICES_INTERFACE_S.NEXTVAL

, 'TESTINV01'

,'this is test invoice'

,'STANDARD'

,SYSDATE -40 --<invoice date>

,35028--<vendor_id validated against po_vendors.vendor_id>,

,2277--<vendor_site_id validated against po_vendor_sites.vendor_site_id>,

,100--<invoice_amount>

,'AED'

,'MANUAL INVOICE ENTRY'

,'CHECK'

, 'AE'

,81

);

INSERT

INTO ap_invoice_lines_interface

(

invoice_id,

invoice_line_id,

line_number,

line_type_lookup_code,

amount,

accounting_date,

dist_code_combination_id

)

VALUES

(

AP_INVOICES_INTERFACE_S.CURRVAL

,AP_INVOICE_LINES_INTERFACE_S.NEXTVAL

,1--<some unique_number>,

,'ITEM'--<ITEM>/<FREIGHT>/<TAX>

,100--<line_amount> sum of line_amount should always be equal to invoice_amount,

,SYSDATE -40

,4565 --'<account code>'—CC_ID

);

COMMIT;

After inserting, run the “PAYABLES OPEN INTERFACE IMPORT” program to load invoice

Purchase Requisition(PR) Creation Interface

Sample Script to create PR:

INSERT INTO po_requisitions_interface_all

                        (interface_source_code

                       , source_type_code

                      , destination_type_code, authorization_status

                      , preparer_id, category_id

                      , item_description, quantity

                      , unit_price, charge_account_id

                      , unit_of_measure

                      , suggested_vendor_id

                      , destination_organization_id

                      , deliver_to_location_id

                       , deliver_to_requestor_id

                      , org_id

                      , group_code,

                      )

                 VALUES (

                      'FSI'

                  , ‘VENDOR’

                  , ‘EXPENSE’

                  , 'INCOMPLETE'

                  , 200 --Person ID

                  , 1233  --Category ID

                  , ‘This is test item’  --Item Description

                   , 10 --Quantity

                   ,   100 --Unit Price

                   , 123  --CC_Id

                   , ’Each’

                   , 231 --suggested_vendor_id

                   , 101   --Destination Org ID

                    , 142 --Deliver to location ID

                     , 200 --Person ID

                     , 81 --Org ID

                     , 103 --Group Code --This is to group the requisition lines

                       );

Then run Requisition Import program:

Changing Oracle logo in Oracle Applications

Name of the Profile - Corporate Branding Image for Oracle Applications

Name of Image – Image_Name.gif (Provide Your Image Name)

Copy the Image to $OA_MEDIA directory.

Clear the Cache:

Navigation to clear the cache:

Responsibility -> Functional Administrator -> Core Services -> Caching Framework -> Global Configuration -> Clear All Cache -> Yes

Then Refresh the login page to see the new image