Friday, 6 April 2018

FRM-40200: Cannot Unfreeze Descriptive Flexfield

FRM-40200: Field is protected against update

follow these steps:

# Select Application Developer responsibility
# Navigate to Flexfield, Descriptive, Register
# Query the flexfield
  There you will see that the protected flag is checked.
  Uncheck and save.

Try and unfreeze the flexfield again.

Tuesday, 3 April 2018

Do you want to save changes in oracle forms

After I query the record and closing the form the error 'Do you want to save changes you have made' will appear without entering or modifying records in the form. So how can I avoid this message?

I defaulting some value for non-database item in Post Query trigger, which causes this message.
Finally used below code in Post Query trigger and worked. 

Thursday, 15 March 2018

Updating Vendor /Supplier Name

Oracle Supplier API API AP_VENDOR_PUB_PKG.UPDATE_VENDOR  Not going to updates Supplier name.

Use HZ_PARTY_V2PUB.update_organization  to update Supplier  name/Customer name

    l_organization_rec      hz_party_v2pub.organization_rec_type;
    x_profile_id                 NUMBER;
    l_party_id                    NUMBER;
    l_object_version_number HZ_PARTIES.OBJECT_VERSION_NUMBER%TYPE;
    l_vendor_number         AP_SUPPLIERS.SEGMENT1%TYPE;

    l_msg_count             NUMBER :=NULL;
    l_msg_data              VARCHAR2(4000);
    l_return_status         VARCHAR2(5);

    SELECT aps.party_id,hzp.object_version_number,aps.segment1
      INTO   l_party_id,l_object_version_number,l_vendor_number
      FROM   AP_SUPPLIERS aps,
             HZ_PARTIES hzp
      WHERE vendor_id =p_vendorid
      AND aps.party_id  = hzp.party_id;
                    fnd_file.put_line(fnd_file.log,'Error While Getting object_version_number from HZ_PARTIES for the Supplier no :'||p_supp_no);

l_organization_rec.party_rec.party_id               := l_party_id;
    l_organization_rec.organization_name                := TO_CHAR(SYSDATE,'DDMMRRRR')||l_vendor_number;
    l_msg_count      :=NULL;
    l_msg_data       :=NULL;
    l_return_status  :=NULL;

     -- API top Update Vendor Name

    HZ_PARTY_V2PUB.update_organization ( p_init_msg_list   => FND_API.G_FALSE
                                        ,p_party_object_version_number => l_object_version_number
                                        ,x_profile_id => x_profile_id
                  fnd_file.put_line(fnd_file.log,'Error While Calling HZ_PARTY_V2PUB.update_organization API for Supplier No'||p_supp_no||'-'||sqlerrm);

Monday, 19 February 2018 - Bursting Error

Start bursting process..
Bursting process complete..
Generating Bursting Status Report..

/u01/oracle/XXX/apps/apps_st/comn/temp/021918_023824550/FILE_NAME.pdf (No such file or directory) /u01/oracle/XXX/apps/apps_st/comn/temp/021918_023824550/FILE_NAME.pdf (No such file or directory)

Solution : 

Check the uploaded template properties. Either use correct territory or leave this field as blank (this is not mandatory)

Friday, 2 February 2018

Need To Delete Credit Card Transaction In IExpense

Run the Credit Card Historical Transactions Management program from Payables Manager  for the specific Credit card number for which you want to deactivate.

Thursday, 4 January 2018

Automatic Receipts Fail With IBY_20400, Error while inserting/updating invoice transaction

When running Automatic Receipts, find that a number of transactions are failing with the error message IBY_20400. 

Issue :  IBY_20400 error was due to custom trigger on IBY_TRXN_SUMMARIES_ALL  table.

Wednesday, 8 November 2017

Returning 'Warning' Status From Host Program

By default, 0 is for success, 1 for warning 2 for error. Where as in Unix both 1 and 2 are returns Error.

By adding below peace of code, we can return Warning status.

     # set request status to warning:
           RESULT =`sqlplus -s ${FCP_LOGIN} <<!
         b_success    BOOLEAN;
         n_session_id NUMBER;
         fnd_global.initialize( session_id            => n_session_id
                               ,user_id               => NULL
                               ,resp_id               => NULL
                               ,resp_appl_id          => NULL
                               ,security_group_id     => NULL
                               ,site_id               => -1
                               ,login_id              => NULL
                               ,conc_login_id         => NULL
                               ,prog_appl_id          => NULL
                               ,conc_program_id       => NULL
                               ,conc_request_id       => ${4} – Request ID
                               ,conc_priority_request => NULL
                               ,form_id               => NULL
                               ,form_appl_id          => NULL
                               ,conc_process_id       => NULL
                               ,conc_queue_id         => NULL
                               ,queue_appl_id         => NULL
                               ,server_id             => -1
          b_success := fnd_concurrent.set_completion_status
                        (status  => 'WARNING'
                        ,message => 'See log file for warning details.'