ERPstuff - Oracle EBS Community

1) Set the following profiles FND: Diagnostics Personalize Self-Service Defn 2) Open Java OAF Page. 3) Click on About this Page in the bottom left of the page. 4) Expand the Business Component References Details Section and go to the View Objects Sub Section. 5) Click the Object by reading the last ...

-- The APEX_DATA_PARSER.PARSE function allows to "select" up to 300 columns (COL001 to COL300) from the -- parsed file. This example uses the following parameters. -- -- P_CONTENT the file content to be parsed as a BLOB -- P_FILE_NAME the name of the file; only used to derive the file typ...

Youtube Video https://youtu.be/HGjKGrIKy60 REGIME: In Oracle E-Business Tax, a Tax Regime is the system of regulations for the determination and administration of one or more taxes. TAX: A Tax is a distinct charge imposed by a government through a fiscal or tax authority. Every tax in Oracle E-Busi...

1. DBMS_DEBUG should be in SYS schema 2. Version check - Oracle Probe API v2.0 or greater required declare probe_major_ver varchar2(10); probe_minor_ver varchar2(10); begin dbms_debug.probe_version(probe_major_ver, probe_minor_ver); dbms_output.put_line('MAJOR=' || probe_major_ver); dbms_output.put_...

Sir, there are 4 Shifts Rotation 24/7 all year Duration of one shift Duty is 12 hours in Day and night For Every Shift, the Person will have the Following Format of work in Rotation Day duty next day night duty than in morning will off on next day also OFF The Purpose of making sheet : 1. To determi...

Hi, Here is a sample code to handle following in R12.1.3 1. Check Workflow Mailer settings to OUTBOND is wrong will update with provided info. 2. Will check if Mailer is running if not will try to start and send email/sms. 3. Will change workflow WF_ADMIN_ROLE to * which gets change to SYSADMIN afte...

BEGIN DBMS_NETWORK_ACL_ADMIN.append_host_ace ( host => 'mail.smtp2go.com', lower_port => 587, upper_port => 587, ace => xs$ace_type(privilege_list => xs$name_list('http'), principal_name => ‘myuser', principal_type => xs_acl.ptype_db)); END; /

CREATE OR REPLACE PROCEDURE erpstuff_email (fromm VARCHAR2, too VARCHAR2, sub VARCHAR2, body VARCHAR2, port NUMBER) IS /* Sample code for R&D purpose only using on PROD need proper testing and UAT hence no liability on ERPstuff.com Verrsion 1.0 by Sikandar Hayat info@erpstuff.com */ objConnectio...

select * from APEX_200100.wwv_flow_mail_queue select * form apex_mail_queue select * from FROM ALL_SCHEDULER_JOB_LOG select * from DBA_SCHEDULER_JOB_RUN_DETAILS where JOB_NAME='ORACLE_APEX_MAIL_QUEUE'; select * from all_scheduler_jobs where job_name like 'ORACLE_APEX_MAIL_QUEUE' select * from all_sc...

ACL BEGIN DBMS_NETWORK_ACL_ADMIN.create_acl ( acl => 'erpstuff_acl.xml', description => 'ACL for LDAP', principal => 'APEX_2002000', << APEX current version username is_grant => TRUE, privilege => 'connect', start_date => SYSTIMESTAMP, end_date => NULL); DBMS_NETWORK_ACL_ADMIN.assign_acl ( acl => '...

Update the bold data in the file as below then save and test, $vi cd $XDO_TOP/resource/xdodelivery.cfg <?xml version="1.0" encoding="UTF-8" ?> <config xmlns="http://xmlns.oracle.com/oxp/delivery/config"> <servers> <server name="smtpserver1" type="smtp_ema...

EXECUTE DBMS_STATS.GATHER_SCHEMA_STATS(ownname => 'SCOTT');

Public Sub User_Range_Selection() ' To show an input box where the user can select a range ' Value Description ' 0 A formula ' 1 A number ' 2 Text (a string) ' 4 A logical value (True or False) ' 8 A cell reference, as a Range object ' 16 An error value, such as #N/A ' 64 An array of values Dim rng ...

Sub FileDialogOpen() ' Open File Dialog to only select multiple Excel files ' ERPstuff.com With Application.FileDialog(msoFileDialogOpen) .AllowMultiSelect = True .Filters.Add "Excel Files", "*.xlsx; *.xlx", 1 .Show For i = 1 To .SelectedItems.Count MsgBox .SelectedItems(i) Next ...

Hi, This is a normal requirement of users who are working on different data analyses on a huge amount of data in Excel like Finance, Marketing, Sales, HR etc. For a detailed demo of this FREE TOOL is in the following youtube video, https://youtu.be/lGnGPTTAmOo To Download click below, - The formula ...