Scripts
SELECT
ood.organization_code Warehouse_code,
ood.organization_name Warehouse,
ood.operating_unit OU_ID,
hou.name OU_Name,
hle.name Legal_entity,
hle.set_of_books_id,
gsob.name SOB
FROM
org_organization_definitions ood,
hr_operating_units hou,
hr_legal_entities hle,
gl_sets_of_books gsob
WHERE
ood.operating_unit = hou.organization_id
AND hou.legal_entity_id = hle.organization_id
AND gsob.set_of_books_id = hle.set_of_books_id
Syntax:
fnd_user_pkg.addresp(username => v_user_name
,resp_app => ‘SYSADMIN’
,resp_key => ‘SYSTEM_ADMINISTRATOR’
,security_group => ‘STANDARD’
,description => ‘Auto Assignment’
,start_date => SYSDATE – 10
,end_date => SYSDATE + 1000);
Usage:
BEGIN
fnd_user_pkg.addresp (‘OPERATIONS’,’SYSADMIN’,’SYSTEM_ADMINISTRATOR’,’STANDARD’,
‘Add Sysadmin Responsibility to OPERATIONS user using pl/sql’, SYSDATE, SYSDATE + 100);
COMMIT;
DBMS_OUTPUT.put_line (‘Responsibility Added Successfully’);
EXCEPTION
WHEN OTHERS
THEN
DBMS_OUTPUT.put_line ( ‘ Responsibility is not added due to ‘ || SQLCODE || SUBSTR (SQLERRM, 1, 100));
ROLLBACK;
END;
General Ledger Interface Tables
- GL_BUDGET_INTERFACE
- GL_DAILY_RATES_INTERFACE
- GL_DRM_HIERARCHY_INTERFACE
- GL_DRM_SEGVALUES_INTERFACE
- GL_IMP_COA_ERR_INTERFACE
- GL_IMP_COA_NORM_HIER_INTERFACE
- GL_IMP_COA_SEG_VAL_INTERFACE
- GL_IEA_INTERFACE
- GL_INTERFACE
- GL_INTERFACE_CONTROL
- GL_INTERFACE_HISTORY
- GL_REPORT_INTERFACE
- GL_XFR_INTERFACE
Account Payables (AP) Interface Tables
- AP_INTERFACE_CONTROLS
- AP_INTERFACE_REJECTIONS
- AP_INVOICE_INTERFACE
- AP_INVOICE_LINES_INTERFACE
- OIE_POL_RATES_INTERFACE
Account Receivables (AR) Interface Tables
- AR_PAYMENTS_INTERFACE_ALL
- AR_TAX_INTERFACE
- HZ_PARTY_INTERFACE
- HZ_PARTY_INTERFACE_ERRORS
- RA_CUSTOMERS_INTERFACE_ALL
- RE_INTERFACE_DISTRIBUTION_ALL
- RA_INTERFACE_ERRORS_ALL
- RA_INTERFACE_LINES_ALL
- RA_INTERFACE_SALESCREDITS_ALL
- AR_INTERFACE_CONTS_ALL
- AR_PMTS_INTERFACE_HEADER_GT
- AR_PMTS_INTERFACE_LINES_GT
- AR_PMTS_INTERFACE_LINE_DETAILS
- HZ_DQM_SH_SYNC_INTERFACE
- HZ_DQM_SYNC_INTERFACE
- RA_INTERFACE_REQID_GT
Fixed Assets (FA) Interface Tables
- FA_BUDGET_INTERFACE
- FA_INV_INTERFACE
- FA_PRODUCTION_INTERFACE
- FA_TAX_INTERFACE
- FA_TRANSACTION_INTERFACE
Cash Management (CE) Interface Tables
- CE_ARCH_INTERFACE_HEADERS
- CE_ARCH_INTERFACE_HEADERS_ALL
- CE_ARCH_INTERFACE_LINES
- CE_HEADER_INTERFACE_ERRORS
- CE_LINE_INTERFACE_ERRORS
- CE_STATEMENT_LINES_INTERFACE
- CE_UK_VALIDATIONS_INTERFACE