Merhaba, İade siparişlerinde, vergi kodunun “%IADE KDV” olarak otomatik gelmesi ihtiyacıyla ilgili aşağıdaki örnek kod kullanılabilir.   CREATE OR REPLACE PACKAGE BODY APPS.XXPELIN_OM_UTILS_PKG AS   FUNCTION xxpelin_get_iade_kdv (p_database_object_name IN VARCHAR2, p_attribute_code IN VARCHAR2) RETURN VARCHAR2 IS l_count VARCHAR2 (200); BEGIN SELECT COUNT (name) INTO l_count FROM oe_transaction_types_tl tt, oe_transaction_types_all x WHERE 1 = 1 AND […]

Merhaba, Mutlaka bazı işlerde ihtiyaç olan trigger içerisinden eşzamanlı talebi çalıştırmak gerektiğinde eşzamanlısının trigger sessionı içerisinden commitlenmeden çalışmasının sağlanması için gerekli olan örnek trigger aşağıdaki gibidir. Eşzamanlının arkaplanda çalışmasının sağlanması için fnd_request.set_mode (TRUE) olarak set edilmelidir. Aşağıdaki şekilde kullanılabilir.   CREATE OR REPLACE TRIGGER "APPS"."XX_RUN_CONCURRENT_FROM_BACKEND_TRG" AFTER INSERT ON MTL_SYSTEM_ITEMS_B FOR EACH ROW DECLARE req_id NUMBER; […]

USER_JE_CATEGORY_NAME = Adjustment Reference21 : POSTING_CONTROL_ID Reference22 : AR_ADJUSTMENTS.ADJUSTMENT_ID Reference23 : AR_DISTRIBUTIONS.LINE_ID Reference24 : RA_CUSTOMER_TRX.TRX_NUMBER Reference25 : AR_ADJUSTMENTS.ADJUSTMENT_NUMBER Reference26 : RA_CUST_TRX_TYPES.TYPE Reference27 : RA_CUSTOMER_TRX.BILL_TO_CUSTOMER_ID Reference28 : ‘ADJ’ Reference29 : ‘ADJ_’||AR_DISTRIBUTIONS.SOURCE_TYPE Reference30 : ‘AR_ADJUSTMENTS’ ——————————————— USER_JE_CATEGORY_NAME = Sales Invoice</strong> Reference21 : POSTING_CONTROL_ID Reference22 : RA_CUSTOMER_TRX.CUSTOMER_TRX_ID Reference23 : RA_CUST_TRX_LINE_GL_DIST.CUST_TRX_LINE_GL_DIST_ID Reference24 : RA_CUSTOMER_TRX.TRX_NUMBER Reference25 : HZ_CUST_ACCOUNTS.ACCOUNT_NUMBER Reference26 : […]

Aşağıda FND_PROFILE.GET Methoduyla çekebileceğiniz değerleri bulabilirsiniz. SELECT fnd_profile.VALUE(‘PROFILEOPTION’) ,fnd_profile.VALUE(‘MFG_ORGANIZATION_ID’) ,fnd_profile.VALUE(‘ORG_ID’) ,fnd_profile.VALUE(‘LOGIN_ID’) ,fnd_profile.VALUE(‘USER_ID’) ,fnd_profile.VALUE(‘USERNAME’) ,fnd_profile.VALUE(‘CONCURRENT_REQUEST_ID’) ,fnd_profile.VALUE(‘GL_SET_OF_BKS_ID’) ,fnd_profile.VALUE(‘SO_ORGANIZATION_ID’) ,fnd_profile.VALUE(‘APPL_SHRT_NAME’) ,fnd_profile.VALUE(‘RESP_NAME’) ,fnd_profile.VALUE(‘RESP_ID’) FROM DUAL;SELECT fnd_profile.value(‘PROFILEOPTION’) ,fnd_profile.value(‘MFG_ORGANIZATION_ID’) ,fnd_profile.value(‘ORG_ID’) ,fnd_profile.value(‘LOGIN_ID’) ,fnd_profile.value(‘USER_ID’) ,fnd_profile.value(‘USERNAME’) ,fnd_profile.value(‘CONCURRENT_REQUEST_ID’) ,fnd_profile.value(‘GL_SET_OF_BKS_ID’) ,fnd_profile.value(‘SO_ORGANIZATION_ID’) ,fnd_profile.value(‘APPL_SHRT_NAME’) ,fnd_profile.value(‘RESP_NAME’) ,fnd_profile.value(‘RESP_ID’) FROM DUAL;

Merhabalar, Aşağıdaki sorgu modüller için dönem statülerini verir. SELECT (SELECT sob.NAME FROM gl.gl_sets_of_books sob WHERE sob.set_of_books_id = a.set_of_books_id) "SOB_Name", a.period_name "Period_Name", a.period_num "Period_Num", a.period_year, a.gl_status "GL_Status", b.po_status "PO_Status", c.ap_status "AP_Status", d.ar_status "AR_Status", e.fa_status "FA_Status" FROM (SELECT period_name, period_num, period_year, DECODE (closing_status, ‘O’, ‘Open’, ‘C’, ‘Closed’, ‘F’, ‘Future’, ‘N’, ‘Never’, closing_status ) gl_status, set_of_books_id FROM gl.gl_period_statuses […]

DECLARE v_itemtype VARCHAR2 (30) := ‘TPLEAVE’; –Item Type Internal Nam v_process VARCHAR2 (30) := ‘DEFAULT_PROCESS’; –Process Name v_itemkey VARCHAR2 (30); BEGIN SELECT rcv_transactions_s.NEXTVAL INTO v_itemkey FROM DUAL; –Assign a item key   wf_engine.createprocess (v_itemtype, v_itemkey, v_process); –Creates a new runtime process for an application item. wf_engine.setitemattrtext (v_itemtype, v_itemkey, ‘EMPLOYEE’, ‘OPERATIONS’); –Input Parameter wf_engine.setitemattrtext (v_itemtype, v_itemkey, […]

Solution: 1. Text Item oluşturulur. 2.Database Item = No 3.Calculation Mode = Formula Formula = :SYSTEM.TRIGGER_RECORD