[Oracel ebs]How to create Request

 Reference Source: 

https://subscription.packtpub.com/book/application-development/9781849684842/1/ch01lvl1sec11/creating-request-sets

Test Run Request:

Reports, Request : Run Request

Parameters: 若有參數要輸入, 例如:有p_user_id, p_order_number, Parameters輸入G1234:55667700  (:分隔)

[Oracle EBS]TABLE後墜代表意思

https://bpcblogsoracle.wordpress.com/2012/05/09/oracle-inventory-inventory-organizations-2/

https://erpschools.com/erps/articles/table-suffixes-oracle-apps_all_tl_f_v_vl_s_a

https://www.oracleappsdna.com/2012/02/oracle-tables-with-suffix-_all-_tl-_b-_f-_v-_vl-_s-_a-_avn-and-_acn/

_ALL: 以_ALL 結尾的表表示它存儲與多個組織相關的數據。這樣的表肯定會有一個名為 org_id 的列，它指定記錄所屬的組織。

_TL: 以_TL 結尾的表是一個翻譯表。這樣的表有一個叫做language的列

_B: Tables ending _B are the base tables

_VL: 以 _VL 結尾的表是基於多語言或翻譯表構建的視圖。換句話說，這種視圖將基表數據與轉換錶數據結合起來。如果您希望查看與一種特定語言相關的數據，您應該使用 USERENV(‘LANG’) 設置語言。

_V: Tables ending with _V are views

_S: Tables ending with _S are Sequences

_A, _Avn, _ACn: Tables ending with _A, _Avn, _ACn are audit tables.

* audit tables:審計表是包含行的完整歷史記錄的表。

_F: 使用兩個日期列（Effective_start_Date、Effective_end_date）跟踪數據的表。這些表主要用於 HRMS 和工資模塊。

_AVN and _ACN are Audit Shadow Views (when data was changed, and with what values

(何時更改數據，以及更改了哪些值)

_KFV is the view which contains all the information about Key Flex Fields(KFFs).

_DFV is the view which contains the information about Descriptive Flex Fields(DFFs).

GL: General Ledger 總帳，使存儲會計資訊的中心，接收來自財務和製造模組的會計資訊
GL包括(共6個模組)：
      採購 Purchasing ，
      應付 Account Payable ，
      資產 Fixed Assets，
      應收 Accounts Receivable，
      庫存 Inventory，
      訂單 Order Management

[Oracel ebs]How to create Concurrent Program

Reference source:

https://www.youtube.com/watch?v=Qjjyraip4DM

http://www.bizinsightconsultingblog.com/2009/06/how-to-create-concurrent-program-on.html

 1. what is concurrent?

2.Concurrent Program Type

PL/SQL Store Procedure | PLSQL

Oracle Reports | SQL/PLSQLL

Host | Shell Script

SQL*Loader | SQLLoader Control File

SQL*Plus | SQL/PLSQL

Java Concurrent Program | Java

-------------------------------------------------------------------

Step:

1. Executable

2. Concurrent Program

3. Attach Concurrent Program with Request Group

-------------------------------------------------------------------

Create Executable

    Concurrent : Program : Executable

Executable

Enter all the details for Executable

Short Name

Best Practice is Short Name of Executable and concurrent program Schedule be same

Subroutine Name

For example: define executable for store procedure

Create Executable  

    Concurrent : Program : Define

  

Program

Enter the name for CP. Check the enable check box.

Short Name

Enter Name for CP Short Name should be same as short name of executable.(It's Best Practice)

Executable-Name

Select executable name from LOV.

Output-Format

Select the output format for CP.

Parameters

    1.Select the Value Set .

    2.Default Type.

    3.Default value for Set

    4.Default Value.

    

Attach Concurrent Program with Request Group  

Security : Responsibility : Request

After Saving the Concurrent Program, Attach it with required Request Set.

Choose the group where you want to attach CP

Add Concurrent program