Oracle Apps Technical Information

Go to Inventory Responsibility Search the function Inventory Delete Items Create one group add the Item which you like to delete save and delete group Auto concurrent triggers ( Delete Item Information) and delete your Item

--Choose the Batch source specific to the Operating unit / Division SELECT batch_source_id, org_id, name, a.* FROM ra_batch_sources_all  a where  org_id in (select ORGANIZATION_ID from Hr_operating_units where SET_OF_BOOKS_ID=2089) and STATUS='A' select * from  RA_batch_sources_all  where batch_source_id in ( 9096,  9106,9102,9113,9122) SELECT 'alter sequence AR.'||seq.sequence_name||' nocache;' FROM (SELECT name bsname, org_id org, 'RA_TRX_NUMBER_'||BATCH_SOURCE_ID||'_'||org_id||'_S' seqname FROM RA_batch_sources_all where org_id in (304) and  batch_source_id in ( 9139)  ) src, dba_sequences seq WHERE src.seqname=seq.sequence_name -- Pass the Org_id  and Batch Source Id  --AND seq.cache_size --execute that output COMMIT; --Check the Sequence Cache cleared or not SELECT sequence_owner, sequence_name, cache_size FROM all_sequences WHERE sequence_name LIKE 'RA_TRX_NUMBER_9139_304_S%'; --ALTER sequence...

Change the Prompt Value from Inherit to New value 

Set the values of following profiles to enable Personalization Page link in OAF Pages Profile Name Value FND: Personalization Region Link Enabled Yes Personalize Self-Service Defn Yes Disable Self-Service Personal No

Solution : Fix the Java path in run time XML Publisher Run time (to preview from local) ADD Ins ->Tools->Option ->Preview ->Java Home Paste the below the path : 32Bit C:\Program86 Files\Java\jre1.8.0_144 64Bit C:\Program Files\Java\jre1.8.0_144

SELECT b.application_table_name , b.descriptive_flexfield_name , a.application_column_name , a.end_user_column_name , a.descriptive_flex_context_code FROM fnd_descr_flex_column_usages a , fnd_descriptive_flexs_vl b WHERE 1 = 1 AND b.descriptive_flexfield_name = a.descriptive_flexfield_name AND b.application_id = a.application_id AND A.CREATED_BY not in (0, 1,2, 5, 120, 121) and b.application_table_name like '%PO%VENDO%' AND b.application_table_name != 'FND_SRS_MASTER' ORDER BY 1,4

Autoinvoice Import Program takes following parameters : argv[0]  program name argv[1]  parallel module name  [MAIN|PU?] argv[2]  running mode  [V|T|P] argv[3]  batch source id argv[4]  batch source name argv[5]  default date argv[6]  concatenated transaction flexfield attribute value argv[7]  transaction type id argv[8]  low bill to customer number argv[9]  high bill to customer number argv[10]  low bill to customer name argv[11] high bill to customer name argv[12] low gl date argv[13] high gl date argv[14] low ship date argv[15] high ship date argv[16] low transaction number argv[17] high transaction number argv[18] low sales order argv[19] high sales order argv[20] low invoice date argv[21] high invoice date argv[22] low ship to customer number argv[23] high ship to customer number argv[24] low ship to customer name argv[25] high ship to customer name argv[26] Call RAXTRX from RAXMTR flag ar...