Ensure that you have run the
"Synchronize Application User Name" concurrent program under
"CRM Administrator" responsibility (using Synchronize
"Both" parameter)
Thursday 22 November 2018
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)
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.
Issue : IBY_20400 error was due to custom trigger on IBY_TRXN_SUMMARIES_ALL table.
Subscribe to:
Posts (Atom)