Oracle EBS (7) 썸네일형 리스트형 FA Mass Addition이 APP-OFA-48678: Date must be in a future asset period 처리방법 Future Addition Transaction Error APP-OFA-48678 in Mass Additions (Doc ID 261215.1)문서 참조 CauseWhen mass additions create was run, it was run before the period was opened so it was a future line. Depreciation was run while the line was in the ON-HOLD or NEW queue and thus Process Pending Transactions didn't pick it up. Now the form will not allow the queue to be set to POST due to validation th.. Value Set 데이터 조회 Query Oracle EBS의 Value Set 및 Value값을 조회하는 Query /* value set에서 COA Account를 찾는다. */ SELECT * FROM FND_FLEX_VALUE_SETS WHERE 1=1 and flex_value_set_name like '%COA_ACCOUNT%' /* value 에서 COA Account 값을 찾는다. */ SELECT ffv.flex_value_set_id ,ffv.flex_value_id ,ffv.flex_value ,ffvt.description ,ffv.enabled_flag ,ffv.summary_flag ,ffv.start_date_active ,ffv.end_date_active ,ffv.structured_hierarchy_level ,.. FND_ 관련 테이블 목록 테이블명 설명 FND_APP_SERVERS This table will track the servers used by the E-Business Suite system. FND_DATABASES It tracks the databases employed by the eBusiness suite. This table stores information about the database that is not instance specific. FND_DATABASE_INSTANCES Stores instance specific information. Every database has one or more instance. FND_ATTACHED_DOCUMENTS Stores information relating.. AR Table 관련 모듈명 제목 내용 AR TRX AR Transaction Interface select * from AR Transaction SELECT * FROM ra_customer_trx_all WHERE 1 = 1 AND trx_number = 70006662; AR Transaction Line SELECT * FROM ra_customer_trx_lines_all WHERE 1 = 1 AND customer_trx_id = 1913008; AR Transaction sales person SELECT * FROM ra_cust_trx_line_salesreps_all WHERE 1 = 1 AND customer_trx_id = 1913008; AR Transaction Distribution SELECT .. AR Table 관련 모듈명 제목 내용 AR TRX AR Transaction Interface select * from AR Transaction SELECT * FROM ra_customer_trx_all WHERE 1 = 1 AND trx_number = 70006662; AR Transaction Line SELECT * FROM ra_customer_trx_lines_all WHERE 1 = 1 AND customer_trx_id = 1913008; AR Transaction sales person SELECT * FROM ra_cust_trx_line_salesreps_all WHERE 1 = 1 AND customer_trx_id = 1913008; AR Transaction Distribution SELECT .. AP Invoice R11버전 R11에는 SLA가 없다. 모듈명 제목 내용 AP AP Invoice Interface select * from ap.ap_invoices_interface t AP Invoice Line Interface select * from ap.AP_INVOICE_LINES_INTERFACE t AP Invoice Header select * from ap_invoices_all where invoice_num = '송장번호'; AP Invoice Distribution select * from ap_invoice_distributions_all where invoice_id = INVOICE_ID; AP Accouning Event select * from ap_accounting_events_all wher.. AP Invoice R12버전 AP시작부터 GL까지 주요 테이블 모듈명 제목 내용 AP AP Invoice Interface select * from ap.ap_invoices_interface t AP Invoice Line Interface select * from ap.AP_INVOICE_LINES_INTERFACE t AP AP Invoice Header select * from ap_invoices_all order by creation_date desc; select * from ap_invoices_all where invoice_num = '송장번호'; AP Invoice Line select * from ap_invoice_lines_all order by creation_date desc; select * from .. 이전 1 다음
