Setting the Password for PDF File sent through XML Publisher Open the rtf for which you want to set password and do the following things 1) Open the .rtf2) Go to File – > Properties Create a new custom property a) Name : xdo-pdf-open-passwordType : text Value : Either Hard Code the value / or […]
Following script and get all the packages related to API in Oracle applications, from which you can select APIs that pertain to AP. You can change the name like to PA or AR and can check for different modules select substr(a.OWNER,1,20), substr(a.NAME,1,30), substr(a.TYPE,1,20) , substr(u.status,1,10) Stat, u.last_ddl_time, substr(text,1,80) Description from dba_source a, dba_objects u WHERE […]
What is Concurrent Programming? Concurrent Processing in Oracle Apps simultaneously executes programs running in the Background with online operations to fully utilize your hardware capacity. Use Concurrent Programming for Long Running – Data intensive tasks such as Posting a Journal or generating a report. What is the Role of Concurrent Managers? A Concurrent Manager is […]
Training of XML Publisher Report (XMLP) or BI Publisher Reports: How to Develop XML Publisher Report (XMLP) or BI Publisher Reports? hey Guys Now adays BI Publisher is in Boom technology formally it know as XMLP means XML Publisher.We can develop this by using following steps: 1)Develop the Report(.rdf) Only DataModel 2)Save the report and […]
load data infile ‘AP_INV.TXT’append into table AP_INVOICES_INTERFACEfields terminated by ‘^’ optionally enclosed by ‘”‘trailing nullcols (INVOICE_NUM CHAR “RTRIM(:INVOICE_NUM)”, INVOICE_TYPE_LOOKUP_CODE CHAR “RTRIM(:INVOICE_TYPE_LOOKUP_CODE)”, INVOICE_DATE DATE “DD-MON-RRRR”, VENDOR_NUM CHAR “RTRIM(:VENDOR_NUM)”, VENDOR_SITE_CODE FILLER, INVOICE_AMOUNT CHAR “RTRIM(:INVOICE_AMOUNT)”, TERMS_NAME CHAR “RTRIM(:TERMS_NAME)”, DESCRIPTION CHAR “RTRIM(:DESCRIPTION)”, DUMMY1 FILLER, DUMMY2 FILLER, DUMMY3 FILLER, DUMMY4 FILLER, GL_DATE DATE “TO_DATE((TO_CHAR(:GL_DATE,’DD-‘)||DECODE(TO_CHAR(:GL_DATE,’MON’),’AUG’,’SEP’,’SEP’,’SEP’,’OCT’,’OCT’,TO_CHAR(:GL_DATE,’MON’))||TO_CHAR(:GL_DATE,’-YYYY’)))”, VOUCHER_NUM CHAR “RTRIM(:VOUCHER_NUM)”, INVOICE_RECEIVED_DATE DATE, AMOUNT_APPLICABLE_TO_DISCOUNT, […]
Recent Comments