Does it support multi-language EBS setups?

Yes, it understands the relationship between base tables (_B) and translation tables (_TL), recommending the use of _VL views or specific language joins.

How does this skill handle Oracle EBS security context?

The skill provides standardized patterns for calling FND_GLOBAL.APPS_INITIALIZE and MO_GLOBAL.set_policy_context to ensure database sessions are correctly scoped to the appropriate user and organization.

Can I use this skill to write directly to EBS transactional tables?

No, the skill enforces EBS best practices which require writing to staging/interface tables first, followed by a PL/SQL API or concurrent program call to process the data.

Which Oracle EBS modules are supported?

It provides specific guidance for Inventory (INV), Bill of Materials (BOM), Work in Process (WIP), Landed Cost Management (LCM), Purchasing (PO), Receiving (RCV), and Accounts Payable (AP).

Oracle EBS Expert

Name: Oracle EBS Expert
Author: Grupo-AFAL

byGrupo-AFAL

•

数据库管理

Provides domain-specific expertise for interacting with Oracle E-Business Suite (EBS) tables, PL/SQL APIs, and complex interface patterns.

The Oracle EBS Expert skill equips Claude with the architectural knowledge required to navigate the complexities of Oracle E-Business Suite within the oracle-gateway project. It enforces critical EBS standards, such as querying via the APPS schema, managing multi-org contexts with MO_GLOBAL, and initializing sessions through FND_GLOBAL. By following the 'interface-table-then-API' write pattern, this skill ensures that integrations with modules like Inventory, Purchasing, and Accounts Payable remain compliant with EBS transactional integrity and business logic.

主要功能

011 GitHub stars

02Handles effective dating and centralized lookup logic for EBS data

03Enforces the EBS-standard interface table write-and-process workflow

04Implements standard FND_GLOBAL and MO_GLOBAL initialization patterns

05Provides templates for robust PL/SQL API calls with status checking

06Navigates APPS schema conventions and table suffixes like _ALL, _B, and _TL

使用场景

01Generating PL/SQL blocks for calling standard EBS APIs like AP_IMPORT_INVOICES_PKG

02Designing multi-org aware queries that filter data by operating unit and effective date

03Building Rails integrations that query or update Oracle EBS module data

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add grupo-afal/claude-plugins ebs-expert

For use in Claude.ai and ChatGPT

主要功能

011 GitHub stars

02Handles effective dating and centralized lookup logic for EBS data

03Enforces the EBS-standard interface table write-and-process workflow

04Implements standard FND_GLOBAL and MO_GLOBAL initialization patterns

05Provides templates for robust PL/SQL API calls with status checking

06Navigates APPS schema conventions and table suffixes like _ALL, _B, and _TL

使用场景

01Generating PL/SQL blocks for calling standard EBS APIs like AP_IMPORT_INVOICES_PKG

02Designing multi-org aware queries that filter data by operating unit and effective date

03Building Rails integrations that query or update Oracle EBS module data

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add grupo-afal/claude-plugins ebs-expert

For use in Claude.ai and ChatGPT