Task:How to find a AP invoice is validated or not through a SQL queryScript:SELECT i.invoice_id, i.invoice_amount, DECODE(APPS.AP_INVOICES_PKG.GET_APPROVAL_STATUS(i.invoice_id, i.invoice_amount,i.payment_status_flag,i.invoice_type_lookup_code), 'NEVER APPROVED', 'Never Validated', ...
AP_INV_APRVL_HIST_ALL table will give you all the details related to approval of particular invoice.Query to get the latest transaction on particular invoice :select created_by from AP_INV_APRVL_HIST_ALLwhere invoice_id = &inv_idand approval_history_id =(select max(approval_history_id) from AP_INV_APRVL_HIST_ALL where invoice_id = &inv_id )Query to get the Initiator of particular invoice :select created_by from AP_INV_APRVL_HIST_ALLwhere ...
Concurrent programsoracle apps R12Query
Query to Find scheduled concurrent program's in Oracle apps
posted on , by Adarsh
SELECT fcr.request_id,DECODE(fcpt.user_concurrent_program_name,'Report Set','Report Set:' || fcr.description,fcpt.user_concurrent_program_name) CONC_PROG_NAME,argument_text PARAMETERS,NVL2(fcr.resubmit_interval,'PERIODICALLY',NVL2(fcr.release_class_id, 'ON SPECIFIC DAYS', 'ONCE')) PROG_SCHEDULE_TYPE,DECODE(NVL2(fcr.resubmit_interval,'PERIODICALLY',NVL2(fcr.release_class_id, 'ON SPECIFIC DAYS', 'ONCE')),'PERIODICALLY','EVERY ' || fcr.resubmit_interval || ' ' ||fcr.resubmit_interval_unit_code || ...
SELECT *FROM ( SELECT 'N' select_flag, 'N' hide_show, xgl.name ledger, xte.ledger_id, le.name legal_entity, ...
SELECT distinct aia.invoice_id, aia.invoice_num, aia.invoice_date, aia.invoice_amount, aia.invoice_currency_code, aia.payment_currency_code, aia.gl_date, xah.period_name, aia.payment_method_code, xah.je_category_name, xev.event_id, xte.ENTITY_CODE ,xte.APPLICATION_ID ,xte.legal_entity_id ,source_id_int_1 ...
DECLAREp_event_source_info xla_events_pub_pkg.t_event_source_info;lv_valuation_method VARCHAR2(100) :=null;lv_security_context xla_events_pub_pkg.t_security;BEGINp_event_source_info.source_application_id := 200; --101 GL -- 602 XLEp_event_source_info.application_id := 200; -- ARp_event_source_info.legal_entity_id := 23273;p_event_source_info.ledger_id := 2021;p_event_source_info.entity_type_code := 'AP_INVOICES';p_event_source_info.transaction_number := NULL;p_event_source_info.source_id_int_1 ...
Below query can be used to add (any)responsibility from backend database:BEGINFND_USER_PKG.ADDRESP ('XX_USERNAME', — Username'SYSADMIN', –application short name'SYSTEM_ADMINISTRATOR', — Responsibility Key'STANDARD', — Security Group Key'Sysadmin Responsibility added due to work', –Descriptionsysdate, –Start datenull –End date);COMMIT;DBMS_OUTPUT.put_line ('Responsibility Added Successfully');EXCEPTIONWHEN OTHERSTHENDBMS_OUTPUT.put_line (' Responsibility is not added due to '|| SQLCODE|| SUBSTR ...
API - pay_element_entry_api.create_element_entryset serveroutput on;DECLAREl_date date := '01-APR-2020'; /*Start date of element*/x NUMBER := 0;input_value_id2 number;input_value_id3 number;LV_ERROR_MSG VARCHAR2(240);LD_EFFECTIVE_START_DATE DATE;LD_EFFECTIVE_END_DATE DATE;LN_ELEMENT_ENTRY_ID NUMBER;LN_OBJECT_VERSION_NUMBER NUMBER;LB_CREATE_WARNING BOOLEAN;lb_delete_warning BOOLEAN;Cursor CREATE_ELEMENT_CUR Is ...
we have to use frmcmp(Form Compiler) for compiling forms and libraries in Oracle Applications Version R12, But in 11i we need to use f60gen to compile forms and libraries which is deprecated in R12.1) Login to application server.2) Go to the directory $AU_TOP/forms/US3) Place “.fmb” file in binary mode4) Execute the below command to generate “.fmx”.frmcmp_batch userid=apps/<apps_paswd> module=<Form_Name>.fmb output_file=<Form_Name>.fmx module_type=form batch=no compile_all=specialEXAMPLE:frmcmp_batch ...
