Wednesday, November 16, 2011

Error Error while caling AS_OPPORTUNITY_PUB.Update_Opp_Header API Current resource does not have a login user assigned. Please use resource manager to assign a login user to this resource

Error: Error while caling AS_OPPORTUNITY_PUB.Update_Opp_Header API Current resource does not have a login user assigned. Please use resource manager to assign a login user to this resource

    headerRec.close_reason     := 'DROPPED';
        headerRec.last_update_date := lastUpdatedDate;
        headerRec.last_updated_by  := FND_GLOBAL.USER_ID;

        AS_OPPORTUNITY_PUB.Update_Opp_Header(p_api_version_number     => '2.0',
                                             p_commit                 => fnd_api.G_FALSE,
                                             p_header_rec             => headerRec,
                                             p_check_access_flag      => 'Y',
                                             p_admin_flag             => 'N',
                                             p_admin_group_id         => null,
                                             p_identity_salesforce_id => null,
                                             p_partner_cont_party_id  => null,
                                             x_return_status          => x_return_status,
                                             x_msg_count              => x_msg_count,
                                             x_msg_data               => x_msg_data,
                                             x_lead_id                => x_lead_id);
        IF (x_return_status != 'S') THEN
          IF (fnd_msg_pub.count_msg > 0) THEN
            FOR i IN 1 .. fnd_msg_pub.count_msg LOOP
              fnd_msg_pub.get(p_msg_index     => i,
                              p_encoded       => 'F',
                              p_data          => x_msg_data,
                              p_msg_index_out => x_msg_count);
              DBMS_OUTPUT.put_line(x_msg_data);
            END LOOP;

Solution: Pass the sales_force_id  into  p_identity_salesforce_id

Wednesday, November 09, 2011

Error - You have encountered an unexpected error. Please contact the System Administrator for assistance.


We have to turn on diagnostics to see the error
Go to Application Developer --> Profiles -- System
Set FND: Diagnostics to Yes . This will display ther details link to show the full error where you can see the error