Wednesday, 12 February 2020

Concurrent program POCIRM returned error ( POCIRM-001: ORA-01403: no data found)


The Requisition Import Program is failing, while we are submitting from back end - but it has failed from concurrent request submission as well.

Error:
POCIRM-001: ORA-01403: no data found


The issue is caused by the fnd loosing its org context or not having the org context set at all - meaning MO: Operating Unit - or MO: Security Profile are not setup.


If the concurrent request from the back end  then add FND_REQUEST.SET_ORG_ID(ORG_ID) command.


fnd_global.APPS_INITIALIZE (l_user_id, l_resp_id, l_appl_id);
MO_GLOBAL.init('PO');
mo_global.set_policy_context('S',p_org_id);
FND_REQUEST.SET_ORG_ID(ORG_ID);


l_request_id :=
  fnd_request.submit_request (application => 'PO',
  program => 'REQIMPORT',
  description => 'Requisition Import',
  start_time => SYSDATE,
  sub_request => FALSE,
  argument1 => 'ORDER ENTRY',
  argument2 => l_req_batch_id,
  argument3 => 'ALL',
  argument4 => NULL,
  argument5 => 'N',
  argument6 => 'Y'
  );


Tuesday, 7 January 2020

How To Determine Matching Approval Level In Supplier Table ap_suppliers

This SQL can be used ...



SELECT DECODE (NVL(APS.receipt_required_flag, 'N'),
               'Y', DECODE(NVL(APS.inspection_required_flag, 'N'),
                           'Y', '4-Way',
                           '3-Way'),
               '2-Way') matching_Level
  FROM ap_suppliers APS

Thursday, 22 November 2018

JTA: APP-JTF-210374: The User ID Already Exists



Ensure that you have run the "Synchronize Application User Name" concurrent program under "CRM Administrator" responsibility (using Synchronize "Both" parameter)


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. 
 
set_record_property(:system.trigger_record,:system.trigger_block,status,query_status);



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);


BEGIN
    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;
    EXCEPTION WHEN OTHERS
                    THEN
                    fnd_file.put_line(fnd_file.log,'Error While Getting object_version_number from HZ_PARTIES for the Supplier no :'||p_supp_no);
   END;



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
     --

    BEGIN
    HZ_PARTY_V2PUB.update_organization ( p_init_msg_list   => FND_API.G_FALSE
                                        ,p_organization_rec=>l_organization_rec
                                        ,p_party_object_version_number => l_object_version_number
                                        ,x_profile_id => x_profile_id
                                        ,x_return_status=>l_return_status
                                        ,x_msg_count=>l_msg_count
                                        ,x_msg_data=>l_msg_data
                                        );
      EXCEPTION WHEN OTHERS
                  THEN
                  fnd_file.put_line(fnd_file.log,'Error While Calling HZ_PARTY_V2PUB.update_organization API for Supplier No'||p_supp_no||'-'||sqlerrm);
                  END;


Monday, 19 February 2018

Java.io.FileNotFoundException - Bursting Error

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

--Exception
/u01/oracle/XXX/apps/apps_st/comn/temp/021918_023824550/FILE_NAME.pdf (No such file or directory)
java.io.FileNotFoundException: /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)